John_GaltLP Percent 2: JUNO - OSMO
    Updated 2022-06-23
    with anchor as (select
    distinct date(block_timestamp) as date
    from osmosis.core.fact_msg_attributes
    where date(block_timestamp) between '2022-03-20' and '2022-06-19'
    ),

    adding as (select
    date,
    case
    when date = '2022-03-20' then '9.470594382'
    when date = '2022-03-27' then '9.182904983'
    when date = '2022-04-03' then '9.144895185'
    when date = '2022-04-10' then '8.958790025'
    when date = '2022-04-17' then '8.933712976'
    when date = '2022-04-24' then '8.509363814'
    when date = '2022-05-01' then '9.048599351'
    when date = '2022-05-08' then '8.862261504'
    when date = '2022-05-15' then '11.832445765'
    when date = '2022-05-22' then '12.512403861'
    when date = '2022-05-29' then '15.151302726'
    when date = '2022-06-05' then '16.128044566'
    when date = '2022-06-12' then '16.083712077'
    when date = '2022-06-19' then '16.700081602'
    end as "top 5",
    case
    when date = '2022-03-20' then '15.620737376'
    when date = '2022-03-27' then '15.164453295'
    when date = '2022-04-03' then '14.754964731'
    when date = '2022-04-10' then '14.454690641'
    when date = '2022-04-17' then '13.865959621'
    when date = '2022-04-24' then '13.471587281'
    when date = '2022-05-01' then '13.26408766'
    when date = '2022-05-08' then '13.67868807'
    when date = '2022-05-15' then '14.414368277'
    when date = '2022-05-22' then '15.178945243'
    when date = '2022-05-29' then '16.452115916'
    Run a query to Download Data