roket
The Law Offices of NEAR
Aug 2, 2022 - Q7. Provide your best assessment of the number of smart contracts deployed on NEAR and clearly outline your methodology (after all, contract lawyers love clearly specified terms). Visualize the number of new smart contracts deployed over time over a time period of your choosing. What are the top 5 new smart contracts interacted in that period of your choosing?
What makes a Top Shots moment valuable? (Part I)
Jul 22, 2022 - Create an analysis on NBA Top Shots moments and attempt to uncover any correlations between a specific category and sales volume. This week, focus specifically on the play_type column in the flow.core.dim_topshot_metadata table. What play_types do users hold most, and how much volume in sales do these play_types generate? Include any other transactional metrics you can think of.
Not Your Keys
Nov 17, 2022 - In wake of the issues surrounding FTX, the old adage "not your keys, not your crypto" reinforces itself. Let's see how this played out during the fallout. Did bridge activity spike over the last 7 days? If so, to what ecosystems? At a more granular level, track net outflows from FTX onto Ethereum. Did any of these outflows flow across Satellite to another destination chain?
Flash Bounty: Post Merge Behavior
Sep 25, 2022 - The merge has occurred. How have users responded in days that followed? Analyze any notable trends or outliers you can see since ETH switched to POS. Compare this to user behavior in the days and weeks leading up. What major changes can you see?
Polygon NFT
Jul 16, 2022 - Q3. How popular are NFTs on Polygon? Track daily volume over the past month/year/etc. How many Polygon users started off with NFTs? Who made the most profit?
Stablecoins on Kashi
Jul 13, 2022 - Q102. Analyze the behavior of stablecoins on Kashi markets. Which ones are being deposited for lending? Which ones as collateral? Do this for both polygon and Ethereum. You can use the cross-chain sushi ez_lending and ez_borrowing.
Flow vs Other L1s Pt (II)
Jul 19, 2022 - How does Flow compare to other L1s in terms of user retention? Is a user who has already made a transaction likely to make another transaction a week or a month later? Compare and contrast this type of activity with other L1s like Solana and Ethereum.
NEAR Gas Guzzlers
Jul 24, 2022 - What contracts are users spending the most gas on to use? How has this changed over the past week? Past month? Hint: The gas units in the table are in raw (not decimal adjusted) format. To adjust accordingly, divide by 10^12.
Waiting for Aurory
Jul 20, 2022 - Aurory is one of the most highly anticipated games to come out on any chain. Create a dashboard highlighting wallet trends around both the tokens and NFTs. Does the price of Aurory token has positive correlation with volume of nft sales? How have token staking and nft expedition patterns changed in the bear market? What have wallets been doing with their airdropped NFTs?
Quixotic NFT Dashboard
Aug 3, 2022 - Q7. Create a secondary market dashboard for NFT sales on Quixotic, the largest NFT marketplace on Optimism! Include any data you think is relevant in our Optimism tables and tell us the most interesting trends you can find with the secondary NFT market.
NEAR Performance
Jul 17, 2022 - Q5. How does NEAR stock up to other L1s in terms of speed and performance? How fast is NEAR, and compare it with other blockchain speeds in terms of transactions per minute and percentage of transactions that fail.
Transactions by Protocol
Jul 15, 2022 - Q115. Using the following App ID lists from Folks Finance, AlgoFi, Tinyman, and AlgoDex, lets look at what percent of transactions their app calls and associated transactions(transactions in the same tx_group_id) make up on the Algorand blockchain. How have the number of transactions changed over time for each Protocol? Also how much in fees have been spent on transactions relating to each protocol? Other things that can be explored are what type of transactions are each protocol producing, or has the price of ALGO been an influence on the number of transactions produced by each protocol.
