picasoTrader Profit/Loss Calculation
Updated 2024-12-21
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
WITH trader_profit_loss AS (
SELECT
TRADER,
SUM(AMOUNT_USD) AS total_trade_volume,
SUM(CASE WHEN IS_TAKER = 'TRUE' THEN AMOUNT_USD ELSE 0 END) AS taker_volume,
SUM(CASE WHEN IS_TAKER = 'FALSE' THEN AMOUNT_USD ELSE 0 END) AS maker_volume
FROM
arbitrum.vertex.ez_perp_trades
GROUP BY
TRADER
)
SELECT
TRADER,
total_trade_volume,
taker_volume,
maker_volume,
taker_volume - maker_volume AS profit_loss
FROM
trader_profit_loss
ORDER BY
profit_loss DESC
LIMIT 10;
QueryRunArchived: QueryRun has been archived