date_trunc('day', block_timestamp) AS date,

platform,

COUNT(DISTINCT tx_hash) AS no_of_trx

FROM polygon.defi.ez_dex_swaps

WHERE event_name = 'Swap'

AND amount_in_usd IS NOT NULL

AND platform = 'quickswap-v3'

AND date >= '2023-02-01'

GROUP BY 1, 2

ORDER BY 1 DESC

LIMIT 1000