alfredfx10UPTOS MIN AND MAX
    Updated 2024-06-06
    WITH LOWEST_PRICE AS (
    SELECT HOUR AS "Datetime Lowest price", MIN(PRICE) AS "($) Lowest Price"
    FROM aptos.price.ez_prices_hourly
    WHERE TOKEN_ADDRESS ='0x4fbed3f8a3fd8a11081c8b6392152a8b0cb14d70d0414586f0c9b858fcd2d6a7::UPTOS::UPTOS'
    GROUP BY 1
    ORDER BY 2 ASC
    LIMIT 1
    ),
    HIGHEST_PRICE AS (SELECT HOUR AS "Datetime Highest Price", MAX(PRICE) AS "($) Highest Price"
    FROM aptos.price.ez_prices_hourly
    WHERE TOKEN_ADDRESS ='0x4fbed3f8a3fd8a11081c8b6392152a8b0cb14d70d0414586f0c9b858fcd2d6a7::UPTOS::UPTOS'
    GROUP BY 1
    ORDER BY 2 DESC
    LIMIT 1
    );
    SELECT *
    FROM LOWEST_PRICE, HIGHEST_PRICE;

    QueryRunArchived: QueryRun has been archived