brian-terra
2. Visualize governance staking of $MINE over time
Nov 10, 2021 - What are the trends? Compare $MINE staking trends with $LUNA staking, do you think a lockup period would be beneficial? For those that have stopped staking, what did they decide to do instead in the Terra ecosystem?
61. [Easy] Stablecoin Total Supply
Sep 8, 2021 - Make a visualization that shows the total circulating supply of each pegged currency in the Terra ecosystem over the past 6 months. Hint: Use the terra.balances table.
20. Staking Rewards
Jul 20, 2021 - What is the ratio of amount staked to rewards earned? Has this changed? What might be causing these changes?
19. Assets on Mirror
Jul 19, 2021 - Of the assets that are on Mirror, what is the ranking of the top 10 by volume over the past month? Quarter? Any theories as to why the changes that you see have occurred?
LunaBulls 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?"
6. Peg Variance
Jun 24, 2021 - For this dashboard, we take a look at the stablecoins in terra.oracle_prices The stablecoins that I am querying are the following:'UST','AUT','CAT','CHT','CNT','DKT','EUT','GBT','HKT','INT','JPT','KRT','MNT','NOT','SDT','SET','SGT','THT' As a reference point for the target/peg of the stablecoins, I averaged every day's price for the last six months. Then I took the minimum price points and maximum price points for each symbol to provide a range for each stablecoin for the variance it had in relation to the average. This dashboard provide: A running chart of Average Stablecoin Price for each symbol for the last 6 months. A chart representing the percentages UNDER the average stablecoin price for the last 6 months. A chart representing the percentages OVER the average stablecoin price for the last 6 months. There are a few days that stand out for the greatest stablecoin peg variance, with the greatest variance over the last 6 months being February 7th for all stablecoins being UNDER the average by a significant amount, and February 8th for all stablecoins being OVER the average by a significant amount.
52. Average Loan Amount
Jun 21, 2021 - Simple query to calculate the average loan size in USD over the last 6 months. I calculated this in two different ways to confirm - by using the AVG function, as well as calculating it manually by using SUM and COUNT functions. Both numbers came out the exact same, but I used the data and chart from the AVG function because it requires less SQL and is cleaner. I will share in the show-and-tell discord to show people how you can use SQL in different ways to get the same results, often.
3. LUNA Validators
Nov 10, 2021 - For addresses that are staking MINE right now, what validators do they prefer for their LUNA staking? Are there any trends or commonalities?
aUST Bridged from Terra to ETH
Dec 22, 2021 - Dashboard to show the total aUST bridged from Terra blockchain to ETH blockchain over the last 30 days.
Terra Explorer Hunt
Jun 26, 2021 - The only data I can find related to my transactions during the Terra Explorer Hunt! I will update this soon - I plan on decoding the msg_values and event_attributes.
21. Oracle Prices
Jul 21, 2021 - How has the oracle price changed in the past 2 months? What are the rates at which the winning price passes/how contested is the vote usually?
4. Decentralization of Validator System
Jun 28, 2021 - For this dashboard, I used terra.validator_voting_power to query the most recent addresses for the total voting power with their respective percentages. Notice that of the 100 validators, the top 10 of them make up 60.47% of the total voting power. The number 1 validator makes up 10.28% of the voting power alone. I have included charts of both the total voting power number and percentages for all 100 addresses. I use a substring to pull back the last 5 characters of the address to shorten it.