yasminTOTAL
    Updated 2025-02-19
    WITH
    standard_chains AS (
    -- SELECT
    -- 'Base' AS blockchain,
    -- COUNT(DISTINCT tx_hash) AS transactions,
    -- COUNT(DISTINCT from_address) AS users
    -- FROM base.core.fact_transactions
    -- WHERE block_timestamp::date >= '2024-09-14'
    -- AND TX_SUCCEEDED = 'TRUE'
    -- GROUP BY blockchain
    -- UNION ALL
    -- SELECT
    -- 'Polygon' AS blockchain,
    -- COUNT(DISTINCT tx_hash) AS transactions,
    -- COUNT(DISTINCT from_address) AS users
    -- FROM polygon.core.fact_transactions
    -- WHERE block_timestamp::date >= '2024-09-14'
    -- AND status = 'SUCCESS'
    -- GROUP BY blockchain
    -- UNION ALL
    -- SELECT
    -- 'Solana' AS blockchain,
    -- COUNT(DISTINCT tx_id) AS transactions,
    -- COUNT(DISTINCT signers[0]) AS users
    -- FROM solana.core.fact_transactions
    -- WHERE block_timestamp::date >= '2024-09-14'
    -- AND succeeded = true
    -- GROUP BY blockchain
    -- UNION ALL
    SELECT
    Last run: 27 days ago
    Blockchain
    Cumulative Transactions
    Cumulative Wallets
    1
    Ronin1768967637497986
    2
    GUN39124730513310688
    3
    B32164481865776438
    3
    81B
    11s