TIME | TXS | PLAYERS | ACTION | |
|---|---|---|---|---|
1 | 2025-02-09 00:00:00.000 | 8081 | 1179 | New game 🏁 |
2 | 2025-01-26 00:00:00.000 | 290 | 77 | New game 🏁 |
3 | 2025-01-28 00:00:00.000 | 1489 | 26 | Stack 🧱 |
4 | 2025-02-09 00:00:00.000 | 163278 | 1179 | Stack 🧱 |
5 | 2025-02-17 00:00:00.000 | 2752 | 593 | End game ✋ |
6 | 2025-01-23 00:00:00.000 | 873 | 153 | End game ✋ |
7 | 2025-01-19 00:00:00.000 | 13 | 3 | End game ✋ |
8 | 2025-01-19 00:00:00.000 | 264 | 3 | Stack 🧱 |
9 | 2025-02-26 00:00:00.000 | 1221 | 405 | New game 🏁 |
10 | 2025-02-24 00:00:00.000 | 1892 | 517 | New game 🏁 |
11 | 2025-03-05 00:00:00.000 | 32959 | 653 | Stack 🧱 |
12 | 2025-03-17 00:00:00.000 | 767 | 308 | New game 🏁 |
13 | 2025-02-22 00:00:00.000 | 47281 | 448 | Stack 🧱 |
14 | 2025-03-05 00:00:00.000 | 1508 | 628 | End game ✋ |
15 | 2025-02-28 00:00:00.000 | 1658 | 546 | New game 🏁 |
16 | 2025-01-21 00:00:00.000 | 737 | 106 | End game ✋ |
17 | 2025-03-13 00:00:00.000 | 988 | 331 | End game ✋ |
18 | 2025-03-15 00:00:00.000 | 710 | 187 | New game 🏁 |
19 | 2025-03-04 00:00:00.000 | 28173 | 660 | Stack 🧱 |
20 | 2025-03-19 00:00:00.000 | 6186 | 119 | Stack 🧱 |
Hessishstkem - txs
Updated 2025-03-19
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
SELECT date_trunc('day',block_timestamp) as time,
count(DISTINCT TX_ID) as txs,
count(DISTINCT signers[0]) as players,
case
when LOG_MESSAGES[1] like '%Start%' then 'New game 🏁'
when LOG_MESSAGES[1] like '%EndGame%' then 'End game ✋'
when LOG_MESSAGES[1] like '%Step%' then 'Stack 🧱'
end as action
from eclipse.core.fact_transactions
where LOG_MESSAGES[0] like '%STKgRMpqo41oATf18cHGFWaqVEe9gAWjLGzGZ9WpGH2%'
and SUCCEEDED = 'TRUE'
group by all
having action is not null
Last run: about 1 month ago
...
183
9KB
189s