nitsTITANIC on-ship addresses
Updated 2022-05-12
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
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