X | LABEL | USERS | TOTAL | PCT | |
---|---|---|---|---|---|
1 | Zeta Markets | 75032 | 286613 | 26.1789 | |
2 | Drift V2 | 162097 | 286613 | 56.5561 | |
3 | Common Users | 49484 | 286613 | 17.2651 |
marquSol Perps - [all] common users
Updated 2025-01-21
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
d2_users as (
select distinct signers[0] as wallet_address
from solana.core.fact_events events
where succeeded
and program_id = 'dRiftyHA39MWEi3m9aunc5MzRF1JYuBsbn6VPcn33UH'
and block_timestamp >= '2023-01-01' ::date
),
zeta_users as (
select distinct signers[0] as wallet_address
from solana.core.fact_events events
where succeeded
and program_id = 'ZETAxsqBRek56DhiGXrn75yj2NHU3aYUnxvHXpkf3aD'
and block_timestamp >= '2023-01-01' ::date
),
user_list as (
select
wallet_address,
case
when d2_users.wallet_address is null then 'Zeta Markets'
when zeta_users.wallet_address is null then 'Drift V2'
else 'Common Users'
end as label
from d2_users
full outer join zeta_users
using(wallet_address)
)
Last run: about 1 month ago
3
121B
70s