Afonso_Diaz2023-02-11 04:41 AM
Updated 2023-02-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
t as (
select
distinct signers[0] as user
from solana.core.fact_events
where program_id in (
'STkwf3sbMapjy7KV3hgrJtcVvY4SvRxWQ8pj4Enw1i5',
'EXpwP3pqPzA4arF8i89w7smtvxHzyYETmCpPspLPrR7J',
'CAsieqooSrgVxhgWRwh21gyjq7Rmuhmo4qTW9XzXtAvW',
'comp8FLpN5bbNUC2fhnkFtM7T16DWvaHs8N5dcaoZWP',
'StKLLTf7CQ9n5BgXPSDXENovLTCuNc7N2ehvTb6JZ5x'
)--Aurory
),
t2 as (
select
distinct signers[0] as user
from solana.core.fact_events
where program_id in (
'StaKe9nb7aUjXpjpZ45o6uJBsZxj2BWCDBtjk8LCg2v',
'HAbiTatJVqoCJd9asyr6RxMEdwtfrQugwp7VAFyKWb1g',
'srmv4uTCPF81hWDaPyEN2mLZ8XbvzuEM6LsAxR8NpjU',
'CrAFTUv7zKXBaS5471aCwHx7mq9Jp1eQQB5FQgdiSLyi'
) --Genopets
),
t3 as (
select
distinct signers[0] as user
from solana.core.fact_events
where program_id in (
'gateVwTnKyFrE8nxUUgfzoZTPKgJQZUbLsEidpG4Dp2',
'traderDnaR5w6Tcoi3NFm53i48FTDNbGjBSZwWXDRrg',
'FLEET1qqzpexyaDpqb2DGsSzE2sDCizewCg9WjrA6DBW'
) --StarAtlas
),
Run a query to Download Data