cryptodaily911Marketcap
Updated 2024-09-10
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
›
⌄
WITH daily_prices AS (
SELECT
date_trunc('day', HOUR) AS date,
PRICE AS close_price,
SYMBOL,
ROW_NUMBER() OVER (PARTITION BY date_trunc('day', HOUR) ORDER BY HOUR DESC) AS rn
FROM
ethereum.price.ez_prices_hourly
WHERE
TOKEN_ADDRESS = '0xee2a03aa6dacf51c18679c516ad5283d8e7c2637'
AND date_trunc('day', HOUR) >= '2024-01-01'
)
SELECT
date,
close_price AS Price,
(close_price * 1000000000) AS Market_cap,
SYMBOL
FROM
daily_prices
WHERE
rn = 1
ORDER BY
date DESC;
QueryRunArchived: QueryRun has been archived