COUNT(DISTINCT tx_hash) AS no_of_transaction

FROM polygon.defi.ez_dex_swaps

WHERE platform IN ('uniswap-v3', 'curve', 'balancer', 'sushiswap')

AND block_timestamp::date >= '2024-01-01'

AND amount_in_usd IS NOT NULL