0-MID2023-06-13 05:56 AM
    Updated 2023-07-14
    select date_trunc('month',BLOCK_TIMESTAMP) as month
    ,sum(AMOUNT/pow(10,DECIMAL)) as volume
    ,count(distinct LIQUIDITY_PROVIDER_ADDRESS) as lpers
    ,count(distinct TX_ID) as lpes
    ,sum(volume)over(order by month) as "Lp volume growth"
    ,sum(lpers)over(order by month) as "Lper growth"
    ,sum(lpes)over(order by month) as "Lp growth"
    from osmosis.core.fact_liquidity_provider_actions
    where CURRENCY='uosmo'
    group by 1

    Run a query to Download Data