keshanHot Contracts on Osmosis
    Updated 2022-07-08
    /*
    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