AephiaSAGE upgrading factions
    Updated 7 hours ago
    WITH LP_redemption AS (
    SELECT
    1692250 as atlas_pool_mud
    ,1739250 as atlas_pool_oni
    ,1714500 as atlas_pool_ust
    ,48 as FRMWRK_lp
    ,76 as ELECTRO_lp
    ,108 as PWRSRC_lp
    ,135 as ELECMAG_lp
    ,1100 as SDU_lp
    ,255 as FSTAB_lp
    ,325 as RADABS_lp
    ,480 as PRTACL_lp
    ---
    ,6 as FOOD_lp
    ,14 as TOOL_lp

    ---MUD---
    ,sum(case when instruction:accounts[29] = 'MUD6bCtMW8sAkMWcBD14bpG65KaJ9Li1mpxmtWhWSWM'
    AND value:parsed:info:mint = 'FMWKb7YJA5upZHbu5FjVRRoxdDw2FYFAu284VqUGF9C2'
    then value:parsed:info:amount * FRMWRK_lp
    end) as FRMWRK_lp_mud
    ,sum(case when instruction:accounts[29] = 'MUD6bCtMW8sAkMWcBD14bpG65KaJ9Li1mpxmtWhWSWM'
    AND value:parsed:info:mint = 'ELECrjC8m9GxCqcm4XCNpFvkS8fHStAvymS6MJbe3XLZ'
    then value:parsed:info:amount * ELECTRO_lp
    end) as ELECTRO_lp_mud
    ,sum(case when instruction:accounts[29] = 'MUD6bCtMW8sAkMWcBD14bpG65KaJ9Li1mpxmtWhWSWM'
    AND value:parsed:info:mint = 'PoWRYJnw3YDSyXgNtN3mQ3TKUMoUSsLAbvE8Ejade3u'
    then value:parsed:info:amount * PWRSRC_lp
    end) as PWRSRC_lp_mud
    ,sum(case when instruction:accounts[29] = 'MUD6bCtMW8sAkMWcBD14bpG65KaJ9Li1mpxmtWhWSWM'
    AND value:parsed:info:mint = 'EMAGoQSP89CJV5focVjrpEuE4CeqJ4k1DouQW7gUu7yX'
    then value:parsed:info:amount * ELECMAG_lp
    end) as ELECMAG_lp_mud
    ,sum(case when instruction:accounts[29] = 'MUD6bCtMW8sAkMWcBD14bpG65KaJ9Li1mpxmtWhWSWM'
    Last run: about 7 hours ago
    NAME
    FACTION
    LP
    UPGRADING_TIME
    PRICE_ATLAS
    LP_VALUE_ATLAS
    PCT_GAIN
    LP_REDEMPTION
    LP_PCT
    NET_PROFIT_PER_CREW
    ROI
    LP_REDEMPTION_SORT
    ATLAS_POOL_ALL_SORT
    1
    Starbase UpgradeMUD5146000
    2
    Starbase UpgradeONI 5146000
    3
    Starbase UpgradeUST5146000
    4
    FrameworkMUD48120.003270.006631102.81597,563,4245%0.04490%5975634245146000
    5
    FrameworkONI 48120.003270.00613387.57392,736,0003%0.04451%3927360005146000
    6
    FrameworkUST48120.003270.007296123.138,710,423,63277%0.04533%87104236325146000
    7
    ElectronicsMUD76140.0056350.010586.323,542,063,06829%0.091,139%35420630685146000
    8
    ElectronicsONI 76140.0056350.0097172.320.081,031%5146000
    9
    ElectronicsUST76140.0056350.011551104.99253,975,2802%0.11,259%2539752805146000
    10
    Power SourceMUD108150.0125470.0149218.92282,990,4562%0.141,809%2829904565146000
    11
    Power SourceONI 108150.0125470.0137999.980.081,032%5146000
    12
    Power SourceUST108150.0125470.01641530.8321,600,0000%0.212,680%216000005146000
    13
    ElectromagnetMUD135160.0095040.01865196.24321,5700%0.243,001%3215705146000
    14
    ElectromagnetONI 135160.0095040.01724981.490.222,747%5146000
    15
    ElectromagnetUST135160.0095040.020519115.9108,540,0001%0.263,284%1085400005146000
    16
    Survey Data UnitMUD110010.1501280.1519671.232,703,354,50022%23.56295,575%27033545005146000
    17
    Survey Data UnitONI 110010.1501280.140545-6.381,713,101,50013%-132.78-1,665,415%17131015005146000
    18
    Survey Data UnitUST110010.1501280.16719111.37539,841,5005%198.742,492,745%5398415005146000
    19
    Field StabilizerMUD255240.0247070.03522942.580.668,233%5146000
    20
    Field StabilizerONI 255240.0247070.03258131.873,734,067,00027%0.536,662%37340670005146000
    42
    4KB
    133s