row_number() over (

order by

block_number,

index

) - 41 as ordinal_number,

BLOCK_TIMESTAMP,

block_number,

tx_id,

-- index,

-- size, -- Byte

-- virtual_size, --vByte

-- fee, -- BTC

-- fee * 1e8 / virtual_size as fee_rate, -- sat/vB

PARSE_JSON(outputs::STRING)[0]['scriptPubKey']['address'] as holder --[1]['script_pub_key']['address'] as minter_address

from

bitcoin.core.fact_transactions

where

block_number > 767429

and cast(hex as varchar) like '%0063036f726401%'

LIMIT 100