Osmosis

    Trending assets in Osmosis: Skill-building Bounty 14 (Easy)

    Solve bounties that help you level up as an analyst. Join us on our live call on Tuesday, October 4 as we walk through solving this bounty together with you

    Payout
    0
    Level
    Beginner
    Difficulty
    Medium
    Ended

    In this skill building bounty, we’ll take a look at osmosis swaps! 


    In the live call, we’ll go over the swaps and labels table (osmosis.core.fact_swaps and osmosis.core.dim_labels) to recreate a dashboard showcasing the following:

    1. Number of unique traders in the past week 
    2. Number of unique traders all time 
    3. Top 5 trending assets people are buying in the past week in terms of number of transactions 



    Don’t forget to join us for a walkthrough for this bounty in our live SQL sessions on discord on October 4. You can also catch the previous live SQL session recordings on our Youtube channel https://www.youtube.com/watch?v=FF_upt0F8gw&t=2s