AmiRtop 5 purchase token/swap
    Updated 2024-08-29
    select SYMBOL_out,
    count(DISTINCT tx_hash) as swaps,
    count(DISTINCT SWAPPER) as swapper,
    sum(amount_out_usd) as vol
    from aptos.defi.ez_dex_swaps
    where BLOCK_TIMESTAMP>=current_date-60 and platform='hippo'
    GROUP by 1
    order by swaps DESC limit 5




    QueryRunArchived: QueryRun has been archived