mlhDistribution of Swaps in $RUNE and USD Values4
Updated 2022-09-05Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
select count (distinct tx_id) as trxs,
pool_name as pool,
case when from_amount_usd < 50 then 'less than 50 USD'
when from_amount_usd >= 50 and from_amount_usd < 100 then 'between 50 to 100 USD'
when from_amount_usd >= 100 and from_amount_usd < 1000 then 'between 100 to 1K USD'
when from_amount_usd >= 1000 and from_amount_usd < 2000 then 'between 1K to 2K USD'
when from_amount_usd >= 2000 and from_amount_usd < 3000 then 'between 2K to 3K USD'
when from_amount_usd >= 3000 and from_amount_usd < 5000 then 'between 3K to 5K USD'
when from_amount_usd >= 5000 and from_amount_usd < 10000 then 'between 5K to 10K USD'
else 'more than 10K USD' end as type
from (select pool_name,
tx_id,
from_amount_usd
from flipside_prod_db.thorchain.swaps
)
group by 2, 3
Run a query to Download Data