nuthatch data model The `nest` nest on mainnet. (seeded from the ABI - edit semantic.toml to improve this) COVERAGE sealed_through = 26470292 (rows at or below this block are sealed Parquet); tip = 26471101 - the `sql` tool reads both the sealed rows and the live tip above them. first_indexed = 10000000 - no block before it is in this nest; indexed from the configured start_block with no --backfill, so the `balances` view is complete if that is the deployment block (which `init` sets). TABLES (one per contract event; query via the `sql` tool) lusd3crv__transfer - `Transfer(address,address,uint256)` events emitted by the `lusd3crv` contract. (seeded from the ABI - edit semantic.toml to improve this) grain: one row per Transfer(address,address,uint256) event columns: from (address), to (address), value (uint256) ⚠ reserved-word columns - double-quote them: "from", "to" ⚠ big-int columns (exact text; SUM/AVG of `_dec` is the values that fit, and WHERE NOT _overflow is that same sum): value → value_dec ⚠ wide columns (>128-bit) whose `_dec` is NULL above 38 digits. A sum of `_dec` is the values that fit; WHERE NOT _overflow is that same sum. Ids, nonces and hashes stay on the raw column: value univ2_usdc_usdt__transfer - `Transfer(address,address,uint256)` events emitted by the `univ2_usdc_usdt` contract. (seeded from the ABI - edit semantic.toml to improve this) grain: one row per Transfer(address,address,uint256) event columns: from (address), to (address), value (uint256) ⚠ reserved-word columns - double-quote them: "from", "to" ⚠ big-int columns (exact text; SUM/AVG of `_dec` is the values that fit, and WHERE NOT _overflow is that same sum): value → value_dec ⚠ wide columns (>128-bit) whose `_dec` is NULL above 38 digits. A sum of `_dec` is the values that fit; WHERE NOT _overflow is that same sum. Ids, nonces and hashes stay on the raw column: value VIEWS (incrementally maintained; reorgs retract automatically) balances - per-address net balance = Σ(received) − Σ(sent), i128 base units as decimal strings, for ERC-20 Transfer tables. Query via the `balance`/`top_balances` tools. FACTORIES (RFC-0009; only in a nest with templates/factories) Children of a template share tables (`pool__swap`, …), distinguished by the `address` column. Each template has a `{template}__children` view: which children were discovered, when, by which parent.