Mrftifrozen-rose
Updated 2024-09-21
9
1
2
3
4
5
6
7
8
›
⌄
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