hessTotal
    Updated 2024-09-26
    with trade as ( select block_timestamp,
    tx_hash,
    trader,
    symbol,
    amount_usd
    from blast.blitz.ez_perp_trades
    where is_taker = 'true'
    )

    select
    sum(amount_usd) as volume,
    avg(amount_usd) as avg_volume,
    max(amount_usd) as max_volume,
    min(amount_usd) as min_volume,
    median(amount_usd) as median_volume
    from trade
    QueryRunArchived: QueryRun has been archived