keshanHot Contracts on Osmosis
Updated 2022-07-08
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
⌄
/*
Since the beginning of May, answer the following questions:
1. What are the top ten most popular contracts on Osmosis?
2. What is the cumulative total of contracts launched on Osmosis,
3. and have there been any spikes since the Terra crash
4. or other noteworthy events?
*/
--select * from osmosis.core.fact_msg_attributes where msg_type='pool_created' limit 10
select block_timestamp::date as date, count(distinct attribute_value)
from osmosis.core.fact_msg_attributes
where block_timestamp::date >= '2022-5-1' and
msg_type='pool_created' group by 1