date(block_timestamp) as date,

avg(token0_usd) as asset1_usd,

avg(token1_usd) as asset2_usd,

token0_usd + token1_usd as pool_tvl_usd

FROM uniswapv3.pool_stats

GROUP BY 1,2