flipside

    TOTAL 1
    yasminTOTAL 1
    Updated 2025-03-04
    WITH
    standard_chains AS (
    SELECT
    BLOCKCHAIN,
    SUM(TRANSACTION_COUNT_SUCCESS) AS transactions
    FROM
    crosschain.stats.ez_core_metrics_hourly
    WHERE
    BLOCK_TIMESTAMP_HOUR::date >= '2024-09-14'
    AND BLOCKCHAIN IN ('arbitrum', 'base', 'polygon', 'solana','ethereum')
    GROUP BY BLOCKCHAIN
    ),

    ronin_transactions AS (
    SELECT
    'Ronin' AS blockchain,
    COUNT(DISTINCT TX_HASH) AS transactions
    FROM ronin.core.fact_transactions
    WHERE block_timestamp::date >= '2024-09-14'
    AND TX_SUCCEEDED = true
    GROUP BY blockchain
    ),

    ------------------------------ GUN blockchain data (using API call)------------------------------------------------------
    gun_transactions AS (
    WITH base_data AS (
    SELECT live.udf_api('https://metrics.avax.network/v2/chains/49321/metrics/cumulativeTxCount?startTimestamp=1726272000&timeInterval=day&pageSize=2160') AS response ),
    flattened_data AS (
    SELECT
    TO_TIMESTAMP(t.value:timestamp)::date AS date,
    t.value:value::integer AS cumulativeTxCount
    FROM base_data,
    LATERAL FLATTEN(input => PARSE_JSON(response:data:results)) t ),
    stats AS (
    SELECT MAX(cumulativeTxCount) AS total_cumulativeTxCount
    FROM flattened_data )
    Last run: 12 days ago
    Blockchain
    Cumulative Transactions
    1
    		polygon493756933
    2
    		base1077966360
    3
    		solana9015510167
    4
    		Ronin189306941
    5
    		arbitrum344214692
    6
    		Gunzilla423106086
    7
    		B3216448186
    8
    		ethereum205989519
    8
    171B
    8s