ETH -> Polygon Bridge Data
Aug 21, 2021 - Using udm_events and events_emitted produces different / missing? data
Curve Liquidity for Liquid Staking
Sep 21, 2021 - [Curve Bounty 2] Analyze the stETH-ETH pool over the past 30 days. What trends can you identify? What might be causing them?
Delegator Overlap
Aug 17, 2021 - [Terra 44] Which validators do the top 25 delegators (by volume) delegate to? Do they tend to delegate to the same validators, or to different ones?
Ethereum UST Peg - Uniswap Liquidity vs Volatility
Jul 27, 2021 - Terra Bounty 28 - Compare the price of the UST-Tether pool on Uniswap V3 against the UST oracle price on Terra.
UST in May: What's a Dollar Worth?
May 10, 2022 - Charts set to refresh hourly, timestamps are in UTC. Note: Terra data is updating intermittently due to the multiple network halts.
Flow Events Backfill
Aug 11, 2022 - Monitoring the rewalk of blocks that were ingested from 7/18-8/4 where transaction event data was missing due to the new HTTPS endpoint. The black line is transaction and block count within the events table, while the bars are the total transactions and events in the core tables. We should expect the line to start to meet the bars as the backfill occurs.
Pudgy Penguins Trading Metrics
Aug 6, 2021 - Flipside's databases are generally 30-60 mins behind the live blockchain. Charts autorefresh every 30 min.
Near Developer Report, 2022 Year End
Dec 30, 2022 - An investigation into developer activity on NEAR related GitHub repositories, per the ecosystem compiled by Electric Capital. Methodology and data extraction explained in the below linked GitHub Repository.
LUNA Price Volatility
Aug 4, 2021 - Terra Bounty 31 - What has the daily volatility (standard deviation of price day over day) of LUNA price been over the past 2 weeks? How does that compare to the volatility of ETH over the past 2 weeks? What are events and/or factors potentially impacting these?
USD, Terra USD
Nov 30, 2021 - [terra 103] Analyze the volume of UST being sent to other chains from Terra using Wormhole.
THORBURN - Upgrades to Native RUNE
Oct 27, 2021 - [Thor Bounty 2] Show the volume of non-native rune being upgraded to native RUNE, broken down by chain (ETH + BNB)
THORChain - Now Open 24/7!
Nov 3, 2021 - [THOR Bounty 8] What time periods (GMT) see the heaviest swap, LP add/withdrawal volumes by asset?
Stablecoin Supplies on the Terra Blockchain
Sep 8, 2021 - 61. [Easy] Stablecoin Total Supply \\ Make a visualization that shows the total circulating supply of each pegged currency in the Terra ecosystem over the past 6 months.
The Great Dumpening
May 9, 2022 - Alt Title, someone arbed the peg and ETH Twitter is all mad.
RUNE Price and THOR Swaps
Nov 3, 2021 - [THOR Bounty 9] Is there a relationship between rune price and trade volume?
Anchors Aweigh! ⚓️💸
Jan 5, 2022 - [Terra 123] How have the average and total borrows and deposits on Anchor changed over time?
Terra Scavenger Hunt
Jun 24, 2021 - General overview of the (early) Terra ecosystem while learning SQL
Self-Validation
Jul 16, 2021 - Terra Bounty 30 - For the top 5 validators, what percent of the LUNA that they hold is their own as opposed to delegated to them? Has this proportion changed over time?
Rewards and Gas
Sep 28, 2021 - [yveCRV Bounty 2] yveCRV Vault users can claim rewards weekly, yvBOOST users have their rewards automatically claimed and reinvests into yveCRV to compound rewards. 1. How many users are claiming rewards weekly in yveCRV? 2. How much gas have yveCRV holders spent since yvBoost launched? 3. Have users of the yveCRV vault made good decisions about claiming tokens with regard to gas fees?
Bitcoin
Jul 19, 2023 - Eric asked me to show off some queries and/or dashboards for the Bitcoin launch but I only had like 20 mins before the call so here are some queries and charts!
Terra Gas
Sep 14, 2021 - [Terra Bounty 66] Find the largest transactions in the past 30 days. How does the gas fee limit set on these transactions compare to the actual gas used for them?
Chai Volume and Terra Fees
Aug 17, 2021 - [Terra 45] What has the monthly volume of payments been on Chai over the past year? What have been the total monthly fees been on Terra over the past year?