flipside
GROWTH MCP
IDG PLAYBOOK
JOURNEYS
INSIGHTS
About
Log in
BECOME A PARTNER
flipside
OP_RETURN TxCount Yearly
SQRR Research
OP_RETURN TxCount Yearly
Updated 2025-02-23
Copy Reference
Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
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
;
Results
QueryRunArchived: QueryRun has been archived