kasadeghCorrelation between Algo Price and Folks Finance' Transaction Count
Updated 2022-07-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
›
⌄
with algo_price as (
select date(BLOCK_HOUR) as day, avg(PRICE_USD) as average_algo_price
from flipside_prod_db.algorand.prices_swap
where ASSET_NAME='ALGO'
group by day
)
,
folks_finance_app_call as (
select * from flipside_prod_db.algorand.application_call_transaction
where APP_ID in (776179559,776176449,752770929,751285119,747239433,747237154,743685742,743679535,696044550,694464549,694405065,686876641,686875498,686862190,686860954,686501760,686500844,686500029,686498781)
or TX_GROUP_ID in (select TX_GROUP_ID from flipside_prod_db.algorand.application_call_transaction
where APP_ID in (776179559,776176449,752770929,751285119,747239433,747237154,743685742,743679535,696044550,694464549,694405065,686876641,686875498,686862190,686860954,686501760,686500844,686500029,686498781))
)
select t1.day ,average_algo_price ,total_number_of_app_call
from (
select date(BLOCK_TIMESTAMP) as day,count(distinct TX_ID) as total_number_of_app_call
from folks_finance_app_call
group by day
)
as t1 join algo_price as t2
on t1.day=t2.day
order by day
Run a query to Download Data