Moe4probprob
    Updated 2022-12-03
    with base as (
    select
    ADDRESS,
    sum(balance/pow(10,decimal)) as balances
    from
    osmosis.core.fact_daily_balances
    where currency = 'ibc/903A61A498756EA560B85A85132D3AEE21B5DEDD41213725D22ABF276EA6945E'
    and DATE::date = CURRENT_DATE - 1
    group by 1)

    select
    case
    when balances < 10 then 'Under 10'
    when balances between 10 and 100 then '10 - 100'
    when balances between 100 and 1000 then '100 - 1000'
    when balances between 1000 and 10000 then '1k - 10k'
    when balances between 10000 and 100000 then '10k - 100k'
    when balances > 100000 then 'above 100k'
    end as tier ,
    count (distinct address) as holders
    from
    base
    group by 1







    Run a query to Download Data