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
corr(from_amount_usd,slippage),
corr(slippage,from_amount_usd)
from swaps