feyikemiDaily Trades
Updated 2024-12-20
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
›
⌄
WITH tb1 AS(
SELECT
DATE_TRUNC('day', BLOCK_TIMESTAMP) AS Date,
EDGE_TRADE_TYPE,
COUNT(DISTINCT TX_HASH) AS Total_Trades,
SUM(Total_Trades) OVER (ORDER BY DATE) AS CUM_TRADES,
COUNT(DISTINCT TRADER) AS Total_Traders,
SUM(Total_Traders) OVER (ORDER BY DATE) AS CUM_TRADERS,
SUM(EDGE_AMOUNT_USD) AS Total_Volume,
SUM(Total_Volume) OVER (ORDER BY DATE) AS CUM_VOLUME
FROM base.vertex.ez_edge_trades
WHERE BLOCK_TIMESTAMP::Date >= '2024-09-17' --Launch date
GROUP BY 1, 2
)
SELECT
Date,
EDGE_TRADE_TYPE,
CASE WHEN EDGE_TRADE_TYPE = 'buy/long' THEN TOTAL_TRADES ELSE -TOTAL_TRADES END AS TOTAL_TRADES,
CUM_TRADES,
CASE WHEN EDGE_TRADE_TYPE = 'buy/long' THEN TOTAL_TRADERS ELSE -TOTAL_TRADERS END AS TOTAL_TRADERS,
CUM_TRADERS,
CASE WHEN EDGE_TRADE_TYPE = 'buy/long' THEN TOTAL_VOLUME ELSE -TOTAL_VOLUME END AS TOTAL_VOLUME,
CUM_VOLUME
FROM tb1
ORDER BY DATE, EDGE_TRADE_TYPE
QueryRunArchived: QueryRun has been archived