with avg_slip_1k as (select '1) 0-1k' as range, 'average' as type, round(avg(SWAP_SLIP_BP)/100, 4) as percentage_slippage from thorchain.swaps where from_amount_usd <= 1000), med_slip_1k as (select '1) 0-1k' as range, 'median' as type, median(SWAP_SLIP_BP)/100 as percentage_slippage from thorchain.swaps where from_amount_usd <= 1000), avg_slip_10k as (select '2) 1k-10k' as range, 'average' as type, round(avg(SWAP_SLIP_BP)/100, 4) as percentage_slippage from thorchain.swaps where from_amount_usd > 1000 and from_amount_usd <= 10000), med_slip_10k as (select '2) 1k-10k' as range, 'median' as type, median(SWAP_SLIP_BP)/100 as percentage_slippage from thorchain.swaps where from_amount_usd > 1000 and from_amount_usd <= 10000), avg_slip_100k as (select '3) 10k-100k' as range, 'average' as type, round(avg(SWAP_SLIP_BP)/100, 4) as percentage_slippage from thorchain.swaps where from_amount_usd > 10000 and from_amount_usd <= 100000), med_slip_100k as (select '3) 10k-100k' as range, 'median' as type, median(SWAP_SLIP_BP)/100 as percentage_slippage from thorchain.swaps where from_amount_usd > 10000 and from_amount_usd <= 100000), avg_slip_500k as (select '4) 100k-500k' as range, 'average' as type, round(avg(SWAP_SLIP_BP)/100, 4) as percentage_slippage from thorchain.swaps where from_amount_usd > 100000 and from_amount_usd <= 500000), med_slip_500k as (select '4) 100k-500k' as range, 'median' as type, median(SWAP_SLIP_BP)/100 as percentage_slippage from thorchain.swaps where from_amount_usd > 100000 and from_amount_usd <= 500000), avg_slip_1m as (select '5) 500k-1m' as range, 'average' as type, round(avg(SWAP_SLIP_BP)/100, 4) as percentage_slippage from thorchain.swaps where from_amount_usd > 500000 and from_amount_usd <= 1000000), med_slip_1m as (select '5) 500k-1m' as range, 'median' as type, median(SWAP_SLIP_BP)/100 as percentage_slippage from thorchain.swaps where from_amount_usd > 500000 and from_amount_usd <= 1000000), avg_slip_1m_plus as (select '6) 1m+' as range, 'average' as type, round(avg(SWAP_SLIP_BP)/100, 4) as percentage_slippage from thorchain.swaps where from_amount_usd > 1000000), med_slip_1m_plus as (select '6) 1m+' as range, 'median' as type, median(SWAP_SLIP_BP)/100 as percentage_slippage from thorchain.swaps where from_amount_usd > 1000000) select * from avg_slip_1k union select * from med_slip_1k union select * from avg_slip_10k union select * from med_slip_10k union select * from avg_slip_100k union select * from med_slip_100k union select * from avg_slip_500k union select * from med_slip_500k union select * from avg_slip_1m union select * from med_slip_1m union select * from avg_slip_1m_plus union select * from med_slip_1m_plus order by range

Swap Size vs Slippage on Thorchain