flipside
Products
For Protocols
For Analysts
For Explorers
About
Log in
Become a Partner
flipside
OP_RETURN TxCount Monthly
SQRR Research
OP_RETURN TxCount Monthly
Updated 2025-02-23
Copy Reference
Fork
99
1
2
3
4
5
6
7
8
9
10
›
⌄
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
Results
QueryRunArchived: QueryRun has been archived