DATE_TRUNC('day', block_timestamp) AS "Date",

COUNT(DISTINCT tx_hash) AS "Daily Swaps",

COUNT(DISTINCT swapper) AS "Daily Swappers",

SUM(amount_in_usd) AS "Daily Swap Volume"

aptos.defi.ez_dex_swaps

block_timestamp >= DATE_TRUNC('month', CURRENT_DATE)

GROUP BY

DATE_TRUNC('day', block_timestamp)

ORDER BY

"Date" ASC;