flipside

    Weekly Pool Size
    MasiWeekly Pool Size
    Updated 2024-07-20
    select trunc(BLOCK_TIMESTAMP,'week') as weekly,
    max(LIQUIDITY_USD) as liquidity,
    sum(volume_usd) as usd_volume,
    sum(usd_volume) over (order by weekly asc) as Cumulative_volume
    from osmosis.defi.fact_pool_hour
    where pool_id = '812'
    group by 1
    QueryRunArchived: QueryRun has been archived