aba8- top users
Updated 2022-12-14
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
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