sssstatisticDaily Game TXS
Updated 2025-01-04
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
select
to_char(BLOCK_TIMESTAMP, 'YYYY-MM-DD') AS time,
count(*) AS transactions
from
blast.core.fact_event_logs
where
contract_address in (
'0xc48f6213a1a4d3ead79db812c2b91817980532c3',
-- game
'0x74d9c915c64ab7587a3abde1827f3a09eac97bac',
-- the last samurai
'0xaf466677d96e6df2e31a86fda7e54a31d64647ed' -- flip coin
)
AND BLOCK_TIMESTAMP < CURRENT_DATE
GROUP by
to_char(BLOCK_TIMESTAMP, 'YYYY-MM-DD')
ORDER BY
time DESC
Auto-refreshes every 12 hours
QueryRunArchived: QueryRun has been archived