date_trunc('day',l.block_timestamp) as day,

pool_name,

count(liquidity_provider, tick_lower, tick_upper, liquidity_adjusted) as pos_changes, -- position changes

sum(fee_usd) as gas_fees

FROM uniswapv3.lp_actions l

INNER JOIN ethereum.transactions t on t.tx_id = l.tx_id

WHERE l.block_timestamp >= getdate() - interval '1 month'

GROUP BY 1, 2

HAVING pos_changes > 50

ORDER BY day