DAY | TRADE_EVENTS | TRADERS | VOLUME_USD | |
|---|---|---|---|---|
1 | 2025-03-02 00:00:00.000 | 6114 | 947 | 307917.168988 |
2 | 2025-03-04 00:00:00.000 | 3090 | 533 | 170920.39655 |
3 | 2025-03-05 00:00:00.000 | 3421 | 505 | 184832.097184 |
4 | 2025-02-24 00:00:00.000 | 9671 | 963 | 1233917.174651 |
5 | 2025-03-09 00:00:00.000 | 1833 | 322 | 141236.968703 |
6 | 2025-03-01 00:00:00.000 | 8565 | 1159 | 556036.201242 |
7 | 2025-02-28 00:00:00.000 | 2921 | 640 | 111827.715354 |
8 | 2025-03-07 00:00:00.000 | 4618 | 629 | 444957.779309 |
9 | 2025-02-26 00:00:00.000 | 5925 | 1691 | 516772.795225 |
10 | 2025-03-08 00:00:00.000 | 1399 | 182 | 40121.732398 |
11 | 2025-03-03 00:00:00.000 | 7817 | 1012 | 500172.585155 |
12 | 2025-02-27 00:00:00.000 | 1630 | 456 | 58094.130067 |
13 | 2025-03-10 00:00:00.000 | 347 | 73 | 14685.663598 |
14 | 2025-03-06 00:00:00.000 | 1941 | 296 | 86118.411878 |
15 | 2025-02-25 00:00:00.000 | 29204 | 3948 | 3547655.333068 |
Pine AnalyticsTime.fun trade 1-1
Updated 1 day 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 tab1 as (
select
block_timestamp,
tx_id,
signers[1] as trader,
'sell' as tx_type,
INNER_INSTRUCTION['instructions'][0]['parsed']['info']['mint'] as token,
INNER_INSTRUCTION['instructions'][3]['parsed']['info']['tokenAmount']['uiAmount'] as volume_usd
from solana.core.fact_events
where program_id like 'BcyCjbQYxE2m2xTZ5tTZXDEz8Up7avTmPqhzCrASRKiQ'
and ARRAY_SIZE(instruction['accounts']) = 17
and ARRAY_SIZE(SIGNERS) = 2
and SUCCEEDED
and block_timestamp > '2025-02-20'
and ARRAY_SIZE(INNER_INSTRUCTION['instructions']) = 4
union all
select
block_timestamp,
tx_id,
signers[1] as trader,
'buy' as tx_type,
INNER_INSTRUCTION['instructions'][5]['parsed']['info']['mint'] as token,
INNER_INSTRUCTION['instructions'][4]['parsed']['info']['tokenAmount']['uiAmount'] as volume_usd
from solana.core.fact_events
where program_id like 'BcyCjbQYxE2m2xTZ5tTZXDEz8Up7avTmPqhzCrASRKiQ'
and ARRAY_SIZE(instruction['accounts']) = 17
and ARRAY_SIZE(SIGNERS) = 2
and SUCCEEDED
and block_timestamp > '2025-02-20'
and ARRAY_SIZE(INNER_INSTRUCTION['instructions']) = 6
union all
Last run: 1 day ago
15
766B
7s