alitaslimiTransactions Daily
    Updated 2025-02-19
    with
    -------------------- Arbitrum --------------------
    arbitrum as (
    select
    block_timestamp::date as date,
    count(distinct tx_hash) as transactions,
    sum(transactions) over (order by date) as transactions_cumulative
    from
    arbitrum.core.fact_event_logs
    where
    tx_status = 'SUCCESS'
    and block_timestamp::date < current_date
    and contract_address = '0x2297aebd383787a160dd0d9f71508148769342e3'
    group by
    date
    ),
    -------------------- Avalanche --------------------
    avalanche as (
    select
    block_timestamp::date as date,
    count(distinct tx_hash) as transactions,
    sum(transactions) over (order by date) as transactions_cumulative
    from
    avalanche.core.fact_event_logs
    where
    tx_status = 'SUCCESS'
    and block_timestamp::date < current_date
    and contract_address = '0x152b9d0fdc40c096757f570a51e494bd4b943e50'
    group by
    date
    ),
    -------------------- BSC --------------------
    bsc as (
    select
    block_timestamp::date as date,
    count(distinct tx_hash) as transactions,
    Last run: 24 days ago
    Date
    Blockchain
    Transactions
    Cumulative TXs
    1
    2025-02-18 00:00:00.000Arbitrum1471867252
    2
    2025-02-18 00:00:00.000Avalanche123889880516
    3
    2025-02-18 00:00:00.000BSC411484903
    4
    2025-02-18 00:00:00.000Optimism33509410
    5
    2025-02-18 00:00:00.000Polygon1311720028
    6
    2025-02-17 00:00:00.000Arbitrum1851867105
    7
    2025-02-17 00:00:00.000Avalanche108319868128
    8
    2025-02-17 00:00:00.000BSC2981484862
    9
    2025-02-17 00:00:00.000Optimism37509377
    10
    2025-02-17 00:00:00.000Polygon4891719897
    11
    2025-02-16 00:00:00.000Arbitrum1061866920
    12
    2025-02-16 00:00:00.000Avalanche103729857297
    13
    2025-02-16 00:00:00.000BSC491484564
    14
    2025-02-16 00:00:00.000Optimism41509340
    15
    2025-02-16 00:00:00.000Polygon671719408
    16
    2025-02-15 00:00:00.000Arbitrum1151866814
    17
    2025-02-15 00:00:00.000Avalanche84119846925
    18
    2025-02-15 00:00:00.000BSC331484515
    19
    2025-02-15 00:00:00.000Optimism43509299
    20
    2025-02-15 00:00:00.000Polygon911719341
    ...
    3900
    190KB
    588s