Osmo-7.In The Stars

    -- 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.

    Methodology

    • Find all the swap transactions by filtering out attribute_value ilike '%ibc/987C17B11ABC2B20019178ACE62929FE9840202CE79498E29FE8E5CB02B7C0A4' -- Stargaze Token
    • The attribute_key tells us if the token was swapped from or swapped to, we consider the volume as combined value of both.
    • 04:00 PM EST is 09:00 PM UTC.

    Swap Volume To and From Since 20 Mar, 2022.

    • Here is the hourly swap volume and swap frequency to and from Stargaze token since Mar 20, 2022.
    • Some of the times when a high swap volume was seen were 02 Feb, 2022 10 AM UTC which saw 6.2M Stargaze tokens swapped into from other tokens.
    • Other notable times of swap are 29 Apr, 2022, 07 PM UTC when we saw 2.4M swapped to stargaze tokens and 2.72M swapped from stargaze tokens.
    Loading...
    Loading...
    Loading...

    Does the volume of swaps involving Stars change around 04 PM EST?

    • The data doesn't show any particular change in volume around 04 PM EST, but Friday is the day with second highest swap volume after Wednesday with 70M and 73M respectively.
    • Looking at the Scatter Plot, Friday has swap volume distributed all over the day, instead of specific hours.
    Loading...
    db_img