cnft_sales_txs as (

select

block_timestamp

, tx_id

, 'tensorswap' as marketplace

, case

when event_type = 'buy'

then decoded_instruction :accounts[9] :pubkey ::string

when event_type = 'takeBidFullMeta'

then decoded_instruction :accounts[12] :pubkey ::string

when event_type = 'takeBidLegacy'

then decoded_instruction :accounts[3] :pubkey ::string

when event_type = 'takeBidMetaHash'

then decoded_instruction :accounts[12] :pubkey ::string

else null

end as buyer

, case

when event_type = 'buy'

then decoded_instruction :accounts[11] :pubkey ::string

when event_type = 'takeBidFullMeta'

then decoded_instruction :accounts[2] :pubkey ::string

when event_type = 'takeBidLegacy'

then decoded_instruction :accounts[1] :pubkey ::string

when event_type = 'takeBidMetaHash'

then decoded_instruction :accounts[2] :pubkey ::string

else null

end as seller

, case

when event_type = 'buy'

then decoded_instruction :accounts[2] :pubkey ::string