aba8- top users
    Updated 2022-12-14
    with pool773 as (
    select distinct liquidity_provider_address
    from osmosis.core.fact_liquidity_provider_actions
    where pool_id[0] = '773'
    and tx_status = 'SUCCEEDED'
    and action = 'pool_joined'
    )
    select trader address,
    count(distinct tx_id) as number_of_transactions,
    sum(from_amount/1e10) as volume
    from osmosis.core.fact_swaps
    left join osmosis.core.dim_labels on to_currency = address
    where trader in (select * from pool773)
    and from_currency = 'ibc/3FF92D26B407FD61AE95D975712A7C319CDE28DE4D80BDC9978D935932B991D7'
    and tx_status = 'SUCCEEDED'
    group by 1
    order by 2 desc
    limit 20
    Run a query to Download Data