MuzeCross over User Base copy
Updated 2023-04-15
999
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 mango as (
-- select
-- distinct signers[0] as user,
-- 'mango' as program
-- from solana.core.fact_events
-- where program_id = '4MangoMjqJ2firMokCjjGgoK8d4MXcrgL7XJaL3w6fVg'
-- and succeeded
-- and block_timestamp > '2023-01-01'
-- ),
-- zeta as (
-- select
-- distinct signers[0] as user,
-- 'zeta' as program
-- from solana.core.fact_events a
-- left join mango b on a.signers[0] = b.user
-- where program_id = 'ZETAxsqBRek56DhiGXrn75yj2NHU3aYUnxvHXpkf3aD'
-- and succeeded
-- and block_timestamp > '2023-01-01'
-- ),
-- drift as (
-- select
-- distinct signers[0] as user,
-- 'drift' as program
-- from solana.core.fact_events a
-- left join mango b on a.signers[0] = b.user
-- where program_id = 'dRiftyHA39MWEi3m9aunc5MzRF1JYuBsbn6VPcn33UH'
-- and succeeded
Run a query to Download Data