Standardized TVL
May 18, 2022 - Traditional TVL metrics are imperfect because they are influenced by both the quantity and price of the tokens over time. We would like to see a version of this metric that abstracts out the price influence on this metric.
RocketPool vs. Lido
May 23, 2022 - RocketPool is a decentralized ETH2 Staking application. Using RocketPool, users can either stake ETH or stake ETH and run a node. Users deposit ETH and mint rETH tokens. For users only interested in staking, the minimum deposit is 0.01 ETH and the rETH tokens are liquid. For users interested in running a node and staking, the minimum deposit is 16 ETH, but better rewards are received. For more information, please see rocketpool.net Lido is another application that also offers ETH2 liquid staking. Compare and contrast activity on RocketPool vs. Lido over the past three months. Is one growing more quickly than the other? Can we conclude if one of these applications is better for users than the other? Are there different types of users using RocketPool compared to Lido, or are the user profiles similar? Visualize and explain your conclusions. Hint: - Lido sETH contract: https://etherscan.io/txs?a=0xae7ab96520de3a18e5e111b5eaab095312d7fe84
Acquiring goBTC and goETH
May 16, 2022 - Where are users acquiring goBTC and goETH? Are they acquiring the assets by swapping or by minting? Has this changed over time? Explain the insights you find.
Flipside Label Coverage Estimator
May 5, 2023 - We are estimating coverage for some label types where it makes sense to do so: these addresses reflect patterns consistent with the type of address we are labeling (e.g. a contract that is engaging in an event akin to a swap, but for which we do not know the protocol or operator responsible for its deployment). However, coverage estimates for many label types are not feasible because they reflect only truths that are reported via project documentation, or have small N. Examples of these include L2 addresses, dapps (that don't fit into a standard defi bucket), centralized exchanges, operators, and known garbage or spam addresses that we label as flotsam.Use the parameter below to toggle between chains. Parameter only applies to EVM chains.
Solana NFT Megadash
Feb 27, 2023 - One-stop shop for all your NFT research! grouping = {hour, day, week, month} start_date/end_date = {YYYY-MM-DD} Select your Collection from the dropdown - or search for it! Dropdown only works if the search is blank
How Relevant is Justin Sun?
May 17, 2022 - Justin Sun has recently announced an algorithmic stablecoin, USDD, with 30% yield. Sun has announced plans to backstop USDD with $10B of crypto as collateral, matching the Luna Foundation Guard (LFG). Do a deep dive, conduct research, and provide a well-researched conclusion to the burning questions: is Justin Sun for real? Is USDD likely to accrue significant backing? How will its 30% offering fare over time?
Flipside Label Adding Tracker
Oct 10, 2023 - Tracks quantity of labels added to Flipside by each of our major sources: Manual, Autolabelling, and deposit wallet algorithm
Degods Bridge Analysis
Apr 6, 2023 - Lets take a look at how key metrics have changed for Degods as they bridged over to ETH
MonkeDAO Voting Break-Down
May 13, 2022 - Q51. Extension off the MonkeDAO question last week: A month ago, the MonkeDAO pressed the Solana Monkey Business team for various changes to be made to the royalty and NFT structure to foster growth for the collection. Ultimately this resulted in the first NFT on-chain vote on Solana to accept or reject the SMB team's proposal, with a 'no' likely resulting in a separation of the two groups. In the end, the MonkeDAO voted to unify with the SMB team and to grow their relationship together. Break down the voting behavior for the first three proposals by the following number of monkes per wallet (1 SMB, 2-3 SMBs, 4+ SMBs). Are there any patterns that you see based on number of SMBs used to vote in a wallet? Why do you think ""whales"" voted the way that they did? Background info: https://decrypt.co/93193/solana-monkey-business-monkedao-battling-over-future Hint: Voting programId : Daovoteq2Y28gJyme6TNUXT9TxXrePiouFuHezkiozci Sample tx of a vote for question 1 (Accept SMB proposal) https://solscan.io/tx/5pTUfdXkHfG8WQhThmYW6fkVpp6oheTZRrLYD3mhANJ86XrkV75AQ8HNuj8CasHVrGHXGaep9nsNM4dTaVpYX4AB Sample tx of a vote for question 2 (If vote 1 was not passed, should vote 1 not succeed, should MonkeDAO membership change from holding a SMB to a NFT issued by MonkeDAO?) https://solscan.io/tx/3B8BRtfSskcRHb2jsQieUUpMXZUAxLZbHzYhd64PBAgJxzdgBVaHBqUdMcMVK3SytJmWHZbfSy4BZbF6MbUsQccT Sample tx of a vote for question 3 (If vote 2 succeeds, what should be the access mechanism for the DAO be?= - airdrop or entanglement? https://solscan.io/tx/GUapUn8FmTqmxkZ9RLtK4WZzhkDSEyYxApBK9r6r1F2wTHcJWfL35xav3qogvBv8EFTz4GX6C3Z1TQaiQB5byPc Overall Voting Results for the first 3 questions: Question 1: Yes (1483) No (64) Question 2: Yes (361) No (181) Question 3: Airdrop (262) Entangle (191) Sample query of a count of all votes: SELECT instructions[0]:accounts[6] AS acct_6 , instructions[0]:data AS data , COUNT(1) AS n , SUM(ARRAY_SIZE(inner_instructions)) AS total_votes FROM solana.fact_transactions WHERE block_timestamp <= '2022-03-05' AND block_timestamp >= '2022-02-15' AND succeeded = 'True' AND instructions[0]:programId = 'Daovoteq2Y28gJyme6TNUXT9TxXrePiouFuHezkiozci' GROUP BY 1, 2 Hint: need to count total votes as shown in sample as you can have more than 1 vote per transaction Hint: You will need to link the last Acct_6 with the data (can reference voting results for confirmation) to map out questions and answers. Hint: use solana.fact_nft_sales and solana.dim_nft_metadata Hint: SMB marketplace program Id: J7RagMKwSD5zJSbRQZU56ypHUtux8LRDkUpAPSKH4WPp Hint: Also need Magic Eden marketplace program Id: M2mx93ekt1fmXSVkTrUL9xVFHkmME8HTUi5Cyc5aF7K
