maybeyonasthor_slip_swap_swap
Updated 2022-01-29
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
with
swaps as (
select
block_timestamp,
split(pool_name,'-')[0]::string as pool,
round(from_amount_usd,-2) as from_amount_usd,
swap_slip_bp/100 as slippage
from thorchain.swaps
)
select
from_amount_usd,
-- pool,
log(10,count(block_timestamp)) as log_swaps,
avg(slippage) as avg_slip,
max(slippage) as max_slip,
min(slippage) as min_slip,
mode(slippage) as mode_slip
from swaps
group by 1--,2
Run a query to Download Data