sssstatisticgas used
    Updated 2025-01-04

    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
    TIME
    Gas Used
    Gas Used _ ETH
    1
    2025-01-0340787986+4.0787986e-11
    2
    2025-01-0239862484+3.9862484e-11
    3
    2025-01-0143934745+4.3934745e-11
    4
    2024-12-3148145697+4.8145697e-11
    5
    2024-12-3079297310+7.929731e-11
    6
    2024-12-2973532700+7.35327e-11
    7
    2024-12-2848239329+4.8239329e-11
    8
    2024-12-27348745493+3.48745493e-10
    9
    2024-12-26437107688+4.37107688e-10
    10
    2024-12-25455781706+4.55781706e-10
    11
    2024-12-24454911874+4.54911874e-10
    12
    2024-12-23478302426+4.78302426e-10
    13
    2024-12-22475789821+4.75789821e-10
    14
    2024-12-21438607429+4.38607429e-10
    15
    2024-12-20657899772+6.57899772e-10
    16
    2024-12-19541414093+5.41414093e-10
    17
    2024-12-18524621178+5.24621178e-10
    18
    2024-12-17482304495+4.82304495e-10
    19
    2024-12-16601019710+6.0101971e-10
    20
    2024-12-15597770450+5.9777045e-10
    ...
    258
    11KB
    58s