KaskoazulBlocks N txs
    Updated 2023-01-22
    -- SELECT
    -- --COALESCE(t.block_timestamp::date, b.block_timestamp::date) AS fecha
    -- t.block_timestamp::date AS fecha
    -- , COUNT(t.tx_hash) AS daily_transactions
    -- , SUM(daily_transactions) OVER (ORDER BY fecha) AS total_cumulative_transactions
    -- , AVG(daily_transactions) OVER (ORDER BY fecha ROWS BETWEEN 7 PRECEDING AND CURRENT ROW) AS rolling_7d_transactions
    -- FROM
    -- near.core.fact_transactions t
    -- LEFT JOIN
    -- near.core.fact_blocks b
    -- ON
    -- t.block_id = b.block_id
    -- GROUP BY
    -- fecha
    -- ORDER BY
    -- fecha DESC

    SELECT
    t.block_id AS bid_t
    ,t.block_timestamp::date AS fecha_t
    , b.block_id AS bid_b
    , b.block_timestamp::date AS fecha_b
    FROM
    near.core.fact_transactions t
    LEFT JOIN
    near.core.fact_blocks b
    ON
    t.block_id = b.block_id
    WHERE
    fecha_t IS NULL
    Run a query to Download Data