masumeh
SOL Swaps on Jupiter
Feb 21, 2022 - Jupiter is the best swap aggregator on Solana, meaning that it optimizes the best token swap rate across all decentralized exchanges for users. Since January 1st, how much SOL has been swapped for other tokens using Jupiter per day? Over the same time period, how much SOL has added from swaps using Jupiter per day? Create a visualization showing the flow of SOL from swaps on Jupiter since January 1st per day and provide insights around any spikes you see.
Terra Scavenger Hunt (Vietnamese)
Feb 11, 2022 - Cổ phần / Ủy quyền LUNA trước (Flipside) Khi bạn đặt mã thông báo LUNA của mình trước thanh Validator - Validator, Validator sẽ góp phần vào việc bảo mật và phần thưởng cho Terra Network.
Net Synth Amounts
May 4, 2022 - Show the net synth amounts (mints - burns) for each chain and each asset? Are there any patterns?
A World Without Anchor
May 4, 2022 - Imagine a world without Anchor, what would be the impact on Terra ecosystem Focus on UST Growth, User Growth, Impact on Market Module. Create Charts & Dashboards to back your analysis.
Getting Started With Algorand Bounties
May 19, 2022 - in this analysis we are looking at the most popular ASAs that are held by wallets created in 2022
Most Popular ASA To Swap From ALGOs
Apr 14, 2022 - Q50. Let’s look at what ASAs(Algorand Standard Assets) are most popular to swap into from ALGOs in 2022 using the swaps table Create a bar chart visualization of the top 10 ASAs by total ALGO swap volume. (Tip: This means we want to look at swaps where the wallet is sending in ALGOs(asset ID: 0) and receiving another asset in return. The volume would in ALGOs would be the sum of all the ALGOs wallets sent in to receiver the asset). Create a table for the top 10 ASAs found in part 1. In this table, list the ALGO swap volume and the average amount of ALGOs involved in a swap. Create a time series chart to look at the number of swaps (from ALGOs) to each of these 10 ASAs over time by day since the beginning of 2022. Note any trends on the increasing or decreasing popularity of any of the ASAs.
Algorand Bounties(Defly Token Launch)
Feb 11, 2022 - Here we refer to the most swaps in tinyman as well as the most Algorand distribution in wallets
Terra Altcoin Behavior
Feb 10, 2022 - Select a Terra “altcoin” (i.e. not LUNA/ANC/MIR) and assess their performance over the past 90 days, using a metric of your choice (examples: price, number of transactions, volatility.) What do you think are the prospects for your chosen altcoin?
USDC Transfer Volumes
Apr 14, 2022 - Compare USDC transfer volumes on Algorand, Solana, Ethereum in 2022.
Yet Another Acme Question
Apr 22, 2022 - Q184. Refer to submissions for #175 - your own, or those of others. Pick your favorite 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 favorite? If you improved it, what changes did you make? You can also refer to the Dashboards from Question #157 here: https://teamflipside.notion.site/Terra-Dashboards-Powered-by-the-Flipside-Community-defa0c2160694af599beecba089b813d
Smart Money NFT Traders
Jun 8, 2022 - Which wallets have made the most SOL off NFT mints and NFT trades since the start of the new year? What types of actions have led to being a profitable NFT trader on SOL? Is there a pattern behind their NFT trading strategy and can you define some of these traders as "smart money"? Do you think you need to be a "whale" to do well trading SOL NFTs, or can anyone have success in this market?
Solana Scavenger Hunt 2.0 (Farsi)
Feb 11, 2022 - در این هانت با دو پلتفرم آشنا شدم ونحوه ی استیک کردن برای گرفتن سود یاد گرفتم
MonkeDAO Validator
Feb 20, 2022 - The MonkeDAO was the first NFT DAO on Solana and also was the first NFT DAO to set up a validator in an effort to help decentralize and secure the network. When a user decides to stake their Solana, they delegate which validator to support with their staked Solana. How many unique wallets since February 1st have decided to delegate their staked Solana to the MonkeDAO validator? Create a visualization showing delegations per day.
LUNA Distribution, Mvmt II
Feb 9, 2022 - What is the distribution of LUNA for active wallets (i.e. wallets with at least one transaction in the past 90 days? What is the distribution of LUNA if wallets that have never transacted are excluded?
More Mints
Apr 22, 2022 - Q56. Metaplex is an open source protocol that allows for the creation and minting of NFTs using a standardized format across wallets and applications. It is essentially the backbone architecture for Solana NFTs. How many NFTs have been minted over the past week? Since the beginning December, how many NFTs have been minted per week? Chart the growth of unique purchasers over time. What percentage of all mints have been via Metaplex's Candy Machine? Hint: https://docs.metaplex.com/candy-machine-v2/introduction Hint: Candy Machine program Ids: cndy3Z4yapfJBmL3ShUp5exZKqR3z33thTzeNMm2gRZ cndyAnrLdpjq1Ssp1z8xxDsB8dxe7u4HL5Nxi2K5WXZ Hint: Use fact_nft_mints
Acquiring goBTC and goETH
Apr 7, 2022 - Q47. Where are users acquiring goBTC and goETH? Are they acquiring the assets by swapping or by minting? Has this changed over time? Explain the insights you find. Tips: When the goBTC and goETH is ""minted"" by a wallet it is distributed from ETGSQKACKC56JWGMDAEP5S2JVQWRKTQUVKCZTMPNUGZLDVCWPY63LSI3H4 to the Algorand wallet. When a wallet wants to ""redeem"" their goETH and goBTC for their original asset, they send it back to the wallet it was distributed from. Asset IDs goBTC: 386192725 goETH: 386195940
Pros of SOL
May 25, 2022 - Q78. Why should developers build on Solana compared to other L1 chains? What features for developers does Solana offer that make it appealing? Compare Solana in terms of transaction speed/throughput, user growth and activity, cost/fees per user, growth in defi and growth in nfts to at least two other chains. How are popular projects on Solana able to scale compared to top projects on other chains (for example a gaming app like StepN or a popular dex like Orca). How do you envision user growth of apps on Solana over time? What types of products seem to be positioned particularly well on Solana? Stay in the loop
What Are Whales Swapping For?
Apr 14, 2022 - Let's look at the whales are swapping for on the DEXes. First identify current whales with the balance field in the algorand.account table.
L1 Unique Users
Mar 17, 2022 - Question 37: Compare the number of unique wallets that have sent a transaction since February 1st on Solana vs Ethereum vs Terra. How does user adoption seem to be trending for Solana compared to these other major chains? Does it appear that market conditions are slowing down growth or activity on the networks?
What Are Users Swapping gALGO3 For?
Apr 30, 2022 - gALGO3 is an asset that is pegged to ALGO. Users can lock their ALGO up on Folks.finance for governance and while their ALGO is locked they receive gALGO3 and you can use it for other defi activities. Read more about it here: https://docs.folks.finance/protocol-architecture/algo-liquid-governance Let’s look what users are swapping their gALGO3 for while their ALGO is locked in governance.
Anchor bETH Collateralization
Mar 31, 2022 - Q6. Quantify the amount of bETH provided as collateral in Anchor Protocol. Note any trends or changes in user behavior in the last 90 days. Based on your results, should the bETH borrow limit be raised to 70% LTV? Include relevant data or visualizations to support your claim.