SYMBOL | NAME | BUDGET | PRICE | SHIPS | FLEETS | FLOOR_PRICE_CREW | CREW | RESSOURCE | RICHNESS | HARDNESS | MR | REVENUE | AMMO_MINE | FOOD_MINE | FUEL_MINE | FUEL_CARGO | SOL_MINE | SOL_CARGO | NET_PROFIT | PM | ROI | PM_LM | ROI_LM | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | CALMAX | Calico Maxhog | 200 | 19.48 | 9.03 | 1 | 2.67 | 9.03 | HYG | 1 | 1 | 0.743 | 168.5 | 52.88 | 32.01 | 3.17 | 0 | 145.86 | 0 | -65.42 | -38.82 | -15.23 | -38.82 | -15.23 |
2 | FBLLOW | Fimbul Lowbie | 200 | 22.2 | 8.04 | 1 | 2.67 | 8.04 | HYG | 1 | 1 | 0.743 | 149.32 | 47.09 | 28.5 | 3.46 | 0 | 162.9 | 0 | -92.63 | -62.03 | -21.56 | -62.03 | -21.56 |
3 | OGKANR | Ogrika Niruch | 200 | 70.99 | 2.72 | 1 | 2.67 | 2.72 | HYG | 1 | 1 | 0.743 | 50.52 | 15.93 | 9.64 | 1.07 | 0 | 162.9 | 0 | -139.02 | -275.18 | -32.36 | -275.18 | -32.36 |
4 | CALMED | Calico Medtech | 200 | 105 | 1.81 | 1 | 2.67 | 3.62 | HYG | 1 | 1 | 2.504 | 110.82 | 35.81 | 6.42 | 3.25 | 0 | 241 | 0 | -175.66 | -158.51 | -40.88 | -158.51 | -40.88 |
5 | PX6 | Pearce X6 | 200 | 80.09 | 2.27 | 1 | 2.67 | 6.81 | HYG | 1 | 1 | 3.062 | 168.35 | 54.97 | 11.93 | 6.14 | 0 | 274.25 | 0 | -178.94 | -106.29 | -41.65 | -106.29 | -41.65 |
6 | VZUSAM | VZUS ambwe | 200 | 96.92 | 1.91 | 1 | 2.67 | 5.73 | HYG | 1 | 1 | 2.979 | 136.96 | 45.05 | 10.04 | 5.16 | 0 | 295.68 | 0 | -218.97 | -159.88 | -50.96 | -159.88 | -50.96 |
7 | TUFAFE | Tufa Feist | 200 | 77 | 2.43 | 1 | 2.67 | 4.86 | HYG | 1 | 1 | 3.062 | 177.41 | 58.85 | 8.61 | 7.68 | 0 | 328.39 | 0 | -226.12 | -127.46 | -52.63 | -127.46 | -52.63 |
8 | FBLBEA | Fimbul BYOS Earp | 200 | 78.22 | 2.39 | 1 | 2.67 | 4.78 | HYG | 1 | 1 | 3.062 | 174.49 | 57.88 | 8.47 | 8.3 | 0 | 328.39 | 0 | -228.55 | -130.98 | -53.19 | -130.98 | -53.19 |
9 | PX4 | Pearce X4 | 200 | 3 | 35.3 | 1 | 2.67 | 35.3 | HYG | 1 | 1 | 0.32 | 268.64 | 89.4 | 60.41 | 11.45 | 0 | 337.2 | 0 | -229.82 | -85.55 | -53.49 | -85.55 | -53.49 |
10 | OGKAMK | Ogrika Mik | 200 | 83.63 | 2.25 | 1 | 2.67 | 4.5 | HYG | 1 | 1 | 3.062 | 164.27 | 54.49 | 7.98 | 7.46 | 0 | 328.39 | 0 | -234.05 | -142.48 | -54.47 | -142.48 | -54.47 |
11 | CHI | Rainbow Chi | 200 | 92.29 | 2.11 | 1 | 2.67 | 2.11 | HYG | 1 | 1 | 3.062 | 154.05 | 51.1 | 3.61 | 6.33 | 0 | 328.39 | 0 | -235.38 | -152.79 | -54.78 | -152.79 | -54.78 |
12 | THRILL | Busan Thrill of Life | 200 | 99 | 1.92 | 1 | 2.67 | 3.84 | HYG | 1 | 1 | 3.062 | 140.18 | 46.5 | 6.81 | 6.37 | 0 | 328.39 | 0 | -247.89 | -176.84 | -57.7 | -176.84 | -57.7 |
13 | PX5 | Pearce X5 | 200 | 18.85 | 8.27 | 1 | 2.67 | 16.54 | HYG | 1 | 1 | 0.99 | 193.2 | 65.45 | 29.32 | 9.4 | 0 | 363.74 | 0 | -274.71 | -142.19 | -63.94 | -142.19 | -63.94 |
14 | OPALJJ | Opal Jetjet | 200 | 15.99 | 9.38 | 1 | 2.67 | 18.76 | HYG | 1 | 1 | 0.81 | 178.43 | 59.39 | 33.25 | 12.86 | 0 | 379.92 | 0 | -306.99 | -172.05 | -71.45 | -172.05 | -71.45 |
15 | OPALJ | Opal Jet | 200 | 2.04 | 42.46 | 1 | 2.67 | 42.46 | HYG | 1 | 1 | 0.262 | 258.1 | 87.37 | 72.66 | 21.48 | 0 | 420.76 | 0 | -344.17 | -133.35 | -80.1 | -133.35 | -80.1 |
16 | FBLAIR | Fimbul Airbike | 200 | 2.28 | 40.39 | 1 | 2.67 | 40.39 | HYG | 1 | 1 | 0.262 | 245.51 | 83.11 | 69.12 | 20.43 | 0 | 420.76 | 0 | -347.91 | -141.71 | -80.98 | -141.71 | -80.98 |
17 | OGKARU | Ogrika Ruch | 200 | 2.51 | 38.63 | 1 | 2.67 | 38.63 | HYG | 1 | 1 | 0.262 | 234.81 | 79.49 | 66.11 | 19.54 | 0 | 420.76 | 0 | -351.09 | -149.52 | -81.72 | -149.52 | -81.72 |
18 | VZUSSO | VZUS solos | 200 | 2.58 | 38.12 | 1 | 2.67 | 38.12 | HYG | 1 | 1 | 0.262 | 231.71 | 78.44 | 65.23 | 19.29 | 0 | 420.76 | 0 | -352.01 | -151.92 | -81.93 | -151.92 | -81.93 |
19 | CALSCD | Calico Scud | 200 | 82.99 | 2.33 | 1 | 2.67 | 2.33 | HYG | 1 | 1 | 0.81 | 44.32 | 14.75 | 3.99 | 3.19 | 0 | 379.92 | 0 | -357.53 | -806.7 | -83.21 | -806.7 | -83.21 |
20 | OGKANR | Ogrika Niruch | 200 | 70.99 | 2.11 | 1 | 2.67 | 2.11 | IRON ORE | 1 | 2 | 0.3715 | 49.44 | 12.36 | 7.48 | 0.42 | 18.49 | 83.26 | 285.47 | -358.04 | -724.19 | -83.33 | -94.71 | -12.38 |
AephiaMining - Budget: $200
Updated 15 hours ago
9999
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 token_prices AS (
SELECT
*
FROM $query('21b1f230-5365-41ed-9d66-3f14153bec8b')
)
,mining_txs_fees AS (
SELECT
sol_mine_txs
FROM $query('e88bc49c-68a5-44dc-b6ce-c64275d58ecf')
WHERE date = current_date-1
)
,gecko_call_data as (
select live.udf_api('https://api.coingecko.com/api/v3/nfts/star-atlas-crew')
as response
)
,gecko_flattened_data as (
select * from
gecko_call_data, lateral flatten(input => parse_json(response:data))
)
,crew AS (
SELECT
case when key = 'floor_price' then value:usd end as fp_crew
FROM gecko_flattened_data
where fp_crew IS NOT NULL
)
,LM_volumes AS (
SELECT
Last run: about 15 hours ago
...
360
54KB
288s