feyikemiGME_Price
Updated 2024-05-15
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
›
⌄
WITH Prices AS (
SELECT
DATE_TRUNC('hour', hour) AS Date,
AVG(
CASE
WHEN token_address = '8wXtPeU6557ETkp9WHFY1n1EcU6NxDvbAggHGsMYiHsB' THEN Price
END
) AS GME_price,
AVG(
CASE
WHEN token_address = 'So11111111111111111111111111111111111111112' THEN Price
END
) AS SOL_price
FROM
solana.price.ez_prices_hourly
WHERE
token_address IN (
'8wXtPeU6557ETkp9WHFY1n1EcU6NxDvbAggHGsMYiHsB',
'So11111111111111111111111111111111111111112'
)
GROUP BY
1
)
SELECT
Date,
GME_price,
SOL_price
FROM
Prices
WHERE
GME_price IS NOT NULL
AND SOL_price IS NOT NULL
ORDER BY
1 DESC
QueryRunArchived: QueryRun has been archived