sagharkari
FLOW's Path To Decentralization
Nov 10, 2022 - Flow is becoming more permissionless! Flow’s long-term vision is to optimize for security and scalability and move toward decentralization over time. With the release of permissionless contract deployment and new nodes for staking, build an analysis around the state of staking on Flow
Ethereum Educational Bounties: Ethereum_Core Tables Walkthrough
Nov 9, 2022 - There’s no monetary or token reward from these bounties, but you will learn a lot and move further along your quest to reach Intermediate or Advanced levels. Access the full content here:https://teamflipside.notion.site/Ethereum-1-Ethereum_Core-Table-Walkthough-Swaps-290ad820a4724c2b97425da1b948ed51
BAYC and Ape Staking
Dec 7, 2022 - In light of the Bored Ape Yacht Club's introduction of Staking, provide an analysis on the token and project. Provide data on APE token distribution in March 2022 and show how the activity has evolved since. Share analysis on future emissions schedule. How have the first hours of APE staking been? How do the staking rewards for each pool compare? Provide any relevant data.
< Hop In the Pool >
Nov 29, 2022 - Analyze how users join pools on Osmosis. Do they dive in headfirst (add both assets; joinpool) or do they wade in carefully (singleside; join swap extern amount in). Also analyze how deep the pool is (typical swap size in token and USD for both activities).
FLOW Wallet Dominance
Nov 4, 2022 - Show the landscape of wallets on Flow right now, like Dapper, Blocto, lilico, etc. Display metrics such as: overall number of users, comparison of NFTs traded by wallet, market share dominance, etc. What are active wallets doing more broadly? Help us get a current understanding of the expanding ecosystem of Flow wallets
[Solana] 1. Swap Volume on Orca
Nov 9, 2022 - This particular SQL guide focuses on the solana.core.fact_swaps table.
Which one is more popular? solanart vs Coralcube
Dec 8, 2022 - Both are popular, but we want to check which one is more popular
Ecosystem or Project Analysis (DOT)
Dec 10, 2022 - Pick your favorite ecosystem or project and tell us why it’s your favorite using data!
NFTs in 2022
Jan 4, 2023 - A retrospective on the NFT market in 2022. NFT project with the highest volume of trades in 2022? Which NFT project had the largest mint by dollar? Which NFT project decreased the most in value this year? Which NFT project gained the most value this year? What was the price of the highest-selling individual NFT? Which NFTs had the longest hold time this year? Which NFT project had the least amount of NFTs listed for sale on an exchange? Which project had the most NFTs listed for sale on an exchange?