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=TRUE THEN AMOUNT_USD ELSE 0 END) as volume

from sei.vertex.ez_perp_trades

WHERE 1=1

AND (symbol ilike '{{ticker}}%' AND symbol ilike '%perp')

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=TRUE THEN AMOUNT_USD ELSE 0 END) as volume

from base.vertex.ez_perp_trades

WHERE 1=1

AND (symbol ilike '{{ticker}}%' AND symbol ilike '%perp')

GROUP BY ddate, label, label2

UNION ALL