saeide-ahmadi-7
The Battle of the Solana NFT Aggregator
Oct 30, 2022 - Hyperspace and Coral Cube are the two most popular NFT aggregators on Solana. This means that they list all NFTs across different marketplaces along with allowing listings on their own marketplace. Create a dashboard comparing KPIs between Hyperspace and Coral Cube. Which marketplace has done more volume? Which collections are popular on each marketplace? Why would I use one marketplace over the other? Are there any noticeable market trends between the marketplaces, especially after Solana marketplaces moved to a 0% creator royalty?
Flash Bounty: LUNA Head
Oct 7, 2022 - What's going on with LUNA, aka LUNA 2.0? Is there any unusual activity? Major whales buying or selling? What dApps are people using? Tell us the story of LUNA using the terra.core tables. Include at least three visualizations in your analysis — the best dashboards will dive deep into particularly interesting trends, outliers, or findings. They'll also be featured in a future video (so include your Twitter handle in the dashboard, and tweet it at @flipsidecrypto)!
Largest Tokemak DEX Pools
Jun 22, 2022 - Q3. What are the largest dex pools for TOKE (UNI, SUSHI, etc.)? What is the behavior of TOKE holders on these token pools currently?
Flipside's World Cup of Bounties Side Quest: LaLiga Golazos
Dec 6, 2022 - LaLiga Golazos: Officially licensed LaLiga video collectibleshttps
Flash Bounty: Art Gobblers
Nov 2, 2022 - Art Gobblers is a pre-reveal NFT project that generates "goo" when you feed it (upload) art you've created. Some say the project is revitalizing NFTs in the bear market - Compare various metrics across NFT activity to support or oppose that idea. Then evaluate how the project's metrics stack up to other top NFT collections before their art reveals. Create a dashboard that shows off stats for Art Gobblers NFTs, and compare it to other top collections. Include at least these metrics, along with any others you find notable or interesting: -Mint volume -Total and Average Sales Volume -Secondary Sales vs Mint sales -Daily Average Sales Price and 7-day moving average -Floor price -% of Gobblers Listed -Total Unique Buyers -Social Mentions/Shares -Any available metrics on GOO token and art uploads -Broader activity in the NFT space
NEAR City Layout
Nov 3, 2022 - How centralized or decentralized is NEAR, really? Choose at least two distinct measures of decentralization that can be explored with on-chain data; clearly define those metrics; and outline how NEAR performs based on those metrics. In your view, is NEAR becoming more centralized or decentralized over time? Grand Prize submissions will also explore these metrics for at least one other blockchain.
Top TOKE Holders
Jun 19, 2022 - Q1. Identify the top holders of the TOKE token in January 2022, have they kept their position today?
Gains Network vs GMX
Nov 2, 2022 - A war of the trading platforms? GMX (native to Arbitrum) - GNS (native to polygon, but announced will be launching on Arbitrum soon). Both platform native tokens (GMX - GNS) have seen meteoric price growth during a bear market. Since June GNS has gone from $0.68 to $3.68 and GMX has gone from $13.70 to $41.56 Observe Trading volume. Has one platform absorbed more volume than the other? How impactful is GNS volume to polygon? GMX volume to Arbitrum? Are there any insights that can reveal why Gains Network wants to move into the Arbitrum ecosystem?
Total Metamask Users
Jun 26, 2022 - Q1. How many total Metamask wallet holders are there? What’s the average value of ETH held in wallets? What percentage of wallets are engaging in a higher order activity, like staking? Hint: For the purpose of this bounty, we can categorize Metamask wallets as wallets who have used the Metamask swap feature (interacted with this contract 0x881D40237659C251811CEC9c364ef91dC08D300C)
Secondary Sales Activity
Jun 21, 2022 - Q2. How many Lil Nouns have been sold on a secondary exchange within 24 hours of being minted? Are there any common traits among these Lil Nouns? Which Lil Noun’s have the biggest difference (positive or negative) between their mint price and secondary sale price? Visualize and analyze your findings. Hint: This query looks at Nouns traits. You will need to modify it for Lil Nouns! select block_number as mint_block, block_timestamp as mint_time, tx_hash as mint_hash, contract_address, tokenflow_eth.hextoint(topics[1])::integer as tokenID, tokenflow_eth.hextoint(substr(data,3,64)) as background, tokenflow_eth.hextoint(substr(data,67,64)) as body, tokenflow_eth.hextoint(substr(data,131,64)) as accessory, tokenflow_eth.hextoint(substr(data,195,64)) as head, tokenflow_eth.hextoint(substr(data,259,64)) as glasses from ethereum.core.fact_event_logs where block_number > 12000000 and contract_address = '0x9c8ff314c9bc7f6e59a9d9225fb22946427edc03' and topics[0]::string = '0x1106ee9d020bfbb5ee34cf5535a5fbf024a011bd130078088cbf124ab3092478' order by tokenId desc;
Solend Demographics
Aug 3, 2022 - Q101.Solend is the leading lending protocol on Solana. What are the demographics of the Solend userbase? What is the user distribution by size of account? (How many have between $1-1,000, 1,000 - 100k, etc). Is the protocol largely influenced by whales, or by average Solana users?
Daily Active User
Oct 17, 2022 - What does a Daily Active User look like on Osmosis? First, plot out how many DAUs there are on Osmosis. For this exercise, consider a DAU would be any wallet transacting on Osmosis a majority of days every week. Once you have the DAUs, what does their activity look like? Do they LP more or swap more? How often do they transfer tokens into Osmosis? Where are these transfers coming from?
Bridge Users (Hop Protocol)
Jun 23, 2022 - Q1. How many unique users have bridged to L2s using Hop? What days in the past 6 months have seen the most volume bridged, and were there any specific events that may have driven these spikes? Which assets have been bridged the most? Show an analysis of the asset distribution of bridging through Hop.
Wallet Balances & Ecosystem Growth
Oct 24, 2022 - With the launch of Flipside's new Balances table, let's take a look at how the story of Osmosis can be told through wallet balances. Provide insights into following metrics: How has the ratio of liquid to staked OSMO changed overtime? Are the top 100 OSMO holders the same now as they were at the start of the year? What is the current average OSMO per wallet? How has that value changed over time? Plot average OSMO/wallet against user growth. Do wallets normally hold a majority of OSMO, or another token? How has this changed over time?
FLASH BOUNTY: FLOW NFT Floor Tracker
Oct 27, 2022 - Let’s sweep some floors. Build a dashboard that tracks the floor by contract for various NFT projects in the FLOW ecosystem. We’re interested to see how you come up with your own methodology. Include at least five projects in your dashboard, as well as any interesting metrics, notes, trends, or outliers that you see.
Trending NFT Projects
Jun 14, 2022 - Q8. Create a visualization showing NFT sales volume on Flow since May 9th. Which NFT projects are trending on Flow right now and what is the general trend of NFT sales over the last month? Do the projects that are trending seem to have common wallets or is there not much crossover between buyers/sellers?
RaceDay NFTs
Oct 20, 2022 - How does Speedway Motorsports RaceDay NFTs stack up to sports NFT collections in the FLOW ecosystem? What other projects are RaceDay fans buying? Create a dashboard that shows off a high-level project overview of RaceDAY. Include at least these metrics, along with any others you find notable or interesting: Average Sales volume (daily/weekly/monthly) Total Sales Volume Secondary Sales vs. Mint Sales Daily Average Sales Price and 7-day moving average Total Unique Buyers Average Buyers/Day Social Mentions/Shares
Ailing Alameda
Nov 8, 2022 - Analyze what Alameda is experiencing. Rumors over the weekend began swirling that alameda research is on the brink of insolvency. Observe net in and outflows of USD tokens from known Alameda or FTX accounts throughout different chains. Are they going somewhere specifically? Are there any signs of potential insolvency? Note any other interesting trends or events you see.
Distinct Wallets (zkSync)
Jun 17, 2022 - Q1. ZkSync is a scaling solution for Ethereum that is live on mainnet. Some of the main features of ZkSync are the extremely low transaction fees and trustless protocol design. How many distinct wallets have deposited ETH into ZkSync in the last 60 days? How much ETH was deposited by day? Visualize both. Hint: use the ethereum.core.ez_eth_transfers table https://etherscan.io/txs?a=0xabea9132b05a70803a4e85094fd0e1800777fbef&p=1
Algorand x Fifa Partnership
May 12, 2022 - Q64. On May 2nd, Algorand announced a technical partnership with Fifa causing the price to move 25%. Over the rest of the week, how did this impact Algorand blockchain activity? Did we see an uptick in new wallets being created? Did we see more ALGOs being transferred on a daily basis? Did we see more transactions happening occurring? Did we see more wallets sending ALGOs from centralized exchanges to their onchain wallets? Did we see an influx of swaps? Note any changes in behavior in on-chain activity that may have been caused by the Fifa partnership!
Fuse Pool DAI Allocation
May 21, 2022 - Q1. How are the tokens in the DAI Vault being allocated into the various Fuse Pools?
The Law Offices of NEAR
Aug 3, 2022 - Q7. Provide your best assessment of the number of smart contracts deployed on NEAR and clearly outline your methodology (after all, contract lawyers love clearly specified terms). Visualize the number of new smart contracts deployed over time over a time period of your choosing. What are the top 5 new smart contracts interacted in that period of your choosing?
Voting Activity
Jun 21, 2022 - Q1. The Lil Nouns DAO is controlled via onchain voting by token holders. Using the ethereum database, analyze voting activity on Lil Nouns proposals. Since voting is on chain and costs gas, are smaller holders excluded from the voting process? Visualize and analyze this question, along with any other trends you find that are relevant. Hint: Sample query to look at a Lil Noun vote select * from ethereum.core.fact_event_logs where block_number = 14887882 and tx_hash = '0x783d64b2146de10f7545e1053a6fa58d2846ee78fb5dc30ed635182ac5313e9b'