yasminSpot Trading Status Past 30-Day
Updated 2024-12-19
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
-- forked from PREP @ https://flipsidecrypto.xyz/edit/queries/e1297f51-a903-4b13-a7de-60ddeb3579cf
SELECT
ORDER_TYPE,
TRADE_TYPE,
SYMBOL,
date_trunc('day', block_timestamp) as date,
SUM(amount_usd) AMOUNT,
CASE
WHEN TRADE_TYPE IN ('buy/long') THEN '🟩'
WHEN TRADE_TYPE IN ('sell/short') THEN '🟥'
ELSE ''
END AS "trade type"
FROM
arbitrum.vertex.ez_spot_trades
WHERE
IS_TAKER = 'TRUE'
AND block_timestamp >= CURRENT_TIMESTAMP - INTERVAL '30 day'
GROUP BY
1, 2, 3, 4;
QueryRunArchived: QueryRun has been archived