flyingfishNPine Kaia Swap details
Updated 2024-07-29
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
select
tx_hash,
input_data,
regexp_substr_all(
SUBSTR(input_data, 275, len(input_data)),
'.{64}'
) AS segmented,
utils.udf_hex_to_int('s2c', segmented [0] :: string) as amount0,
'0x' || ltrim(segmented [1] :: string, 0) as token0,
'0x' || ltrim(segmented [2] :: string, 0) as token2,
utils.udf_hex_to_int('s2c', segmented [3] :: string) as amount1,
'0x' || ltrim(segmented [4] :: string, 0) as think_its_the_signer,
utils.udf_hex_to_int('s2c', segmented [5] :: string) as token0_amount,
utils.udf_hex_to_int('s2c', segmented [6] :: string) as token1_amount
from
kaia.core.fact_transactions
where
tx_hash = '0x024ed36cd753bc8674b0e91dee62fe537f90e32e3a554d55f6376262c9292413'
and block_number = 160070562
QueryRunArchived: QueryRun has been archived