nuthatch data model Circle's native USDC on Base (FiatToken proxy 0x8335...2913): transfers, approvals, mints, burns and blacklisting. Amounts have 6 decimals. COVERAGE sealed_through = 59831129 (rows at or below this block are sealed Parquet); tip = 59838299 - the `sql` tool reads both the sealed rows and the live tip above them. first_indexed = 56516981 - no block before it is in this nest; history was cut short (--backfill, or no start_block), so the `balances` view is the net flow since then, not a balance. TABLES (one per contract event; query via the `sql` tool) usdc__approval - `Approval(address,address,uint256)` events emitted by the `usdc` contract. (seeded from the ABI - edit semantic.toml to improve this) grain: one row per Approval(address,address,uint256) event columns: owner (address), spender (address), value (uint256) ⚠ 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 usdc__authorization_canceled - `AuthorizationCanceled(address,bytes32)` events emitted by the `usdc` contract. (seeded from the ABI - edit semantic.toml to improve this) grain: one row per AuthorizationCanceled(address,bytes32) event columns: authorizer (address), nonce (bytes32) usdc__authorization_used - `AuthorizationUsed(address,bytes32)` events emitted by the `usdc` contract. (seeded from the ABI - edit semantic.toml to improve this) grain: one row per AuthorizationUsed(address,bytes32) event columns: authorizer (address), nonce (bytes32) usdc__blacklisted - `Blacklisted(address)` events emitted by the `usdc` contract. (seeded from the ABI - edit semantic.toml to improve this) grain: one row per Blacklisted(address) event columns: _account (address) usdc__blacklister_changed - `BlacklisterChanged(address)` events emitted by the `usdc` contract. (seeded from the ABI - edit semantic.toml to improve this) grain: one row per BlacklisterChanged(address) event columns: newBlacklister (address) usdc__burn - `Burn(address,uint256)` events emitted by the `usdc` contract. (seeded from the ABI - edit semantic.toml to improve this) grain: one row per Burn(address,uint256) event columns: burner (address), amount (uint256) ⚠ big-int columns (exact text; SUM/AVG of `_dec` is the values that fit, and WHERE NOT _overflow is that same sum): amount → amount_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: amount usdc__master_minter_changed - `MasterMinterChanged(address)` events emitted by the `usdc` contract. (seeded from the ABI - edit semantic.toml to improve this) grain: one row per MasterMinterChanged(address) event columns: newMasterMinter (address) usdc__mint - `Mint(address,address,uint256)` events emitted by the `usdc` contract. (seeded from the ABI - edit semantic.toml to improve this) grain: one row per Mint(address,address,uint256) event columns: minter (address), to (address), amount (uint256) ⚠ reserved-word columns - double-quote them: "to" ⚠ big-int columns (exact text; SUM/AVG of `_dec` is the values that fit, and WHERE NOT _overflow is that same sum): amount → amount_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: amount usdc__minter_configured - `MinterConfigured(address,uint256)` events emitted by the `usdc` contract. (seeded from the ABI - edit semantic.toml to improve this) grain: one row per MinterConfigured(address,uint256) event columns: minter (address), minterAllowedAmount (uint256) ⚠ big-int columns (exact text; SUM/AVG of `_dec` is the values that fit, and WHERE NOT _overflow is that same sum): minterAllowedAmount → minterAllowedAmount_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: minterAllowedAmount usdc__minter_removed - `MinterRemoved(address)` events emitted by the `usdc` contract. (seeded from the ABI - edit semantic.toml to improve this) grain: one row per MinterRemoved(address) event columns: oldMinter (address) usdc__ownership_transferred - `OwnershipTransferred(address,address)` events emitted by the `usdc` contract. (seeded from the ABI - edit semantic.toml to improve this) grain: one row per OwnershipTransferred(address,address) event columns: previousOwner (address), newOwner (address) usdc__pause - `Pause()` events emitted by the `usdc` contract. (seeded from the ABI - edit semantic.toml to improve this) grain: one row per Pause() event columns: usdc__pauser_changed - `PauserChanged(address)` events emitted by the `usdc` contract. (seeded from the ABI - edit semantic.toml to improve this) grain: one row per PauserChanged(address) event columns: newAddress (address) usdc__rescuer_changed - `RescuerChanged(address)` events emitted by the `usdc` contract. (seeded from the ABI - edit semantic.toml to improve this) grain: one row per RescuerChanged(address) event columns: newRescuer (address) usdc__transfer - `Transfer(address,address,uint256)` events emitted by the `usdc` 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 usdc__un_blacklisted - `UnBlacklisted(address)` events emitted by the `usdc` contract. (seeded from the ABI - edit semantic.toml to improve this) grain: one row per UnBlacklisted(address) event columns: _account (address) usdc__unpause - `Unpause()` events emitted by the `usdc` contract. (seeded from the ABI - edit semantic.toml to improve this) grain: one row per Unpause() event columns: AUTHORED VIEWS (derived - query by name, recomputed per query over hot∪cold) issuance - One row per Mint or Burn: kind, actor (the minter or burner), and amount_raw (6 decimals, negative for a burn). sum(amount_raw) over a block range is the change in totalSupply across it. transfers_hourly - USDC transfers and value_raw (6 decimals) per hour. hour is the unix time the hour starts. 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.