Upgrading - Budget: $200

AephiaUpgrading - Budget: $200

Updated 5 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 5 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	171.15	10	3.39	50.49	16	0.00761	0.012154	917632	0.3	1.79	0.04	327%
2	Field Stabilizer	200	171.15	10	3.39	50.49	24	0.018146	0.022957	384833	0.47	1.25	0.02	228%
3	Power Source	200	171.15	10	3.39	50.49	15	0.006885	0.009723	1014260	0.29	1.2	0.02	219%
4	Electronics	200	171.15	10	3.39	50.49	14	0.004347	0.006842	1606436	0.19	1.09	0.02	199%
5	Radiation Absorber	200	171.15	10	3.39	50.49	48	0.021614	0.029259	323086	0.28	0.99	0.02	181%
6	Particle Accelerator	200	171.15	10	3.39	50.49	96	0.031111	0.043213	224460	0.2	0.78	0.02	142%
7	Framework	200	171.15	10	3.39	50.49	12	0.003027	0.004321	2306963	0.16	0.68	0.01	124%
8	Survey Data Unit	200	171.15	10	3.39	50.49	120	0.134179	0.09903	52044	0.7	-1.83	-0.04	-334%

756B

164s

flipside