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.
MetricsDAO Workshop #2
Feb 9, 2022 - Anchor's Collateral - Trends over time and changing user behaviors.
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?
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?
⚓️ The Robust Anchor Protocol
Aug 2, 2021 - Terra Bounty 32 - How have deposits on Anchor changed in the past 2 weeks? Why do you think this is? ----- Terra Bounty 33 - What has happened to Anchor's collateralization ratio over the past two weeks? What impact has this had on user behavior on Anchor? Pick at least 2 metrics to quantify the impact. (ie. TVL, 24hr volume)
Pudgy Penguins Trading Metrics
Aug 6, 2021 - Flipside's databases are generally 30-60 mins behind the live blockchain. Charts autorefresh every 30 min.
USD, Terra USD
Nov 30, 2021 - [terra 103] Analyze the volume of UST being sent to other chains from Terra using Wormhole.
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?
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)
RUNE Price and THOR Swaps
Nov 3, 2021 - [THOR Bounty 9] Is there a relationship between rune price and trade volume?
The Great Dumpening
May 9, 2022 - Alt Title, someone arbed the peg and ETH Twitter is all mad.
Terra Scavenger Hunt
Jun 24, 2021 - General overview of the (early) Terra ecosystem while learning SQL
Anchors Aweigh! ⚓️💸
Jan 5, 2022 - [Terra 123] How have the average and total borrows and deposits on Anchor changed over time?
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?
CRV Token Uses
Sep 21, 2021 - [Curve Bounty 1] What else do people do with the CRV token (besides vote-lock)?
THORSwap User Metrics
Oct 27, 2021 - [THOR Bounty 5] Show the number of swaps as well as the unique number of swappers in total and by pool, today and daily.
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!
Dumb game
Mar 17, 2023 - Enter a number from 1-100 in the guess box and apply. If you get it, you win.
Flow Latency // Time to Complete Coverage
Dec 8, 2023 - Latency on Flow is expected to be worse than other chains because, at minimum, 4 calls are required to generate a complete block. Blocks are requested by height, which returns an array of collections by ID. These collections are containers for transactions, thus the collection response (called by individual ID) contains an array of transaction IDs. Transactions are then requested by ID, twice, for the tx body and tx response. The response contains the event data and is often an order of magnitude slower than the other 3 gRPC calls.