Updated 2022-10-26
    with daily_prices as (
    select
    date(RECORDED_AT) as day,
    address,
    avg(PRICE) as price_usd
    from
    osmosis.core.dim_prices a join osmosis.core.dim_labels b on project_name = symbol
    group by
    day, address
    ), daily_banalces as (
    select
    DATE as day,
    a.ADDRESS,
    BALANCE/pow(10, DECIMAL)*price_usd as balance_usd,
    case
    when balance_usd<=1000 then 'Shrimp'
    when balance_usd>1000 and balance_usd<=5000 then 'Fish'
    when balance_usd>5000 and balance_usd<=10000 then 'Dolphin'
    when balance_usd>10000 and balance_usd<=100000 then 'Shark'
    else 'Whale'
    end as address_type
    from
    osmosis.core.fact_daily_balances a join daily_prices b on a.date=b.day and a.currency=b.address
    where DATE=(select date(max(date)) from osmosis.core.fact_daily_balances)
    )
    select
    address_type,
    count(distinct address) as cnt
    from
    daily_banalces
    group by
    address_type
    Run a query to Download Data