eferVII > Price analysis
Updated 2023-04-13
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 main AS (
SELECT
BLOCK_TIMESTAMP::date AS date,
SUM(RAW_AMOUNT)/POW(10, 18) AS OP,
SUM(OP) OVER(ORDER BY date ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS cumulative,
cumulative AS supply
FROM
optimism.core.fact_token_transfers
WHERE
FROM_ADDRESS = '0xfedfaf1a10335448b7fa0268f56d2b44dbd357de'
AND ORIGIN_FUNCTION_SIGNATURE = '0x2e7ba6ef'
GROUP BY date
ORDER BY date
), price AS (
SELECT
HOUR::date AS date,
AVG(PRICE) AS average_price
FROM
optimism.core.fact_hourly_token_prices
WHERE
SYMBOL = 'OP'
GROUP BY date
)
SELECT
t1.date,
t1.supply,
t2.average_price
FROM
main t1
LEFT JOIN (
SELECT * FROM price
) t2
ON t1.date = t2.date
Run a query to Download Data