freemartianorbiter test
Updated 2023-11-17
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
-- SELECT * from ethereum.core.fact_traces
-- where tx_hash = lower('0xa3ade53fefb46c690261a9935e10c9deee06a8387e1cf2318c789c473bc6a631')
with a as (
select
regexp_substr_all(SUBSTR(input, 11, len(input)), '.{64}') AS segmented_data
from ethereum.core.fact_traces
where tx_hash = '0xa3ade53fefb46c690261a9935e10c9deee06a8387e1cf2318c789c473bc6a631'
--where to_address = '0xaaaaaaaaa24eeeb8d57d431224f73832bc34f688'
)
select
ethereum.public.udf_hex_to_int(substr(segmented_data[0], 1, 64):: STRING),
ethereum.public.udf_hex_to_int(substr(segmented_data[1], 1, 64):: STRING),
ethereum.public.udf_hex_to_int(substr(segmented_data[2], 1, 64):: STRING),
ethereum.public.udf_hex_to_int(substr(segmented_data[3], 1, 64):: STRING),
ethereum.public.udf_hex_to_int(substr(segmented_data[4], 1, 64):: STRING),
ethereum.public.udf_hex_to_int(substr(segmented_data[5], 1, 64):: STRING),
ethereum.public.udf_hex_to_int(substr(segmented_data[6], 1, 64):: STRING),
ethereum.public.udf_hex_to_int(substr(segmented_data[7], 1, 64):: STRING),
ethereum.public.udf_hex_to_int(substr(segmented_data[8], 1, 64):: STRING),
ethereum.public.udf_hex_to_int(substr(segmented_data[9], 1, 64):: STRING)
from a
Run a query to Download Data