SQRR ResearchOP_RETURN TxCount Monthly
    Updated 2025-02-23
    SELECT date_trunc('month', BLOCK_TIMESTAMP) AS month
    ,count(TX_ID) AS "OP_Return TX"
    FROM bitcoin.core.fact_outputs
    WHERE PUBKEY_SCRIPT_ADDRESS IS NULL
    AND PUBKEY_SCRIPT_ASM LIKE 'OP_RETURN%'
    AND PUBKEY_SCRIPT_TYPE = 'nulldata'
    GROUP BY 1
    ORDER BY 1


    QueryRunArchived: QueryRun has been archived