John_GaltLP Percent 5: EVMOS - 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-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
)