StangFAST008 - overview [ number ]
Updated 2023-10-24
999
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
›
⌄
--- vault deposit | withdraw | request W | instant W
----------------------------------------------------------------------------------------------------------------
--- WAVAX = 0x866810349B2e28E411669911bB0babb06cc60625 0xb6b55f25 | 0x36ea4344 , 0x7ab7cbb1 , 0x441a3e70
--- BTC.b = 0x1cd7b33faf4f172146bcbb841c7addc96802e6c4 0xb6b55f25 | 0x36ea4344 , 0x7ab7cbb1 , 0x441a3e70
--- USDC = 0x11B29AE3037F4526e4AA56952318e0d01ADA836A 0xb6b55f25 | 0x36ea4344 , 0x7ab7cbb1 , 0x441a3e70
--- Inactive vault
----------------------------------------------------------------------------------------------------------------
--- WAVAX = 0xFC0E57b5F8adCadc5e6E37578bb9Aa30cEe312Af 0xb6b55f25 | 0x745400c9 , 0xfd92bff2 , 0x441a3e70
--- USDC = 0x86A6391D5d7C02245927E2DC0cBFa3e5F1B9aBC7 0xb6b55f25 | 0x745400c9 , 0xfd92bff2 , 0x441a3e70
with
price AS
(
SELECT
date_trunc( 'day' , a.hour ) AS date
, avg( a.price ) AS price
, a.token_address AS address
, a.symbol AS symbol
, a.decimals AS decimal
FROM
avalanche.price.ez_hourly_token_prices a
GROUP BY 1 , 3 , 4 , 5
ORDER BY 1 DESC
)
,
symbol AS
(
SELECT
a.contract_address
AS address
, case
when a.contract_address = lower( '0x866810349B2e28E411669911bB0babb06cc60625' ) then 'WAVAX'
when a.contract_address = lower( '0x1cd7b33faf4f172146bcbb841c7addc96802e6c4' ) then 'BTC.b'
Run a query to Download Data