Mr_AceCORRELATION TO SOL AND JUP
Updated 2024-05-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 A AS (
SELECT
DATE_TRUNC('HOUR', recorded_hour) AS Date1,
CLOSE AS WEN_PRICE,
token_address
FROM
solana.price.ez_token_prices_hourly
WHERE
recorded_hour >= '2024-01-26'
AND recorded_hour <= CURRENT_DATE
AND token_address = 'WENWENvqqNya429ubCdR81ZmD69brwQaaBYY6p3LCpk'
),
B AS (
SELECT
DATE_TRUNC('HOUR', recorded_hour) AS Date2,
CLOSE AS SOL_PRICE,
token_address
FROM
solana.price.ez_token_prices_hourly
WHERE
recorded_hour >= '2024-01-26'
AND recorded_hour <= CURRENT_DATE
AND token_address = 'So11111111111111111111111111111111111111112'
),
C AS (
SELECT
DATE_TRUNC('HOUR', recorded_hour) AS Date3,
CLOSE AS JUP_PRICE,
token_address
FROM
solana.price.ez_token_prices_hourly
WHERE
recorded_hour >= '2024-01-26'
AND recorded_hour <= CURRENT_DATE
AND token_address = 'JUPyiwrYJFskUPiHa7hkeR8VUtAeFoSYbKedZNsDvCN'
),
QueryRunArchived: QueryRun has been archived