crypto_gostvulnerable-aquamarine
    Updated 2024-10-13
    WITH BNsolprice AS (
    SELECT
    hour AS recorded_Hour,
    price AS BNsol_Price
    FROM solana.price.ez_prices_hourly
    WHERE token_address = 'BNso1VUJnh4zcfpZa6986Ea66P6TCp59hvtNJ8b1X85'
    ),
    minimum AS (
    SELECT
    MIN(BNsol_Price) AS Min_Price
    FROM BNsolPrice
    WHERE BNsol_Price > 0
    ),
    maximum AS (
    SELECT
    MAX(BNsol_Price) AS Max_Price
    FROM BNsolPrice
    ),
    current_priceT AS (
    SELECT
    BNsol_Price AS current_Price
    FROM BNsolPrice
    ORDER BY recorded_Hour DESC
    LIMIT 1
    ),
    last24 AS (
    SELECT
    BNsol_Price AS last24price
    FROM BNsolPrice
    WHERE recorded_Hour > CURRENT_TIMESTAMP - INTERVAL '24 hours'
    ORDER BY recorded_Hour ASC
    LIMIT 1
    ),
    launch_price AS (
    SELECT
    BNsol_Price AS launch_Price
    QueryRunArchived: QueryRun has been archived