flipside

    datavortex
    Updated 2024-12-20
    WITH trader_data AS (
    SELECT
    trader,
    COUNT(DISTINCT digest) AS trades_count,
    SUM(
    CASE
    WHEN is_taker = FALSE THEN amount_usd
    ELSE 0
    END
    ) AS trade_volume
    FROM
    arbitrum.vertex.ez_perp_trades
    WHERE
    trader != '0x0000000000000000000000000000000000000000'
    AND subaccount != '0x0000000000000000000000000000000000000000000000000000000000000001'
    GROUP BY
    trader
    ),
    ranked_traders AS (
    SELECT
    trader,
    trades_count,
    trade_volume,
    RANK() OVER (
    ORDER BY
    trade_volume DESC
    ) AS volume_rank
    FROM
    trader_data
    )
    SELECT
    trader,
    trades_count,
    trade_volume,
    volume_rank
    FROM
    QueryRunArchived: QueryRun has been archived