Aephia SB crafting profitability
    Updated 2 hours ago
    WITH atlas_price AS (
    SELECT
    hour::DATE AS DATE,
    AVG(price) AS atlas_price
    FROM
    SOLANA.price.ez_prices_hourly
    WHERE token_address = 'ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXx'
    AND hour::DATE >= current_date -14 AND hour::DATE < current_date

    GROUP BY ALL

    ),

    gecko_call_data as (
    select live.udf_api('https://api.coingecko.com/api/v3/nfts/star-atlas-crew')
    as response
    )

    ,gecko_flattened_data as (
    select * from
    gecko_call_data, lateral flatten(input => parse_json(response:data))
    )

    ,crew AS (
    SELECT
    case when key = 'floor_price' then value:usd end as fp_crew
    FROM gecko_flattened_data
    )


    ,sage_volumes AS (
    select
    --*
    date_trunc('day', block_timestamp::date) as date,
    Last run: about 2 hours agoAuto-refreshes every 12 hours
    NAME
    SYMBOL
    CRAFTING_TIME
    VALUE_INGREDIENTS
    PRICE_ATLAS
    CRAFTING_DISCOUNT_IN_PCT
    ENTRY_LIQUIDITY
    EXIT_LIQUIDITY
    RECOMMENDATION
    NET_PROFIT_PER_CREW
    ROI_COMP
    ROI_RAW
    1
    AerogelAGEL20.0075130.0090348.1934.7854.74craft0.05634.89634.89
    2
    AmmunitionAMMO10.0026950.001911-38.2310.22147.25buy-0.16-2125.58-708.53
    3
    CopperCOPPER10.0010930.00134710.9344.9427.79craft0.02246.49246.49
    4
    Copper WireCPRWIRE40.0013470.00233958.5527.799.67craft0.03406.91408.32
    5
    Crystal Lattice 1CRYSLAT120.0086260.0101855.16163.5861.35craft0.03459.56459.56
    6
    Crystal Lattice 2CRYSLAT220.009310.010185-2.56163.5861.35buy-0.02-245.78-245.78
    7
    Crystal Lattice 3CRYSLAT320.0088070.0101853.01163.5861.35craft0.02273.68273.68
    8
    ElectromagnetELECMAG160.0114580.009504-27.4410.5861.91buy-0.03-405.43-191.16
    9
    ElectronicsELECTRO140.0038570.00563527.8733.8764.49craft0.01158.47104.43
    10
    Energy SubstrateENRGSUB60.0088550.01221.061815.73craft0.05641.2986.07
    11
    Field StabilizerFSTAB240.0192180.02470714.14116.193.82craft0.02233.56342.1
    12
    FoodFOOD10.001320.001332-10.690.81135.62buy-0.02-291.23-291.23
    13
    Framework 1FRMWRK1180.0022890.0032723.4210.2244.27craft061.4770.21
    14
    Framework 2FRMWRK2120.00230.0032722.8523.5644.27craft0.0190.35-11.33
    15
    Framework 3FRMWRK360.0066990.00327-57.8256.1944.27buy-0.1-1332.17-703.97
    16
    FuelFUEL10.0011250.00121-4.7591.52325.22buy-0.01-110.32-110.32
    17
    Golden Ticket 2624GT24105.837.06003113.83478.531103.55craft12.63166400.65394.6
    18
    GrapheneGRAPH20.0042380.003835-19.758.2511.92buy-0.07-861.41-861.41
    19
    HydrocarbonHCRB20.0024460.002311-16.05149.773.73buy-0.03-404.95-404.95
    20
    IronIRON10.0010030.0011450.3350.3310.22craft06.856.85
    35
    3KB
    107s