sssstatisticDaily Game TXS
    Updated 2025-01-04
    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: about 2 months agoAuto-refreshes every 12 hours
    TIME
    TRANSACTIONS
    1
    2025-01-03404
    2
    2025-01-02416
    3
    2025-01-01423
    4
    2024-12-31447
    5
    2024-12-30646
    6
    2024-12-29593
    7
    2024-12-28471
    8
    2024-12-273252
    9
    2024-12-263974
    10
    2024-12-254223
    11
    2024-12-244181
    12
    2024-12-234440
    13
    2024-12-224359
    14
    2024-12-214057
    15
    2024-12-205415
    16
    2024-12-194909
    17
    2024-12-184793
    18
    2024-12-174517
    19
    2024-12-165357
    20
    2024-12-155292
    ...
    258
    5KB
    55s