TheLaughingManDaily Stats - maker instance param
    Updated 2025-01-24


    with edge_vols as (
    SELECT
    block_timestamp::date as ddate
    , 'sei' as label
    , CASE
    WHEN
    (trader = '0x0000000000000000000000000000000000000000'
    AND subaccount='0x0000000000000000000000000000000000000000000000000000000000000001')
    THEN 'EDGE'
    ELSE 'Normal' END as label2
    , SUM(CASE WHEN is_taker=FALSE THEN AMOUNT_USD ELSE 0 END) as volume
    from sei.vertex.ez_perp_trades
    WHERE 1=1
    GROUP BY ddate, label, label2

    UNION ALL

    SELECT
    block_timestamp::date as ddate
    , 'base' as label
    , CASE
    WHEN
    (trader = '0x0000000000000000000000000000000000000000'
    AND subaccount='0x0000000000000000000000000000000000000000000000000000000000000001')
    THEN 'EDGE'
    ELSE 'Normal' END as label2
    , SUM(CASE WHEN is_taker=FALSE THEN AMOUNT_USD ELSE 0 END) as volume
    from base.vertex.ez_perp_trades
    WHERE 1=1
    GROUP BY ddate, label, label2

    UNION ALL

    SELECT
    QueryRunArchived: QueryRun has been archived