TheLaughingManall time volume - perps ( No EDGE )
    Updated 2025-05-05
    with merge as (

    ---arbitrum
    SELECT * EXCLUDE version, 'arbitrum' as label from arbitrum.vertex.ez_perp_trades
    WHERE 1=1
    AND trader != '0x0000000000000000000000000000000000000000'
    AND subaccount!='0x0000000000000000000000000000000000000000000000000000000000000001'
    UNION ALL
    ---base
    SELECT *, 'base' as label from base.vertex.ez_perp_trades
    WHERE 1=1
    AND trader != '0x0000000000000000000000000000000000000000'
    AND subaccount!='0x0000000000000000000000000000000000000000000000000000000000000001'

    UNION ALL
    ---blitz
    SELECT * , 'blitz' as label from blast.blitz.ez_perp_trades
    WHERE 1=1
    AND trader != '0x0000000000000000000000000000000000000000'
    AND subaccount!='0x0000000000000000000000000000000000000000000000000000000000000001'

    UNION ALL
    ---mantle
    SELECT *, 'mantle' as label from mantle.vertex.ez_perp_trades
    WHERE 1=1
    AND trader != '0x0000000000000000000000000000000000000000'
    AND subaccount!='0x0000000000000000000000000000000000000000000000000000000000000001'

    UNION ALL
    ---sei
    SELECT * , 'sei' as label from sei.vertex.ez_perp_trades
    WHERE 1=1
    AND trader != '0x0000000000000000000000000000000000000000'
    AND subaccount!='0x0000000000000000000000000000000000000000000000000000000000000001'
    Last run: 23 days ago
    UNIQUE_TRADERS
    TOTAL_ORDERS
    TOTAL_VOLUME
    TOTAL_FEES
    1
    5096791243726150950321944.19121785173.4365517
    1
    52B
    8s