KaskoazulTracking USDH top10 by swaps
    Updated 2022-04-16
    select address_name,
    count(tx_id) as swaps,
    sum(swap_from_amount) as USDH_vol
    from solana.fact_swaps fs
    inner join solana.dim_labels dl
    on fs.swap_to_mint = dl.address
    where swap_from_mint = 'USDH1SM1ojwWUga67PGrgFWUHibbjqMvuMaDkRJTgkX'
    and succeeded = 'TRUE'
    group by 1
    order by 2 desc, 3

    Run a query to Download Data