nuthatch data model
The `beefy-hyperevm` nest on hyperevm. (seeded from the ABI - edit semantic.toml to improve this)
COVERAGE
sealed_through = 51942675 (rows at or below this block are sealed Parquet);
tip = 51950352 - the `sql` tool reads both the sealed rows and the live tip above them.
first_indexed = 4883535 - 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)
classic_vault__approval - `Approval(address,address,uint256)` events emitted by the `classic_vault` 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
classic_vault__initialized - `Initialized(uint8)` events emitted by the `classic_vault` contract. (seeded from the ABI - edit semantic.toml to improve this)
grain: one row per Initialized(uint8) event
columns: version (uint8)
classic_vault__new_strat_candidate - `NewStratCandidate(address)` events emitted by the `classic_vault` contract. (seeded from the ABI - edit semantic.toml to improve this)
grain: one row per NewStratCandidate(address) event
columns: implementation (address)
classic_vault__ownership_transferred - `OwnershipTransferred(address,address)` events emitted by the `classic_vault` contract. (seeded from the ABI - edit semantic.toml to improve this)
grain: one row per OwnershipTransferred(address,address) event
columns: previousOwner (address), newOwner (address)
classic_vault__transfer - `Transfer(address,address,uint256)` events emitted by the `classic_vault` 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
classic_vault__upgrade_strat - `UpgradeStrat(address)` events emitted by the `classic_vault` contract. (seeded from the ABI - edit semantic.toml to improve this)
grain: one row per UpgradeStrat(address) event
columns: implementation (address)
classic_vault_factory__proxy_created - `ProxyCreated(address)` events emitted by the `classic_vault_factory` contract. (seeded from the ABI - edit semantic.toml to improve this)
grain: one row per ProxyCreated(address) event
columns: proxy (address)
clm_manager__approval - `Approval(address,address,uint256)` events emitted by the `clm_manager` 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
clm_manager__deposit - `Deposit(address,uint256,uint256,uint256,uint256,uint256)` events emitted by the `clm_manager` contract. (seeded from the ABI - edit semantic.toml to improve this)
grain: one row per Deposit(address,uint256,uint256,uint256,uint256,uint256) event
columns: user (address), shares (uint256), amount0 (uint256), amount1 (uint256), fee0 (uint256), fee1 (uint256)
⚠ reserved-word columns - double-quote them: "user"
⚠ big-int columns (exact text; SUM/AVG of `_dec` is the values that fit, and WHERE NOT _overflow is that same sum): shares → shares_dec, amount0 → amount0_dec, amount1 → amount1_dec, fee0 → fee0_dec, fee1 → fee1_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: shares, amount0, amount1, fee0, fee1
clm_manager__e_i_p712_domain_changed - `EIP712DomainChanged()` events emitted by the `clm_manager` contract. (seeded from the ABI - edit semantic.toml to improve this)
grain: one row per EIP712DomainChanged() event
columns:
clm_manager__initialized - `Initialized(uint8)` events emitted by the `clm_manager` contract. (seeded from the ABI - edit semantic.toml to improve this)
grain: one row per Initialized(uint8) event
columns: version (uint8)
clm_manager__ownership_transferred - `OwnershipTransferred(address,address)` events emitted by the `clm_manager` contract. (seeded from the ABI - edit semantic.toml to improve this)
grain: one row per OwnershipTransferred(address,address) event
columns: previousOwner (address), newOwner (address)
clm_manager__transfer - `Transfer(address,address,uint256)` events emitted by the `clm_manager` 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
clm_manager__withdraw - `Withdraw(address,uint256,uint256,uint256)` events emitted by the `clm_manager` contract. (seeded from the ABI - edit semantic.toml to improve this)
grain: one row per Withdraw(address,uint256,uint256,uint256) event
columns: user (address), shares (uint256), amount0 (uint256), amount1 (uint256)
⚠ reserved-word columns - double-quote them: "user"
⚠ big-int columns (exact text; SUM/AVG of `_dec` is the values that fit, and WHERE NOT _overflow is that same sum): shares → shares_dec, amount0 → amount0_dec, amount1 → amount1_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: shares, amount0, amount1
clm_manager_factory__proxy_created - `ProxyCreated(address)` events emitted by the `clm_manager_factory` contract. (seeded from the ABI - edit semantic.toml to improve this)
grain: one row per ProxyCreated(address) event
columns: proxy (address)
reward_pool__add_reward - `AddReward(address)` events emitted by the `reward_pool` contract. (seeded from the ABI - edit semantic.toml to improve this)
grain: one row per AddReward(address) event
columns: reward (address)
reward_pool__approval - `Approval(address,address,uint256)` events emitted by the `reward_pool` 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
reward_pool__initialized - `Initialized(uint8)` events emitted by the `reward_pool` contract. (seeded from the ABI - edit semantic.toml to improve this)
grain: one row per Initialized(uint8) event
columns: version (uint8)
reward_pool__notify_reward - `NotifyReward(address,uint256,uint256)` events emitted by the `reward_pool` contract. (seeded from the ABI - edit semantic.toml to improve this)
grain: one row per NotifyReward(address,uint256,uint256) event
columns: reward (address), amount (uint256), duration (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, duration → duration_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, duration
reward_pool__ownership_transferred - `OwnershipTransferred(address,address)` events emitted by the `reward_pool` contract. (seeded from the ABI - edit semantic.toml to improve this)
grain: one row per OwnershipTransferred(address,address) event
columns: previousOwner (address), newOwner (address)
reward_pool__remove_reward - `RemoveReward(address,address)` events emitted by the `reward_pool` contract. (seeded from the ABI - edit semantic.toml to improve this)
grain: one row per RemoveReward(address,address) event
columns: reward (address), recipient (address)
reward_pool__rescue_tokens - `RescueTokens(address,address)` events emitted by the `reward_pool` contract. (seeded from the ABI - edit semantic.toml to improve this)
grain: one row per RescueTokens(address,address) event
columns: token (address), recipient (address)
reward_pool__reward_paid - `RewardPaid(address,address,uint256)` events emitted by the `reward_pool` contract. (seeded from the ABI - edit semantic.toml to improve this)
grain: one row per RewardPaid(address,address,uint256) event
columns: user (address), reward (address), amount (uint256)
⚠ reserved-word columns - double-quote them: "user"
⚠ 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
reward_pool__set_whitelist - `SetWhitelist(address,bool)` events emitted by the `reward_pool` contract. (seeded from the ABI - edit semantic.toml to improve this)
grain: one row per SetWhitelist(address,bool) event
columns: manager (address), whitelist (bool)
reward_pool__staked - `Staked(address,uint256)` events emitted by the `reward_pool` contract. (seeded from the ABI - edit semantic.toml to improve this)
grain: one row per Staked(address,uint256) event
columns: user (address), amount (uint256)
⚠ reserved-word columns - double-quote them: "user"
⚠ 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
reward_pool__transfer - `Transfer(address,address,uint256)` events emitted by the `reward_pool` 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
reward_pool__withdrawn - `Withdrawn(address,uint256)` events emitted by the `reward_pool` contract. (seeded from the ABI - edit semantic.toml to improve this)
grain: one row per Withdrawn(address,uint256) event
columns: user (address), amount (uint256)
⚠ reserved-word columns - double-quote them: "user"
⚠ 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
reward_pool_factory__instance_upgraded - `InstanceUpgraded(string,address)` events emitted by the `reward_pool_factory` contract. (seeded from the ABI - edit semantic.toml to improve this)
grain: one row per InstanceUpgraded(string,address) event
columns: RewardPoolName (string), newImplementation (address)
reward_pool_factory__new_reward_pool_added - `NewRewardPoolAdded(string,address)` events emitted by the `reward_pool_factory` contract. (seeded from the ABI - edit semantic.toml to improve this)
grain: one row per NewRewardPoolAdded(string,address) event
columns: rewardPoolName (string), implementation (address)
reward_pool_factory__ownership_transferred - `OwnershipTransferred(address,address)` events emitted by the `reward_pool_factory` contract. (seeded from the ABI - edit semantic.toml to improve this)
grain: one row per OwnershipTransferred(address,address) event
columns: previousOwner (address), newOwner (address)
reward_pool_factory__proxy_created_00ff - `ProxyCreated(address)` events emitted by the `reward_pool_factory` contract. (seeded from the ABI - edit semantic.toml to improve this)
grain: one row per ProxyCreated(address) event
columns: proxy (address)
reward_pool_factory__proxy_created_3699 - `ProxyCreated(string,address)` events emitted by the `reward_pool_factory` contract. (seeded from the ABI - edit semantic.toml to improve this)
grain: one row per ProxyCreated(string,address) event
columns: rewardPoolName (string), proxy (address)
reward_pool_factory__reward_pool_is_immutable - `RewardPoolIsImmutable(string)` events emitted by the `reward_pool_factory` contract. (seeded from the ABI - edit semantic.toml to improve this)
grain: one row per RewardPoolIsImmutable(string) event
columns: rewardPoolName (string)
reward_pool_factory__set_keeper - `SetKeeper(address)` events emitted by the `reward_pool_factory` contract. (seeded from the ABI - edit semantic.toml to improve this)
grain: one row per SetKeeper(address) event
columns: keeper (address)
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.