![brian-terra | Flipside Analyst brian-terra | Flipside Analyst](https://res.cloudinary.com/dsr37ut2z/image/upload/assets/backgrounds/analyst-bg.png)
brian-terra
![Levana NFT Trading - Impact Analysis Levana NFT Trading - Impact Analysis](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
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 Iced Out Bulls - Sales/Volume Basics](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
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 23. Tax Rate](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
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)
![17. Native Swaps vs Terra Swaps 17. Native Swaps vs Terra Swaps](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
17. Native Swaps vs Terra Swaps
Jul 14, 2021 - In this dashboard, we take a look at terra.swaps and terra.msgs to compare the top 5 pairs for each Native Swaps and Terra Swaps.
![2. Visualize governance staking of $MINE over time 2. Visualize governance staking of $MINE over time](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
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 61. [Easy] Stablecoin Total Supply](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
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 20. Staking Rewards](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
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 19. Assets on Mirror](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
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 LunaBulls NFT Trading - Impact Analysis](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
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 6. Peg Variance](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
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 52. Average Loan Amount](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
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.
![Total NFT Sales on Terra Total NFT Sales on Terra](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
Total NFT Sales on Terra
Nov 23, 2021 - This dashboard displays some NFT sales volume data on Terra. I investigate data from both RandomEarth and knowhere.art
![3. LUNA Validators 3. LUNA Validators](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
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 aUST Bridged from Terra to ETH](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
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.