hess16. Total Per Chain
    Updated 2025-01-21
    with trade as ( select block_timestamp,
    'Sei' as chain,
    tx_hash,
    trader,
    symbol,
    amount_usd
    from sei.vertex.ez_perp_trades
    where is_taker = 'true'
    UNION
    select block_timestamp,
    'Arbitrum' as chain,
    tx_hash,
    trader,
    symbol,
    amount_usd
    from arbitrum.vertex.ez_perp_trades
    where is_taker = 'true'
    UNION
    select block_timestamp,
    'Mantle' as chain,
    tx_hash,
    trader,
    symbol,
    amount_usd
    from mantle.vertex.ez_perp_trades
    where is_taker = 'true'
    UNION
    select block_timestamp,
    'Blitz' as chain,
    tx_hash,
    trader,
    symbol,
    amount_usd
    from blast.blitz.ez_perp_trades
    where is_taker = 'true'
    UNION
    Last run: 3 months ago
    CHAIN
    VOLUME
    AVG_VOLUME
    MAX_VOLUME
    MIN_VOLUME
    MEDIAN_VOLUME
    TRADERS
    PREP_TRADES
    1
    Sei10162336014.98352187.1131631115804703.8660626131295.4851234646461
    2
    Base31588279.77735711892.306941674201533.3626725354.318176923.4486897387216693
    3
    Mantle955387943.7524871656.416560478309547.5181124.275438788982.14329576780
    4
    Arbitrum5173635376.041961842.515234067580353.9063.7419941.9115818342807920
    5
    Blitz1098043465.9171764.863671956350072.4694938993.841059.695424622169
    5
    426B
    8s