SQRR ResearchOP_RETURN by Protocol
Updated 2025-02-23
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
›
⌄
SELECT date_trunc('month', BLOCK_TIMESTAMP) AS "Month"
,CASE
WHEN PUBKEY_SCRIPT_HEX LIKE '6a5d%020%'
THEN 'Rune'
WHEN PUBKEY_SCRIPT_HEX LIKE '6a5d%010%'
THEN 'Rune'
WHEN PUBKEY_SCRIPT_HEX LIKE '6a5d%14%'
THEN 'Rune'
WHEN PUBKEY_SCRIPT_HEX LIKE '6a5d0414011400'
THEN 'Rune'
WHEN PUBKEY_SCRIPT_HEX LIKE '6a5d%00%'
THEN 'Rune'
WHEN PUBKEY_SCRIPT_HEX LIKE '6a5d%16%'
THEN 'Rune'
WHEN PUBKEY_SCRIPT_HEX LIKE '6a5d021603'
THEN 'Rune'
WHEN PUBKEY_SCRIPT_HEX LIKE '6a146f6d6e69%'
THEN 'Omni'
ELSE 'Other'
END AS "OP_Return Use"
,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
,2
ORDER BY 1 DESC;
QueryRunArchived: QueryRun has been archived