datavortexTotal Volume Traded Per Symbol
    Updated 2024-12-16

    Perpetual_Trades AS (
    SELECT
    SYMBOL AS symbol,
    QUOTE_DELTA_AMOUNT AS quoteDelta,
    IS_TAKER AS isTaker
    FROM
    arbitrum.vertex.ez_perp_trades
    WHERE
    EVENT_NAME = 'FillOrder'
    AND BLOCK_TIMESTAMP >= TIMESTAMP '2023-04-26'
    ),
    Combined_Trades AS (
    SELECT * FROM Spot_Trades
    UNION ALL
    SELECT * FROM Perpetual_Trades
    )

    SELECT
    symbol,
    SUM(CASE WHEN quoteDelta > 0 THEN quoteDelta ELSE -quoteDelta END) AS "all time vol",
    SUM(SUM(CASE WHEN quoteDelta > 0 THEN quoteDelta ELSE -quoteDelta END))
    OVER (PARTITION BY NULL) AS "all time total vol"
    FROM
    Combined_Trades
    WHERE
    isTaker = TRUE
    GROUP BY
    symbol
    ORDER BY
    "all time vol" DESC
    LIMIT 10;

    QueryRunArchived: QueryRun has been archived