date_trunc('week', block_timestamp) Date,

platform,

SUM(amount_in_usd) Weekly_Volume

base.defi.ez_dex_swaps

amount_in_usd IS NOT NULL

GROUP BY

1,

2

ORDER BY

1 DESC --LIMIT 100