SELECT

DATE_TRUNC('day', block_timestamp) AS day,

SUM(amount_in_usd) AS daily_volume

FROM aptos.defi.ez_dex_swaps

WHERE

block_timestamp >= '2024-01-01'

AND block_timestamp < '2024-02-01'

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

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

GROUP BY day

day,

daily_volume,

LAG(daily_volume) OVER (ORDER BY day) AS previous_day_volume,

ROUND(

(daily_volume - LAG(daily_volume) OVER (ORDER BY day))

/ NULLIF(LAG(daily_volume) OVER (ORDER BY day), 0) * 100, 2

) AS growth_percentage

FROM volume_growth

ORDER BY day DESC;