Nat
Fourth part of the Journey: The Arts District
Aug 24, 2022 - A thorough analysis on the NFTs found on 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
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.
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.
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?
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)
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.
The beginning of the Journey: Bridging into NEAR
Aug 22, 2022 - A thorough analysis of the Rainbow Bridge.
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.
Fifth part of the Journey: The Local Government
Aug 25, 2022 - A thorough analysis on the state of governance on NEAR.
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.
NEAR MegaDashboard
Oct 31, 2022 - Here you will find anything you might want to explore or analyse on the NEAR network - enjoy!
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?
Second part of the Journey: The Capital
Aug 25, 2022 - A thorough analysis on the state of Near's Capital.
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?
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.
IL Insurance
Apr 7, 2022 - Q54. What % of users that are removing liquidity are receiving IL insurance? Hint: use thorchain.liquidity_actions
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.
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?
Third part of the Journey: The Financial District
Aug 22, 2022 - A thorough analysis on the DeFi protocols found on NEAR.
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.
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)?
LUNA & Drawdowns
Apr 13, 2022 - Q180. Evaluate the price performance of LUNA following liquidation-inducing drawdowns. What is the average time (days) for LUNA to recover its previous price level. How does this period change relative to the size of the drawdown (in percentage terms)?
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?
Transactional Nature
Mar 25, 2022 - Q171. In your own words, briefly explain how UST transaction volume relates to fees paid to stakers. Then, create a graph to show the fees derived from UST transactions and native swaps.
Successful Bids on Kujira
Apr 11, 2022 - Q178. 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?
Distinct Wallets (zkSync)
Jun 14, 2022 - Q1. How many distinct wallets have deposited ETH into ZkSync in the last 60 days? How much ETH was deposited by day? Visualize both.