DATE | MIC_COSTS_COMP | OIC_COSTS_COMP | UIC_COSTS_COMP | MIC_COSTS_RAW | OIC_COSTS_RAW | UIC_COSTS_RAW | MIC_COMP_PROFIT_SORT | OIC_COMP_PROFIT_SORT | UIC_COMP_PROFIT_SORT | MIC_RAW_PROFIT_SORT | OIC_RAW_PROFIT_SORT | UIC_RAW_PROFIT_SORT | MIC_COMP_PROFIT | OIC_COMP_PROFIT | UIC_COMP_PROFIT | MIC_RAW_PROFIT | OIC_RAW_PROFIT | UIC_RAW_PROFIT | MUD_CRAFTING_TIME | ONI_CRAFTING_TIME | UST_CRAFTING_TIME | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 2025-02-14 00:00:00.000 | 2.43 | 2.39 | 2.31 | 2.08 | 2.21 | 1.95 | -22.63 | -21.34 | -18.61 | -9.62 | -14.93 | -3.59 | -22.63% | -21.34% | -18.61% | -9.62% | -14.93% | -3.59% | 104 | 97 | 132 |
2 | 2025-02-13 00:00:00.000 | 2.4 | 2.39 | 2.31 | 2.18 | 2.22 | 2.01 | -21.67 | -21.34 | -18.61 | -13.76 | -15.32 | -6.47 | -21.67% | -21.34% | -18.61% | -13.76% | -15.32% | -6.47% | 104 | 97 | 132 |
3 | 2025-02-12 00:00:00.000 | 2.14 | 2.39 | 2.35 | 2.02 | 2.11 | 1.88 | -12.15 | -21.34 | -20 | -6.93 | -10.9 | 0 | -12.15% | -21.34% | -20.% | -6.93% | -10.9% | 0.% | 104 | 97 | 132 |
4 | 2025-02-11 00:00:00.000 | 2.15 | 2.37 | 2.3 | 2.1 | 2.12 | 1.89 | -12.56 | -20.68 | -18.26 | -10.48 | -11.32 | -0.53 | -12.56% | -20.68% | -18.26% | -10.48% | -11.32% | -0.53% | 104 | 97 | 132 |
5 | 2025-02-10 00:00:00.000 | 2.11 | 2.2 | 2.15 | 2.01 | 1.98 | 1.85 | -10.9 | -14.55 | -12.56 | -6.47 | -5.05 | 1.62 | -10.9% | -14.55% | -12.56% | -6.47% | -5.05% | 1.62% | 104 | 97 | 132 |
6 | 2025-02-09 00:00:00.000 | 2.15 | 2.39 | 2.19 | 2.01 | 1.98 | 1.84 | -12.56 | -21.34 | -14.16 | -6.47 | -5.05 | 2.17 | -12.56% | -21.34% | -14.16% | -6.47% | -5.05% | 2.17% | 104 | 97 | 132 |
7 | 2025-02-08 00:00:00.000 | 2.08 | 2.36 | 2.13 | 1.93 | 1.94 | 1.78 | -9.62 | -20.34 | -11.74 | -2.59 | -3.09 | 5.62 | -9.62% | -20.34% | -11.74% | -2.59% | -3.09% | 5.62% | 104 | 97 | 132 |
8 | 2025-02-07 00:00:00.000 | 2.14 | 2.29 | 2.11 | 1.9 | 1.93 | 1.79 | -12.15 | -17.9 | -10.9 | -1.05 | -2.59 | 5.03 | -12.15% | -17.9% | -10.9% | -1.05% | -2.59% | 5.03% | 104 | 97 | 132 |
9 | 2025-02-06 00:00:00.000 | 2.16 | 2.2 | 2.3 | 1.89 | 1.92 | 1.8 | -12.96 | -14.55 | -18.26 | -0.53 | -2.08 | 4.44 | -12.96% | -14.55% | -18.26% | -0.53% | -2.08% | 4.44% | 104 | 97 | 132 |
10 | 2025-02-05 00:00:00.000 | 2.19 | 2.2 | 2.36 | 1.88 | 1.92 | 1.79 | -14.16 | -14.55 | -20.34 | 0 | -2.08 | 5.03 | -14.16% | -14.55% | -20.34% | 0.% | -2.08% | 5.03% | 104 | 97 | 132 |
11 | 2025-02-04 00:00:00.000 | 2.18 | 2.23 | 2.46 | 1.81 | 1.9 | 1.76 | -13.76 | -15.7 | -23.58 | 3.87 | -1.05 | 6.82 | -13.76% | -15.7% | -23.58% | 3.87% | -1.05% | 6.82% | 104 | 97 | 132 |
12 | 2025-02-03 00:00:00.000 | 2.02 | 2.13 | 2.41 | 1.76 | 1.85 | 1.74 | -6.93 | -11.74 | -21.99 | 6.82 | 1.62 | 8.05 | -6.93% | -11.74% | -21.99% | 6.82% | 1.62% | 8.05% | 104 | 97 | 132 |
13 | 2025-02-02 00:00:00.000 | 1.88 | 2.11 | 2.29 | 1.88 | 1.96 | 1.83 | 0 | -10.9 | -17.9 | 0 | -4.08 | 2.73 | 0.% | -10.9% | -17.9% | 0.% | -4.08% | 2.73% | 104 | 97 | 132 |
14 | 2025-02-01 00:00:00.000 | 1.99 | 2.14 | 2.31 | 1.88 | 1.95 | 1.8 | -5.53 | -12.15 | -18.61 | 0 | -3.59 | 4.44 | -5.53% | -12.15% | -18.61% | 0.% | -3.59% | 4.44% | 104 | 97 | 132 |
15 | 2025-01-31 00:00:00.000 | 2 | 2.04 | 2.32 | 1.83 | 2.01 | 1.77 | -6 | -7.84 | -18.97 | 2.73 | -6.47 | 6.21 | -6.% | -7.84% | -18.97% | 2.73% | -6.47% | 6.21% | 104 | 97 | 132 |
16 | 2025-01-30 00:00:00.000 | 2.08 | 2.01 | 2.41 | 1.89 | 2.14 | 1.9 | -9.62 | -6.47 | -21.99 | -0.53 | -12.15 | -1.05 | -9.62% | -6.47% | -21.99% | -0.53% | -12.15% | -1.05% | 104 | 97 | 132 |
17 | 2025-01-29 00:00:00.000 | 2.15 | 2.04 | 2.45 | 1.86 | 2.05 | 1.81 | -12.56 | -7.84 | -23.27 | 1.08 | -8.29 | 3.87 | -12.56% | -7.84% | -23.27% | 1.08% | -8.29% | 3.87% | 104 | 97 | 132 |
18 | 2025-01-28 00:00:00.000 | 2.03 | 2.46 | 2.44 | 1.93 | 2.03 | 1.85 | -7.39 | -23.58 | -22.95 | -2.59 | -7.39 | 1.62 | -7.39% | -23.58% | -22.95% | -2.59% | -7.39% | 1.62% | 104 | 97 | 132 |
19 | 2025-01-27 00:00:00.000 | 2.22 | 2.44 | 2.29 | 1.86 | 1.98 | 1.8 | -15.32 | -22.95 | -17.9 | 1.08 | -5.05 | 4.44 | -15.32% | -22.95% | -17.9% | 1.08% | -5.05% | 4.44% | 104 | 97 | 132 |
20 | 2025-01-26 00:00:00.000 | 2.01 | 2.42 | 2.28 | 1.94 | 2.01 | 1.84 | -6.47 | -22.31 | -17.54 | -3.09 | -6.47 | 2.17 | -6.47% | -22.31% | -17.54% | -3.09% | -6.47% | 2.17% | 104 | 97 | 132 |
AephiaFaction Infrastructure Contracts old
Updated 2025-02-14
999
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 last_value AS (
SELECT
*
from $query('6a2519e0-27f9-4633-8fe0-8934f60d6bb2')
)
,sage_volumes AS (
select
--*
date_trunc('day', block_timestamp::date) as date,
----------------------------------------------------
sum(case when inner_instruction:instructions[2]:parsed:info:mint::string = 'ARCoQ9dndpg6wE2rRexzfwgJR3NoWWhpcww3xQcQLukg' then inner_instruction:instructions[2]:parsed:info:tokenAmount:uiAmount when inner_instruction:instructions[1]:parsed:info:mint::string = 'ARCoQ9dndpg6wE2rRexzfwgJR3NoWWhpcww3xQcQLukg' then inner_instruction:instructions[1]:parsed:info:tokenAmount:uiAmount
end) AS ARCO_amount,
sum(case when inner_instruction:instructions[2]:parsed:info:mint::string = 'ARCoQ9dndpg6wE2rRexzfwgJR3NoWWhpcww3xQcQLukg' AND inner_instruction:instructions[1]:parsed:info:mint::string = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v' then (inner_instruction:instructions[0]:parsed:info:tokenAmount:uiAmount + inner_instruction:instructions[1]:parsed:info:tokenAmount:uiAmount) when inner_instruction:instructions[1]:parsed:info:mint::string = 'ARCoQ9dndpg6wE2rRexzfwgJR3NoWWhpcww3xQcQLukg' AND inner_instruction:instructions[2]:parsed:info:mint::string = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v' then (inner_instruction:instructions[0]:parsed:info:tokenAmount:uiAmount + inner_instruction:instructions[2]:parsed:info:tokenAmount:uiAmount)
end) AS ARCO_usdc_amount,
sum(case when inner_instruction:instructions[2]:parsed:info:mint::string = 'ARCoQ9dndpg6wE2rRexzfwgJR3NoWWhpcww3xQcQLukg' AND inner_instruction:instructions[1]:parsed:info:mint::string = 'ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXx' then (inner_instruction:instructions[0]:parsed:info:tokenAmount:uiAmount + inner_instruction:instructions[1]:parsed:info:tokenAmount:uiAmount) when inner_instruction:instructions[1]:parsed:info:mint::string = 'ARCoQ9dndpg6wE2rRexzfwgJR3NoWWhpcww3xQcQLukg' AND inner_instruction:instructions[2]:parsed:info:mint::string = 'ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXx' then (inner_instruction:instructions[0]:parsed:info:tokenAmount:uiAmount + inner_instruction:instructions[2]:parsed:info:tokenAmount:uiAmount)
end) AS ARCO_atlas_amount,
sum(case when inner_instruction:instructions[2]:parsed:info:mint::string = 'MASS9GqtJz6ABisAxcUn3FeR4phMqH1XfG6LPKJePog' then inner_instruction:instructions[2]:parsed:info:tokenAmount:uiAmount when inner_instruction:instructions[1]:parsed:info:mint::string = 'MASS9GqtJz6ABisAxcUn3FeR4phMqH1XfG6LPKJePog' then inner_instruction:instructions[1]:parsed:info:tokenAmount:uiAmount
end) AS BIOMASS_amount,
sum(case when inner_instruction:instructions[2]:parsed:info:mint::string = 'MASS9GqtJz6ABisAxcUn3FeR4phMqH1XfG6LPKJePog' AND inner_instruction:instructions[1]:parsed:info:mint::string = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v' then (inner_instruction:instructions[0]:parsed:info:tokenAmount:uiAmount + inner_instruction:instructions[1]:parsed:info:tokenAmount:uiAmount) when inner_instruction:instructions[1]:parsed:info:mint::string = 'MASS9GqtJz6ABisAxcUn3FeR4phMqH1XfG6LPKJePog' AND inner_instruction:instructions[2]:parsed:info:mint::string = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v' then (inner_instruction:instructions[0]:parsed:info:tokenAmount:uiAmount + inner_instruction:instructions[2]:parsed:info:tokenAmount:uiAmount)
end) AS BIOMASS_usdc_amount,
sum(case when inner_instruction:instructions[2]:parsed:info:mint::string = 'MASS9GqtJz6ABisAxcUn3FeR4phMqH1XfG6LPKJePog' AND inner_instruction:instructions[1]:parsed:info:mint::string = 'ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXx' then (inner_instruction:instructions[0]:parsed:info:tokenAmount:uiAmount + inner_instruction:instructions[1]:parsed:info:tokenAmount:uiAmount) when inner_instruction:instructions[1]:parsed:info:mint::string = 'MASS9GqtJz6ABisAxcUn3FeR4phMqH1XfG6LPKJePog' AND inner_instruction:instructions[2]:parsed:info:mint::string = 'ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXx' then (inner_instruction:instructions[0]:parsed:info:tokenAmount:uiAmount + inner_instruction:instructions[2]:parsed:info:tokenAmount:uiAmount)
end) AS BIOMASS_atlas_amount,
sum(case when inner_instruction:instructions[2]:parsed:info:mint::string = 'CARBWKWvxEuMcq3MqCxYfi7UoFVpL9c4rsQS99tw6i4X' then inner_instruction:instructions[2]:parsed:info:tokenAmount:uiAmount when inner_instruction:instructions[1]:parsed:info:mint::string = 'CARBWKWvxEuMcq3MqCxYfi7UoFVpL9c4rsQS99tw6i4X' then inner_instruction:instructions[1]:parsed:info:tokenAmount:uiAmount
end) AS CARBON_amount,
sum(case when inner_instruction:instructions[2]:parsed:info:mint::string = 'CARBWKWvxEuMcq3MqCxYfi7UoFVpL9c4rsQS99tw6i4X' AND inner_instruction:instructions[1]:parsed:info:mint::string = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v' then (inner_instruction:instructions[0]:parsed:info:tokenAmount:uiAmount + inner_instruction:instructions[1]:parsed:info:tokenAmount:uiAmount) when inner_instruction:instructions[1]:parsed:info:mint::string = 'CARBWKWvxEuMcq3MqCxYfi7UoFVpL9c4rsQS99tw6i4X' AND inner_instruction:instructions[2]:parsed:info:mint::string = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v' then (inner_instruction:instructions[0]:parsed:info:tokenAmount:uiAmount + inner_instruction:instructions[2]:parsed:info:tokenAmount:uiAmount)
end) AS CARBON_usdc_amount,
sum(case when inner_instruction:instructions[2]:parsed:info:mint::string = 'CARBWKWvxEuMcq3MqCxYfi7UoFVpL9c4rsQS99tw6i4X' AND inner_instruction:instructions[1]:parsed:info:mint::string = 'ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXx' then (inner_instruction:instructions[0]:parsed:info:tokenAmount:uiAmount + inner_instruction:instructions[1]:parsed:info:tokenAmount:uiAmount) when inner_instruction:instructions[1]:parsed:info:mint::string = 'CARBWKWvxEuMcq3MqCxYfi7UoFVpL9c4rsQS99tw6i4X' AND inner_instruction:instructions[2]:parsed:info:mint::string = 'ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXx' then (inner_instruction:instructions[0]:parsed:info:tokenAmount:uiAmount + inner_instruction:instructions[2]:parsed:info:tokenAmount:uiAmount)
end) AS CARBON_atlas_amount,
sum(case when inner_instruction:instructions[2]:parsed:info:mint::string = 'CUore1tNkiubxSwDEtLc3Ybs1xfWLs8uGjyydUYZ25xc' then inner_instruction:instructions[2]:parsed:info:tokenAmount:uiAmount when inner_instruction:instructions[1]:parsed:info:mint::string = 'CUore1tNkiubxSwDEtLc3Ybs1xfWLs8uGjyydUYZ25xc' then inner_instruction:instructions[1]:parsed:info:tokenAmount:uiAmount
end) AS COPPER_ORE_amount,
sum(case when inner_instruction:instructions[2]:parsed:info:mint::string = 'CUore1tNkiubxSwDEtLc3Ybs1xfWLs8uGjyydUYZ25xc' AND inner_instruction:instructions[1]:parsed:info:mint::string = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v' then (inner_instruction:instructions[0]:parsed:info:tokenAmount:uiAmount + inner_instruction:instructions[1]:parsed:info:tokenAmount:uiAmount) when inner_instruction:instructions[1]:parsed:info:mint::string = 'CUore1tNkiubxSwDEtLc3Ybs1xfWLs8uGjyydUYZ25xc' AND inner_instruction:instructions[2]:parsed:info:mint::string = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v' then (inner_instruction:instructions[0]:parsed:info:tokenAmount:uiAmount + inner_instruction:instructions[2]:parsed:info:tokenAmount:uiAmount)
end) AS COPPER_ORE_usdc_amount,
sum(case when inner_instruction:instructions[2]:parsed:info:mint::string = 'CUore1tNkiubxSwDEtLc3Ybs1xfWLs8uGjyydUYZ25xc' AND inner_instruction:instructions[1]:parsed:info:mint::string = 'ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXx' then (inner_instruction:instructions[0]:parsed:info:tokenAmount:uiAmount + inner_instruction:instructions[1]:parsed:info:tokenAmount:uiAmount) when inner_instruction:instructions[1]:parsed:info:mint::string = 'CUore1tNkiubxSwDEtLc3Ybs1xfWLs8uGjyydUYZ25xc' AND inner_instruction:instructions[2]:parsed:info:mint::string = 'ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXx' then (inner_instruction:instructions[0]:parsed:info:tokenAmount:uiAmount + inner_instruction:instructions[2]:parsed:info:tokenAmount:uiAmount)
Last run: about 2 months ago
65
10KB
83s