ArioVertex Traders Leaderboard (Top 100)
Updated 2024-09-27
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
30
31
32
33
34
35
36
›
⌄
-- forked from Ali3N / Vertex Traders Leaderboard (Top 100) @ https://flipsidecrypto.xyz/Ali3N/q/FZOzLb5Kcj7E/vertex-traders-leaderboard-top-100
with maintable as (
select
'Perpetual' as Trading_Type,
block_timestamp,
tx_hash,
contract_address,
symbol,
trader,
amount_usd,
fee_amount,
is_taker
from
arbitrum.vertex.ez_perp_trades
UNION
ALL
select
'Spot' as Trading_Type,
block_timestamp,
tx_hash,
contract_address,
symbol,
trader,
amount_usd,
fee_amount,
is_taker
from
arbitrum.vertex.ez_spot_trades
)
select
trader as "Trader Wallet Address",
sum (
case
when is_taker = 'true' then amount_usd
else 0
end
QueryRunArchived: QueryRun has been archived