kasadeghCorrelation between Algo Price and Folks Finance' Transaction Count
    Updated 2022-07-12

    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