date_trunc('{{Timeframe}}', BLOCK_TIMESTAMP) AS date,

case

when TOKEN0_SYMBOL='WETH' then AMOUNT0_ADJUSTED

when TOKEN0_SYMBOL='WETH' then AMOUNT1_ADJUSTED

else null end AS Amount,

tx_hash

from ethereum.uniswapv3.ez_lp_actions

where date between '2022-07-15' and '2022-09-15'

and ACTION='DECREASE_LIQUIDITY')

select

date,

count(*) AS "events number",

avg("events number") over (order by date, date rows between 6 preceding and current row) as "7 day MA"

from tb where Amount >= 1000

group by 1