0xHaM-d
Successful Bids on Kujira -Terra Bounties-
Apr 13, 2022 - Q179. Determine the total unique users placing bids on Kujira since its inception. Compare bids on bLUNA vs bETH. What portion of these users are seeing their bids filled?
Sushiswap DEX Loyal Users
May 11, 2022 - Q77. Rank wallets that used SushiSwap based on the number of trades and number of days they used the DEX. How many users keep coming back to the platform ? Use different frequencies for the ranking : Last month, Year to date and since inception
Crossover with NBA Top Shot
Jun 15, 2022 - Q9. Which Flow NFT projects appear to have the most crossover of buyers with NBA Top Shot addresses?
Forefront Participation Incentives (Forefront Bounties)
Apr 16, 2022 - Q4. Compare the incentives for participating in Forefront with at least two other social tokens/DAOs of your choice citing two metrics of your choice.
Votes, Votes, Votes - Terraa
Apr 25, 2022 - Q185. On average, how much voting power (in Luna) was used to vote 'YES' for governance proposals? Out of this, how much Luna comes from validators vs regular wallets?
Governance Period 2 Payouts (Algorand Bounties)
Apr 14, 2022 - Q49. Let's look at the Algorand Period 2 Governance Rewards Payouts
Fuse Pool Analysis
May 25, 2022 - Q3. Are the DAI and USDC Vaults using the same Fuse Pools to seek yield? What differences can you identify? USDC payout will be in the ETH network.
Seedclub Members
Mar 19, 2022 - Question 1: How many members have joined the Seedclub? And How many projects have successfully launched and received their CLUB tokens?
Governance Reaction to Terra
May 24, 2022 - The period between May 8th - May 13th was a busy week for Osmosis governance. What was the community response like to these proposals? How quickly did these proposals hit quorum compared to the last two months of proposals? What was the voter turnout for these proposals vs the last two months of proposals?
Tinyman Dex Popularity (Algorand Bounties)
Mar 21, 2022 - Q36. Tinyman was Algorand’s first DEX(decentralized exchange) and in 2022 we’ve seen the launch of three other DEXes: pactFi, algoFi, and Wagmiswap. Let’s look at the launch of these other DEXes and see how they have impacted the number of swaps on Tinyman.
2023-04-18 12:26 PM
Apr 18, 2023 - key insights: 1- The count of active users on contracts and dApps has generally decreased over the past 12 months, but certain platforms have experienced spikes in user count during specific time periods. 2- Stargate Finance and Step App were the dApps that experienced the most significant growth in active user count, while Avalanche was the chain with the highest number of active users overall. 3- The majority of active users on both contracts and dApps have had less than 10 transactions, indicating that most users tend to have minimal interactions with these platforms. 4- The most popular contracts and dApps with active users are constantly changing, so it's important to regularly monitor user activity and identify which platforms are experiencing growth. Additional metrics such as average active users and new active users can provide further insights into which platforms are growing in popularity.
USDC Transfer Volumes (Algorand Bounties)
Apr 12, 2022 - Q51. Compare USDC transfer volumes on Algorand, Solana, Ethereum in 2022.
Who's That Going Across My Bridge (Redux) (Terra Bounties)
Apr 22, 2022 - Q186. Pick one bridge from Terra and a destination of your choice. (e.g. Shuttle bridge Terra <-> Ethereum or Wormhole Terra <-> Solana). Assess the daily and cumulative amount of UST that goes through that bridge, both inflow and outflow. How many users are using the bridge on a daily basis? How many transactions take place on a daily basis?
HODL or Sell?
Jun 15, 2022 - Q11. Identify accounts that have staked ETH with Lido when the price of ETH was much higher or much lower than it is now. Have they held or sold their stETH?
Volume Scoring with NBA Top Shot
Jun 7, 2022 - Q5. NBA Top Shot allows users to buy, sell, and collect NBA NFTs that showcase influential “Moments” minted on the FLOW blockchain. Create a visualization tracking the total sales volume traded on NBA Top Shot since May 9th by day. How many unique wallets have made a trade on Top Shot over that timeframe? How do those metrics compare to sales volume and unique users of Magic Eden on Solana and OpenSea on Ethereum?
Moonbirds Mint Distribution (Moonbirds Bounties)
Apr 21, 2022 - Q5. What was the mint distribution of the Dutch Auction? Plot the distribution at various price points and/or the mints over time with the cost. Use the Ethereum_core schema. Hint: https://etherscan.io/address/0x23581767a106ae21c074b2276d25e5c3e136a68b
Orca User Growth
May 25, 2022 - Q76. Orca, a popular decentralized exchange on Solana seems to have been gaining significant adoptions over the last few months, especially compared to other exchanges. Create a visualization showing Orca adoption in terms of swap volume and number of unique wallets compared to at least two other popular Solana exchanges and Uniswap on Ethereum? What can explain this increase in adoption? Provide some insights on this trend and the types of users using Orca (hint look into which popular app on Solana is using Orca).
Sablier Cash Streams (Hot on ETH Week Day 2)
Apr 21, 2022 - Q9. Out of all streams of cash created on Sablier, how many have been cancelled before their stop time?
Yet Another Acme Question
Apr 26, 2022 - Q184. Refer to submissions for #175 - your own, or those of others. Pick your favorite Terra metric or visualization and recreate your own version. Your SQL can be similar or even identical to the original, but you should put your own narrative and explanation. Why is this metric/visualization your favorite? If you improved it, what changes did you make?
Synth Mints + Burns (THORChain Bounties)
Apr 12, 2022 - Show the minting + burning of synthetic assets over time.