TIME | TRANSACTIONS | |
|---|---|---|
1 | 2025-04-03 | 315 |
2 | 2025-04-02 | 351 |
3 | 2025-04-01 | 336 |
4 | 2025-03-31 | 402 |
5 | 2025-03-30 | 354 |
6 | 2025-03-29 | 282 |
7 | 2025-03-28 | 386 |
8 | 2025-03-27 | 315 |
9 | 2025-03-26 | 346 |
10 | 2025-03-25 | 347 |
11 | 2025-03-24 | 363 |
12 | 2025-03-23 | 368 |
13 | 2025-03-22 | 358 |
14 | 2025-03-21 | 370 |
15 | 2025-03-20 | 348 |
16 | 2025-03-19 | 351 |
17 | 2025-03-18 | 335 |
18 | 2025-03-17 | 328 |
19 | 2025-03-16 | 384 |
20 | 2025-03-15 | 370 |
sssstatisticDaily Game TXS
Updated 3 days ago
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
Last run: 3 days agoAuto-refreshes every 12 hours
...
348
7KB
57s