select

block_timestamp ,

tx_hash,

origin_function_signature::string as ofg,

event_inputs:"fromAddress"::string as seller,

event_inputs:"toAddress"::string as buyer,

event_inputs:"punkIndex"::string as punk,

event_inputs:"value"/1e18 as eth

from ethereum.core.fact_event_logs

where

(contract_address='0x79da5fa272e8fb280cee4d0649aa6a9e4e62ceb0' and origin_function_signature in ('0xab834bab'))

and event_name='wall st bulls'

)

,

trans2 as

(

select

block_timestamp ,

tx_hash,

origin_function_signature::string as ofg,

FROM_ADDRESS::string as seller,

tx_json:"receipt":"logs"[0]:decoded:inputs:"to"::string as buyer,

tokenflow_eth.hextoint(substr(input_data,11,64))::string as punk,

tokenflow_eth.hextoint(substr(input_data,75,64))/1e18 as eth

from ethereum.core.fact_transactions

where tx_json:"receipt":"logs"[0]:address='0x79da5fa272e8fb280cee4d0649aa6a9e4e62ceb0'

and tx_json:"receipt":"logs"[1]:decoded:eventName='wall st bulls'

)

,

combined as

(