DATE(BLOCK_TIMESTAMP) AS transaction_date,

COUNT(*) AS total_transactions

FROM

solana.defi.fact_swaps

WHERE SWAP_TO_MINT = '3S8qX1MsMqRbiwKg2cQyx7nis1oHMgaCuc9c4VfvVdPN'

OR SWAP_TO_MINT = '3S8qX1MsMqRbiwKg2cQyx7nis1oHMgaCuc9c4VfvVdPN'

GROUP BY

DATE(BLOCK_TIMESTAMP)

ORDER BY

transaction_date;