h4wkNetwork
    Updated 2024-02-29
    select date(block_timestamp) as date,
    'Arbitrum' as chain,
    status,
    count(DISTINCT tx_hash) as total_tx,
    total_tx/86400 as tps
    from arbitrum.core.fact_transactions
    where block_timestamp::date >= '2023-09-15' and block_timestamp < CURRENT_DATE
    group by 1,2,3
    UNION
    select date(block_timestamp) as date,
    'Optimism' as chain,
    status,
    count(DISTINCT tx_hash) as total_tx,
    total_tx/86400 as tps
    from optimism.core.fact_transactions
    where block_timestamp::date >= '2023-09-15' and block_timestamp < CURRENT_DATE
    group by 1,2,3
    UNION
    select date(block_timestamp) as date,
    'Avalanche' as chain,
    status,
    count(DISTINCT tx_hash) as total_tx,
    total_tx/86400 as tps
    from avalanche.core.fact_transactions
    where block_timestamp::date >= '2023-09-15' and block_timestamp < CURRENT_DATE
    group by 1,2,3
    UNION
    select date(block_timestamp) as date,
    'Sei' as chain,
    case when TX_SUCCEEDED = 'true' then 'SUCCESS' else 'FAIL' end as status,
    count(DISTINCT tx_id) as total_tx,
    total_tx/86400 as tps
    from sei.core.fact_transactions
    where block_timestamp::date >= '2023-09-15' and block_timestamp < CURRENT_DATE
    group by 1,2,3
    UNION
    QueryRunArchived: QueryRun has been archived