t

as (

select BLOCK_TIMESTAMP,

TX_HASH,

ACTION,

LIQUIDITY_PROVIDER,

POOL_NAME,

case when TOKEN0_SYMBOL = 'WETH' then AMOUNT0_ADJUSTED when TOKEN1_SYMBOL = 'WETH' then AMOUNT1_ADJUSTED end as Amount

from ethereum.uniswapv3.ez_lp_actions

where (TOKEN0_SYMBOL = 'WETH' or TOKEN1_SYMBOL = 'WETH')

and BLOCK_TIMESTAMP::DATE >= '2022-07-01' and BLOCK_TIMESTAMP::DATE < CURRENT_DATE and Amount > 0

),

D

as

(

select

date_trunc('day', block_timestamp) as day,

sum(Amount) as eth_amount,

count(distinct TX_HASH) as d_txCount,

count(distinct LIQUIDITY_PROVIDER) as Depositors

from t