-- Popular platform Monitor- Monitors the most popular and rising platforms being traded into across Avalanche DEXes.
-- Looks at the number of users trading the platforms and at what volume.
select
block_timestamp,tx_hash,pool_name,amount_in_usd,amount_out_usd
from avalanche.defi.ez_dex_swaps
where origin_from_address=lower('{{user_address}}')
and amount_in_usd>0 and amount_in_usd is not null
order by block_timestamp desc