danhan
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.
$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.
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
$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.
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!).
Total Metamask Users
Jun 23, 2022 - Q1. How many total Metamask wallet holders are there? What’s the average value of ETH held in wallets? What percentage of wallets are engaging in a higher-order activity, like staking?
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?
Distinct Wallets (zkSync)
Jun 16, 2022 - In this dashboard, we want to analyze the number of distinct wallets that have deposited Eth into ZkSync in the last 60 days and we also want to see the amount of their Eth deposited by day.
Flow NFT Wallet Behavior Comparison
Jul 17, 2022 - Create a series of dashboards comparing wallet behavior for buying and selling NFTs on Flow compared to Ethereum and Solana. Is there more or less "whale" activity on Flow compared to each of the other chains?
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?
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?