2844ALGO DISTURBUTION-SWAPPERS
Updated 2022-07-07
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
SELECT
case
WHEN 1<=balance and balance <=100 then 'less than 1000'
WHEN balance > 100 and balance <=1000 then 'between 100 and 1000'
WHEN balance > 1000 and balance <=10000 then 'between 1000 and 10000'
WHEN balance > 10000 then 'more than 10000'
end as holders_ALGO,
count(1) as distribution_of_ALGO
from flipside_prod_db.algorand.account
inner join flipside_prod_db.algorand.swaps S on S.SWAPPER =flipside_prod_db.algorand.account.ADDRESS
where S.block_timestamp>= '2022-05-01' and S.block_timestamp <'2022-07-01'
and BALANCE >=1
group by 1
Run a query to Download Data