flipside

    Price vs transactions
    nitsPrice vs transactions
    Updated 2022-07-02
    with algo as
    (SELECT date(block_hour) as day, avg(price_usd) as avg_price_algo FROM flipside_prod_db.algorand.prices_swap
    WHERE asset_id = 0 and block_hour >= '2022-01-01'
    GROUP by 1 ),
    algo_activity as
    (SELECT date(block_timestamp) as day_, count(DISTINCT tx_id) as total_txs from algorand.transactions
    where day_ >= '2022-01-01'
    GROUP by 1 )

    SELECT * from algo
    join algo_activity on day = day_
    -- limit 100
    Run a query to Download Data