SELECT

Block_timestamp,

tx_hash,

sender,

platform,

amount_in_usd,

amount_out_usd

FROM avalanche.defi.ez_dex_swaps

WHERE (symbol_in = 'sAVAX' OR symbol_out = 'sAVAX')

SELECT

platform,

COUNT(DISTINCT tx_hash) AS swap_count,

SUM(amount_in_usd) AS total_volume_usd

FROM savax_swaps

GROUP BY platform

ORDER BY total_volume_usd DESC;

LIMIT 10;