StangFASTEGG / AVAX
Updated 2023-08-12
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
›
⌄
-- forked from 01 - action @ https://flipsidecrypto.xyz/edit/queries/2a2de6cc-8c5d-42f6-9c3d-0751b6e77c24
-- forked from 00 - overview @ https://flipsidecrypto.xyz/edit/queries/328dfa7c-3b0d-4568-8f5b-2d33701ade38
-- forked from 01 - overview chart normal @ https://flipsidecrypto.xyz/edit/queries/1fe91107-72da-421b-8dda-12361cc60ba8
-- forked from 01 - overview @ https://flipsidecrypto.xyz/edit/queries/c84fdbcc-ba52-4b62-92fc-f74ee4a13feb
--- 0x3052a75dfD7A9D9B0F81E510E01d3Fe80A9e7ec7 egg / avax
--- 0x3B90A467f58631369903c2005457a3d28d47f3E5 fert / avax
--- 0x017025f07b23Bb30e1140dB10D3fe7A1626CFdD0 feed / avax
--- 0x10866fE002e9fcFD3f9Be92B6521Cdb4A9f8378b worm / avax
--- 0xf91b3f72 -> add lp -> contract_address and to_address
--- 0xbaa2abde -> remove lp -> contract_address and from_address [ from_address not 0x0000000000000000000000000000000000000000 ]
with
chikn AS
(
SELECT
date_trunc( 'day' , a.hour ) AS "day"
, avg( a.price ) AS "price"
, a.symbol AS "token"
, a.token_address AS "token_address"
, a.decimals AS "decimals"
FROM
avalanche.core.fact_hourly_token_prices AS a
WHERE
a.token_address IN (
lower( '0x79BA10485ae46a9436D560D9664369176EC2eB2b' )
, lower( '0xab592d197ACc575D16C3346f4EB70C703F308D1E' )
, lower( '0x9C846D808A41328A209e235B5e3c4E626DAb169E' )
, lower( '0x7761E2338B35bCEB6BdA6ce477EF012bde7aE611' )
, lower( '0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7' )
)
Run a query to Download Data