DDATE | LABEL | LABEL2 | VOLUME | |
|---|---|---|---|---|
1 | 2024-03-13 00:00:00.000 | arbitrum | Normal | 342170054.213059 |
2 | 2024-03-13 00:00:00.000 | arbitrum | EDGE | 30258871.0106 |
3 | 2024-03-14 00:00:00.000 | arbitrum | Normal | 391403158.248967 |
4 | 2024-03-14 00:00:00.000 | arbitrum | EDGE | 75744281.3628 |
5 | 2024-03-15 00:00:00.000 | arbitrum | Normal | 440710180.341316 |
6 | 2024-03-15 00:00:00.000 | arbitrum | EDGE | 92720209.7178 |
7 | 2024-03-16 00:00:00.000 | arbitrum | Normal | 301429697.152345 |
8 | 2024-03-16 00:00:00.000 | arbitrum | EDGE | 83305671.1688 |
9 | 2024-03-17 00:00:00.000 | arbitrum | Normal | 240041293.507127 |
10 | 2024-03-17 00:00:00.000 | arbitrum | EDGE | 53131888.2282 |
11 | 2024-03-18 00:00:00.000 | arbitrum | Normal | 291196284.933417 |
12 | 2024-03-18 00:00:00.000 | arbitrum | EDGE | 59679601.7543 |
13 | 2024-03-19 00:00:00.000 | arbitrum | Normal | 417909510.602239 |
14 | 2024-03-19 00:00:00.000 | arbitrum | EDGE | 76576457.3578 |
15 | 2024-03-20 00:00:00.000 | arbitrum | Normal | 474061507.053826 |
16 | 2024-03-20 00:00:00.000 | arbitrum | EDGE | 66813524.3244 |
17 | 2024-03-21 00:00:00.000 | arbitrum | Normal | 403695730.55599 |
18 | 2024-03-21 00:00:00.000 | arbitrum | EDGE | 47426959.0654 |
19 | 2024-03-22 00:00:00.000 | arbitrum | Normal | 446646324.840754 |
20 | 2024-03-22 00:00:00.000 | arbitrum | EDGE | 43047390.706 |
TheLaughingManDaily Stats - taker instance param
Updated 2025-05-24
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 edge_vols as (
SELECT
block_timestamp::date as ddate
, 'sei' as label
, CASE
WHEN
(trader = '0x0000000000000000000000000000000000000000'
AND subaccount='0x0000000000000000000000000000000000000000000000000000000000000001')
THEN 'EDGE'
ELSE 'Normal' END as label2
, SUM(CASE WHEN is_taker=TRUE THEN AMOUNT_USD ELSE 0 END) as volume
from sei.vertex.ez_perp_trades
WHERE 1=1
GROUP BY ddate, label, label2
UNION ALL
SELECT
block_timestamp::date as ddate
, 'base' as label
, CASE
WHEN
(trader = '0x0000000000000000000000000000000000000000'
AND subaccount='0x0000000000000000000000000000000000000000000000000000000000000001')
THEN 'EDGE'
ELSE 'Normal' END as label2
, SUM(CASE WHEN is_taker=TRUE THEN AMOUNT_USD ELSE 0 END) as volume
from base.vertex.ez_perp_trades
WHERE 1=1
GROUP BY ddate, label, label2
UNION ALL
SELECT
Last run: 12 days ago
...
876
53KB
2s