Query editor
-- This query has been migrated to run on DuneSQL.-- If you need to change back because you’re seeing issues, use the Query History view to restore the previous version.-- If you notice a regression, please email [email protected].WITHordinalsmarket_btc AS (SELECTid,block_time,DATE_TRUNC('day', 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 > CAST('2023-04-28' AS TIMESTAMP)) AS aaaWHEREtx4_in = tx7_out) AS bbbWHEREtx4_out = 'bc1p39tdzrddy5swrsf4ysu9k867283nhq754lnfhj23u543a72r60wsz8c74p'),okx AS (SELECTid,block_time,DATE_TRUNC('day', block_time) AS day,'okx' AS marketplace,tx4_in AS buyer,tx3_in AS seller,val3_out AS amount