SQRR ResearchOP_RETURN TxCount Yearly
    Updated 2025-02-23
    SELECT
    EXTRACT(YEAR FROM BLOCK_TIMESTAMP) AS "Year",
    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