keean82decisive-gold
Updated 2024-08-24
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
›
⌄
WITH token_l AS (
SELECT
tx_id,
mint as token,
amount as token_amount
FROM
solana.defi.fact_liquidity_pool_actions
WHERE
mint != 'So11111111111111111111111111111111111111112'
)
SELECT
s.tx_id,
s.mint as sol,
s.amount as sol_amount,
t.token,
t.token_amount
FROM
solana.defi.fact_liquidity_pool_actions s
JOIN
token_l t ON t.tx_id = s.tx_id
WHERE
s.mint = 'So11111111111111111111111111111111111111112'
AND t.token != 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v'
LIMIT 10;
QueryRunArchived: QueryRun has been archived