Pudgy Penguins Trading Metrics
Aug 6, 2021 - Flipside's databases are generally 30-60 mins behind the live blockchain. Charts autorefresh every 30 min.
THORChain Restart - Third Time's the Charm ... ?
Dec 1, 2021 - [thor 22] THORChain was halted from 11/12 - 11/17 and re-started on 11/18. What behavior has been seen since the network re-started?
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.
ENS Airdrop - the best kept secret on Twitter
Dec 15, 2021 - [ENS 5] Look at ENS registrations before and after the cutoff date for the airdrop. Do you notice anything suspicious that makes you think that some people knew the airdrop was coming?
bLUNA vs LUNA
Aug 18, 2021 - [Terra 46] Compare the quantity of Bonded Luna to unbonded Luna. Visualize the changes in each over a time period of your choice, and provide a quick explanation of the insights or significance: what can we learn from the ratio of bLUNA to LUNA?
Terra Scavenger Hunt
Jun 24, 2021 - General overview of the (early) Terra ecosystem while learning SQL
ORION Constellation Hunt
Oct 23, 2021 - Txs complete as of 4:50 MST 10/23 ... dash will update w details when they hit the database.