SYMBOL | NAME | PRODUCTION | CONSUMPTION | PCR_4W | PCR_1W | |
|---|---|---|---|---|---|---|
1 | ARCO | Arco | 213453024 | 168998464 | 1.26 | 1.61 |
2 | BIOMASS | Biomass | 1205890896 | 1142948854 | 1.06 | 0.91 |
3 | CARBON | Carbon | 3169424802 | 3920312982 | 0.81 | 1.03 |
4 | CUORE | Cuore | 2102323558 | 1749021853 | 1.2 | 1.01 |
5 | DIAMOND | Diamond | 297538366 | 122996238 | 2.42 | 1.48 |
6 | HYG | Hyg | 7959521616 | 8141355918 | 0.98 | 0.96 |
7 | FEORE | Feore | 673365947 | 644629733 | 1.04 | 1.05 |
8 | LUMAN | Luman | 549853814 | 481505106 | 1.14 | 1.1 |
9 | NITRO | Nitrogen | 281844195 | 139345012 | 2.02 | 1.25 |
10 | ROCHINOL | Rochinol | 301380097 | 180652214 | 1.67 | 1.17 |
11 | SAND | Silica | 102694646 | 69672506 | 1.47 | 2.44 |
12 | TIORE | Titanium Ore | 148293697 | 114682662 | 1.29 | 1.23 |
13 | AGEL | Aerogel | 34836253 | 17024087 | 2.05 | 1.04 |
14 | AMMO | Ammunition | 578194258 | 587915885 | 0.98 | 0.99 |
15 | COPPER | Copper | 1749021853 | 1568943516 | 1.11 | 1.02 |
16 | CPRWIRE | Copper Wire | 273136095 | 306052056 | 0.89 | 0.97 |
17 | CRYSLAT | Crystal Lattice | 236323458 | 283831453 | 0.83 | 0.24 |
18 | ELECMAG | Electromagnet | 48222119 | 18552684 | 2.6 | 1.48 |
19 | ELECTRO | Electronics | 292052503 | 213135965 | 1.37 | 1.05 |
20 | ENRGSUB | Energy Substrate | 177625233 | 177127405 | 1 | 1.56 |
AephiaSB Production Consumption Ratio
Updated 2025-04-19
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 mining AS (
select
date_trunc('day', block_timestamp::date) as date
----------------------------------------------------
,sum(case when value:parsed:info:authority IN ('qe84yNaK76yaZqGqyWJ9A1Npgnt4NSzicbcZvxEQuJy')
then value:parsed:info:amount
end) as ARCO_mined
,sum(case when value:parsed:info:authority IN ('CHxH1BkLp5A6VcQFCYqKGW88i5XFJV5KyyxewSiwcbkB')
then value:parsed:info:amount
end) as BIOMASS_mined
,sum(case when value:parsed:info:authority IN ('6ny545QXZbGDWXo6F7UEVC7MncAzNNxB62tbVoYWG5gs')
then value:parsed:info:amount
end) as CARBON_mined
,sum(case when value:parsed:info:authority IN ('4rZNPtbe9kD44RNdf5XxB6RBWsWaHTg76esbrkWGpkXU')
then value:parsed:info:amount
end) as CUORE_mined
,sum(case when value:parsed:info:authority IN ('9LPyad7NE1VDApsirv46gMrRhbmsbFGMMy5CUiAQXkfP')
then value:parsed:info:amount
end) as DIAMOND_mined
,sum(case when value:parsed:info:authority IN ('FpTUZKuviuGaww6ijjXdoeuJtFeEjabEXnzxRYHukhMx')
then value:parsed:info:amount
end) as HYG_mined
,sum(case when value:parsed:info:authority IN ('2mCjq4ST1Svtn4f61cCvoQmQcZ9Zk5S1LcyCZKgwfmae')
then value:parsed:info:amount
end) as FEORE_mined
,sum(case when value:parsed:info:authority IN ('4PxrWv9WGmbXTSwpkP8kKASrH8VGt2Zd53ePvVmQMoG5')
then value:parsed:info:amount
end) as LUMAN_mined
,sum(case when value:parsed:info:authority IN ('FiSSigWUWGir9mTLpzRVm8XXXy1SAju6Ehcvb3xJP2iF')
then value:parsed:info:amount
end) as NITRO_mined
,sum(case when value:parsed:info:authority IN ('6fzSXrr9TGJVYcLjZz9W86Ac4DdG3dmKbNhRrmeRRq9g')
then value:parsed:info:amount
end) as ROCHINOL_mined
,sum(case when value:parsed:info:authority IN ('F6JHyw2XqCL4TsbAYZfKU1CPrx74webLCPkoDSgHAg7c')
then value:parsed:info:amount
Last run: about 1 month ago
43
2KB
123s