PS0G1STG price
Updated 2023-10-30
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
›
⌄
WITH STG AS (
SELECT
HOUR::date AS date,
AVG(PRICE) AS STG_price,
AVG(STG_price) OVER (ORDER BY date ROWS BETWEEN 6 PRECEDING AND CURRENT ROW) AS D7MA,
AVG(STG_price) OVER (ORDER BY date ROWS BETWEEN 13 PRECEDING AND CURRENT ROW) AS D14MA,
AVG(STG_price) OVER (ORDER BY date ROWS BETWEEN 29 PRECEDING AND CURRENT ROW) AS D30MA,
LAG(STG_price) OVER (ORDER BY date) AS previous_price,
(STG_price - LAG(STG_price) OVER (ORDER BY date)) / LAG(STG_price) OVER (ORDER BY date) * 100 AS percentage_change
FROM
avalanche.price.ez_hourly_token_prices
WHERE TOKEN_ADDRESS = LOWER('0x2f6f07cdcf3588944bf4c42ac74ff24bf56e7590')
GROUP BY 1
),
AVA AS (
SELECT
HOUR::date AS date,
AVG(PRICE) AS AVAX_price
FROM
avalanche.price.ez_hourly_token_prices
WHERE
TOKEN_ADDRESS = LOWER('0xB31f66AA3C1e785363F0875A1B74E27b85FD66c7')
GROUP BY 1
)
SELECT
date_trunc('{{time_interval}}', STG.date) as date,
AVAX_price,
STG_price,
D7MA,
D14MA,
D30MA,
percentage_change
FROM
STG
JOIN AVA ON STG.date = AVA.date
Run a query to Download Data