mlhDaily count of wallets based on $AXl balance on Osmosis
    Updated 2022-12-02
    select date,
    'osmosis' as network,
    case when BALANCE/pow(10,decimal)<1 then 'less than 1 $AXL'
    when BALANCE/pow(10,decimal) >1 and BALANCE/pow(10,decimal)<10 then 'Between 1 to 10 $AXL'
    when BALANCE/pow(10,decimal) >10 and BALANCE/pow(10,decimal)<100 then 'Between 10 to 100 $AXL'
    when BALANCE/pow(10,decimal) >100 and BALANCE/pow(10,decimal)<1000 then 'Between 100 to 1k $AXL'
    else 'more than 1K $AXL' end as bal,
    count(distinct ADDRESS) as wallet
    from osmosis.core.fact_daily_balances
    where currency='ibc/903A61A498756EA560B85A85132D3AEE21B5DEDD41213725D22ABF276EA6945E'
    group by 1, 2, 3


    Run a query to Download Data