SELECT
'Long' as position,
symbol,
COUNT(DISTINCT tx_hash) AS transaction_count,
COUNT(DISTINCT trader) AS unique_trader_count,
SUM(amount_usd) AS transaction_volume,
FROM
blast.blitz.ez_perp_trades
WHERE
trader != '0x0000000000000000000000000000000000000000' and
trade_type = 'buy/long'
group by position, symbol
union
SELECT
'Short' as position,
symbol,
-COUNT(DISTINCT tx_hash) AS transaction_count,
-COUNT(DISTINCT trader) AS unique_trader_count,
-SUM(amount_usd) AS neg_transaction_volume,
FROM
blast.blitz.ez_perp_trades
WHERE
trader != '0x0000000000000000000000000000000000000000' and
trade_type = 'sell/short'
group by position, symbol