Aephia SAGE prices daily table
    Updated 29 seconds 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 >= '2023-09-22' AND hour::DATE < current_date

    GROUP BY ALL

    ),

    sabe_symbols (symbol, name) AS (
    SELECT 'ARCO', 'Arco'
    UNION ALL
    SELECT 'BIOMASS', 'Biomass'
    UNION ALL
    SELECT 'CARBON', 'Carbon'
    UNION ALL
    SELECT 'COPPER_ORE', 'Copper Ore'
    UNION ALL
    SELECT 'DIAMOND', 'Diamond'
    UNION ALL
    SELECT 'HYDROGEN', 'Hydrogen'
    UNION ALL
    SELECT 'IRON_ORE', 'Iron Ore'
    UNION ALL
    SELECT 'LUMANITE', 'Lumanite'
    UNION ALL
    SELECT 'ROCHINOL', 'Rochinol'
    UNION ALL
    SELECT 'ENRGSUB', 'Energy Substrate'
    UNION ALL
    SELECT 'ELECMAG', 'Electromagnet'
    Last run: 1 minute agoAuto-refreshes every 6 hours
    NAME
    PRICE_ATLAS
    DAILY_CHANGE_PERCENTAGE
    TRADING_VOLUME
    TRADING_VOLUME_IN_USD
    CRAFTING_FEE
    AVG_7D_CF
    PREMIUM_IN_PCT
    1
    Survey Data Unit0.1326170.752490098406.65000
    2
    Fuel0.001056-2.35187439162243.8465.1774.57-12.61
    3
    Steel0.0038627.5148363421230150.57212.2-29.04
    4
    Ammunition0.001564-3.5181526111157.05131.39110.2919.13
    5
    Hydrogen0.0003194.14312880788122.74000
    6
    Electronics0.0042673.0422057532115.91364.49297.4222.55
    7
    Power Source0.0077812.5912060234115.55547.19495.1910.5
    8
    Food0.0015343.3656573738106.8772.8102.54-29.01
    9
    Toolkits0.00158-2.744580818989.15144.62112.4728.59
    10
    Iron Ore0.00078-3.888864059685.17000
    11
    Particle Accelerator0.0307140.55185628170.212197.092147.012.33
    12
    Crystal Lattice0.0091074.07566930363.58501.69583.63-14.04
    13
    Strange Emitter0.0100890480309159.67661.15711.12-7.03
    14
    Titanium0.00229632.031585636044.84132.58139.29-4.82
    15
    Electromagnet0.006813-2.81476900040.01619.71506.3722.38
    16
    Diamond0.0023341.991241294935.67000
    17
    Framework0.003145-1.27865500033.51248.01230.387.65
    18
    Field Stabilizer0.016689-6.99144177829.631290.031211.726.46
    19
    Carbon0.000587-1.553808385527.52000
    20
    Silica0.0012430.841389872821.28000
    38
    2KB
    171s