PLATFORM | POOL_NAME | POOL_ADDRESS | PAIRED_TOKEN_SYMBOL | CURRENT_LIQUIDITY_USD | |
|---|---|---|---|---|---|
1 | meteora | TITCOIN-SOL | 6GaSinNQ2EmRUJpD4Y9Z7dWHKJibBpvVAADnjcSNZXjb | SOL | 8732.33526772 |
2 | meteora | TITCOIN-SOL | 6GaSinNQ2EmRUJpD4Y9Z7dWHKJibBpvVAADnjcSNZXjb | 8732.33526772 | |
3 | orca | SOL-TITCOIN | J4P6jbFfLknYZu4eJY2ZCwqareu7wDrE5fCkPg8sY8mt | SOL | 3026.4192798 |
4 | raydium | TITCOIN-TITSHARE | CkkWhNhuZmebxMbhXZHXwymHKNBv5hxLAvtec7A5Zd2h | TITSHARE | 18.61765281 |
defi__josh$TITCOIN token trading pairs and their liquidity
Updated 1 day ago
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
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')
)
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' 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
Last run: 1 day ago
4
376B
4s