SELECT
DATE_TRUNC('week', block_timestamp) AS block_date,
chain,
SUM(usd_amount) AS volume
FROM
crosschain.dex.trades_evm
WHERE
chain IN (
'base',
'arbitrum',
'optimism',
'blast',
'scroll',
'polygon_zkevm'
)
GROUP BY
ALL
ORDER BY
1 DESC
LIMIT
500000
2024-09-09T00:00:00
optimism
2024-09-09T00:00:00
arbitrum
2024-09-09T00:00:00
polygon_zkevm