block_timestamp,

SUM(amount_in_usd) AS weekly_volume

FROM aptos.defi.ez_dex_swaps

WHERE symbol_in = 'SHRIMP'

AND amount_in_usd IS NOT NULL

AND block_timestamp >= CURRENT_DATE - INTERVAL '7 day'

GROUP BY block_timestamp

ORDER BY block_timestamp DESC, weekly_volume DESC