DATE | CUMULATIVE_SOL_STUCK | |
|---|---|---|
1 | 2024-10-02 00:00:00.000 | 681733.191138665 |
2 | 2025-02-01 00:00:00.000 | 2200319.02167507 |
3 | 2025-03-11 00:00:00.000 | 2427902.85691013 |
4 | 2025-02-28 00:00:00.000 | 2386510.81491151 |
5 | 2024-08-05 00:00:00.000 | 516909.892934522 |
6 | 2024-08-14 00:00:00.000 | 558169.762619843 |
7 | 2024-10-12 00:00:00.000 | 749644.382963201 |
8 | 2024-09-27 00:00:00.000 | 649704.772913761 |
9 | 2024-09-10 00:00:00.000 | 602055.532467989 |
10 | 2024-02-15 00:00:00.000 | 356.477186652 |
11 | 2024-07-11 00:00:00.000 | 409121.69762741 |
12 | 2025-01-14 00:00:00.000 | 1899907.00156964 |
13 | 2025-02-18 00:00:00.000 | 2352260.45427258 |
14 | 2024-12-23 00:00:00.000 | 1639440.62490352 |
15 | 2024-08-28 00:00:00.000 | 579393.285403016 |
16 | 2024-04-19 00:00:00.000 | 71465.458133117 |
17 | 2024-12-07 00:00:00.000 | 1462109.88395747 |
18 | 2024-10-23 00:00:00.000 | 883012.50612523 |
19 | 2024-06-25 00:00:00.000 | 340388.489812459 |
20 | 2024-04-26 00:00:00.000 | 82448.969723437 |
blocmates researchCumulative SOL locked in Pump.fun LPs
Updated 3 days ago
999
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 pools_information AS (
SELECT
t.block_timestamp,
t.TX_ID,
MAX(
CASE
WHEN acc.value:name = 'amm' THEN acc.value:pubkey
END
) AS pool_Address,
MAX(
CASE
WHEN acc.value:name = 'poolCoinTokenAccount' THEN acc.value:pubkey
END
) AS poolsolTokenAccount,
MAX(
CASE
WHEN acc.value:pubkey = 'So11111111111111111111111111111111111111112'
AND acc.value:name = 'pcMint' THEN t.DECODED_INSTRUCTION:args:initPcAmount
WHEN acc.value:pubkey = 'So11111111111111111111111111111111111111112'
AND acc.value:name = 'coinMint' THEN t.DECODED_INSTRUCTION:args:initCoinAmount
ELSE NULL
END
) / pow(10, 9) AS sol_amount
FROM
solana.core.ez_events_decoded t,
TABLE(FLATTEN(input => t.DECODED_INSTRUCTION:accounts)) AS acc
WHERE
t.SIGNERS [0] IN (
'39azUYFWPz3VHgKCf3VChUwbpURdCHRxjWVowf5jUJjg',
'5PXxuZkvftsg5CAGjv5LL5tEtvBRskdx1AAjxw8hK2Qx',
'7ihN8QaTfNoDTRTQGULCzbUT3PHwPDTu5Brcu4iT2paP',
'DCpJReAfonSrgohiQbTmKKbjbqVofspFRHz9yQikzooP'
)
AND t.event_type = 'initialize2'
AND block_id >= 243310797
GROUP BY
Last run: 3 days ago
...
416
18KB
657s