Month,

((NewValue - PreviousValue) / PreviousValue) * 100 AS GrowthRate

Month,

NewValue,

LAG(NewValue) OVER (ORDER BY Month) AS PreviousValue

date_trunc('month',block_timestamp) as month,

count(user_wallet_address) as NewValue

FROM (SELECT

BLOCK_TIMESTAMP,

ORIGIN_FROM_ADDRESS as user_wallet_address,

'swapping' as EVENT_NAME,

AMOUNT_IN_USD,

AMOUNT_OUT_USD,

PLATFORM,

SYMBOL_IN,

SYMBOL_out,

RANK() OVER (partition by ORIGIN_FROM_ADDRESS order by BLOCK_TIMESTAMP asc)as rank

FROM ethereum.core.ez_dex_swaps

where platform in ('uniswap-v2','uniswap-v3'))

WHERE rank=1 and BLOCK_TIMESTAMP>=current_date-365

GROUP BY month))

WHERE GrowthRate is not NULL