SELECT

origin_from_address AS SwapperAddress,

platform AS PlatformName,

SUM(amount_in_usd) AS TotalVolumeUSD

FROM

polygon.defi.ez_dex_swaps

WHERE

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

GROUP BY

origin_from_address, platform

PlatformName AS TradingPlatform,

COUNT(DISTINCT SwapperAddress) AS TotalDistinctTraders,

SUM(TotalVolumeUSD) AS TotalVolumeUSD

platform_volume

GROUP BY

PlatformName

ORDER BY

TotalVolumeUSD DESC;