princefarzamOp price
Updated 2022-12-22
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
›
⌄
With
OP_price AS (
SELECT
date_trunc('day', HOUR)::date AS day,
avg(PRICE) AS OP_price
FROM
optimism.core.fact_hourly_token_prices
WHERE
SYMBOL = 'OP'
AND day >= '2022-11-01'
group by
day
ORDER BY
day ASC
),
WBTC_price AS (
SELECT
date_trunc('day', HOUR)::date AS day,
avg(PRICE) AS WBTC_price
FROM
optimism.core.fact_hourly_token_prices
WHERE
SYMBOL = 'WBTC'
AND day >= '2022-11-01'
group by
day
ORDER BY
day ASC
)
SELECT
FROM OP_price O left join WBTC_price B ON O.day=B.day