DATE_TRUNC('DAY', block_timestamp) AS "Day",

COUNT(tx_hash) AS "Total Swaps",

SUM(COALESCE(amount_in_usd, 0) + COALESCE(amount_out_usd, 0)) AS "Total Volume (USD)",

COUNT(DISTINCT origin_function_signature) AS "Unique Traders"

FROM base.defi.ez_dex_swaps

WHERE token_in = '0xd27c288fd69f228e0c02f79e5ecadff962e05a2b'

OR token_out = '0xd27c288fd69f228e0c02f79e5ecadff962e05a2b'

GROUP BY "Day"

ORDER BY "Day";