Nat
NEAR MegaDashboard
Oct 31, 2022 - Here you will find anything you might want to explore or analyse on the NEAR network - enjoy!
The last part of the Journey: Bridging out of the City of Near
Aug 25, 2022 - A thorough analysis on the Rainbow Bridge outflows and next steps after leaving the City of Near.
"Small" LP Actions
Apr 7, 2022 - Q55. What percent of LP adds to each pool are small (<$1k USD)? Is there a relationship between the chain and the proportion of “small” LPs? We're particularly curious to know if chains with low gas fees (like Terra) have a larger proportion of small LPs than chains with high gas fees (like Ethereum). Hint: use thorchain.liquidity_actions
Active Wallets on Terra
May 3, 2022 - Define "Active Wallets" on Terra. Based on your definition, display the active wallets by day, month, and Year-To-Date in 2022.
The beginning of the Journey: Bridging into NEAR
Aug 22, 2022 - A thorough analysis of the Rainbow Bridge.
stETH vs ETH
Jun 7, 2022 - Q2. How has the price of stETH compared to ETH? Are there any events that triggered a big difference in price between the two tokens?
Net $THOR Staked
May 23, 2022 - Q91. Since vTHOR and THOR Staking 2.0 was released in May, we’re interested in finding out more about how the community has embraced the staking rewards.
Daily Transactions and Unique Addresses
Jul 12, 2022 - Q1. Count and plot the number of daily transactions and unique addresses on Polygon, beginning July 1, 2022.
Fifth part of the Journey: The Local Government
Aug 25, 2022 - A thorough analysis on the state of governance on NEAR.
Open Analytics Bounty: Arbitrum
Aug 17, 2022 - Deep dive into what Arbitrum users do by investigating different labels.
Distinct Wallets (Optimism Bridge)
Jun 16, 2022 - Q1. How many distinct wallets have deposited or withdrawn ETH to Optimism via the native bridge in the last 60 days? Visualize your findings.
The Eclipse Score
Apr 27, 2022 - Invent an easy-to use ""Eclipse Score"", based on at least 3 metrics, to display validators who are not effectively representing their delegators via voting. For example: if you participate in only 5% of votes but are in the top 5% of validators by LUNA delegated, you should have a terrible Eclipse Score. Alternatively, if you participate in 5% of votes but are in the bottom 10% of Validators by amount delegated, you're not letting down the community quite as badly, and your score should reflect that (but it still shouldn't be very good; 5% is awful1) Provide a table and at least 1 visual that displays validators according to your Eclipse Score, e.g. a bubble chart with LUNA Delegated vs. Votes Attended. Top Score Worthy: Additionally, analyze the top 5 best and top 5 worst validators according to your Eclipse score. For Insight, provide your analysis or commentary on one, several, or all of these validators.
Open Analytics Vol. II: Environmental Impact Study
Oct 4, 2022 - Recently, we analysed SWEAT - one of the premier projects on NEAR. Do a deep dive into another project on NEAR and analyse its impact, defining metrics for “impact” and displaying them with data.
Top Kashi Pairs III
May 23, 2022 - Q81. Find the top 5 kashi pairs based on: A - The number of loans they have generated B - The total available for lending (in USD) C - Total collateral deposited (in USD)
Distributed Validator Technology
Apr 10, 2022 - Q1. Explain what Distributed Validator Technology (DSV) through the Obol network is and why it might help with decentralization on Ethereum 2.0 or other Proof-of-Stake chains.
Second part of the Journey: The Capital
Aug 25, 2022 - A thorough analysis on the state of Near's Capital.
Yet Another Acme Question
Apr 18, 2022 - Q184. Refer to submissions for #175 - your own, or those of others. Pick your favourite 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 favourite? If you improved it, what changes did you make?
Waiting for Aurory
Jul 19, 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 have a positive correlation with the 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?
Fourth part of the Journey: The Arts District
Aug 24, 2022 - A thorough analysis on the NFTs found on NEAR.
Third part of the Journey: The Financial District
Aug 22, 2022 - A thorough analysis on the DeFi protocols found on NEAR.
IL Insurance
Apr 7, 2022 - Q54. What % of users that are removing liquidity are receiving IL insurance? Hint: use thorchain.liquidity_actions
Sushi's contribution to Polygon growth
May 14, 2022 - Since Sushi-swap introduced polygon, many have adopted polygon to either swap or use other services. With this in mind, what is the contribution of Sushi to the growth of Polygon user base?
NEAR Tournament Round 2: Local Government
Aug 2, 2022 - Every city has its governors, and the City of NEAR is no different. Assess the state of governance on NEAR, with an eye toward assessing its decentralisation.
Optimism: Inflows and Outflows
Sep 10, 2022 - What is the volume of ETH and a stablecoin of your choice that's moved between the Optimism network and the Ethereum network across the bridge? How has that changed over time?
TVL on Solana
May 24, 2022 - Q77. With the market conditions souring over the last few months, how has that affected TVL (total value locked) in defi on Solana? Highlight three projects of your choosing (reference this for the list of top projects by TVL https://defillama.com/chain/Solana) and highlight key metrics and insights on each project to investigate what is influencing shifts in TVL and the number of users over time. What factors in the market or specifically about the projects cause TVL fluctuations?
Celsius and Sushi
Jul 12, 2022 - Q104. Find out what Celsius platform has done on sushi (swaps, lending, LP'ing, farming). Make sure to use cross-chain tables as much as possible to capture data on all chains.
Velodrome Locks
Jul 13, 2022 - Analyse new locks created on Velodrome Finance. Analyse new locks created on Velodrome Finance. What durations are most common? Which wallets have locked the most in the last 4 weeks? Which pools are wallets voting for with their locked tokens most often?
Bridger Destinations
Jul 31, 2022 - Q5. Where do people go when they bridge to Polygon from Ethereum? What are the 10 most popular first destinations for Polygon addresses that have just bridged from Ethereum?
Fuse Pool USDC Allocation
May 23, 2022 - Q2. How are the tokens in the USDC Vault being allocated into the various Fuse Pools?
UST Competitive Advantages
Apr 30, 2022 - Question: Why would a user choose to transact using UST over DAI (and vice versa)?