DATE | over-bought zone | over-sold zone | AVGPRICE | RSI | |
|---|---|---|---|---|---|
1 | 2024-01-23 00:00:00.000 | 80 | 20 | 0.1148631276 | 100 |
2 | 2024-01-24 00:00:00.000 | 80 | 20 | 0.1218258114 | 100 |
3 | 2024-01-25 00:00:00.000 | 80 | 20 | 0.117930345 | 64.124032901 |
4 | 2024-01-26 00:00:00.000 | 80 | 20 | 0.1196868361 | 69.119483414 |
5 | 2024-01-27 00:00:00.000 | 80 | 20 | 0.1256621974 | 79.045369312 |
6 | 2024-01-28 00:00:00.000 | 80 | 20 | 0.1273828311 | 80.820559638 |
7 | 2024-01-29 00:00:00.000 | 80 | 20 | 0.1270449674 | 79.498122771 |
8 | 2024-01-30 00:00:00.000 | 80 | 20 | 0.1281849476 | 80.57078749 |
9 | 2024-01-31 00:00:00.000 | 80 | 20 | 0.1288674613 | 81.160912884 |
10 | 2024-02-01 00:00:00.000 | 80 | 20 | 0.1898235732 | 94.925713807 |
11 | 2024-02-02 00:00:00.000 | 80 | 20 | 0.2434916747 | 96.912123919 |
12 | 2024-02-03 00:00:00.000 | 80 | 20 | 0.2618379372 | 97.276576116 |
13 | 2024-02-04 00:00:00.000 | 80 | 20 | 0.2445635802 | 87.547355999 |
14 | 2024-02-05 00:00:00.000 | 80 | 20 | 0.260018843 | 88.570142682 |
15 | 2024-02-06 00:00:00.000 | 80 | 20 | 0.2535668586 | 85.633938022 |
16 | 2024-02-07 00:00:00.000 | 80 | 20 | 0.2585435236 | 85.485829089 |
17 | 2024-02-08 00:00:00.000 | 80 | 20 | 0.2940938087 | 89.271031254 |
18 | 2024-02-09 00:00:00.000 | 80 | 20 | 0.3326976801 | 90.78491469 |
19 | 2024-02-10 00:00:00.000 | 80 | 20 | 0.3532291473 | 91.271450835 |
20 | 2024-02-11 00:00:00.000 | 80 | 20 | 0.3585877738 | 91.38513006 |
Kruys-Collinstesty-salmon
Updated 2025-03-23
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
WITH price_changes AS (
SELECT
date_trunc('day', hour) AS date,
AVG(price) as AVGprice,
LAG(AVGprice) OVER (ORDER BY date) AS prev_price,
AVGprice - LAG(AVGprice) OVER (ORDER BY date) AS change
FROM
aptos.price.ez_prices_hourly
WHERE TOKEN_ADDRESS ilike '{{Token_Address}}'
GROUP BY 1
),
gains_and_losses AS (
SELECT
date,
AVGprice,
change,
CASE WHEN change > 0 THEN change ELSE 0 END AS gain,
CASE WHEN change < 0 THEN ABS(change) ELSE 0 END AS loss
FROM
price_changes
),
average_gains_and_losses AS (
SELECT
date,
AVGprice,
AVG(gain) OVER (ORDER BY date ROWS BETWEEN 13 PRECEDING AND CURRENT ROW) AS avg_gain,
AVG(loss) OVER (ORDER BY date ROWS BETWEEN 13 PRECEDING AND CURRENT ROW) AS avg_loss
FROM
gains_and_losses
)
SELECT
date,
80 as "over-bought zone",
20 as "over-sold zone",
AVGprice,
CASE WHEN avg_loss = 0 THEN 100 ELSE 100 - (100 / (1 + (avg_gain / avg_loss))) END AS RSI
Last run: about 1 month ago
...
426
25KB
6s