SELECT pool_address

, pool_name

, block_timestamp::date AS utc_date

, token0_balance_usd + token1_balance_usd AS tvl_usd

FROM ethereum.uniswapv3.ez_pool_stats

WHERE pool_address = '{{PoolAddress}}'

AND block_timestamp >= '{{StartDate}}'

AND (CASE WHEN '{{EndDate}}' = 'Today' THEN True

ELSE block_timestamp <= '{{EndDate}} 23:59:59.999' END)

QUALIFY row_number() OVER (partition by pool_address, block_timestamp::date

order by block_timestamp desc) = 1

ORDER BY utc_date DESC

LIMIT 10000