0xHaM-dCopy of Top 10 Assets Swapped Tx count "TO" Hubble
    Updated 2022-10-09
    select
    LABEL,
    count(distinct tx_id) as swap_tx,
    sum(swap_to_amount) as swap_vol_to_hubbl
    from solana.core.fact_swaps a join solana.core.dim_labels b on a.swap_from_mint = b.address
    where swap_to_mint = ('USDH1SM1ojwWUga67PGrgFWUHibbjqMvuMaDkRJTgkX')
    and succeeded = 'TRUE'
    group by 1
    order by 2 DESC
    limit 10
    Run a query to Download Data