SELECT

date_trunc('week', block_timestamp) as Date,

COUNT(DISTINCT tx_hash) as Total_Transaction,

COUNT(DISTINCT origin_from_address) as Total_Traders,

avg(amount_in_usd) as Avg_volume,

sum(amount_in_usd) as Total_Volume

FROM ethereum.defi.ez_dex_swaps

WHERE

token_in = '0x3593d125a4f7849a1b059e64f4517a86dd60c95d'

OR token_out = '0x3593d125a4f7849a1b059e64f4517a86dd60c95d'

AND amount_in_usd is NOT NULL

AND block_timestamp BETWEEN '2023-01-01' AND '2024-03-26'

GROUP BY 1

ORDER BY 1 ASC

LIMIT 1000