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
QueryRunArchived: QueryRun has been archived