2844Algorand Price Correlation-2
    Updated 2022-06-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