danhan
Arbitrum Scavenger Hunt: Odyssey Pt. 1
Jun 26, 2022 - Arbitrum has announced the Odyssey initiative to invite users to explore the Arbitrum ecosystem. Users that participate stand to receive exclusive NFTs (and possibly ~fingers crossed~ an airdrop at some point!).
NEAR Scavenger Hunt
Jul 12, 2022 - In this dashboard I by following some steps to get familiar with near network
Optimism Scavenger Hunt (June 14)
Jun 15, 2022 - Used these three Steps to do : Bridge from Polygon to Optimism Swap to Snx by using Uniswap on Optimism Stake Snx
Applications on Algorand
Jun 30, 2022 - Q108. How have the number of application calls changed in the first 6 months of 2022 compared to the last 6 months of 2021?
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?
Bridge Volume (Hop Protocol)
Jun 21, 2022 - Q2. How much volume has Hop bridged to Polygon, Optimism, and Arbitrum compared to those protocols’ native bridges? What is Hop’s total TVL? Create an analysis on the Hop’s TVL and how it’s changed over a time period of your choosing.
NBA Playoff Usage
Jun 26, 2022 - Q.15 Analyze the start of the NBA playoffs (mid-April) and determine whether it had an impact on Flow transaction volume. What about NBA Top Shots? ----------------------------- Methodology: First based on NBA playoff match plans I categorize transactions to 3 parts(before playoff ends, playoff ends day, and after playoff ends) I use the fact_transactions table for that, then by using the fact_nft_sales table and the contract of NBA Topshot NFT and based on the game plan I try to find out how much NFT sold out in different stages of the playoff game.
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.
$RUNE Movement from Crypto.com
Jun 21, 2022 - Q104. In this dashboard, I show the in + outflow from cryto.com to native wallets over time. We checked to see if there was a trend.
$RUNE Upgrades
Jun 27, 2022 - Q.107 There has been a big push for users to upgrade their ETH.RUNE + BNB.RUNE -> native RUNE, as the wrapped versions will be depreciated.
Pooly NFT
Jun 19, 2022 - Q2. How many Pooly NFTs have been minted thus far, and by how many unique wallets? How many Pooly NFTs does the average collector hold?
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?