block_timestamp::date as day,

sum(liquidity) as total_liquidity,

count(distinct sender) as number_of_users,

count(distinct tx_hash) as number_of_transactions,

split(pool_name, ' ')[0] as pool_names

from ethereum.uniswapv3.ez_swaps

where day >= CURRENT_DATE - 52

and day < CURRENT_DATE - 1

group by day, pool_name