-- forked from Vertex Arbitrum - Edge Volumes (maker) @ https://flipsidecrypto.xyz/edit/queries/d2f6ea6d-3b55-4223-9a04-ed62bc971d45

SELECT

date_trunc('day', block_timestamp) as ddate

, CASE

WHEN trader = '0x0000000000000000000000000000000000000000'

and subaccount='0x0000000000000000000000000000000000000000000000000000000000000001'

THEN 'Edge' ELSE 'Normal' END as label

, SUM(amount_usd) as volume

from blast.blitz.ez_perp_trades

WHERE 1=1

AND block_timestamp>='2024-03-13'

AND SYMBOL=upper('{{TICKER}}') || '-PERP'

AND is_taker='false'

GROUP BY ddate, label

ORDER BY ddate ASC, label ASC