0xHaM-dCross Over Projects
Updated 2023-02-10
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 starTb as (
select
'Star Atlas' as game,
block_timestamp,
tx_id,
signers[0] as user_address
from solana.core.fact_events events
where program_id in (
'FLEET1qqzpexyaDpqb2DGsSzE2sDCizewCg9WjrA6DBW', -- SA FLEET Program
'traderDnaR5w6Tcoi3NFm53i48FTDNbGjBSZwWXDRrg', -- SA Marketplace Program
'gateVwTnKyFrE8nxUUgfzoZTPKgJQZUbLsEidpG4Dp2' -- SA Governance Staking Program
)
and succeeded = TRUE
)
, genopetsTb as (
select
'Genopets' as game,
block_timestamp,
tx_id,
signers[0] as user_address
from solana.core.fact_events events
where program_id in (
'HAbiTatJVqoCJd9asyr6RxMEdwtfrQugwp7VAFyKWb1g', -- GP Habitats Program
'CrAFTUv7zKXBaS5471aCwHx7mq9Jp1eQQB5FQgdiSLyi', -- GP Alchemy Program
'StaKe9nb7aUjXpjpZ45o6uJBsZxj2BWCDBtjk8LCg2v', -- GP Staking Program
'srmv4uTCPF81hWDaPyEN2mLZ8XbvzuEM6LsAxR8NpjU' -- GP Marketplace Program
)
and succeeded = TRUE
)
, auroryTb as (
select
'Genopets' as game,
block_timestamp,
tx_id,
signers[0] as user_address
from solana.core.fact_events events
Run a query to Download Data