yasmin-n-d-r-hUntitled Query
    Updated 2022-08-01
    WITH Quixotic as (
    SELECT
    x.block_timestamp,
    x.tx_hash,
    x.origin_from_address as buyer,
    regexp_substr_all(
    SUBSTR(
    x.DATA,
    3,
    len(x.DATA)
    ),
    '.{64}'
    ) AS segmented_data,
    ethereum.public.udf_hex_to_int(segmented_data [1] :: STRING) as raw_volume,
    raw_volume / pow(10, 18) as volume,
    b.contract_address
    FROM
    optimism.core.fact_event_logs x
    INNER JOIN optimism.core.fact_event_logs b ON x.tx_hash = b.tx_hash
    WHERE
    x.DATA != '0x'
    AND x.tx_status = 'SUCCESS'
    AND x.origin_to_address in (
    '0x3f9da045b0f77d707ea4061110339c4ea8ecfa70'
    )
    AND b.event_name = 'Transfer'
    )
    SELECT
    sum(volume) as eth_volume,
    contract_address,
    project_name
    FROM
    Quixotic x
    INNER JOIN optimism.core.dim_labels b ON x.contract_address = b.address
    GROUP BY
    2,
    Run a query to Download Data