StangFAST02 - number token's price
Updated 2023-08-12
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
SELECT
max( date_trunc( 'day' , a.hour ) ) AS "day"
, avg( a.price ) AS "price"
, a.symbol AS "token"
FROM
avalanche.core.fact_hourly_token_prices AS a
WHERE
a.token_address IN (
lower( '0x79BA10485ae46a9436D560D9664369176EC2eB2b' )
, lower( '0xab592d197ACc575D16C3346f4EB70C703F308D1E' )
, lower( '0x9C846D808A41328A209e235B5e3c4E626DAb169E' )
, lower( '0x7761E2338B35bCEB6BdA6ce477EF012bde7aE611' )
)
AND a.hour::date >= dateadd ( 'day' , -1 , current_date )
GROUP BY 3
ORDER BY 3 DESC
Run a query to Download Data