shadilDistribution of Thorchain users that swapped in $RUNE
Updated 2022-09-04
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
select case when total_volume >= 1 and total_volume < 10 then 'Less 10 RUNE'
when total_volume >= 10 and total_volume < 50 then '10 - 50 $RUNE'
when total_volume >= 50 and total_volume < 100 then '50 - 100 $RUNE'
when total_volume >= 100 and total_volume < 500 then '100 - 500 $RUNE'
when total_volume >= 500 and total_volume < 1000 then '500 - 1k $RUNE'
when total_volume >= 1000 and total_volume < 3000 then '1k - 3k $RUNE'
when total_volume >= 3000 and total_volume < 5000 then '3k - 5k $RUNE'
when total_volume >= 5000 and total_volume < 10000 then '5k - 10k $RUNE'
when total_volume >= 10000 and total_volume < 15000 then '10k - 15k $RUNE'
when total_volume >= 15000 and total_volume < 20000 then '15k - 20k $RUNE'
when total_volume >= 20000 then 'More 20k $RUNE' end as category,
count(distinct wallet_address) as total_wallets
from (select from_address as wallet_address, sum(total_volume) as total_volume
from (select from_address,
case when to_asset ilike 'thor.rune'
then to_amount
when from_asset ilike 'thor.rune'
then from_amount
end as total_volume
from flipside_prod_db.thorchain.swaps) group by wallet_address)
where category is not null
group by category
Run a query to Download Data