SalehAlgorand Price Correlation-algo btc
    Updated 2022-07-01
    with btc as (
    select
    hour::date as day
    ,avg(price) as price
    from ethereum.core.fact_hourly_token_prices
    where hour::date >='2022-01-01'
    and symbol = 'WBTC'
    group by 1
    order by 1
    )

    ,algo as (
    select
    block_hour::date as day
    ,avg(price_usd) as price
    from flipside_prod_db.algorand.prices_swap
    where block_hour::date >= '2022-01-01'
    and asset_id = 0
    group by 1
    order by 1
    )
    select 'BTC' as type ,* from btc
    union all
    select 'ALGO' as type ,* from algo

    Run a query to Download Data