2844Algorand Price Correlation-2
Updated 2022-06-30
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
›
⌄
with TRANSFERS as
(
SELECT date_trunc('day',BLOCK_TIMESTAMP) as "DTE",COUNT (TX_ID) as "TRANSFERS"
from flipside_prod_db.algorand.transfers
where
"DTE" > '2022-01-30'
AND ASSET_ID ='0'
GROUP BY 1
),
TRANSACTIONS AS
(SELECT date_trunc('day',BLOCK_TIMESTAMP) as "DTE",COUNT (TX_ID) as "TRANSACTIONS"
from flipside_prod_db.algorand.transactions
where
"DTE" > '2022-01-30'
GROUP BY 1
),
ALGO AS
(
SELECT date_trunc('day',BLOCK_HOUR) as "DTE",avg(PRICE_USD) as "ALGO Price"
from flipside_prod_db.algorand.prices_swap
where ASSET_NAME ilike 'Algo' and
ASSET_ID ='0'
and "DTE" > '2022-01-30'
--AND "DTE" != '2022-05-23'
GROUP BY 1
)
SELECT ALGO."DTE",ALGO."ALGO Price",TRANSFERS."TRANSFERS",TRANSACTIONS."TRANSACTIONS"
FROM TRANSACTIONS,TRANSFERS,ALGO
WHERE ALGO."DTE"=TRANSACTIONS."DTE" AND ALGO."DTE"=TRANSFERS."DTE"
Run a query to Download Data