ramishoowUntitled Query
    Updated 2022-10-26
    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