Decode Workspace

freemartianDecode Workspace

Updated 2023-03-08

-- with Open_NewPosition AS (

-- SELECT

-- TX_HASH,

-- BLOCK_TIMESTAMP,

-- regexp_substr_all(SUBSTR(DATA, 3, len(DATA)), '.{64}') AS segmented_data,

-- topics[1] AS PositionID,

-- CONCAT('0x', substr(topics[2] :: STRING, 27, 42)) AS User_Address,

-- ethereum.public.udf_hex_to_int(segmented_data [0] :: STRING) AS Direction,

-- ethereum.public.udf_hex_to_int(segmented_data [3] :: STRING)/pow(10,8) AS Margin,

-- ethereum.public.udf_hex_to_int(segmented_data [4] :: STRING)/pow(10,8) AS Leverage,

-- ethereum.public.udf_hex_to_int(segmented_data [5] :: STRING)/pow(10,8) AS Fee,

-- ethereum.public.udf_hex_to_int(segmented_data [7] :: STRING)/pow(10,8) AS Funding

-- FROM

-- optimism.core.fact_event_logs

-- WHERE topics[0] IN ('0xf0179f06d5592030053869d8d0ae508420786cda1b88f04f1611215f029a35ab')

-- AND User_Address = lower('0x39Fe1bEEf05deD01D35C2b97E3fB6939D4f0AeE3')),

-- Open_ExecuteNewPosition AS (

-- SELECT

-- TX_HASH,

-- BLOCK_TIMESTAMP,

-- regexp_substr_all(SUBSTR(DATA, 3, len(DATA)), '.{64}') AS segmented_data,

-- CONCAT('0x', substr(topics[1] :: STRING, 27, 42)) AS User_Address,

-- ethereum.public.udf_hex_to_int(segmented_data [0] :: STRING) AS ProductID,

-- ethereum.public.udf_hex_to_int(segmented_data [6] :: STRING)/pow(10,8) AS Execution_Fee

-- FROM

-- optimism.core.fact_event_logs

-- WHERE topics[0] = '0xc5b9318d477559e5a19fc064b667a7f44e91bd26a16bd850b8ca7e9fc9c2ad37'

-- AND User_Address = lower('0x39Fe1bEEf05deD01D35C2b97E3fB6939D4f0AeE3')),

-- open_table AS (

-- SELECT

-- np.tx_hash AS open_tx,

-- np.block_timestamp AS open_time,

-- np.User_Address AS open_user,

Run a query to Download Data

flipside