Curriculum·Graduate·G101
Querying On-Chain Data
FTX and its affiliate Alameda Research, November 2022. The failure was off the chain, a hole between customer balances and what remained that Bankman-Fried himself put at as much as 8 billion dollars, but the warning was on it.
Start with lesson 14 lessons · about 2 hours · free account to read in full
Lesson 1 opens on
FTX and Alameda Research, November 2022
FTX was one of the largest cryptocurrency exchanges, tightly linked to the trading firm Alameda Research.6 billion dollars by Nansen's account, sat in FTT, a token FTX itself had issued, and related tokens rather than independent assets.1 million dollars in the week to 7 November, and over 6 billion dollars gone in 72 hours.
The lessons
- G101-01What the chain records, and the run FTX could not hideState what a public blockchain records and what it does not, and why that makes it evidenceabout 30 min · opens on FTX and Alameda Research, November 2022
- G101-02Schema literacy: accounts, transactions, logs, and eventsName the core objects of the on-chain schema: accounts, transactions, internal calls, and event logsabout 30 min · opens on An address poisoning campaign, February to May 2024
- G101-03Aggregating with SQL and DuneExplain what aggregation does: turn millions of individual events into a pattern by grouping and countingabout 30 min · opens on LooksRare wash trading, January 2022
- G101-04What a query cannot tell youState the boundary of on-chain querying: it shows assets and flows, not liabilities, intent, or off-chain factsabout 30 min · opens on Proof of reserves after FTX, late 2022