block_timestamp,

tx_hash,

tx:receipt as receipt,

tx:public_key as public_key,

tx:signer_id as signer_id,

tx:receiver_id as receiver_id

FROM near.core.fact_transactions

WHERE block_timestamp::date < CURRENT_DATE

),

JSON_PARSING AS (

SELECT

block_timestamp,

tx_hash,

public_key,

signer_id,

receiver_id,

seq,key,path,index,

replace(value:outcome:logs[0], '\\') as logs, -- remove // | convert variant | parse json

check_json(logs) as checks

FROM tx,

table(flatten(input => receipt))

),

nft_tx_log AS (

SELECT

--PARSE_JSON(LOGS):PARAMS

block_timestamp,

tx_hash,

public_key,

signer_id,

receiver_id,

try_parse_json(logs) as parse_logs,

parse_logs:type as type,

parse_logs:params:buyer_id as buyer_id,

parse_logs:params:owner_id as owner_id,