nitsTITANIC on-ship addresses
    Updated 2022-05-12
    SELECT distribution, count(DISTINCT address), sum(amt) as total_amt
    from
    (SELECT address, sum(balance) as amt,
    case when amt < 1 then 'dust'
    when amt >= 1 and amt < 10 then '1-10'
    when amt>= 10 and amt < 20 then 'a-10-20luna'
    when amt>= 20 and amt < 30 then 'b-20-30luna'
    when amt>= 30 and amt < 50 then 'c-30-50luna'
    when amt>= 50 and amt < 75 then 'd-50-75luna'
    when amt>= 75 and amt < 100 then 'e-75-100luna'
    when amt>= 100 and amt < 200 then 'f-100-200luna'
    when amt>= 200 and amt < 500 then 'g-200-500luna'
    when amt>= 500 and amt < 1000 then 'h-500-1000luna'
    when amt>= 1000 and amt < 10000 then 'i-1000-10kluna'
    when amt>= 10000 then 'j-10k+LUNA'end as distribution
    from terra.daily_balances
    where date = CURRENT_DATE -4 and currency = 'LUNA' and balance_type = 'staked'
    GROUP by 1 )
    where amt > 10
    GROUP by 1
    Run a query to Download Data