SELECT

platform,

DATE_TRUNC('week', block_timestamp) AS week,

COUNT(DISTINCT swapper) AS unique_swappers

FROM

aptos.defi.ez_dex_swaps

WHERE

block_timestamp >= '2024-01-01'

AND block_timestamp < '2025-01-01'

AND (token_in = '0xf22bede237a07e121b56d91a491eb7bcdfd1f5907926a9e58338f964a01b17fa::asset::USDT'

OR token_out = '0xf22bede237a07e121b56d91a491eb7bcdfd1f5907926a9e58338f964a01b17fa::asset::USDT')

GROUP BY

platform, week

platform,

week,

unique_swappers,

LAG(unique_swappers) OVER (PARTITION BY platform ORDER BY week) AS previous_week_swappers,

ROUND((unique_swappers - COALESCE(LAG(unique_swappers) OVER (PARTITION BY platform ORDER BY week), 0)) / NULLIF(LAG(unique_swappers) OVER (PARTITION BY platform ORDER BY week), 0) * 100, 2) AS growth_rate

weekly_swappers

ORDER BY

platform, week;