LABEL | UNIQUE_TRADERS | TOTAL_ORDERS | TOTAL_VOLUME | TOTAL_FEES | |
|---|---|---|---|---|---|
1 | arbitrum | 1190 | 2486054 | 3057008069.43649 | 209052.362194474 |
2 | base | 98 | 6656 | 1735490.631289 | 6142.02543373 |
3 | blitz | 268 | 287293 | 392199382.488211 | 33657.12593958 |
4 | mantle | 26 | 291240 | 529791274.589692 | -10995.48421625 |
5 | sei | 112 | 6478742 | 8330528176.20971 | 610986.102720668 |
TheLaughingMantotal stats by label
Updated 2025-04-11
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
›
⌄
with merge as (
---arbitrum
SELECT * EXCLUDE version, 'arbitrum' as label from arbitrum.vertex.ez_perp_trades
WHERE 1=1
AND block_timestamp::date BETWEEN '{{start_date}}' AND '{{end_date}}'
AND trader != '0x0000000000000000000000000000000000000000'
AND subaccount!='0x0000000000000000000000000000000000000000000000000000000000000001'
UNION ALL
---base
SELECT *, 'base' as label from base.vertex.ez_perp_trades
WHERE 1=1
AND block_timestamp::date BETWEEN '{{start_date}}' AND '{{end_date}}'
AND trader != '0x0000000000000000000000000000000000000000'
AND subaccount!='0x0000000000000000000000000000000000000000000000000000000000000001'
UNION ALL
---blitz
SELECT * , 'blitz' as label from blast.blitz.ez_perp_trades
WHERE 1=1
AND block_timestamp::date BETWEEN '{{start_date}}' AND '{{end_date}}'
AND trader != '0x0000000000000000000000000000000000000000'
AND subaccount!='0x0000000000000000000000000000000000000000000000000000000000000001'
UNION ALL
---mantle
SELECT * , 'mantle' as label from mantle.vertex.ez_perp_trades
WHERE 1=1
AND block_timestamp::date BETWEEN '{{start_date}}' AND '{{end_date}}'
AND trader != '0x0000000000000000000000000000000000000000'
AND subaccount!='0x0000000000000000000000000000000000000000000000000000000000000001'
Last run: 18 days ago
5
268B
5s