John_GaltLP Percent 1: ATOM - 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-03-20' and '2022-06-19'
    ),

    adding as (select
    date,
    case
    when date = '2022-03-20' then '26.634156722'
    when date = '2022-03-27' then '25.724118414'
    when date = '2022-04-03' then '25.188991261'
    when date = '2022-04-10' then '25.073160836'
    when date = '2022-04-17' then '25.899108619'
    when date = '2022-04-24' then '26.661381971'
    when date = '2022-05-01' then '26.849207443'
    when date = '2022-05-08' then '27.343085169'
    when date = '2022-05-15' then '33.752986361'
    when date = '2022-05-22' then '31.219108885'
    when date = '2022-05-29' then '25.494799457'
    when date = '2022-06-05' then '25.906726152'
    when date = '2022-06-12' then '25.441388991'
    when date = '2022-06-19' then '26.38558212'
    end as "top 5",
    case
    when date = '2022-03-20' then '11.028512845'
    when date = '2022-03-27' then '8.962249824'
    when date = '2022-04-03' then '9.334559684'
    when date = '2022-04-10' then '9.120910653'
    when date = '2022-04-17' then '9.149925798'
    when date = '2022-04-24' then '9.428686236'
    when date = '2022-05-01' then '9.611156436'
    when date = '2022-05-08' then '9.343048289'
    when date = '2022-05-15' then '8.977471191'
    when date = '2022-05-22' then '9.475137454'
    when date = '2022-05-29' then '10.638047291'
    Run a query to Download Data