blue27opos
Updated 2023-01-24
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
with token_average_price_usd as (select avg(price) as price , symbol , currency from osmosis.core.ez_prices
group by symbol,currency)
, tops as (select sum(amount/pow(10,DECIMAL) * price) as amount_USD , sender
from osmosis.core.fact_transfers
inner join token_average_price_usd on token_average_price_usd.currency=osmosis.core.fact_transfers.currency
where DECIMAL is not null and amount/pow(10,DECIMAL) < 100000 and symbol='OSMO'
group by sender
order by amount_USD DESC
limit 10)
select * from tops
Run a query to Download Data