DATE_TRUNC('day', block_timestamp) AS day,

SUM(amount_in_usd) AS total_volume_usd

kaia.defi.ez_dex_swaps

block_timestamp >= '2024-08-01'

AND block_timestamp < '2024-09-01'

GROUP BY

day

ORDER BY

day;