StangFASTpart 1 - new holder
Updated 2024-09-17
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
›
⌄
-- $COQ — 0x420fca0121dc28039145009570975747295f2329 - fdd46b
-- $TECH — 0x5ac04b69bde6f67c0bd5d6ba6fd5d816548b066a - 3fa5c7
-- $WOLF - 0x4f94b8aef08c92fefe416af073f1df1e284438ec - fff600
-- $NOCHILL — 0xacfb898cff266e53278cc0124fc2c7c94c8cb9a5 - 2a4163
-- $KIMBO 0x184ff13b3ebcb25be44e860163a5d8391dd568c1 - fa8f41
-- $HEFE - 0x18e3605b13f10016901eac609b9e188cf7c18973 - 7ac342
-- $MEOW — 0x8ad25b0083c9879942a64f00f20a70d3278f6187 - cf0508
-- $MAJIN - 0x73f49d00ac1b520f94d11248808c40774aeb0802 - e84142
with
price as(
select
date_trunc( 'month' , a.hour ) as date
, avg( a.price ) as price
, a.decimals as decimals
, a.symbol as symbol
, a.token_address as token_address
from
avalanche.price.ez_prices_hourly a
where
date_trunc( 'day' , a.hour ) = date_trunc( 'day' , current_date )
and a.token_address in (
'0x420fca0121dc28039145009570975747295f2329' ,
'0x5ac04b69bde6f67c0bd5d6ba6fd5d816548b066a' ,
'0x4f94b8aef08c92fefe416af073f1df1e284438ec' ,
'0xacfb898cff266e53278cc0124fc2c7c94c8cb9a5' ,
'0x184ff13b3ebcb25be44e860163a5d8391dd568c1' ,
'0x18e3605b13f10016901eac609b9e188cf7c18973' ,
'0x8ad25b0083c9879942a64f00f20a70d3278f6187' ,
'0x73f49d00ac1b520f94d11248808c40774aeb0802'
)
group by 1 , 3 , 4 , 5
order by 1 desc
)
,
QueryRunArchived: QueryRun has been archived