SELECT

DATE_TRUNC('day', BLOCK_TIMESTAMP) AS Date,

COUNT (DISTINCT TX_HASH) AS swaps,

COUNT(DISTINCT SWAPPER) AS swappers,

SUM(COALESCE(AMOUNT_IN_USD, AMOUNT_OUT_USD)) AS swap_Volume

FROM aptos.defi.ez_dex_swaps

WHERE EVENT_ADDRESS='0x48271d39d0b05bd6efca2278f22277d6fcc375504f9839fd73f74ace240861af'

GROUP by 1

Date,

swaps,

LAG(swaps) OVER (ORDER BY Date) AS Previous_day_swaps,

((swaps - LAG(swaps) OVER (ORDER BY date)) / LAG(swaps) OVER (ORDER BY date)) * 100 Swaps_Perc_diff,

swappers,

LAG(swappers) OVER (ORDER BY Date) AS Previous_day_swappers,

((swappers - LAG(swappers) OVER (ORDER BY date)) / LAG(swappers) OVER (ORDER BY date)) * 100 Swappers_Perc_diff,

swap_Volume,

LAG(swap_Volume) OVER (ORDER BY Date) AS Previous_day_swap_volume,

((swap_Volume - LAG(swap_Volume) OVER (ORDER BY date)) / LAG(swap_Volume) OVER (ORDER BY date)) * 100 Swap_volume_Perc_diff

FROM Stats

ORDER BY date DESC