with swaps as ( select swap_in.block_timestamp::date as date, swap_in.amount_usd as amin, swap_out.amount_usd as amout, amin-amout as difference, case when difference = 0 then 0 else abs((difference/amin)*100) end as slippage, swap_in.platform from ethereum.dex_swaps swap_in join ethereum.dex_swaps swap_out on swap_in.tx_id = swap_out.tx_id where swap_in.platform in ('sushiswap','uniswap-v3') and swap_in.pool_address in ('0x6a091a3406e0073c3cd6340122143009adac0eda', '0x397ff1542f962076d0bfe58ea045ffa2d347aca0', '0xe12af1218b4e9272e9628d7c7dc6354d137d024e', '0xd4e7a6e2d03e4e48dfc27dd3f46df1c176647e38', '0xceff51756c56ceffca006cd410b03ffc46dd3a58', '0x8ad599c3a0ff1de082011efddc58f1908eb6e6d8', '0x5777d92f208679db4b9778590fa3cab3ac9e2168', '0xcbcdf9626bc03e24f779434178a73a0b4bad62ed', '0x88e6a0c2ddd26feeb64f039a2c41296fcb3f5640', '0xc63b0708e2f7e69cb8a1df0e1389a98c35a76d52') and swap_in.amount_usd > 0 and swap_in.direction = 'IN' and swap_out.platform in ('sushiswap','uniswap-v3') and swap_out.pool_address in ('0x6a091a3406e0073c3cd6340122143009adac0eda', '0x397ff1542f962076d0bfe58ea045ffa2d347aca0', '0xe12af1218b4e9272e9628d7c7dc6354d137d024e', '0xd4e7a6e2d03e4e48dfc27dd3f46df1c176647e38', '0xceff51756c56ceffca006cd410b03ffc46dd3a58', '0x8ad599c3a0ff1de082011efddc58f1908eb6e6d8', '0x5777d92f208679db4b9778590fa3cab3ac9e2168', '0xcbcdf9626bc03e24f779434178a73a0b4bad62ed', '0x88e6a0c2ddd26feeb64f039a2c41296fcb3f5640', '0xc63b0708e2f7e69cb8a1df0e1389a98c35a76d52') and swap_out.amount_usd > 0 and swap_out.direction = 'OUT' and datediff(month,date,current_date) < 3 ) select platform, case when slippage < 10 then '0-10' when slippage < 20 then '10-20' when slippage < 30 then '20-30' when slippage < 40 then '30-40' when slippage < 50 then '40-50' when slippage < 60 then '50-60' when slippage < 70 then '60-70' when slippage < 80 then '70-80' when slippage < 90 then '80-90' when slippage < 100 then '90-100' else '>100' end as slippage_bucket, count(*) from swaps group by 1,2 order by 1

Slippery Slippage