picasoPrice Impact on Volume and Fees by Market
    Updated 2024-12-21
    WITH market_impact AS (
    SELECT
    SYMBOL AS market,
    AVG(PRICE_AMOUNT) AS avg_price,
    SUM(AMOUNT_USD) AS total_volume_usd,
    SUM(ABS(FEE_AMOUNT)) AS total_fees
    FROM
    arbitrum.vertex.ez_perp_trades
    GROUP BY
    market
    ORDER BY
    total_volume_usd DESC
    )
    SELECT
    market,
    avg_price,
    total_volume_usd,
    total_fees
    FROM
    market_impact
    LIMIT
    10;
    QueryRunArchived: QueryRun has been archived