elsinaUntitled Query
Updated 2022-07-22
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
SELECT
block_timestamp,
regexp_substr_all(SUBSTR(DATA, 3, len(DATA)), '.{64}') AS segmented_data,
origin_from_address,
origin_to_address,
contract_address,
tx_hash,
ethereum.public.udf_hex_to_int(
segmented_data [1] :: STRING
)/pow(10,18) AS VALUE
FROM
optimism.core.fact_event_logs
where event_name = 'Swap' and tx_hash = '0xc0c09d96719e06c50cb19c1b5a2a314de57181eea24f2db392c1cb38dabce831'
limit 1000
Run a query to Download Data