LIQUIDITY_POOL_ADDRESS | PROGRAM_ID | TOKEN_PAIR | DEPOSIT | WITHDRAW | TOTAL_TVL | TOTAL_TVL_USD | POOL_LINK | |
|---|---|---|---|---|---|---|---|---|
1 | 7dSpZ1dJH7J1NbGgrcfxSVfHBevRhG1hCWP7E2xpudAw | LBUZKhRxPF3XUpBCjp4YzTKgLccjZhTSDM9YuVaPwxo | 71N5uX79nSSpxRBoxmVmGgdszdAEtjfMt2mK37qCR6MG BILLY | ###,###,###.## | 0.00 | ###,###,###.## | 9.23 | Meteora: https://edge.meteora.ag/dlmm/7dSpZ1dJH7J1NbGgrcfxSVfHBevRhG1hCW... |
2 | BAgh7qdwRagQRh77cdFZzyjNaJWfWDVbKcNy8ZgxDgJk | LBUZKhRxPF3XUpBCjp4YzTKgLccjZhTSDM9YuVaPwxo | SMF SOL | ###,###,###.## | 0.00 | ###,###,###.## | 199.67 | Meteora: https://edge.meteora.ag/dlmm/BAgh7qdwRagQRh77cdFZzyjNaJWfWDVbKc... |
3 | 9CQnibp4h4J5QYQsGXXFKZeo4DM9Po1NDtbRfSKPoiA7 | LBUZKhRxPF3XUpBCjp4YzTKgLccjZhTSDM9YuVaPwxo | J2Hrg4SFoo3ju4Cm9mVAHw8k3pRBBwSiq8N8FW6k6fzJ USDC | ###,###,###.## | ###,###,###.## | ###,###,###.## | -571.86 | Meteora: https://edge.meteora.ag/dlmm/9CQnibp4h4J5QYQsGXXFKZeo4DM9Po1NDt... |
4 | 9TgDBnpVVqPFHv8hckK6vmWX8NjQocYJHbBYosGZfyYK | LBUZKhRxPF3XUpBCjp4YzTKgLccjZhTSDM9YuVaPwxo | RNA SOL | ###,###,###.## | ###,###,###.## | ###,###,###.## | 803.34 | Meteora: https://edge.meteora.ag/dlmm/9TgDBnpVVqPFHv8hckK6vmWX8NjQocYJHb... |
5 | pv7Ea9sgK8q4E7Qnp973PRidWrzAekXhd977Wcxdjqq | LBUZKhRxPF3XUpBCjp4YzTKgLccjZhTSDM9YuVaPwxo | SOL WLFI | ###,###,###.## | 0.00 | ###,###,###.## | 370.74 | Meteora: https://edge.meteora.ag/dlmm/pv7Ea9sgK8q4E7Qnp973PRidWrzAekXhd9... |
6 | GxgcUkdwr6eQdUAfhbwgx3FxeJmEsk8F5GvB4N6UJ2f4 | LBUZKhRxPF3XUpBCjp4YzTKgLccjZhTSDM9YuVaPwxo | SOLETF SOLETF | ###,###,###.## | ###,###,###.## | ###,###,###.## | 46.13 | Meteora: https://edge.meteora.ag/dlmm/GxgcUkdwr6eQdUAfhbwgx3FxeJmEsk8F5G... |
7 | EzoVg8ADenZCQ3QnojzdCxpCJZ6m7pJDT43LC8ctQG3m | LBUZKhRxPF3XUpBCjp4YzTKgLccjZhTSDM9YuVaPwxo | GpEgGjfYWy44aoHDNv7SZNUPQr1JjpqE4FVin3xstPvC USDC | ###,###,###.## | 0.00 | ###,###,###.## | 21.00 | Meteora: https://edge.meteora.ag/dlmm/EzoVg8ADenZCQ3QnojzdCxpCJZ6m7pJDT4... |
8 | 9xyMp3xu17s6oTHPJcdZzpB7bCgGWWCbcoDryQUw5R2U | LBUZKhRxPF3XUpBCjp4YzTKgLccjZhTSDM9YuVaPwxo | ADAM SOL | ###,###,###.## | ###,###,###.## | ###,###,###.## | -321.44 | Meteora: https://edge.meteora.ag/dlmm/9xyMp3xu17s6oTHPJcdZzpB7bCgGWWCbco... |
9 | HFpL6WtuCjB41PKZuyJ3Q1n6zJm5smzE7WfNQP8wDZXR | LBUZKhRxPF3XUpBCjp4YzTKgLccjZhTSDM9YuVaPwxo | DNA SOL | ###,###,###.## | ###,###,###.## | ###,###,###.## | -495.19 | Meteora: https://edge.meteora.ag/dlmm/HFpL6WtuCjB41PKZuyJ3Q1n6zJm5smzE7W... |
10 | 2PTyoMnW3qkDQJqvRa1FydDLsNPJqqUWhZKbzNrj3wuj | LBUZKhRxPF3XUpBCjp4YzTKgLccjZhTSDM9YuVaPwxo | D.O.G.E SOL | ###,###,###.## | ###,###,###.## | ###,###,###.## | 752.88 | Meteora: https://edge.meteora.ag/dlmm/2PTyoMnW3qkDQJqvRa1FydDLsNPJqqUWhZ... |
11 | 9n9GRRYzX5ED1VMxqXgp9iKYzpatHXPgQ6XcmWePkDxh | LBUZKhRxPF3XUpBCjp4YzTKgLccjZhTSDM9YuVaPwxo | H4RLHiehZo8cwd7KntPFApsvunmBagaWjcdHZx8YFhdp SOL | ###,###,###.## | ###,###,###.## | ###,###,###.## | -830.17 | Meteora: https://edge.meteora.ag/dlmm/9n9GRRYzX5ED1VMxqXgp9iKYzpatHXPgQ6... |
12 | T3cND6njDXkYykfTNCGKwPqbcuG6bybwhbgpgBxzmKU | LBUZKhRxPF3XUpBCjp4YzTKgLccjZhTSDM9YuVaPwxo | D.O.G.E. MAGASHIB | ###,###,###.## | 0.00 | ###,###,###.## | 30.83 | Meteora: https://edge.meteora.ag/dlmm/T3cND6njDXkYykfTNCGKwPqbcuG6bybwhb... |
13 | AthWxi5ycdRwuNuZ6JqBt3A8dW4i2AtKeRdSWQd7fouT | LBUZKhRxPF3XUpBCjp4YzTKgLccjZhTSDM9YuVaPwxo | MAGADOGE WYAC | ###,###,###.## | 85,305,921.93 | ###,###,###.## | 25.14 | Meteora: https://edge.meteora.ag/dlmm/AthWxi5ycdRwuNuZ6JqBt3A8dW4i2AtKeR... |
14 | 7JkiKtWL6bRFCpc4ansGfRqSB3ZYbzjyRzfBTR4fxpHp | LBUZKhRxPF3XUpBCjp4YzTKgLccjZhTSDM9YuVaPwxo | 5NSLkhKomR9YUE99W9i9xbxwuoCvqEXwEhAAeN2mpump Fefecfi5DhahY51XqQTP2qjFGhn... | ###,###,###.## | ###,###,###.## | ###,###,###.## | 0.00 | Meteora: https://edge.meteora.ag/dlmm/7JkiKtWL6bRFCpc4ansGfRqSB3ZYbzjyRz... |
15 | 6U5hQisguTzk6RFLLHDDPbPKD3hqAMScyRitCBNSwHQ4 | LBUZKhRxPF3XUpBCjp4YzTKgLccjZhTSDM9YuVaPwxo | Fefecfi5DhahY51XqQTP2qjFGhnuoSjrVivL6k9Ercw6 KIRA | ###,###,###.## | ###,###,###.## | ###,###,###.## | -96.95 | Meteora: https://edge.meteora.ag/dlmm/6U5hQisguTzk6RFLLHDDPbPKD3hqAMScyR... |
16 | 8RrtD37DPWSgojZRyypC8RzdCVuvekYvUo6quCbGBXXX | LBUZKhRxPF3XUpBCjp4YzTKgLccjZhTSDM9YuVaPwxo | DJT SOL | ###,###,###.## | ###,###,###.## | ###,###,###.## | -1.97 | Meteora: https://edge.meteora.ag/dlmm/8RrtD37DPWSgojZRyypC8RzdCVuvekYvUo... |
17 | 3mmZropfkWw4C7f3YxLXVwqvqPBPaEcSm9aHGkzUW3yj | LBUZKhRxPF3XUpBCjp4YzTKgLccjZhTSDM9YuVaPwxo | USDC ei4iaEcXx51X2hwVrMR1dkuetiaZNYGqEp7CCbDag3K | ###,###,###.## | 0.00 | ###,###,###.## | 0.00 | Meteora: https://edge.meteora.ag/dlmm/3mmZropfkWw4C7f3YxLXVwqvqPBPaEcSm9... |
18 | 2GkmS8Z8oYN52MMYFJfjRrA4Mp47jfkXTkK5d2eGhcrF | LBUZKhRxPF3XUpBCjp4YzTKgLccjZhTSDM9YuVaPwxo | 7wcnnmEwS6sjdaN7o7cxAXYbRCmqerSUJv1sPUtg2xdd MAGADOGE | ###,###,###.## | ###,###,###.## | ###,###,###.## | 20.32 | Meteora: https://edge.meteora.ag/dlmm/2GkmS8Z8oYN52MMYFJfjRrA4Mp47jfkXTk... |
19 | 9Ap7yU7Z68xHy1xEcM98as8EeEX6j5qdvsoequBKnRzN | LBUZKhRxPF3XUpBCjp4YzTKgLccjZhTSDM9YuVaPwxo | Fefecfi5DhahY51XqQTP2qjFGhnuoSjrVivL6k9Ercw6 SWARM | ###,###,###.## | ###,###,###.## | ###,###,###.## | 412.66 | Meteora: https://edge.meteora.ag/dlmm/9Ap7yU7Z68xHy1xEcM98as8EeEX6j5qdvs... |
20 | 4uF3pBJFdy2XoGQpwgJEqGd8rgmRb81M3TuV2qzcR2QA | LBUZKhRxPF3XUpBCjp4YzTKgLccjZhTSDM9YuVaPwxo | MOLECULE SOL | ###,###,###.## | ###,###,###.## | ###,###,###.## | -320.21 | Meteora: https://edge.meteora.ag/dlmm/4uF3pBJFdy2XoGQpwgJEqGd8rgmRb81M3T... |
HitmonleeCryptoconservative-magenta
Updated 2025-02-02
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 agg AS (
SELECT
liquidity_pool_address,
program_id,
mint,
SUM(CASE WHEN action = 'addLiquidityByStrategy' THEN amount ELSE 0 END) AS total_added,
SUM(CASE WHEN action = 'removeLiquidityByRange' THEN amount ELSE 0 END) AS total_removed,
SUM(CASE WHEN action = 'addLiquidityByStrategy' THEN amount ELSE 0 END)
- SUM(CASE WHEN action = 'removeLiquidityByRange' THEN amount ELSE 0 END) AS tvl
FROM solana.defi.fact_liquidity_pool_actions
WHERE succeeded = true
AND program_id IN (
'9W959DqEETiGZocYWCQPaJ6sBmUzgfxXfqGeTEdp3aQP', -- Orca v2 Program ID
'whirLbMiicVdio4qvUfM5KAg6Ct8VwpYzGff3uctyCc', -- Orca Whirlpool Program ID
'675kPX9MHTjS2zt1qfr1NYHuzeLXfQM9H24wFSUt1Mp8', -- Raydium V4 Program ID
'CAMMCzo5YL8w4VFF8KVHrK22GGUsp5VTaW7grrKgrWqK', -- Raydium CLMM Program ID
'CPMMoo8L3F4NbTegBCKVNunggL7H1ZpdTHKxQB5qKP1C', -- Raydium CPMM Program ID
'LBUZKhRxPF3XUpBCjp4YzTKgLccjZhTSDM9YuVaPwxo', -- Meteora DLMM Program
'Eo7WjKq67rjJQSZxS6z3YkapzY3eMj6Xy8X5EQVn5UaB', -- Dynamic AMM Pools Program
'FEESngU3neckdwib9X3KWqdL7Mjmqk9XNp3uh5JbP4KP', -- M3M3 Stake-for-Fee Program
'24Uqj9JCLxUeoC3hGfh5W3s9FM9uCHDS2SG3LYwBpyTi', -- Vault Program
'FarmuwXPWXvefWUeqFAa5w6rifLkq5X6E8bimYvrhCB1', -- Farm Program
'vaU6kP7iNEGkbmPkLmZfGwiGxd4Mob24QQCie5R9kd2' -- Meteora DLMM Vault Program
)
GROUP BY liquidity_pool_address, program_id, mint
),
latest_prices AS (
SELECT
token_address,
symbol,
name,
price,
ROW_NUMBER() OVER (PARTITION BY token_address ORDER BY hour DESC) AS rn
FROM solana.price.ez_prices_hourly
),
agg_with_price AS (
Last run: 2 months ago
20
5KB
14s