John_GaltLP Percent 1: ATOM - OSMO
Updated 2022-06-21
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
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