alfredfx10PRICE(CURRENT, MINIMUM AND MAXIMUM)
Updated 2024-08-05
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
WITH WUFFI_PRICE AS(SELECT HOUR, PRICE
FROM solana.price.ez_prices_hourly
WHERE TOKEN_ADDRESS = '73xsLcBnLnc9bh81cqVKqj8uEyiarXng5ZwJuTbnVebG'),
CURRENT_PRICE AS (SELECT PRICE AS "Current price ($)", HOUR
FROM WUFFI_PRICE
ORDER BY HOUR DESC
LIMIT 1),
MAXIMUM_PRICE AS(SELECT MAX(PRICE) AS "Maximum price ($)"
FROM WUFFI_PRICE
LIMIT 1),
MINIMUM_PRICE AS(SELECT MIN(PRICE) AS "Minimum price ($)"
FROM WUFFI_PRICE
LIMIT 1)
SELECT "Current price ($)", "Maximum price ($)", "Minimum price ($)" ,
("Maximum price ($)" -"Minimum price ($)") / "Minimum price ($)" * 100 AS "All Time High Price Change %",
("Current price ($)" -"Minimum price ($)") / "Minimum price ($)" * 100 AS "Current Price Change %",
FROM CURRENT_PRICE, MAXIMUM_PRICE, MINIMUM_PRICE
QueryRunArchived: QueryRun has been archived