StangFAST011
Updated 2023-10-14
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
›
⌄
with
token AS
(
SELECT
a.address AS address
, a.symbol AS symbol
, a.name AS name
, a.decimals AS decimals
FROM
avalanche.core.dim_contracts a
WHERE
a.address in (
lower( '0xB97EF9Ef8734C71904D8002F8b6Bc66Dd9c48a6E' )
, lower( '0x9702230A8Ea53601f5cD2dc00fDBc13d4dF4A8c7' )
, lower( '0x152b9d0FdC40C096757F570A51E494bd4b943E50' )
, lower( '0x130966628846BFd36ff31a822705796e8cb8C18D' )
, lower( '0xA7D7079b0FEaD91F3e65f86E8915Cb59c1a4C664' )
, lower( '0x6e84a6216eA6dACC71eE8E6b0a5B7322EEbC0fDd' )
, lower( '0xc7198437980c041c805A1EDcbA50c1Ce5db95118' )
, lower( '0xB31f66AA3C1e785363F0875A1B74E27b85FD66c7' )
, lower( '0x2F6F07CDcf3588944Bf4C42aC74ff24bF56e7590' )
)
OR a.name = 'Joe LP Token'
)
,
token_price AS
(
SELECT
date_trunc( 'day' , a.hour ) AS day
, avg( a.price ) AS price_usd
, a.symbol AS symbol
, a.token_address AS address
FROM
avalanche.price.ez_hourly_token_prices a
Run a query to Download Data