John_GaltLP Percent 5: EVMOS - OSMO
    Updated 2022-06-21
    with anchor as (select
    distinct date(block_timestamp) as date
    from osmosis.core.fact_msg_attributes
    where date(block_timestamp) between '2022-05-22' and '2022-06-19'
    ),

    adding as (select
    date,
    case
    when date = '2022-05-29' then '78.701049485'
    when date = '2022-06-05' then '53.850919304'
    when date = '2022-06-12' then '42.51157874'
    when date = '2022-06-19' then '30.593967066'
    end as "top 5",
    case
    when date = '2022-05-29' then '5.056483157'
    when date = '2022-06-05' then '9.458589445'
    when date = '2022-06-12' then '10.331826485'
    when date = '2022-06-19' then '15.677370215'
    end as "top 6-15",
    case
    when date = '2022-05-29' then '6.662863055'
    when date = '2022-06-05' then '9.753884668'
    when date = '2022-06-12' then '12.265521536'
    when date = '2022-06-19' then '16.825476414'
    end as "top 16-45",
    case
    when date = '2022-05-29' then '516'
    when date = '2022-06-05' then '1701'
    when date = '2022-06-12' then '2096'
    when date = '2022-06-19' then '2547'
    end as "LP addr count"
    from anchor
    where "top 5" > 0
    order by date
    )