flipside

    Pika Volume (Gone Through Contracts)
    freemartianPika Volume (Gone Through Contracts)
    Updated 2023-02-17
    with Source AS (
    SELECT
    regexp_substr_all(SUBSTR(DATA, 3, len(DATA)), '.{64}') AS segmented_data,
    ethereum.public.udf_hex_to_int(segmented_data [0] :: STRING) AS asset,
    ethereum.public.udf_hex_to_int(segmented_data [1] :: STRING)/pow(10,8) AS Margin,
    ethereum.public.udf_hex_to_int(segmented_data [2] :: STRING)/pow(10,8) AS Leverage,
    Margin*Leverage as Trade_Volume,
    ethereum.public.udf_hex_to_int(segmented_data [4] :: STRING) AS Direction,
    ethereum.public.udf_hex_to_int(segmented_data [6] :: STRING)/pow(10,8) AS Execution_fee_ETH
    FROM
    optimism.core.fact_event_logs
    WHERE topics[0] = '0xc5b9318d477559e5a19fc064b667a7f44e91bd26a16bd850b8ca7e9fc9c2ad37')
    --and tx_hash = '0x6b635eaa9777aff97d1a05d82eb6d3d1a0eec3bf39665a024b78b0ca7950bea2'
    --and origin_from_address = lower('0x39Fe1bEEf05deD01D35C2b97E3fB6939D4f0AeE3'))

    SELECT
    -- tx_hash,
    -- Margin,
    -- Leverage,
    sum(Trade_Volume)
    FROM Source


    Run a query to Download Data