Cosmic Champs Token Launch

    Use the swaps table to look at $COSG and show daily swap to and swap from volume for the asset. Note any trends There is a Yieldly Staking Pool for $COSG (https://app.yieldly.finance/distribution?id=710543830). Show how many stake actions a day are occurring. Plot the staking amounts(the amount of $COGS staked) by day over time on a scatter plot. What types of trends do you see?

    this dashboard will answer to below questions:

    Use the swaps table to look at $COSG and show daily swap to and swap from volume for the asset. Note any trends There is a Yieldly Staking Pool for $COSG (https://app.yieldly.finance/distribution?id=710543830). Show how many stake actions a day are occurring. Plot the staking amounts(the amount of $COGS staked) by day over time on a scatter plot. What types of trends do you see?

    There is a Yieldly Staking Pool for $COSG (https://app.yieldly.finance/distribution?id=710543830). Show how many stake actions a day are occurring.

    first we will query swaps table on flipside database to check swap to and swap from volume for the COSG token and then check for any trends.

    so the chart shows swap to and swap from volume of COSG token.in this chart no time filter has been used and first swaps happened at Apr 20th 2022. in the first days swap to volume is more than swap from volume which probably because it was first release of token and users was keen to buy it.

    Loading...
    Loading...

    total stakes are not so much per day and as we see it is decreasing per day.

    base on given transaction in the bounty, I filtered the transactions to find stakes per day.in the next chart transaction groups are counted which means a user may stake twice in a day and then it counted twice too.

    Loading...

    the next chart shows total amount of COSG staked in Yieldly pool.

    as chart shows and as previous chart showed that first stake happened at Apr 21th, the amounts too are from Apr 21th and on Apr 21th and 22th about 7.7M COSG has been staked. staking amount per day are decreasing and from Apr 23th, day less amounts are staked.