adambalaUntitled Query
Updated 2022-07-18Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
›
⌄
SELECT tx_hash,block_timestamp, contract_address, provider, locked_date, tokenID, VALUE, deposit_type
FROM (
SELECT
*,
CONCAT('0x', SUBSTR(topics [1] :: STRING, 27, 42)) AS provider, ethereum.public.udf_hex_to_int( topics [2] :: STRING) :: DATE AS locked_date,
regexp_substr_all(SUBSTR(DATA, 3, len(DATA)), '.{64}') AS segmented_data,ethereum.public.udf_hex_to_int(segmented_data [0] :: STRING) AS tokenID,
ethereum.public.udf_hex_to_int(segmented_data [1] :: STRING)/pow(10,18) AS VALUE,ethereum.public.udf_hex_to_int(segmented_data [2] :: STRING) AS deposit_type,ethereum.public.udf_hex_to_int( segmented_data [3] :: STRING) AS TIMESTAMP
FROM optimism.core.fact_event_logs
WHERE block_number >= 12097159 and topics [0] :: STRING = '0xff04ccafc360e16b67d682d17bd9503c4c6b9a131f6be6325762dc9ffc7de624')
LIMIT 3
Run a query to Download Data