DDATE | LABEL | UNIQUE_TRADERS | TOTAL_ORDERS | TOTAL_VOLUME | TOTAL_FEES | |
|---|---|---|---|---|---|---|
1 | 2024-10-01 00:00:00.000 | new | 50 | 176 | 362026.949 | 409.844053575 |
2 | 2024-10-01 00:00:00.000 | old | 497 | 293798 | 261748850.539119 | 40220.491547044 |
3 | 2024-10-02 00:00:00.000 | new | 30 | 254 | 364239.52 | 311.280326321 |
4 | 2024-10-02 00:00:00.000 | old | 387 | 239328 | 208106846.868987 | 31827.050707089 |
5 | 2024-10-03 00:00:00.000 | new | 42 | 126 | 0 | 503.278761321 |
6 | 2024-10-03 00:00:00.000 | old | 311 | 233708 | 186977009.052795 | 27674.765509097 |
7 | 2024-10-04 00:00:00.000 | new | 45 | 627 | 260542.416 | 520.892291109 |
8 | 2024-10-04 00:00:00.000 | old | 310 | 158433 | 140986221.716446 | 21938.39755002 |
9 | 2024-10-05 00:00:00.000 | new | 19 | 337 | 168548.031 | 134.510961073 |
10 | 2024-10-05 00:00:00.000 | old | 245 | 64867 | 53345705.4876267 | 8137.92222964 |
11 | 2024-10-06 00:00:00.000 | new | 19 | 546 | 1737379.561 | 1154.636489902 |
12 | 2024-10-06 00:00:00.000 | old | 234 | 78138 | 74458438.0041755 | 10649.810563434 |
13 | 2024-10-07 00:00:00.000 | new | 26 | 251 | 159427.797 | 74.675720447 |
14 | 2024-10-07 00:00:00.000 | old | 360 | 196118 | 188417722.382831 | 29274.337691914 |
15 | 2024-10-08 00:00:00.000 | new | 70 | 470 | 190942.021 | 80.176219944 |
16 | 2024-10-08 00:00:00.000 | old | 360 | 143382 | 123832441.621925 | 19126.289480463 |
17 | 2024-10-09 00:00:00.000 | new | 67 | 455 | 302268.216 | 197.502852302 |
18 | 2024-10-09 00:00:00.000 | old | 366 | 127477 | 115383969.60744 | 17681.596067103 |
19 | 2024-10-10 00:00:00.000 | new | 90 | 1456 | 515883.225 | 181.034206465 |
20 | 2024-10-10 00:00:00.000 | old | 370 | 118699 | 98484191.7953855 | 15410.948406531 |
TheLaughingMannew vs old traffic
Updated 7 days ago
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 new users by instance @ https://flipsidecrypto.xyz/studio/queries/c8ac5c1a-c63d-4c2f-bb3c-8bf718b0822c
-- forked from new users @ https://flipsidecrypto.xyz/studio/queries/1a856392-7af8-4ad9-96ee-909b0154fe62
with merge_all_time 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: 7 days ago
...
184
13KB
77s