flyingfishmamad kaia
Updated 2024-07-29
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
›
⌄
⌄
/* select
'0x128acb08000000000000000000000000dff9d1cff3c37b84704eed4465a83e6c453c35f600000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000007ce66c50e284000000000000000000000000000000000000000000000000000000000001000276a400000000000000000000000000000000000000000000000000000000000000a000000000000000000000000000000000000000000000000000000000000000c000000000000000000000000000000000000000000000000000000000000000200000000000000000000000000000000000000000000000000000000000000040000000000000000000000000dff9d1cff3c37b84704eed4465a83e6c453c35f6000000000000000000000000000000000000000000000000000000000000002b19aac5f612f524b754ca7e7c41cbfa2e981a44320001f45c13e303a62fc5dedf5b52d66873f2e59fedadc2000000000000000000000000000000000000000000' as data
, regexp_substr_all(SUBSTR(data, 10+1, len(data)), '.{64}') AS segmented_data
, utils.udf_hex_to_int(segmented_data[2]) as in_amount
*/
select
tx_hash
, tx_position
, trace_index
-- , from_address
-- , to_address
, regexp_substr_all(SUBSTR(output, 3, len(output)), '.{64}') AS segmented_output
, utils.udf_hex_to_int('s2c', segmented_output[0]::string) as amount0
, utils.udf_hex_to_int('s2c', segmented_output[1]::string) as amount1
, data
from kaia.core.fact_traces
where 1 = 1
and tx_hash = '0xe6286c687dec7ad77df27f293db1c017a5d49bf9d3fd2572ff9d4c3d7fcee269'
and block_number = 156621570
and input ilike '0x128acb08%'
QueryRunArchived: QueryRun has been archived