omer93rune 4
Updated 2023-06-12
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 tab1 AS (
SELECT
trunc(fp.BLOCK_TIMESTAMP, 'month') AS date,
AVG(fp.RUNE_USD) AS RUNE_USD,
SUM(RUNE_AMOUNT) AS RUNE_AMOUNT
FROM
thorchain.core.fact_prices fp
LEFT JOIN
(
SELECT
trunc(BLOCK_TIMESTAMP, 'month') AS month,
SUM(RUNE_AMOUNT) AS RUNE_AMOUNT
FROM
thorchain.core.fact_transfers
WHERE
ASSET = 'THOR.RUNE'
GROUP BY
trunc(BLOCK_TIMESTAMP, 'month')
) ft ON trunc(fp.BLOCK_TIMESTAMP, 'month') = ft.month
WHERE
fp.BLOCK_TIMESTAMP >= CURRENT_DATE() - INTERVAL '1 YEAR'
GROUP BY
trunc(fp.BLOCK_TIMESTAMP, 'month')
ORDER BY
trunc(fp.BLOCK_TIMESTAMP, 'month')
)
SELECT
date,
CORR(RUNE_USD, RUNE_AMOUNT) AS correlation_coefficient
FROM
tab1
GROUP BY
date
ORDER BY
date ASC;
Run a query to Download Data