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

SUM(ABS(AMOUNT_IN_USD) + ABS(AMOUNT_OUT_USD)) AS "Trading Volume in USD"

FROM

base.defi.ez_dex_swaps

WHERE

TOKEN_IN IN (

SELECT DISTINCT CONTRACT_ADDRESS

FROM base.core.ez_token_transfers

)

OR TOKEN_OUT IN (

SELECT DISTINCT CONTRACT_ADDRESS

FROM base.core.ez_token_transfers

)

GROUP BY

DATE_TRUNC('day', BLOCK_TIMESTAMP)

ORDER BY

"Date" ASC;