StangFAST03 - growth
Updated 2023-08-26
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
›
⌄
-- forked from 03 - transactions @ https://flipsidecrypto.xyz/edit/queries/8e86f5dc-214b-4612-afaa-f4af0d845903
-- forked from 01 - success rate @ https://flipsidecrypto.xyz/edit/queries/f2298130-6d1d-48e1-bbca-adfd2b32da17
-- forked from 01 - overview @ https://flipsidecrypto.xyz/edit/queries/fa6c1428-0f60-404d-a4ba-9103c388e7ce
with
token_price AS
(
SELECT
date_trunc( 'day' , a.hour ) AS day
, avg( a.price ) AS price
, a.symbol AS token
, a.token_address AS token_id
FROM
base.core.fact_hourly_token_prices a
GROUP BY 1 , 3 , 4
ORDER BY 1 DESC
)
,
eth_price AS
(
SELECT
date_trunc( 'day' , a.hour ) AS day
, avg( a.price ) AS price
, a.symbol AS token
, a.token_address AS token_id
FROM
base.core.fact_hourly_token_prices a
WHERE
a.symbol = 'WETH'
GROUP BY 1 , 3 , 4
ORDER BY 1 DESC
)
Run a query to Download Data