Across-1.Bridge Transactions (Across)
-- Q1. Analyze bridge transactions via the Across bridge over the last two weeks. -- What assets are users bridging from Ethereum, and to what chains? -- Across transaction event data is undecoded in the Ethereum core tables. -- Users can use these functions to parse and decode the data: -- regexp_substr_all(SUBSTR(DATA, 3, len(DATA)), '.{64}') AS segmented_data ethereum.public.udf_hex_to_int() -- Hint: A user begins a bridge transaction by calling the deposit function on the SpokePool contract from the origin chain. -- Ethereum SpokePool contract : 0x4D9079Bb4165aeb4084c526a32695dCfd2F77381