flipside

    18. Price
    hess18. Price
    Updated 2025-03-16
    WITH axl AS (
    SELECT
    RECORDED_HOUR::date AS date,
    AVG(price) AS "AXL Price"
    FROM
    osmosis.price.ez_prices
    WHERE
    symbol = 'AXL'
    GROUP BY
    1
    )
    ,
    current_p AS (
    SELECT
    "AXL Price" AS current_p
    FROM
    axl
    WHERE
    date = current_date - 1
    ),
    last_30 AS (
    SELECT
    "AXL Price" AS l30
    FROM
    axl
    WHERE
    date = current_date - 30
    ),
    last_60 AS (
    SELECT
    "AXL Price" AS l60
    FROM
    axl
    WHERE
    date = current_date - 60
    ),
    Last run: about 1 month ago
    CURRENT_P
    L30
    L60
    L90
    L180
    GROWTH_30_DAYS
    GROWTH_60_DAYS
    GROWTH_90_DAYS
    GROWTH_180_DAYS
    1
    		0.39539204170.47697045830.62161166670.95870458330.492668375-17.103452686-36.392435524-58.757676917-19.744789451
    1
    123B
    1s