flipside

    Total $OSMO count: LP actions(exited-joined)
    SpiltadavidTotal $OSMO count: LP actions(exited-joined)
    Updated 2022-10-12
    select sum(AMOUNT/1e6),count(*),ACTION
    from osmosis.core.fact_liquidity_provider_actions
    where CURRENCY='uosmo' and BLOCK_TIMESTAMP::date > current_date - interval '15 days'
    group by 3
    Run a query to Download Data