transactions as (

select

block_timestamp,

block_number,

tx_id,

inputs,

outputs

from

bitcoin.core.fact_transactions

where

block_number > 767429

and block_timestamp::date between '2023-12-01' and '2024-03-05'

),

gamma as (

select

transactions.block_timestamp,

transactions.tx_id,

'Gamma' as marketplace,

transactions.outputs[1]:scriptPubKey:address::string AS buyer,

input3.pubkey_script_address AS seller,

transactions.outputs[2]:value AS amount

from

transactions

join bitcoin.core.fact_inputs input1 on transactions.tx_id = input1.tx_id

join bitcoin.core.fact_inputs input2 on transactions.tx_id = input2.tx_id

join bitcoin.core.fact_inputs input3 on transactions.tx_id = input3.tx_id

join bitcoin.core.fact_inputs input4 on transactions.tx_id = input4.tx_id

where

input1.index = 0

and input2.index = 1