token,

COUNT(DISTINCT tx_id) AS swap_count

FROM (

SELECT

swap_from_symbol AS token,

tx_id

FROM

solana.defi.ez_dex_swaps

WHERE

block_timestamp >= CURRENT_TIMESTAMP - INTERVAL '30 day'

UNION ALL

SELECT

swap_to_symbol AS token,

tx_id

FROM

solana.defi.ez_dex_swaps

WHERE

block_timestamp >= CURRENT_TIMESTAMP - INTERVAL '30 day'

) AS all_swaps

GROUP BY

token

ORDER BY

swap_count DESC

LIMIT 15;