Query editor
SELECTt1.hash as t1_has,t2.hash as t2_hash,t1.block_time as t1_time,t2.block_time as t2_time,t3.block_time as t3_time,to_unixtime(t2.block_time) - to_unixtime(t1.block_time) as s1_internal,to_unixtime(t3.block_time) - to_unixtime(t2.block_time) as s2_internal,t1.value as t1_value,t2.value as t2_value,t1."from" as t1_from,t1."to" as t1_to,t2."from" as t2_from,t2."to" as t2_to,t3.data as t3_data,t3."from" as t3_from,t3."to" as t3_to,t3.value as t3_valueFROM(SELECT"from","to",value,hash,block_time,VARBINARY_SUBSTRING ("to", 1, 2) AS to_head,VARBINARY_SUBSTRING ("to", 18) AS to_tail,VARBINARY_SUBSTRING ("to", 10, 11) AS to_midFROMethereum.transactionsWHEREblock_date = TRY_CAST('2024-05-03' AS DATE)) AS t1,(SELECT"from","to",value,hash,block_time,VARBINARY_SUBSTRING ("from", 1, 2) AS from_head,VARBINARY_SUBSTRING ("from", 18) AS from_tail,VARBINARY_SUBSTRING ("from", 10, 11) AS from_midFROMethereum.transactionsWHEREblock_date = TRY_CAST('2024-05-03' AS DATE)) AS t2,(SELECT"from","to",block_time,value,dataFROMethereum.transactionsWHEREblock_date = TRY_CAST('2026-08-010' AS DATE)