DATE_TRUNC('day', block_timestamp) AS day,

COUNT(DISTINCT tx_id) AS swaps,

COUNT(DISTINCT swapper) AS swappers,

SUM(NVL(SWAP_FROM_AMOUNT_USD, SWAP_TO_AMOUNT_USD)) AS swap_volume_usd

FROM

solana.defi.ez_dex_swaps

WHERE

Swap_from_mint = '2zMMhcVQEXDtdE6vsFS7S7D5oUodfJHE8vd1gnBouauv'

OR swap_to_mint = '2zMMhcVQEXDtdE6vsFS7S7D5oUodfJHE8vd1gnBouauv'

GROUP BY

day

ORDER BY

day DESC