with pool as (

SELECT

date_trunc('week',block_timestamp) as day,

pool_name,

-- action,

token0_symbol,

token1_symbol,

COUNT(DISTINCT tx_hash) as p_txns,

COUNT(DISTINCT liquidity_provider) AS p_lps,

COUNT(DISTINCT nf_position_manager_address) as p_pm,

SUM(amount0_adjusted) as t0_pool_adjusted,

SUM(amount1_adjusted) as t1_pool_adjusted

FROM (

SELECT

f.block_timestamp,

f.tx_hash,

f.pool_name,

f.action,

f.liquidity_provider,

f.nf_position_manager_address,

f.token0_symbol,

f.token1_symbol,

f.amount0_adjusted,

f.amount1_adjusted

FROM ethereum.uniswapv3.ez_lp_actions f

WHERE f.pool_address = LOWER('{{pool_address}}')

ORDER BY 1 DESC

)

GROUP BY 1,2,3,4

ORDER BY 1 DESC

),

vault as (