SELECT

platform AS PlatformName,

symbol_in AS TokenIn,

symbol_out AS TokenOut,

(

ABS(amount_in_usd - amount_out_usd) / amount_in_usd

) * 100 AS SlippagePercentage,

block_timestamp

FROM

polygon.defi.ez_dex_swaps

WHERE

amount_in_usd IS NOT NULL

AND amount_out_usd IS NOT NULL

AND amount_in_usd != 0

AND block_timestamp >= DATEADD(MONTH, -3, CURRENT_DATE)

PlatformName AS Platform,

TokenIn AS SymbolIn,

TokenOut AS SymbolOut,

AVG(SlippagePercentage) AS AvgSlippage

slippage_by_platform

GROUP BY

Platform,

SymbolIn,

SymbolOut

AVG(SlippagePercentage) < 100

ORDER BY

AvgSlippage DESC

20;