sssstatisticgas used
    Updated 2025-05-21

    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: 22 days agoAuto-refreshes every 12 hours
    TIME
    Gas Used
    Gas Used _ ETH
    1
    2025-04-0328280615+2.8280615e-11
    2
    2025-04-0232899574+3.2899574e-11
    3
    2025-04-0132723657+3.2723657e-11
    4
    2025-03-3141409697+4.1409697e-11
    5
    2025-03-3035257038+3.5257038e-11
    6
    2025-03-2927314974+2.7314974e-11
    7
    2025-03-2838323077+3.8323077e-11
    8
    2025-03-2729129035+2.9129035e-11
    9
    2025-03-2632125875+3.2125875e-11
    10
    2025-03-2532384775+3.2384775e-11
    11
    2025-03-2433370407+3.3370407e-11
    12
    2025-03-2334470831+3.4470831e-11
    13
    2025-03-2232145803+3.2145803e-11
    14
    2025-03-2133635951+3.3635951e-11
    15
    2025-03-2032837560+3.283756e-11
    16
    2025-03-1932340941+3.2340941e-11
    17
    2025-03-1831379049+3.1379049e-11
    18
    2025-03-1729837556+2.9837556e-11
    19
    2025-03-1635187981+3.5187981e-11
    20
    2025-03-1533962477+3.3962477e-11
    ...
    348
    14KB
    218s