TIME | TXS | PLAYERS | ACTION | |
|---|---|---|---|---|
1 | 2025-04-11 00:00:00.000 | 1726 | 33 | Stack 🧱 |
2 | 2025-02-04 00:00:00.000 | 1049 | 7 | Stack 🧱 |
3 | 2025-03-31 00:00:00.000 | 472 | 231 | New game 🏁 |
4 | 2025-03-15 00:00:00.000 | 572 | 155 | End game ✋ |
5 | 2025-02-07 00:00:00.000 | 4338 | 647 | End game ✋ |
6 | 2025-03-22 00:00:00.000 | 703 | 185 | End game ✋ |
7 | 2025-03-15 00:00:00.000 | 14442 | 186 | Stack 🧱 |
8 | 2025-02-01 00:00:00.000 | 21 | 10 | End game ✋ |
9 | 2025-01-23 00:00:00.000 | 1063 | 157 | New game 🏁 |
10 | 2025-02-24 00:00:00.000 | 1569 | 496 | End game ✋ |
11 | 2025-03-16 00:00:00.000 | 495 | 186 | New game 🏁 |
12 | 2025-02-08 00:00:00.000 | 9337 | 1077 | New game 🏁 |
13 | 2025-03-25 00:00:00.000 | 331 | 146 | End game ✋ |
14 | 2025-02-08 00:00:00.000 | 7771 | 1057 | End game ✋ |
15 | 2025-04-09 00:00:00.000 | 305 | 150 | New game 🏁 |
16 | 2025-04-10 00:00:00.000 | 107 | 43 | End game ✋ |
17 | 2025-04-12 00:00:00.000 | 4 | 1 | End game ✋ |
18 | 2025-01-16 00:00:00.000 | 12 | 4 | End game ✋ |
19 | 2025-03-10 00:00:00.000 | 1098 | 302 | New game 🏁 |
20 | 2025-04-08 00:00:00.000 | 5404 | 211 | Stack 🧱 |
Hessishstkem - txs
Updated 2025-05-11
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: 14 days ago
...
254
13KB
671s