mz01112023-05-25 05:57 AM
    select
    date_trunc('day', block_timestamp) as Date_Day,
    avg(liquidity) as Liquidity,
    avg(LIQUIDITY_USD) as Liquidity_USD,
    rank() over (order by date asc ) as Day

    from osmosis.core.fact_pool_hour

    where pool_id = 789
    group by 1

    Run a query to Download Data