kimkim
Solana Educational Bounties: Swap Volume on Jupiter & Orca
Aug 2, 2022 - By using the solana.swaps table, create the same flow analysis for SOL-USDC swaps on Jupiter from February 1 - February 28, 2022 - Does the token flow on Orca follow a similar pattern as the token flow on Jupiter?
MakerDao: Skill-building Bounty 3
Aug 24, 2022 - Using a combination of ethereum.maker.ez_deposits , ethereum.maker.ez_vault_creation and ethereum.core.ez_token_transfers Create a scatter plot showing the percentage of DAI borrowed divided by the WETH deposited (in USD values) Who are the top borrowers?
Ethereum Educational Bounties: Ethereum_Core Tables Walkthrough
Aug 1, 2022 - By using the ethereum_core tables, create the analysis for WBTC-WETH pool on Sushiswap from April 1 - April 15, 2022 - the WBTC-WETH pool on Sushiswap’s contract address is 0xceff51756c56ceffca006cd410b03ffc46dd3a58 - Does this pool have more or less swap volume compared to WETH-USDC?
Untitled Board
Aug 31, 2022 - Pick a NFT of your choice. Then, find a sample NFT minting transaction’s tx_hash and look at the data from both ethereum.core.ez_nft_mints and ethereum.core.fact_event_logs with this tx_hash. Then, we’ll try to decipher what we see from etherscan and how it relates back to the fact_event_logs table.
Avalanche Education Bounties: Buying GLP
Aug 19, 2022 - Show the weekly amount of GLP minted and redeemed with the right decimal places. How many people have minted GLP and out of those, how many have redeemed GLP? Calculate the price of GLP from the minting and redeeming transactions.
NEAR Meta-Analysis
Sep 14, 2022 - Craft your own remix to these dashboards, analyzing and summarizing the most important points in a single easy-to-view dashboard, with your own original commentary.
ERC20 balance: Skill-building Bounty 4
Aug 24, 2022 - Using the ethereum.core.ez_current_balances table, choose your favorite erc20 token and create a chart that shows the latest top 10 holders of that token with the token amounts. Then, create the same graph but this time showing the USD prices of that token instead of the amount.