Upgrading - Budget: $200

AephiaUpgrading - Budget: $200

Updated 22 hours ago

WITH LP_redemption AS (

SELECT

atlas_pool_all_sort

,sum(case when name = 'TOTAL'

then lp_redemption_sort

end) as total_lp

,total_lp / 3 as avg_lp

--,atlas_pool_all_sort / nullifzero(avg_lp) as lp_atlas_value

,atlas_pool_all_sort / nullifzero(total_lp) as lp_atlas_value

FROM $query('1f08298d-8319-463d-9bb4-329e4d3bfadb')

GROUP by ALL

)

,token_prices AS (

SELECT

hour::DATE AS DATE,

AVG(case when token_address = 'ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXx'

then price end) as atlas_price,

AVG(case when token_address = 'So11111111111111111111111111111111111111112'

then price end) as sol_price

FROM

SOLANA.price.ez_prices_hourly

WHERE

hour::DATE >= current_date-120

GROUP BY ALL

--order by 1 desc

)

,gecko_call_data as (

select live.udf_api('https://api.coingecko.com/api/v3/nfts/star-atlas-crew')

Last run: about 22 hours ago

	NAME	BUDGET	BUDGET_CREW	BUDGET_COMPONENTS	FLOOR_PRICE_CREW	CREW	UPGRADING_TIME	PRICE_ATLAS	LP_VALUE_ATLAS	COMPONENTS_PER_UPGRADE_JOB	UPGRADE_JOBS_PER_DAY	NET_PROFIT	NET_PROFIT_PER_CREW	ROI
1	Electromagnet	200	173.28	10	2.55	67.95	16	0.007	0.012357	1239733	0.3	2.3	0.03	420%
2	Radiation Absorber	200	173.28	10	2.55	67.95	48	0.0165	0.029748	525947	0.23	1.85	0.03	338%
3	Power Source	200	173.28	10	2.55	67.95	15	0.006174	0.009886	1405593	0.28	1.68	0.02	307%
4	Electronics	200	173.28	10	2.55	67.95	14	0.003719	0.006957	2333459	0.18	1.57	0.02	287%
5	Field Stabilizer	200	173.28	10	2.55	67.95	24	0.018136	0.023341	478503	0.51	1.46	0.02	266%
6	Framework	200	173.28	10	2.55	67.95	12	0.00265	0.004394	3274767	0.15	0.99	0.01	181%
7	Particle Accelerator	200	173.28	10	2.55	67.95	96	0.033363	0.043936	260112	0.24	0.76	0.01	139%
8	Survey Data Unit	200	173.28	10	2.55	67.95	120	0.135356	0.100687	64113	0.76	-1.95	-0.03	-356%

755B

73s

flipside