brian-terra
33. Voting Behavior
Jul 7, 2021 - In this dashboard, we use ethereum.events_emitted to take a look at the voting behaviors of the top 5 addresses that have had tokens delegated to them for voting. After determining the top 5 (see data below) I assigned each of them a rank 1 through 5. 1 - 0x2b1ad6184a6b0fac06bd225ed37c2abc04415ff4 2 - 0xe02457a1459b6c49469bf658d4fe345c636326bf 3 - 0xbbf3f1421d886e9b2c5d716b5192ac998af2012c 4 - 0x6626593c237f530d15ae9980a95ef938ac15c35c 5 - 0x61c8d4e4be6477bb49791540ff297ef30eaa01c2 Then I created a chart to investigate their respective voting behaviors and found the following information. Rank 1 voted on three different proposals. They casted approximately 15 Million votes each towards proposal IDs 1, 3, and 4. Rank 2 had no votes cast towards any proposal. I did not find any voting participation at all. Rank 3 voted with approximately 13.38 million votes towards proposal ID 3. Rank 4 had the greatest variety and involvement in an array of proposals. Approximately 10.67 million votes towards proposal ID 1. Then ~126k votes towards each proposals 31, 35, 36, 37, 38, 39, 40, 42, 43, 44, 45, 46, 47, and 49. Rank 5 voted with approximately 10.45 million votes each towards proposal IDs 1, 4 and 5. They also designated 50k votes each towards proposal IDs 42 and 43. In the last month, each rank 1, 4 and 5 have been active. Rank 3 has not been active since 12/23/2021, while 2 seems to have never voted.
23. Gas fees on failed Ethereum transactions
Jun 14, 2021 - What an awesome metric to study! I'm proud of this one :D This dashboard contains the following data/charts: Ethereum Average Gas Fees - Success vs Failed - Percentages (90 days - daily) Failed Gas Fees - Percentages (90 days - daily) Ethereum Average Gas Fees - Success vs Failed - Percentages (30 days - daily) Failed Gas Fees - Percentages (30 days - daily) Ethereum Average Gas Fees - Success vs Failed - Percentages (7 days - hourly) Failed Gas Fees - Percentages (7 days - hourly) These two charts + datasets are generated by calculating the total number of transactions (succeeded + failed) and then multiplying it by the average price for the hour or day, respectively. Conclusion **After reviewing this data, there has been no significant change in the past 7 days or 30 days, but on the 90 day trend we see there has been a continual increase in fees given for failed transactions.** I have also included some charts of the total number of successful vs failed transactions at the bottom of this dashboard. Not as significant because it doesn't account for the fees themselves, but it is interesting to note the total number of failed transactions vs successful. Note the one hour - June12th 10:00 that failed transactions exceeded successful. This is the only time that occurred.
Keypom.xyz Stats Dashboard
Aug 8, 2023 - Currently for 'create_account_and_claim' only. Claims where they create a new wallet at the same time as the claim. Working on adding other claims as well. (therefore NEAR unclaimed will be off because I need to add the other claims on there)
3. Transaction Fees
Jun 28, 2021 - Here I use terra.swaps to compare the total daily fees for each terra stablecoin. It is clear to see that UST produces the largest amount of transaction fees. There is a large spike of fees paid on June 17th for UST, but not for the other stablecoins. If we take away UST (see the 2nd chart below) you can see that the fees paid is a lot closer between the stablecoins. The top 3 after UST seem to be KRT, MNT and SDT - with the remaining stablecoins looking to be fairly negligible in comparison.
3. [Hard] Opensea Fees
Aug 25, 2021 - Find the wallet that collects Opensea fees. Make a dashboard showing how much Opensea has earned through Polygon transactions. Show fees earned in USD total, and also by token amounts. Also show the top 10 NFT’s generating fees for Opensea on Polygon.
23. Gas Fees on Failed Uniswap Transactions
Jun 15, 2021 - What an awesome metric to study! I'm proud of this one :D Very little difference between all ETH and only Uniswap. This dashboard contains the following data/charts: Uniswap Average Gas Fees - Success vs Failed - Percentages (90 days - daily) Failed Gas Fees - Percentages (90 days - daily) Uniswap Average Gas Fees - Success vs Failed - Percentages (30 days - daily) Failed Gas Fees - Percentages (30 days - daily) Uniswap Average Gas Fees - Success vs Failed - Percentages (7 days - hourly) Failed Gas Fees - Percentages (7 days - hourly) These two charts + datasets are generated by calculating the total number of transactions (succeeded + failed) and then multiplying it by the average price for the hour or day, respectively. Conclusion **After reviewing this data, there has been no significant change in the past 7 days or 30 days, but on the 90 day trend we see there has been a continual increase in fees given for failed transactions.** I have also included some charts of the total number of successful vs failed transactions at the bottom of this dashboard. Not as significant because it doesn't account for the fees themselves, but it is interesting to note the total number of failed transactions vs successful. Note the one hour - June12th 10:00 that failed transactions exceeded successful. This is the only time that occurred.
14. Whale Activity
May 28, 2021 - Investigating uniswap whale activity via total transaction volume based liquidity movements. Also taking a look at total transaction/swap volume. Comparing total transaction volume, increasing/decreasing positions, and swaps. Using only data after 5/15/2021 to specifically target the recent drop. Defining "whale" activity as any transaction/swap with a value of $100k USD or more. 6 charts total, broken down by the following: Total $100k+ liquidity increase/decrease transactions, daily and hourly breakdowns. (2 bar charts) Total $100k+ swap transactions, daily and hourly breakdowns. (2 bar charts) Total $100k+ liquidity transactions (increase + decrease added together), daily and hourly breakdowns. (2 bar charts) Notes - May 19th was the only day where liquidity decreasing transactions were greater than increasing. May 19th had the highest number of $100k+ swaps as well. I was surprised to see the total number of $100k+ liquidity transactions for May 19th did not stand out.
Terra - The Rise and Fall of LUNA/UST
Apr 17, 2023 - This dashboard gives a quick view on the price action of both UST and LUNA pre and post depeg. i cri evry tim
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?
NEAR - Monthly Active Users Dashboard
Mar 2, 2023 - Active user is defined by a wallet that has signed a transaction.
Hellcats + Hellhounds NFT Stats
Jan 5, 2023 - Dashboard to display the total Hellcats and Hellhounds stats on OnePlanet since launching on Polygon. https://twitter.com/brian_terra_
Anchor Collateral/Borrow Stats - Last 90 Days
Jan 15, 2022 - For each question, we are interested in the underlying query(ies) and corresponding table(s) of the address-level data for each stat, rather than in a comprehensive analysis. Thank you for your help! 1. What are the average, median, and 10/90 percentile LTV ratios for each active address on Anchor in the last 90 days? 2. For each active Anchor borrower address, how many times and for how much of their collateral (absolute, and percentage) were they liquidated in the last 90 days?
Loop LP Metrics
Jan 27, 2022 - https://docs.google.com/document/d/19de-ZyQaKqHCWd7odRH2MgdOosHWNbDy7pU8VOJX3YA/edit
54. Supplied Token Comparison
Jun 21, 2021 - Query brings back the most recent data for compound.market_stats - then provides the latest totals on all of the underlying symbols for supply, reserves, and borrows. Highest Supply (USD) - USDC with ~$2.959 Billion Highest Reserves (USD) - DAI with ~$13.5 Million Highest Borrows (USD) - DAI with ~$1.91 Billion
NEAR Developer Activity - Last 30 Days
Oct 3, 2023 - All github developer data for owners with at least one commit in the last 30 days.
22. New User Activity
Jul 21, 2021 - Using the answer to this bounty as reference material, map the inflows of new users to Terra against inflows of assets to different projects in the ecosystem like Mirror, TerraSwap, and Anchor. When people come to Terra, what is the first thing that they do? Has that stayed the same or does it change with, say, new product releases?
25. Delegator Behavior
Jul 28, 2021 - Map the behavior of delegators versus non-delegators. Is there a distinct difference in where they engage in the Terra ecosystem? Tip - Start with the top 10 delegating and non-delegating accounts and scale from there.
SQL Adept Exam - Ethereum Data
Jul 3, 2021 - In order on the dashboard: 1. Compute these two metrics: sum of transactions per day, and count of distinct addresses that initiated a transaction (i.e. the “from” side). 2. Compute the sum of transactions per day by label type. 3. Compute the USD denominated volume on Ethereum per day. 4. Identify the top 10 addresses per day ranked by transaction count. Note - I set block_timestamp > 2021-06-01 to limit the amount of data we are returning. Looking at all of the ethereum data can obviously be a bit heavy for the query :)
4. Swaps + Pools
Nov 10, 2021 - How many tokens have been distributed via Pylon swaps? How many tokens have been earned via Pylon pools?
Part 2 of 2 - Terra Airdrops - Swap Info
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?
36. Active LPs New Position Count
Jul 14, 2021 - For the 10 most active LPs in WETH - USDC pools, how many times have they opened a new position when they had an existing position they could have repurposed in the past 30 days?
Low cap transactions (<=$1k) vs high cap transactions (>$1m)
Jun 4, 2021 - UNISWAP - liquidity provider Transaction metrics for $1000 or less VERSUS $1000000 or more. These first 4 charts are the most significant because they show the Increase VS Decrease of liquidity in small vs large transactions. Notice - for the $1m+ transactions, whales were adding to their positions instead of decreasing. For the transactions <=$1k, they were decreasing their positions HEAVILY. I believe this says a lot about retail investors and general panic in the market.
34. DeFi Users vs Newbies
Jul 7, 2021 - A poor attempt at this bounty, but still some interesting information! Over the last 7 days, how the totals of UNI holders (>100UNI) vary in other holdings!
42. Analysis of Capital Utilization Ratio - Compound
May 19, 2021 - Revitalized an older query with new charts and some code changes. TVL Over Time: USD Percent TVL Over Time: USD (adds to 100% total) Percent Supply Over Time: USD (adds to 100% total) Percent Borrowed vs Supply Over Time: USD Percent Reserves Over Time: USD (adds to 100% total) Percent Borrowed Breakdown (adds to 100% total)
Galactic Punks 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?"
53. Who is most in debt?
Jun 16, 2021 - I included both a top 10 dataset and chart for compound's most in debt over the last 60 days, and for all time. I figured it would be nice to have a comparison. You can see that the address with the highest amount borrowed in the last 60 days is: 0x1f99aaa8b4fb631d25b38b8a9099ef8f2611e46b with $195998066.47 borrowed. You can see that the address with the highest amount borrowed for all time is: 0x701bd63938518d7db7e0f00945110c80c67df532 with $350033349.54 borrowed.