AephiaStarbases Demand
Updated 2025-02-09
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 mining_fleets AS (
SELECT
instruction:accounts[3] as mining_fleets
FROM solana.core.fact_events
WHERE program_id = 'SAGE2HAwep459SNq61LHvjxPk4pLPEJLoMETef7f7EE'
AND instruction:accounts[4] = 'GAMEzqJehF8yAnKiTARUuhZMvLvkZVAsCVri5vSfemLr'
AND instruction:accounts[18] = 'MineMBxARiRdMh7s1wdStSK4Ns3YfnLjBfvF5ZCnzuw'
AND succeeded = 'true'
AND block_timestamp > current_date-40 AND block_timestamp < current_date
group by 1
)
,scanning_fleets AS (
SELECT
instruction:accounts[3] as scanning_fleets
FROM solana.core.fact_events
WHERE program_id = 'SAGE2HAwep459SNq61LHvjxPk4pLPEJLoMETef7f7EE'
AND instruction:accounts[4] = 'GAMEzqJehF8yAnKiTARUuhZMvLvkZVAsCVri5vSfemLr'
AND instruction:accounts[18] = 'DataJpxFgHhzwu4zYJeHCnAv21YqWtanEBphNxXBHdEY'
AND succeeded = 'true'
AND block_timestamp > current_date-40 AND block_timestamp < current_date
group by 1
)
,cargo_fleets AS (
SELECT
instruction:accounts[0] as cargo_fleets
Auto-refreshes every 24 hours
QueryRunArchived: QueryRun has been archived