SELECT

block_timestamp,

tx4_in AS buyer,

tx3_in AS seller

FROM

(

SELECT

tx_id,

max(block_timestamp) as block_timestamp,

MAX(CASE WHEN input.index = 0 THEN input.PUBKEY_SCRIPT_ADDRESS END) as tx1_in,

MAX(CASE WHEN input.index = 0 THEN input.VALUE END) as val1_in,

MAX(CASE WHEN input.index = 1 THEN input.PUBKEY_SCRIPT_ADDRESS END) as tx2_in,

MAX(CASE WHEN input.index = 1 THEN input.VALUE END) as val2_in,

MAX(CASE WHEN input.index = 2 THEN input.PUBKEY_SCRIPT_ADDRESS END) as tx3_in,

MAX(CASE WHEN input.index = 3 THEN input.PUBKEY_SCRIPT_ADDRESS END) as tx4_in,

MAX(CASE WHEN output.index = 0 THEN output.VALUE END) as val1_out,

MAX(CASE WHEN output.index = 3 THEN output.PUBKEY_SCRIPT_ADDRESS END) as tx4_out,

MAX(CASE WHEN output.index = 3 THEN output.VALUE END) as val4_out,

MAX(CASE WHEN output.index = 4 THEN output.PUBKEY_SCRIPT_ADDRESS END) as tx5_out,

MAX(CASE WHEN output.index = 4 THEN output.VALUE END) as val5_out

FROM bitcoin.core.fact_inputs input join bitcoin.core.fact_outputs output using(block_timestamp, tx_id)

where block_timestamp >= '2023-05-15'

GROUP BY tx_id

) AS aaa

WHERE

val1_in = 600 / pow(10,8)

AND val2_in = 600 / pow(10,8)

AND val1_out = 1200 / pow(10,8)

AND val4_out = 600 / pow(10,8)

AND val5_out = 600 / pow(10,8)

AND tx1_in = tx4_out

AND tx2_in = tx5_out

),