Query editor
WITHordinalsmarket_btc AS (SELECTid,block_time,DATE_TRUNC('week', block_time) AS day,'ordinals market btc' AS marketplace,tx4_in AS buyer,tx3_out AS seller,val3_out AS amountFROM(SELECT*FROM(SELECTid,block_time,ELEMENT_AT(input, 0 + 1).script_pub_key.address AS tx1_in,ELEMENT_AT(input, 0 + 1).value AS val1_in,ELEMENT_AT(input, 1 + 1).script_pub_key.address AS tx2_in,ELEMENT_AT(input, 1 + 1).value AS val2_in,ELEMENT_AT(input, 2 + 1).script_pub_key.address AS tx3_in,ELEMENT_AT(input, 2 + 1).value AS val3_in,ELEMENT_AT(input, 3 + 1).script_pub_key.address AS tx4_in,ELEMENT_AT(input, 3 + 1).value AS val4_in,ELEMENT_AT(output, 0 + 1).script_pub_key.address AS tx1_out,ELEMENT_AT(output, 0 + 1).value AS val1_out,ELEMENT_AT(output, 1 + 1).script_pub_key.address AS tx2_out,ELEMENT_AT(output, 1 + 1).value AS val2_out,ELEMENT_AT(output, 2 + 1).script_pub_key.address AS tx3_out,ELEMENT_AT(output, 2 + 1).value AS val3_out,ELEMENT_AT(output, 3 + 1).script_pub_key.address AS tx4_out,ELEMENT_AT(output, 3 + 1).value AS val4_out,ELEMENT_AT(output, 6 + 1).script_pub_key.address AS tx7_outFROMbitcoin.transactionsWHEREblock_time >= NOW() - interval '365' day) AS aaaWHEREtx4_in = tx7_out) AS bbbWHEREtx4_out in ('bc1qcq2uv5nk6hec6kvag3wyevp6574qmsm9scjxc2', '3P4WqXDbSLRhzo2H6MT6YFbvBKBDPLbVtQ')),okx AS (SELECTid,block_time,DATE_TRUNC('week', block_time) AS day,'okx' AS marketplace,tx4_in AS buyer,tx3_in AS seller,val3_out AS amountFROM