HOUR | SWAPS | TRADERS | VOLUME_USD | |
|---|---|---|---|---|
1 | 2025-03-22 15:00:00.000 | 25563 | 14489 | 1437520.42639395 |
2 | 2025-03-22 00:00:00.000 | 28344 | 6330 | 2228689.19396375 |
3 | 2025-03-26 18:00:00.000 | 85343 | 55265 | 5038338.49616444 |
4 | 2025-03-21 07:00:00.000 | 5019 | 2192 | 387046.578304597 |
5 | 2025-03-22 18:00:00.000 | 26885 | 8223 | 2434860.831473 |
6 | 2025-03-23 05:00:00.000 | 40722 | 15713 | 3360759.31786583 |
7 | 2025-03-20 20:00:00.000 | 11649 | 4672 | 667597.256365591 |
8 | 2025-03-25 14:00:00.000 | 57107 | 23399 | 3508698.15738876 |
9 | 2025-03-21 19:00:00.000 | 53182 | 46960 | 606907.3808901 |
10 | 2025-03-24 07:00:00.000 | 86036 | 57006 | 4217067.2962715 |
11 | 2025-03-21 08:00:00.000 | 4466 | 1980 | 404595.139845638 |
12 | 2025-03-25 04:00:00.000 | 110725 | 67307 | 6096544.04318989 |
13 | 2025-03-25 13:00:00.000 | 43622 | 13993 | 5168923.89260204 |
14 | 2025-03-22 19:00:00.000 | 27280 | 15833 | 1453933.46725391 |
15 | 2025-03-24 19:00:00.000 | 160672 | 90780 | 17017397.9118182 |
16 | 2025-03-25 15:00:00.000 | 91159 | 33244 | 7414205.12416568 |
17 | 2025-03-27 02:00:00.000 | 49157 | 13085 | 5802458.29992653 |
18 | 2025-03-29 23:00:00.000 | 91341 | 22843 | 4365748.67740223 |
19 | 2025-03-22 12:00:00.000 | 21365 | 7950 | 1747255.15409435 |
20 | 2025-03-29 01:00:00.000 | 54302 | 15450 | 3594684.32495542 |
Pine Analyticspump.fun dex v1 copy copy
Updated 3 days 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 tab1 AS (
SELECT
tx_id,
block_timestamp,
signers[0] AS trader,
inner_instruction['instructions'][0]['parsed']['info']['mint'] AS token_in,
inner_instruction['instructions'][0]['parsed']['info']['tokenAmount']['uiAmount'] AS amount_in,
inner_instruction['instructions'][1]['parsed']['info']['mint'] AS token_out,
inner_instruction['instructions'][1]['parsed']['info']['tokenAmount']['uiAmount'] AS amount_out
FROM solana.core.fact_events
WHERE program_id = 'pAMMBay6oceH9fJKBRHGP5D4bD4sWpmSwMn52FMfXEA'
AND succeeded
AND ARRAY_SIZE(instruction['accounts']) = 17
AND amount_in IS NOT NULL
AND amount_out IS NOT NULL
AND inner_instruction['instructions'][1]['parsed']['info']['mint'] IS NOT NULL
and block_timestamp > '2025-02-20'
union all
select
tx_id,
block_timestamp,
signers[0] as trader,
inner_instruction['instructions'][5]['parsed']['info']['mint'] as token_in,
inner_instruction['instructions'][5]['parsed']['info']['tokenAmount']['uiAmount'] as amount_in,
inner_instruction['instructions'][6]['parsed']['info']['mint'] as token_out,
inner_instruction['instructions'][6]['parsed']['info']['tokenAmount']['uiAmount'] as amount_out
from solana.core.fact_events
where program_id like 'pAMMBay6oceH9fJKBRHGP5D4bD4sWpmSwMn52FMfXEA'
and SUCCEEDED
and ARRAY_SIZE(INSTRUCTION['accounts']) = 17
and inner_instruction['instructions'][0]['parsed']['info']['mint'] = inner_instruction['instructions'][1]['parsed']['info']['mint']
and block_timestamp > '2025-02-20'
Last run: 3 days ago
...
232
13KB
17s