EXTRACT(YEAR FROM block_timestamp) AS transaction_year,

COUNT(*) AS eth_transaction_count

FROM

ethereum.defi.ez_dex_swaps

WHERE

token_out = '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'

AND event_name = 'Swap'

AND block_timestamp >= '2020-01-01'

AND block_timestamp < '2025-01-01'

GROUP BY

EXTRACT(YEAR FROM block_timestamp)

ORDER BY

transaction_year;