dannyamahVertex Trades and Traders(Total)
Updated 2024-08-08
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
27
28
29
›
⌄
WITH Vertex as (
SELECT
date_trunc(day, block_timestamp) AS date,
trader,
tx_hash,
amount_usd,
fee_amount
FROM arbitrum.vertex.ez_perp_trades
WHERE is_taker = TRUE
UNION all
SELECT
date_trunc(day, block_timestamp) AS date,
trader,
tx_hash,
amount_usd,
fee_amount
FROM arbitrum.vertex.ez_spot_trades
WHERE is_taker = TRUE
)
SELECT
count(DISTINCT trader) AS "Total Traders",
count(DISTINCT tx_hash) AS "Total Trades",
sum(amount_usd) AS "Total Trading Volume",
sum(fee_amount) AS "Total Fee Paid"
FROM Vertex
QueryRunArchived: QueryRun has been archived