SELECT

BLOCK_TIMESTAMP,

BLOCK_NUMBER,

INDEX,

TX_ID,

hex,

input_value,

output_value,

fee

FROM

bitcoin.core.fact_transactions

WHERE

1 = 1

AND BLOCK_NUMBER >= 840000

AND (

cast(hex AS VARCHAR) LIKE '%6f7264%'

OR cast(hex AS VARCHAR) LIKE '%00000000000000002%'

)

),

tb2 as (

SELECT

BLOCK_TIMESTAMP,

TX_ID,

INDEX,

PUBKEY_SCRIPT_ASM,

PUBKEY_SCRIPT_HEX

FROM

bitcoin.core.fact_outputs

WHERE

1 = 1

AND BLOCK_NUMBER >= 840000

AND PUBKEY_SCRIPT_ASM LIKE 'OP_RETURN 13 020%'

OR PUBKEY_SCRIPT_ASM LIKE 'OP_RETURN 13 010%'

AND (

PUBKEY_SCRIPT_ASM NOT LIKE 'OP_RETURN 13 00%'