Query editor
WITH transactions AS (SELECTblock_time,id AS hash,-- Input addresses and values using ELEMENT_AT for safe accessELEMENT_AT(input, 1).script_pub_key.address AS tx1_in,ELEMENT_AT(input, 1).value AS val1_in,ELEMENT_AT(input, 2).script_pub_key.address AS tx2_in,ELEMENT_AT(input, 3).script_pub_key.address AS tx3_in,ELEMENT_AT(input, 4).script_pub_key.address AS tx4_in,ELEMENT_AT(input, 5).script_pub_key.address AS tx5_in,ELEMENT_AT(input, 6).script_pub_key.address AS tx6_in,ELEMENT_AT(input, 7).script_pub_key.address AS tx7_in,ELEMENT_AT(input, 8).script_pub_key.address AS tx8_in,ELEMENT_AT(input, 9).script_pub_key.address AS tx9_in,ELEMENT_AT(input, 10).script_pub_key.address AS tx10_in,-- Output addresses and values using ELEMENT_ATELEMENT_AT(output, 1).script_pub_key.address AS tx1_out,ELEMENT_AT(output, 1).value AS val1_out,ELEMENT_AT(output, 2).script_pub_key.address AS tx2_out,ELEMENT_AT(output, 2).value AS val2_out,ELEMENT_AT(output, 3).script_pub_key.address AS tx3_out,ELEMENT_AT(output, 3).value AS val3_out,ELEMENT_AT(output, 4).script_pub_key.address AS tx4_out,ELEMENT_AT(output, 4).value AS val4_out,ELEMENT_AT(output, 5).script_pub_key.address AS tx5_out,ELEMENT_AT(output, 6).script_pub_key.address AS tx6_out,-- Additional fieldsELEMENT_AT(output, 1).script_pub_key.asm AS op_check,-- Conditions(ELEMENT_AT(output, 2).script_pub_key.address <> ELEMENT_AT(output, 3).script_pub_key.address) AS unique_user_condition,(ELEMENT_AT(output, 2).script_pub_key.address <> ELEMENT_AT(output, 5).script_pub_key.address) AS unique_user_condition_runesFROM bitcoin.transactionsWHEREblock_time > TRY_CAST('2023-10-07' AS TIMESTAMP)),volume_v1 AS (SELECTDATE_TRUNC('day', block_time) AS day,DATE_TRUNC('week', block_time) AS week,hash,tx1_in,tx2_in,tx3_in,tx4_in,tx5_in,tx6_in,tx7_in,tx8_in,tx9_in,tx10_in,tx1_out,val1_out,tx2_out,val2_out,