DATE_TRUNC('day', block_timestamp) AS recorded_day,

SUM(SWAP_FROM_AMOUNT_USD) AS Swap_Volume_USD,

COUNT(DISTINCT tx_id) AS No_of_Swaps,

COUNT(DISTINCT SWAPPER) AS N_Swapper

FROM

solana.defi.ez_dex_swaps

WHERE

(SWAP_FROM_MINT = '3psH1Mj1f7yUfaD5gh6Zj7epE8hhrMkMETgv5TshQA4o'

OR SWAP_TO_MINT = '3psH1Mj1f7yUfaD5gh6Zj7epE8hhrMkMETgv5TshQA4o')

AND DATE(block_timestamp) = '2024-07-22'

GROUP BY

recorded_day

ORDER BY

recorded_day;