Drsimontop token - price daily
    Updated 2023-01-27
    with tab1 as ( select symbol as Symbol1,
    avg (price) as Previous_Price
    from osmosis.core.dim_prices
    where symbol in ('ATOM' , 'osmo' , 'axl' , 'wbtc' ,'statom' , 'WETH' , 'JUNO', 'DAI','EVMOS','CRO')
    --and recorded_at >= '2023-01-01'
    group by 1)


    select recorded_at::date as date,
    symbol, price ,
    (avg(price - Previous_Price)/avg(Previous_Price)) * 100 as Price_Change_Ratio
    from osmosis.core.dim_prices t1 join tab1 t2 on Symbol1 = symbol
    where symbol in ('ATOM' , 'osmo' , 'axl' , 'wbtc' ,'statom' , 'WETH' , 'JUNO', 'DAI','EVMOS','CRO')
    --and recorded_at >= '2023-01-01'
    group by 1,2,3


    Run a query to Download Data