danhan
Osmosis Scavenger Hunt
Jun 20, 2022 - Overview By the end of this hunt, we did these steps: Send tokens to the Osmosis wallet Swap ATOM for OSMO using Osmosis Stake tokens using Osmosis
Osmosis The Unstakeeeeers
Jul 18, 2022 - How frequently do users on Osmosis un-stake their Osmosis? What do they do with the OSMO once un-staked?
Osmosis Swap Fees
Jun 25, 2022 - Q21. Do fees on Osmosis differ when users swap to or from different tokens? On average, which tokens have the highest and lowest swap fees on Osmosis? --------------- Methodology: First I try to look at the fact_swaps table to find out information about different swaps like from_asset and to_asset and then by joining to fact_transactions table in the condition of the same tx_id I try to find out each swap fee and by grouping swap pairs and getting average from swap fees I could find which pairs have more fees and which of them have less. we also join our findings with the dim_lables table to sort swaps by their labels which is easier to look at.
Hot Contracts on Osmosis
Jul 12, 2022 - Q20. A lot of new contracts are being deployed on Osmosis lately. Since the beginning of May, answer the following questions: What are the top ten most popular contracts on Osmosis? What is the cumulative total of contracts launched on Osmosis, and have there been any spikes since the Terra crash or other noteworthy events?