sakineh5021-nIQRzBThe Meme's game (price)
Updated 2022-03-22
99
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 shib as ( select cast(hour as date) as date_swap , avg(price) as shiba
from ethereum.token_prices_hourly
where token_address = '0x95ad61b0a150d79219dcf64e1e6cc01f0b64c4ce'
group by 1
) ,
kish as ( SELECT cast(hour as date) as date_swap , avg(price) as KIshu
from ethereum.token_prices_hourly
where token_address = '0xa2b4c0af19cc16a6cfacce81f192b024d625817d'
group by 1
) ,
Elo as ( SELECT cast(hour as date) as date_swap , avg(price) as Elon
from ethereum.token_prices_hourly
where token_address = '0x761d38e5ddf6ccf6cf7c55759d5210750b5d60f3'
group by 1
) ,
Hog as ( SELECT cast(hour as date) as date_swap , avg(price) as Hoge
from ethereum.token_prices_hourly
where token_address = '0xfad45e47083e4607302aa43c65fb3106f1cd7607'
group by 1
) ,
Woof as ( SELECT cast(hour as date) as date_swap , avg(price) as Woofy
from ethereum.token_prices_hourly
where token_address = '0xd0660cd418a64a1d44e9214ad8e459324d8157f1'
group by 1
)
SELECT S.date_swap as swa_date , Shiba ,Woofy, Hoge , Elon , kishu
from Shib S
left outer join hog H on S.date_swap = H.date_swap
left outer join woof W on S.date_swap = W.date_swap
left outer join Elo E on S.date_swap = E.date_swap
left outer join kish K on S.date_swap = K.date_swap
Run a query to Download Data