the_defi_freakShiba Price
Updated 2024-09-17
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
With price AS(
SELECT
date_trunc('day', Hour) as date,
avg(PRICE) as price,
Symbol
FROM
ethereum.price.ez_prices_hourly
where
Symbol = 'SHIB'
and date >= '2024-01-01'
group by
1,
symbol
)
select
date,
price,
(price * 589270000000000) as Market_cap,
Symbol
from
price
Order by
date Desc
QueryRunArchived: QueryRun has been archived