KARTODOP price
Updated 2022-10-02
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
›
⌄
WITH p AS (
SELECT
date(HOUR) AS Time,
AVG(price) AS OP_price
FROM optimism.core.fact_hourly_token_prices
WHERE TOKEN_ADDRESS = '0x4200000000000000000000000000000000000042'
group by Time
),
Start_price AS (
SELECT
OP_price as OP_start_price
FROM p
ORDER BY time asc
LIMIT 1
)
SELECT
time,
OP_price AS "OP price",
100*(OP_price - lag(OP_price,1) over (order by time))/ (lag(OP_price,1) over (order by time)) as "Daily OP price change",
OP_price - OP_start_price as "Change in USD",
(OP_price - OP_start_price)/ (OP_start_price) as "% change",
AVG(OP_price) OVER (ORDER BY time ROWS BETWEEN 30 PRECEDING AND 0 FOLLOWING) AS "MA(30) OP price",
AVG(OP_price) OVER (ORDER BY time ROWS BETWEEN 14 PRECEDING AND 0 FOLLOWING) AS "MA(14) OP price"
FROM p, Start_price
ORDER BY time desc
Run a query to Download Data