WITH token_swaps AS (

SELECT

symbol_in AS token,

COUNT(DISTINCT tx_hash) AS swap_count

FROM

aptos.defi.ez_dex_swaps

WHERE

block_timestamp BETWEEN '2024-01-01' AND '2024-12-31'

AND symbol_in IS NOT NULL

GROUP BY

symbol_in

UNION ALL

SELECT

symbol_out AS token,

COUNT(DISTINCT tx_hash) AS swap_count

FROM

aptos.defi.ez_dex_swaps

WHERE

block_timestamp BETWEEN '2024-01-01' AND '2024-12-31'

AND symbol_out IS NOT NULL

GROUP BY

symbol_out

SELECT

token AS "Token",

SUM(swap_count) AS "Total Swaps"

FROM

token_swaps

GROUP BY

token

ORDER BY

"Total Swaps" DESC