tkvresearchhushed-blush
Updated 2024-10-23
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
›
⌄
with full_data as
(
select * from (values
('0x420fca0121dc28039145009570975747295f2329','Cog Inu'), --
('0x184ff13b3ebcb25be44e860163a5d8391dd568c1','Kimbo'), --
('0xacfb898cff266e53278cc0124fc2c7c94c8cb9a5','Avax has no chill'), --
('0x65378b697853568da9ff8eab60c13e1ee9f4a654','husky avax'), --
('0x5ac04b69bde6f67c0bd5d6ba6fd5d816548b066a','NumberGoUpTech'), --
('0x4a5bb433132b7e7f75d6a9a3e4136bb85ce6e4d5','Booty'), --
('0x502580fc390606b47fc3b741d6d49909383c28a9','HatchyPocket'), --
('0x8ad25b0083c9879942a64f00f20a70d3278f6187','MeowCat'), --
('0xc8e7fb72b53d08c4f95b93b390ed3f132d03f2d5','SQRCAT'), --
('0x440abbf18c54b2782a4917b80a1746d3a2c2cce1','Shibavax'), --
('0x694200a68b18232916353250955be220e88c5cbb','Kovin Segnocchi'), --
('0xc06e17bdc3f008f4ce08d27d364416079289e729','DOGwifCROCS'), --
('0x82fe038ea4b50f9c957da326c412ebd73462077c','Joe Hat'), --
('0x3377aca4c0bfd021be6bd762b5f594975e77f9cf','Cat Wif Hands'), --
('0x89a8633bcad3af0951acc5137811ea21a17c37dc','Lama'), --
('0x22897cf0da31e1f118649d9f6ad1809cabd84948','Baby Coq Inu'), --
('0x214dd1b5cbe543d4189ab39832f1bc1eedebb1d3','Junior'), --
('0x4f94b8aef08c92fefe416af073f1df1e284438ec','Landwolf on AVAX'), --
('0x4586af10ecceed4e383e3f2ec93b6c61e26500b5','HUNDRED'), --
('0xe06fba763c2104db5027f57f6a5be0a0d86308af','Akitavax'), --
('0xb36faf341c7817d681f23bcedbd3d85467e5ad9f','Red Pepe'), --
('0xf6240f39f9f82e7cafbe6ffe0bfaf1e2e4c5bdb4','Red Hat Games'), --
('0xe8385cecb013561b69beb63ff59f4d10734881f3','Gecko Inu'),
('0x3301ee63fb29f863f2333bd4466acb46cd8323e6','Akita Inu'),
('0x87bbfc9dcb66caa8ce7582a3f17b60a25cd8a248','The Big Red'),
('0xed0d09ee0f32f7b5afae6f2d728189c5e355b52a','LIZARD')
) as l1(address,token_name)
),
price as (
select date(hour) as datetime,
token_address,
symbol,
QueryRunArchived: QueryRun has been archived