Updated 2022-06-10

    select
    liquidity_provider_address,
    sum(amount)/1e6 as amount, --uosmo is the subdivision token from osmo
    action,
    currency
    from osmosis.core.fact_liquidity_provider_actions
    where action = 'pool_exited' and currency = 'uosmo' and block_id between '4707300' and '4713064'

    group by 1, 3, 4
    order by amount desc
    Run a query to Download Data