SELECT

swap_to_symbol,

COUNT(DISTINCT tx_id) AS hourly_swaps,

SUM(swap_from_amount_usd) AS hourly_volume

FROM

solana.defi.ez_dex_swaps

WHERE

swap_from_symbol = 'TRUMP'

GROUP BY

swap_to_symbol

SELECT

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

hourly_swaps,

hourly_volume

FROM

buying_data

ORDER BY

hourly_swaps DESC

LIMIT 10;