DATE | TX | TOTAL_TX | LIMIT_ORDER_TRADERS | |
|---|---|---|---|---|
1 | 2025-01-28 00:00:00.000 | 49 | 28273419 | 17 |
2 | 2025-01-27 00:00:00.000 | 185 | 28273370 | 49 |
3 | 2025-01-26 00:00:00.000 | 243 | 28273185 | 51 |
4 | 2025-01-25 00:00:00.000 | 280 | 28272942 | 58 |
5 | 2025-01-24 00:00:00.000 | 137 | 28272662 | 48 |
6 | 2025-01-23 00:00:00.000 | 152 | 28272525 | 72 |
7 | 2025-01-22 00:00:00.000 | 318 | 28272373 | 83 |
8 | 2025-01-21 00:00:00.000 | 118 | 28272055 | 62 |
9 | 2025-01-20 00:00:00.000 | 350 | 28271937 | 106 |
10 | 2025-01-19 00:00:00.000 | 458 | 28271587 | 159 |
11 | 2025-01-18 00:00:00.000 | 230 | 28271129 | 113 |
12 | 2025-01-17 00:00:00.000 | 52 | 28270899 | 32 |
13 | 2025-01-16 00:00:00.000 | 128 | 28270847 | 63 |
14 | 2025-01-15 00:00:00.000 | 321 | 28270719 | 58 |
15 | 2025-01-14 00:00:00.000 | 136 | 28270398 | 32 |
16 | 2025-01-13 00:00:00.000 | 84 | 28270262 | 38 |
17 | 2025-01-12 00:00:00.000 | 34 | 28270178 | 24 |
18 | 2025-01-11 00:00:00.000 | 85 | 28270144 | 32 |
19 | 2025-01-10 00:00:00.000 | 77 | 28270059 | 32 |
20 | 2025-01-09 00:00:00.000 | 76 | 28269982 | 43 |
JhanlycnJupiter LO Txs corrected
Updated 2025-01-28
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
select
date_trunc('day', block_timestamp) as date,
count(distinct tx_id) as tx,
sum(count(distinct tx_id)) over (
order by
date rows between unbounded preceding
and current row
) as total_tx,
count(distinct signers[0]) as limit_order_traders
from
solana.core.fact_events
where succeeded
and program_id = 'jupoNjAxXgZ4rjzxzPMP4oxduvQsQtZzyknqvzYNrNu'
group by
date
order by
date desc
Last run: 3 months agoAuto-refreshes every 24 hours
...
818
36KB
34s