elsinaUntitled Query
    Updated 2022-07-22
    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