SELECT

pool_address,

pool_name,

liquidity

FROM ethereum.uniswapv3.ez_lp_actions

QUALIFY ROW_NUMBER() OVER (PARTITION BY POOL_ADDRESS ORDER BY BLOCK_TIMESTAMP DESC) = 1

SELECT * FROM MAIN LIMIT 100