select
date_trunc('day',block_timestamp) as block_day,
action,
count(distinct(liquidity_provider)),
sum(amount0_usd),
sum(amount1_usd)
from uniswapv3.lp_actions
where block_day >= '2021-11-13'
and pool_name like 'USDC-USDT%'
group by block_day,action
order by block_day