DATE_TRUNC('day', block_timestamp) AS day,

COUNT(DISTINCT tx_id) AS swap_activities,

COUNT(DISTINCT swapper) AS daily_unique_swappers,

SUM(swap_from_amount_usd) AS total_swap_from_volume_usd

FROM

solana.defi.ez_dex_swaps

WHERE

swap_from_mint = 'So11111111111111111111111111111111111111112'

AND block_timestamp >= '2023-07-01'

AND block_timestamp < '2023-10-01'

GROUP BY

DATE_TRUNC('day', block_timestamp)

ORDER BY

day;