flipside

    traders categories
    datavortextraders categories
    Updated 2025-04-28
    WITH SwapData AS (
    SELECT
    tx_hash,
    origin_from_address AS trader,
    block_timestamp
    FROM
    ink.core.ez_decoded_event_logs
    WHERE
    event_name = 'Swap'
    AND origin_to_address = '0xa8c1c38ff57428e5c3a34e0899be5cb385476507'
    AND block_timestamp IS NOT NULL
    AND tx_succeeded = TRUE
    ),

    token_transfers AS (
    SELECT
    tx_hash,
    symbol,
    amount_usd
    FROM
    ink.core.ez_token_transfers
    ),

    transfers_with_index AS (
    SELECT
    tx_hash,
    symbol,
    amount_usd,
    ROW_NUMBER() OVER (PARTITION BY tx_hash ORDER BY LOWER(symbol) ASC) AS symbol_index
    FROM
    token_transfers
    ),

    amounts_with_index AS (
    SELECT
    t1.tx_hash,
    Last run: 14 days ago
    VOLUME_CATEGORY
    num_traders
    total_trades
    total_volume_usd
    avg_volume_per_trader_usd
    1
    		Under 10 USD4230312390061404.261.451534407
    2
    		10-50 USD20859146539517469.3624.807965866
    3
    		50-100 USD375048306252536.0867.342954667
    4
    		100-500 USD258431577542374.78209.897360681
    5
    		500-1000 USD5168659358918.5695.578488372
    6
    		1000-5000 USD686206071566145.72283.01122449
    7
    		5000-10000 USD17429511225231.727041.561609195
    8
    		10000+ USD202135906948519.9434398.613564356
    8
    409B
    9s