alirsCopy of Untitled Query
    Updated 2022-06-29
    with WBTC_price as (
    select
    distinct balance_date::date as day
    ,avg(price) as avg_WBTC_Price
    from flipside_prod_db.ethereum.erc20_balances
    where symbol = 'WBTC'
    and balance_date >= CURRENT_DATE-180
    GROUP BY 1
    order by 1),
    ETH_Price as (
    select
    distinct balance_date::date as day
    ,avg(price) as avg_ETH_Price
    from flipside_prod_db.ethereum.erc20_balances
    where symbol = 'ETH'
    and balance_date >= CURRENT_DATE-180
    GROUP BY 1
    order by 1)
    ,Algo_price as(


    select
    distinct block_hour::date as day
    ,avg(price_usd) as avg_Algo_Price
    from flipside_prod_db.algorand.prices_swap
    where asset_id = 0
    and block_hour >= CURRENT_DATE-180
    GROUP BY 1
    order by 1)


    select WBTC.day,ETH.day,Algo.day, avg(WBTC.avg_WBTC_Price),
    avg(ETH.avg_ETH_Price),avg(ALGO.avg_Algo_Price)
    from WBTC_price WBTC,ETH_price ETH,Algo_price ALGO
    Run a query to Download Data