FROM polygon.core.fact_event_logs

SELECT

date_trunc('Year', block_timestamp) "Date", platform, count(tx_hash) "Number of Transactions", count(distinct tx_hash) "Number of Unique Transactions",

count(DISTINCT origin_from_address) "Number of Unique Users",

FROM ethereum.core.ez_dex_swaps

Where "Date" Between '2020-01-01' AND '2022-12-01' AND PLATFORM IN('uniswap-v2', 'uniswap-v3', 'sushiswap')

GROUP BY 1, 2

order by "Date" Desc