alfredfx10UPTOS MIN AND MAX
Updated 2024-06-06
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
⌄
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