DATE_TRUNC(day, block_timestamp) AS day,

SUM(swap_from_amount_usd + swap_to_amount_usd) AS trading_volume,

SUM(swap_from_amount + swap_to_amount) AS swap_volume,

COUNT(DISTINCT tx_id) AS swap_count,

COUNT(DISTINCT swapper) AS swapper_count

FROM solana.defi.ez_dex_swaps

WHERE swap_from_mint = 'FUAfBo2jgks6gB4Z4LfZkqSZgzNucisEHqnNebaRxM1P'

OR swap_to_mint = 'FUAfBo2jgks6gB4Z4LfZkqSZgzNucisEHqnNebaRxM1P'

GROUP BY ALL

ORDER BY day;