alitaslimiTransactions Overview
    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
    Group
    Total
    1
    Last 24 Hours12741
    2
    Overall15465379
    2
    46B
    589s