SELECT

swap_from_symbol,

COUNT(DISTINCT tx_id) AS hourly_swaps,

SUM(swap_from_amount_usd) AS hourly_volume

FROM

solana.defi.ez_dex_swaps

WHERE

swap_to_symbol = 'TRUMP'

AND swap_from_symbol IS NOT NULL

GROUP BY

swap_from_symbol

SELECT

CONCAT(swap_from_symbol, '-TRUMP') AS swap_pair,

hourly_swaps,

hourly_volume

FROM

buying_data

ORDER BY

hourly_swaps DESC

LIMIT 10;