mining_slabs

Aephiamining_slabs

Updated 11 hours ago

WITH atlas_price AS (

SELECT

hour::DATE AS DATE,

AVG(price) AS atlas_price

FROM

SOLANA.price.ez_prices_hourly

WHERE

hour::DATE >= current_date-90

AND token_address = 'ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXx'

--AND block_timestamp > current_date-90 --AND block_timestamp < current_date

group by ALL

)

,r20_prices AS (

SELECT

--*

date_trunc('day', block_timestamp::date) as date,

--fp_crew,

----------------------------------------------------

sum(case when inner_instruction:instructions[2]:parsed:info:mint::string = 'fueL3hBZjLLLJHiFH9cqZoozTG3XQZ53diwFPwbzNim'

AND (inner_instruction:instructions[0]:parsed:info:tokenAmount:uiAmount + inner_instruction:instructions[1]:parsed:info:tokenAmount:uiAmount) / inner_instruction:instructions[2]:parsed:info:tokenAmount:uiAmount > 0.0001

then (inner_instruction:instructions[0]:parsed:info:tokenAmount:uiAmount + inner_instruction:instructions[1]:parsed:info:tokenAmount:uiAmount)

end) as fuel_atlas_amount,

sum(case when inner_instruction:instructions[2]:parsed:info:mint::string = 'fueL3hBZjLLLJHiFH9cqZoozTG3XQZ53diwFPwbzNim'

then inner_instruction:instructions[2]:parsed:info:tokenAmount:uiAmount

end) as fuel_amount,

fuel_atlas_amount / fuel_amount as fuel_price,

--------------------------------------------------------------

sum(case when inner_instruction:instructions[2]:parsed:info:mint::string = 'foodQJAztMzX1DKpLaiounNe2BDMds5RNuPC6jsNrDG'

Last run: about 11 hours agoAuto-refreshes every 12 hours

	SYMBOL	NAME	SPEC	CLASS	POINTS	MINING_RATE	CARGO_CAPACITY	PRICE	MINING_RATE_PER_USD	MINING_RATE_PER_POINT	MINING_RATE_PER_OP_COSTS	MAX_MINING_TIME_IN_MINUTES
1	OPALJ	Opal Jet	Racer	1	1	0.262	249	1.799125	8.7376	15.72	6421.7	15.84
2	FBLAIR	Fimbul Airbike	Racer	1	1	0.262	249	1.92	8.1875	15.72	6421.7	15.84
3	PX4	Pearce X4	Fighter	1	1	0.32	389	3.5	5.4857	19.2	7041.22	20.26
4	VZUSSO	VZUS Solos	Racer	1	1	0.262	249	3.99	3.9398	15.72	6421.7	15.84
5	OPALJJ	Opal Jetjet	Opal	2	4	0.81	863	13.14	3.6986	12.15	5036.07	17.76
6	FBLEUN	Fimbul ECOS Unibomba	Bomber	1	1	0.325	274	6.23	3.13	19.5	7151.24	14.05
7	FBLLOW	Fimbul Lowbie	Transport	2	4	0.743	1965	14.975	2.977	11.15	4756.96	44.08
8	FBLMEX	Fimbul Mamba EX	Bounty Hunter	4	16	9.212	17341	210.7875	2.6222	34.55	7225.45	31.37
9	CALMAX	Calico Maxhog	Transport	2	4	0.743	2205	17.9075	2.4895	11.15	4756.96	49.46
10	TUFAFE	Tufa Feist	Fighter	3	9	3.062	3832	74.957321981	2.451	20.41	7724.53	20.86
11	PX6	Pearce X6	Fighter	3	9	3.062	4661	75.673636364	2.4278	20.41	6451.58	25.37
12	PX5	Pearce X5	Fighter	2	4	0.99	1107	25	2.376	14.85	5614.43	18.64
13	FBLBEA	Fimbul BYOS Earp	Fighter	3	9	3.062	3832	79.4	2.3139	20.41	7724.53	20.86
14	OGKAMK	Ogrika Mik	Fighter	3	9	3.062	3832	80.121875	2.293	20.41	7724.53	20.86
15	CHI	Rainbow Chi	Fighter	3	9	3.062	3832	84.541375	2.1731	20.41	9759.06	20.86
16	VZUSAM	VZUS ambwe	Bounty Hunter	3	9	2.979	4180	85.945	2.0797	19.86	6359.73	23.39
17	PF4	Pearce F4	Fighter	4	16	9.468	16135	335.9125	1.6912	35.51	8044.55	28.4
18	CALCH	Calico Compact Hero	Multi-role	4	16	8.509	17341	303.1875	1.6839	31.91	7717.31	33.97
19	FBLEGR	Fimbul ECOS Greenader	Bomber	5	25	29.67	59228	1137.5	1.565	71.21	5682.95	33.27
20	THRILL	Busan Thrill of Life	Fighter	3	9	3.062	3832	120	1.531	20.41	7724.53	20.86

5KB

95s

flipside

flipside