maybeyonasthor_swapsize_chain
Updated 2021-12-05
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
select
-- split(from_asset,'-')[0]::string || ' to ' || split(to_asset,'-')[0]::string as combination,
blockchain,
count(tx_id) as swaps,
sum(from_amount_usd) as vol,
median(from_amount_usd) as median_swap_size,
avg(from_amount_usd) as avg_swap_size
from thorchain.swaps
group by 1
order by avg_swap_size desc
-- limit 100
-- select * from thorchain.swaps
-- limit 100
Run a query to Download Data