SELECT DISTINCT

pool_address,

pool_name,

platform,

token_a_mint,

token_a_symbol,

token_b_mint,

token_b_symbol

FROM solana.defi.ez_liquidity_pool_actions

WHERE block_timestamp >= DATEADD('day', -30, CURRENT_TIMESTAMP())

AND (token_a_mint = '9BB6NFEcjBCtnNLFko2FqVQBq8HHM13kCyYcdQbgpump'

OR token_b_mint = '9BB6NFEcjBCtnNLFko2FqVQBq8HHM13kCyYcdQbgpump')

SELECT

p.platform,

p.pool_name,

p.pool_address,

CASE

WHEN p.token_a_mint = '9BB6NFEcjBCtnNLFko2FqVQBq8HHM13kCyYcdQbgpump'

THEN p.token_b_symbol

ELSE p.token_a_symbol

END as paired_token_symbol,

SUM(CASE

WHEN lpa.action_type = 'deposit' THEN

COALESCE(lpa.token_a_amount_usd, 0) + COALESCE(lpa.token_b_amount_usd, 0)

WHEN lpa.action_type = 'withdraw' THEN

-1 * (COALESCE(lpa.token_a_amount_usd, 0) + COALESCE(lpa.token_b_amount_usd, 0))

ELSE 0

END) as current_liquidity_usd

FROM pool_info p

LEFT JOIN solana.defi.ez_liquidity_pool_actions lpa

ON p.pool_address = lpa.pool_address

AND lpa.block_timestamp >= DATEADD('day', -30, CURRENT_TIMESTAMP())

GROUP BY 1,2,3,4