What question wants??

Q7. Stargaze Zone is an IBC NFT launchpad and marketplace, and new launchpad projects drop on mint every Friday at 4:00 PM EST. Does the volume of swaps involving Stars change around this time? Analyze the volume of swaps involving STARS from March 20th until present.

Hint: Use the msg_attributes table and select transactions that have an appropriate msg_type for swaps. The token address for STARS and other tokens can be found by joining to the labels table.

What is Stargaze Zone?

Stargaze is a sociable ecosystem from chastely crypto-native projects. The sociable chart is established on ownership of tokens. Content, including profile avatars, are NFTs. And curation and moderation are done by DAOs.

The native token of this project is STARS.

Stargaze is built as a proof-of-stake Cosmos zone, giving it maximum flexibility in protocol design, interoperability, and scalability right out of the gate. The governance-driven development process of Cosmos chains allows rapid development and iteration required for a consumer social protocol. Furthermore, due to IBC and Gravity Bridge, it can interoperate with every other blockchain, including Terra, and Ethereum and its L2s Reference.

Approach:

According to the question, on Stargate zone the new projects drop on mint every Friday at 16:00. Based on this consideration, the volume size of STARS token swap has been evaluated and investigated on the launch time of projects.

The methodology contains the following steps:

• Swap analyze

    from osmosis.core.fact_msg_attributes
    where MSG_TYPE='token_swapped'
  

• STARS token

    Address='ibc/987C17B11ABC2B20019178ACE62929FE9840202CE79498E29FE8E5CB02B7C0A4'
  

• Time period

    BLOCK_TIMESTAMP between '2022-05-20 14:00:00' and '2022-05-20 18:00:00' Friday
    
    BLOCK_TIMESTAMP between '2022-05-27 14:00:00' and '2022-05-27 18:00:00' Friday
   
    This consideration has been used to analyze the 2 hours before and after launch time.
  

Results:

The daily analysis has been illustrated in this chart. We know that May 20th and 27th are Friday.

According to the consideration on Approach section, it shown that right before the launch time of mints on Friday 16:00, the swap sizes have been increased accordingly.

The hourly analysis verified it by the demonstration of peak points of STARS swap.

Also, it can be seen that after launch time of projects on May 27th, The swap volume has been increased immediately.