web3explorerChains Total Transactions
    Updated 2024-01-07
    -- forked from Hemin / AllTransactions @ https://flipsidecrypto.xyz/Hemin/q/all-transactions-BnINh4

    with ArbitrumTransactionRate AS
    (
    SELECT count(STATUS) as total,
    'Arbitrum' as Project
    FROM arbitrum.core.fact_transactions
    ),

    AvalancheTransactionRate AS
    (
    SELECT count(STATUS) as total,
    'Avalanche' as Project
    FROM avalanche.core.fact_transactions
    ),

    BscTransactionRate AS
    (
    SELECT count(STATUS) as total,
    'Bsc' as Project
    FROM bsc.core.fact_transactions
    ),

    CosmosTransactionRate AS
    (
    SELECT count(TX_SUCCEEDED) as total,
    'Cosmos' as Project
    FROM cosmos.core.fact_transactions
    ),

    EthereumTransactionRate AS
    (
    SELECT count(STATUS) as total,
    'Ethereum' as Project
    FROM ethereum.core.fact_transactions
    ),
    QueryRunArchived: QueryRun has been archived