flipside

    Data Science - Vertex Traders Data Clustering
    feyikemiData Science - Vertex Traders Data Clustering
    Updated 2024-04-22
    -- forked from SocioCrypto / Vertex Traders Data @ https://flipsidecrypto.xyz/SocioCrypto/q/pKznEWXxIgEH/vertex-traders-data

    with vertex_users as (
    SELECT
    trader
    FROM
    arbitrum.vertex.ez_account_stats
    WHERE
    FIRST_TRADE_TIMESTAMP >= current_date - interval '3 months'
    ),
    vertex_behaviour as (
    SELECT
    trader,
    trade_count,
    PERP_TRADE_COUNT,
    SPOT_TRADE_COUNT,
    LONG_COUNT,
    SHORT_COUNT,
    TOTAL_USD_VOLUME,
    AVG_USD_TRADE_SIZE,
    TOTAL_FEE_AMOUNT
    FROM
    arbitrum.vertex.ez_account_stats
    WHERE
    trader in (
    SELECT
    trader
    FROM
    vertex_users
    )
    ),
    defi_interactions as (
    SELECT
    trader,
    count(DISTINCT platform) as n_defi_interactions
    FROM
    QueryRunArchived: QueryRun has been archived