flipside

    Near vs Avalanche
    JabiNear vs Avalanche
    Updated 2022-07-19
    with Near AS
    (SELECT
    DATE_TRUNC('day', minute) AS date,
    ROUND(AVG(txn)) AS avg_txn
    FROM (
    SELECT
    DATE_TRUNC('minute', block_timestamp) AS MINUTE,
    COUNT(TXN_HASH) AS txn
    FROM
    flipside_prod_db.mdao_near.transactions
    WHERE
    block_timestamp::date >= '2022-06-01'
    GROUP BY
    MINUTE)
    GROUP BY
    date
    ORDER BY
    date),
    Avalanche AS (
    SELECT
    DATE_TRUNC('day', MINUTE) AS date,
    ROUND(AVG(txn)) AS avg_txn
    FROM (
    SELECT
    DATE_TRUNC('minute', block_timestamp) AS MINUTE,
    COUNT(tx_hash) AS txn
    FROM
    avalanche.core.fact_transactions
    WHERE
    block_timestamp::date >= '2022-06-01'
    GROUP BY
    MINUTE
    )
    GROUP BY
    date
    ORDER BY
    Run a query to Download Data