brian-terra
30. WETH Owed
Jun 16, 2021 - Using uniswapv3.pools and uniswapv3.positions, we take a look at the largest amounts of WETH owed for all three WETH-USDT pools. I have broken down my results into 2 parts: Data - Largest Amount of WETH Owed Chart - Largest Amount of WETH Owed And for all 3 separate pools, the most WETH owed for positions are the following: WETH-USDT 10000 200: 2.30 WETH WETH-USDT 3000 60: 8.03 WETH WETH-USDT 500 10: 0.13 WETH With WETH-USDT 3000 60 owing the most and WETH-USDT 500 10 owing the least.
30. Self-Validating
Jul 28, 2021 - For the top 5 validators, what percent of the LUNA that they hold is their own as opposed to delegated to them? Has this proportion changed over time?
Total Number of ETH Transactions $1k vs $1m
Jun 4, 2021 - Additional metrics regarding ETH transactions $1k or less VS $1million or more.
32. ETH Price Drop and Liquidity Pools
Jun 28, 2021 - For this dashboard, I used uniswapv3.lp_actions to calculate the daily number of LPs increasing and decreasing their positions in relation to any ETH pool. You can see below that prior to the drop below $2k and even during, LPs increased their positions. For the USD amounts for these increases/decreases, we can see that just yesterday and today there has been a substantial increase in the total volume of USD flowing through positions. While during June 19th (the dopr below 2k), LPs still increased their positions overall. While on the 20th, they decreased their positions.
LunaBulls - Iced Out - All Traits
Jan 18, 2022 - This dashboard displays the breakdown of all traits held by Iced Out bulls.
28. Increase/Decrease Liquidity Frequency
Jun 15, 2021 - Using uniswapv3.lp_actions, we take a look at the total number of times distinct wallets increased and decreased liquidity in the past 7 days. I have broken down my results into 4 parts: Total Data - Liquidity Change Frequency - Last 7 days Total Number Chart - Liquidity Change Frequency - Last 7 days Daily Liquidity Change Frequency - Last 7 days Hourly Liquidity Change Frequency - Last 7 days We can see a few significant changes in the hourly on June 15th where LPs increased their positions, but overall it remains fairly consistent.
Uniswap Grant Program v3 - Analytics Dashboard
May 28, 2021 - This dashboard investigates a wide range of Uniswap analytics. Including top-ranking pools/swap, total liquidity transactions and swap transactions - broken down by token, totals, and daily/hourly increments.
46. What happened to leveraged borrowers with the crashes?
Jun 15, 2021 - Taking a look at liquidations over time for Compound. Scary stuff - especially with the recent crash! First I put together the two charts you see below: Liquidations Over Time by Token (since 5-1-2021) - Daily Chart Total Liquidations Over Time (since 5-1-2021) - Daily Chart You can clearly see how significant the crash was on May 19th. In order to determine if this has ever happened in the past and what trends could be drawn from it, I had to take a look further back in time. I created two additional charts on the following: Liquidations Over Time by Token (for all time) Total Liquidations Over Time (for all time) Here you can clearly see that for this timeline of data, no liquidation has ever occurred at the levels that occured on May 18th, 2021.Even 4 days later, on May 22nd there was a second round of liquidations that really crushed a large majority of people that I am assuming "bought the dip". There were a few other rounds of liquidations that occurred on these dates: November 25th, 2020 January 10th, 2021 February 22nd, 2021 But these are still dwarfed by the magnitude of the most recent crash on May 18th and May 22nd. ADDED - USD Value for Liquidations Charts. Wanted to see USD values as well. *****Changes made - The USD Value for liquidations amounts on earlier crashes actually exceeds the most recent crash! This is new information! This tells me that most recently, the number of liquidations is higher because people are beginning to DIVERSIFY! They have their money more widespread into different tokens, thus reducing the chance that all their positions will be liquidated. I suspect that they will continue to diversify into more and more tokens. Of course if the entire market crashes, the majority will still liquidate but people are still spreading their eggs into many different baskets as time goes on!***** The fact that there were opportunities for this amount of liquidations, tells me that people are continuing to buy the dips all along the way. If you looked at the November liquidations back then, you would have thought that that was the worst round of liquidations ever seen. But as we could see in May, there were still a lot more to be had. This tells me that there still may be more to be had. If this bull run in all of crypto continues, we may see people continuing to buy this dip only for another steep drop and even larger round of liquidations happening. Time will tell! I also included a chart of total liquidations since May 1st for additional info. Neat metric.
19. Active Liquidity
Jun 2, 2021 - Objective: Find the 5 largest liquidity pools in Uniswap V3. What percentage of positions and what percentage of virtual liquidity (liquidity_adjusted) are currently out of range? When this occurs which is the approach most taken: updating the range or waiting it out. - It seems as though for the extreme DAI/USDC/USDT relationships, that the only option is waiting it out. Conclusion: The only two pools that were considered to be "out of range" by my calculations where DAI-USDC 500 10 and USDC-USDT 500 10. I define pools that are "out of range" to be positions where the liquidity adjusted is greater than gross liquidity. These percentages are fairly negligible, but can be calculated to be the following: With 129,584 (USDC-USDT 500 10) positions, 91 positions would be .07% out of range. With 97,541 (DAI-USDC 500 10) positions, 103 positions would be .106% out of range. Finally, I compared the total sum of position liquidities vs the gross liquidity for each pool, and got the following results: Position Liquidity vs Gross Liquidity DAI-USDC 500 10 - 129,962% USDC-USDT 500 10 - 97,879% USDC-WETH 3000 60 - 18.10% WETH-USDT 3000 60 - 10.57% WBTC-WETH 3000 60 - 0.09% Really interesting to see the DAI/USDC/USDT relationships SIGNIFICANTLY outweighing the WETH and WBTC relationships. Not super surprising given the lower-risk potential there, but still amazing to see it written in the data. Please take a look at all of the data below for my references.
8. Whale Spotting
Jul 3, 2021 - In this dashboard we use terra.swaps and terra.staking to take a look at a select group of addresses with swaps + stakings positions that are valued at 1 million USD or more. The first part of this dashboard I queried terra.swaps to determine who has swaps greater than 1 million USD. There are only 7 unique addresses with swaps greater than 1 million USD. Using a substring of the address, I found the following results: (look at Whale Spotting - swaps w/ fees paid) One address has the most swaps with 59 swaps greater than 1 million USD. This address has paid ~2.49million USD in swap fees. I took those 7 unique addresses and wanted to see how many of them have staking positions greater than 1 million USD. Only 3 of the 7 have had staking positions greater than 1 million USD. terra1vz0k2glwuhzw3yjau0su5ejk3q9z2zj4ess86s terra1ujx3r76xqylazwwdr3eywas2tfzm2n68a368w9 terra1ezyh02ehmma2g37zlvhymlm5mnw3w5yw7vklaf These 3 address have all had staking positions greater than 1 million USD. If I ignore the 7 specific addresses and look at staking alone, there are 192 addresses with staking positions greater than 1 million USD. Of those 192, I looked at the top 10 and created a chart with their respective ranks.
60. [Easy] Average Trade Sizes
Sep 8, 2021 - What are the average trade sizes across the top 5 assets by volume traded with native Terra swaps currently? Hint: Use the terra.swaps table to find all native swaps
39. Compound Governance Dashboard
May 26, 2021 - Breaking down Compound votes/voters by proposal. Votes for vs votes not for. Votes for meaning in favor of, and votes not for meaning either against or abstain. (There was a change in syntax from "true/false" votes to "0/1/2" votes, so I had to group false, 0 and 2 votes. 1 votes are in favor of. Data Queried Below Chart - Number of Voters by Proposal - For vs Not For Chart - Number of Votes by Proposal - For vs Not For
46. [Easy] Bonded vs. Unbonded LUNA Board
Aug 18, 2021 - Compare the quantity of Bonded Luna to unbonded Luna. Visualize the changes in each over a time period of your choice, and provide a quick explanation of the insights or significance: what can we learn from the ratio of bLUNA to LUNA?
15. Concentration of Liquidity
May 26, 2021 - Graphic representations of liquidity changes during current bear market. Compared deposits vs withdrawals on the daily and hour time scales. Looking at May 15th to present. Notice how May 19th there were a lot more withdrawals vs deposits, which is certainly telling of the market that day. It seems to be recovering fine and deposits are back up again.
31. Voting Power Distribution
Jun 28, 2021 - For this dashboard, I used ethereum.events_emitted to query the uniswap governance voting power data. There is only data as recent at 6/17/2021, so I provided 2 charts + datasets. For the first, we look at getdate() - interval '30 days' and for the 2nd one, we look at the last 30 days where uniswap voting data existed.
32. [Easy] Anchor Deposits
Aug 4, 2021 - How have deposits on Anchor changed in the past 2 weeks? Why do you think this is?
Top Anchor Users: Part 1
Dec 22, 2021 - Explore the power users of the Anchor Protocol. Define “power user” according to at least two metrics of your choice, and analyze Anchor users based on these metrics. Are they retail investors? Whales? Do they transact regularly or infrequently? What conclusions can we draw from your explorations?
3. [Hard] Angel - Validator Rewards
Dec 24, 2021 - Assess the US dollar value of rewards generated from the Angel Protocol validator, over time and cumulative. Provide your assessment of the donations sent from Angel's validator, and forecast what additional validator-driven donations might look like over the next year.
5. Galactic Punks
Nov 10, 2021 - How much UST has been deposited into the lottery since it’s inception? What has been the average UST deposit amount?
1 of 2 - Terra Airdrops - Total Claimed
Jul 21, 2021 - What's going with airdrops? Do an analysis of what is happening to air drops from Terra based projects (ex. Anchor, Mirror, etc) - for example, are they being staked? Traded on a centralized exchange?
Geometry Runners Features
Aug 29, 2021 - I recreated a large majority of the Features listed on https://rarity.guide/project/138
27. UST Dominance
Jul 28, 2021 - What percentage of the number of swap transactions and swap volume magnitude does UST makes up on TerraSwap compared to native swaps (i.e. swaps in ANC-UST for UST)? How has this changed over time?
Can we trace the Bitcoin?
May 14, 2022 - Find and observe BTC trading data and correlate it to de-pegging events since Friday, May 6. Is it possible to observe unusual patterns of short positions for BTC or UST? Compare and contrast to the Black Wednesday attack. What was similar? What was different?
35. Simple vs Complex Swaps
Jul 14, 2021 - The largest pools on Uniswap are frequently used to facilitate swaps between tokens in relatively small pools. For example, swapping USDC for SUSHI actually swaps USDC to USDT and USDT to SUSHI. For the three largest pools, calculate what proportion of swap transactions are "simple" swaps of the two tokens in the pool, vs. "complex" swaps of multiple tokens.
24. Community Treasury
Jul 21, 2021 - Where in the world is the Terra community treasury address? What are some likely contenders and why?
26. Unique Users
Jul 28, 2021 - How many unique new users have been onboarding to Terra per day? How has this changed? What has been the largest event, project, or initiative that Terra has released so far in terms of how many unique new users joined that day? https://amusing-sky-b53.notion.site/Terra-New-User-Activity-968c66bc25df4783ac687490141631e2
Astroport/Terraswap/Loop DEX - Bracketed Trades
Mar 31, 2022 - This dashboard displays the total number of trades performed on Astroport, Terraswap, and Loop DEXs. The only assets that are listed on this dashboard include: LUNA, ANC, MIR, LOOP, PRISM, and bLUNA.
102. [Elite] Burn, Baby, Burn (Elite Edition)
Nov 24, 2021 - In this dashboard, we will investigate the results of the latest LUNA burn. Proposals 133 + 134
101. [Elite] Crypto-Cosmology, Part 1: Wormhole
Nov 24, 2021 - This dashboard will investigate a few of the Terra wormhole usages post Columbus 5.
18. Anchor Repayments
Jul 14, 2021 - Using terra.msgs to calculate the total USD borrowed, repaid, and total debt in the Anchor market.
Levana NFT Trading - Impact Analysis
Jan 23, 2022 - "Who are the largest traders by dollar-denominated volume & by frequency of trades? Is it possible to identify their motives?"
Iced Out Bulls - Sales/Volume Basics
Apr 6, 2022 - Ignore tokenid in the "Iced Out Sales" csv - I had to substring it to get the data to match up quickly/crudely, I will bring in the real/full token id eventually if it's needed. For now you can pull it from the tx_id in finder.
23. Tax Rate
Jul 21, 2021 - - How has the tax rate changed over the past 10 epochs (weeks)? -What dynamics in the other macroeconomic factors in Terra including Seignorage Rewards and Total Staked Luna may have informed these changes? (Resource: https://docs.terra.money/dev/spec-treasury.html#observed-indicators)