Total $TITCOIN locked in pools

defi__joshTotal $TITCOIN locked in pools

Updated 2 days ago

-- forked from $TITCOIN token trading pairs and their liquidity @ https://flipsidecrypto.xyz/studio/queries/69bfe164-cb5c-4a1b-8912-9294d31f5b2c

WITH pool_info AS (

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 = 'FtUEW73K6vEYHfbkfpdBZfWpxgQar2HipGdbutEhpump'

OR token_b_mint = 'FtUEW73K6vEYHfbkfpdBZfWpxgQar2HipGdbutEhpump')

pool_liquidity AS (

SELECT

p.platform,

p.pool_name,

p.pool_address,

CASE

WHEN p.token_a_mint = 'FtUEW73K6vEYHfbkfpdBZfWpxgQar2HipGdbutEhpump'

THEN p.token_b_symbol

ELSE p.token_a_symbol

END as paired_token_symbol,

SUM(CASE

WHEN lpa.action_type = 'deposit' AND p.token_a_mint = 'FtUEW73K6vEYHfbkfpdBZfWpxgQar2HipGdbutEhpump'

THEN COALESCE(lpa.token_a_amount, 0)

WHEN lpa.action_type = 'deposit' AND p.token_b_mint = 'FtUEW73K6vEYHfbkfpdBZfWpxgQar2HipGdbutEhpump'

THEN COALESCE(lpa.token_b_amount, 0)

WHEN lpa.action_type = 'withdraw' AND p.token_a_mint = 'FtUEW73K6vEYHfbkfpdBZfWpxgQar2HipGdbutEhpump'

THEN -1 * COALESCE(lpa.token_a_amount, 0)

WHEN lpa.action_type = 'withdraw' AND p.token_b_mint = 'FtUEW73K6vEYHfbkfpdBZfWpxgQar2HipGdbutEhpump'

THEN -1 * COALESCE(lpa.token_b_amount, 0)

Last run: 2 days ago

581B