1D Avg Price | 7D Avg Price | 14D Avg Price | 30D Avg Price | 1D vs 7D % | 1D vs 14D % | 1D vs 30D % | |
|---|---|---|---|---|---|---|---|
1 | 5.9342 | 6.6277 | 7.2213 | 8.1303 | -10.46 | -17.82 | -27.01 |
Movement TeamPrice Growth
Updated 2025-02-06
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 apt AS (
SELECT
hour,
AVG(price) AS "Apt Price"
FROM
aptos.price.ez_prices_hourly
WHERE
symbol = 'APT'
GROUP BY
1
),
current_1d_avg AS (
SELECT
AVG("Apt Price") AS avg_1d
FROM
apt
WHERE
hour >= CURRENT_TIMESTAMP - INTERVAL '1 day'
),
last_7d_avg AS (
SELECT
AVG("Apt Price") AS avg_7d
FROM
apt
WHERE
hour >= CURRENT_TIMESTAMP - INTERVAL '7 days'
),
last_14d_avg AS (
SELECT
AVG("Apt Price") AS avg_14d
FROM
apt
WHERE
Last run: 3 months ago
1
52B
3s