nitsNEAR Distribution
    Updated 2022-09-08
    with withdrawal as
    (SELECT tx_signer as addr, sum(deposit)/pow(10,24)*(-1) as amt from mdao_near.transfers
    GROUP by 1 ),
    deposits as
    (SELECT tx_receiver as addr, sum(deposit)/pow(10,24) as amt from mdao_near.transfers
    GROUP by 1)

    SELECT distribution, count(DISTINCT addr) as total_addresses, sum(net_balance) as net_wealth_in_category from
    (SELECT addr, sum(amt) as net_balance,
    case when net_balance < 1 then 'a-less than 1 NEAR'
    when net_balance >= pow(10,0) and net_balance < pow(10,1) then 'b- 1-10 NEAR'
    when net_balance >= pow(10,1) and net_balance < pow(10,2) then 'c- 10-100 NEAR'
    when net_balance >= pow(10,2) and net_balance < pow(10,3) then 'd- 100-1k NEAR'
    when net_balance >= pow(10,3) and net_balance < pow(10,4) then 'e- 1k-10k NEAR'
    when net_balance >= pow(10,4) and net_balance < pow(10,5) then 'f- 10k-100k NEAR'
    when net_balance >= pow(10,5) and net_balance < pow(10,6) then 'g- 100k-1M NEAR'
    when net_balance >= pow(10,6) and net_balance < pow(10,7) then 'h- 1M-10M NEAR'
    when net_balance >= pow(10,7) then 'i- 10M+ NEAR'
    end as distribution
    from
    (SELECT * from deposits
    UNION ALL
    SELECT * FROM withdrawal)
    GROUP by 1 )
    GROUP by 1
    limit 100

    Run a query to Download Data