select

liquidity_pool_address, count(*), max(tx_id), min(tx_id)

from solana.defi.fact_liquidity_pool_actions

where block_timestamp > '2024-08-01'

group by liquidity_pool_address