ramishoowUntitled Query
Updated 2022-10-26
9
1
2
3
4
5
›
⌄
with ramishoow as (select project_name as " names ", count(a.address) as number_holders, rank() over (order by number_holders desc) as rank
from osmosis.core.fact_daily_balances s join osmosis.core.dim_labels a on s.currency = a.address
where date::date = '2022-10-21' and currency not ilike ('%gamm%')
and BALANCE_TYPE = 'liquid' group by 1 order by 2 desc) select *
from ramishoow order by number_holders desc limit 10
Run a query to Download Data