Mrftifrozen-rose
    Updated 2024-09-21
    SELECT *--,
    -- '0x' || SUBSTR(PARSE_JSON(TOPICS)[0]::string, -40) AS user_address1,
    -- '0x' || SUBSTR(PARSE_JSON(TOPICS)[1]::string, -40) AS user_address2,
    -- '0x' || SUBSTR(PARSE_JSON(TOPICS)[2]::string, -40) AS user_address3,
    -- '0x' || SUBSTR(PARSE_JSON(TOPICS)[3]::string, -40) AS token_address,
    --utils.udf_hex_to_int(SUBSTRING(DATA, 1, 66))/pow (10,18)
    from berachain.testnet.fact_traces
    where tx_hash = '0x3455b2bca5269df4f73504c910b9622e4c35fbefd41453fca1fdd2e0dc08540c'
    QueryRunArchived: QueryRun has been archived