flyingfishNPine Kaia Swap details
    Updated 2024-07-29
    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