TIME | Gas Used | Gas Used _ ETH | |
---|---|---|---|
1 | 2025-01-03 | 40787986 | +4.0787986e-11 |
2 | 2025-01-02 | 39862484 | +3.9862484e-11 |
3 | 2025-01-01 | 43934745 | +4.3934745e-11 |
4 | 2024-12-31 | 48145697 | +4.8145697e-11 |
5 | 2024-12-30 | 79297310 | +7.929731e-11 |
6 | 2024-12-29 | 73532700 | +7.35327e-11 |
7 | 2024-12-28 | 48239329 | +4.8239329e-11 |
8 | 2024-12-27 | 348745493 | +3.48745493e-10 |
9 | 2024-12-26 | 437107688 | +4.37107688e-10 |
10 | 2024-12-25 | 455781706 | +4.55781706e-10 |
11 | 2024-12-24 | 454911874 | +4.54911874e-10 |
12 | 2024-12-23 | 478302426 | +4.78302426e-10 |
13 | 2024-12-22 | 475789821 | +4.75789821e-10 |
14 | 2024-12-21 | 438607429 | +4.38607429e-10 |
15 | 2024-12-20 | 657899772 | +6.57899772e-10 |
16 | 2024-12-19 | 541414093 | +5.41414093e-10 |
17 | 2024-12-18 | 524621178 | +5.24621178e-10 |
18 | 2024-12-17 | 482304495 | +4.82304495e-10 |
19 | 2024-12-16 | 601019710 | +6.0101971e-10 |
20 | 2024-12-15 | 597770450 | +5.9777045e-10 |
sssstatisticgas used
Updated 2025-01-04
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
SELECT to_char(block_timestamp, 'YYYY-MM-DD') as time, sum(GAS_USED) as "Gas Used", concat('+', (sum(GAS_USED) / pow(10, 18))::TEXT) as "Gas Used _ ETH"
FROM blast.core.fact_transactions txs
WHERE EXISTS (
select 1
from blast.core.fact_event_logs block
where contract_address in (
'0xc48f6213a1a4d3ead79db812c2b91817980532c3', -- game
'0x74d9c915c64ab7587a3abde1827f3a09eac97bac', -- the last samurai
'0xaf466677d96e6df2e31a86fda7e54a31d64647ed' -- flip coin
)
AND block.tx_hash = txs.tx_hash
)
AND BLOCK_TIMESTAMP < CURRENT_DATE
GROUP BY to_char(block_timestamp, 'YYYY-MM-DD')
ORDER BY time DESC
Last run: about 2 months agoAuto-refreshes every 12 hours
...
258
11KB
58s