John_GaltLP Percent 2: JUNO - OSMO
Updated 2022-06-23
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 '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