TheLaughingMan16. Total Per Chain copy
    Updated 2024-12-21
    -- forked from hess / 16. Total Per Chain @ https://flipsidecrypto.xyz/hess/q/VuVmObAHHBBz/16.-total-per-chain

    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 ALL
    select block_timestamp,
    'Arbitrum' as chain,
    tx_hash,
    trader,
    symbol,
    amount_usd
    from arbitrum.vertex.ez_perp_trades
    where is_taker = 'true'
    UNION ALL
    select block_timestamp,
    'Mantle' as chain,
    tx_hash,
    trader,
    symbol,
    amount_usd
    from mantle.vertex.ez_perp_trades
    where is_taker = 'true'
    UNION ALL
    select block_timestamp,
    'Blitz' as chain,
    tx_hash,
    trader,
    symbol,
    amount_usd
    from blast.blitz.ez_perp_trades
    Last run: 20 days ago
    CHAIN
    VOLUME
    AVG_VOLUME
    MAX_VOLUME
    MIN_VOLUME
    MEDIAN_VOLUME
    TRADERS
    PREP_TRADES
    1
    Base26941080.51486381944.502382884154236.1715954.854069614959.6069213846713855
    2
    Sei10282181411.53852045.7020743835804703.68226341054.2968593721435026236
    3
    Blitz2008441797.130041860.012777487350072.4694938993.6831074.5857084925071079800
    4
    Arbitrum6570697276.426851719.425609612755081.0162032413.6443368803.3519813821449
    5
    Mantle1217838572.729511636.681816352313374.2748549714.3273977.306229744090
    5
    445B
    7s