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

'decrease Liquidity' AS Action,

sum(case

when TOKEN0_SYMBOL='WETH' then AMOUNT0_ADJUSTED

when TOKEN0_SYMBOL='WETH' then AMOUNT1_ADJUSTED

else null end) AS "ETH Amount",

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

max(case

when TOKEN0_SYMBOL='WETH' then AMOUNT0_ADJUSTED

when TOKEN0_SYMBOL='WETH' then AMOUNT1_ADJUSTED

else null end) AS "highest ETH withdarw",

count(distinct LIQUIDITY_PROVIDER) AS "distinct user number",

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

count(*) AS "Events number",

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

from ethereum.uniswapv3.ez_lp_actions

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

and ACTION='DECREASE_LIQUIDITY'

group by 1, 2