nuthatch data model
The `mpamm-monad` nest on monad. (seeded from the ABI - edit semantic.toml to improve this)
COVERAGE
sealed_through = 124430818 (rows at or below this block are sealed Parquet);
tip = 124451591 - the `sql` tool reads both the sealed rows and the live tip above them.
first_indexed = 65199911 - no block before it is in this nest.
TABLES (one per contract event; query via the `sql` tool)
capricorn_factory__pool_created - `PoolCreated(address,address,uint256,address)` events emitted by the `capricorn_factory` contract. (seeded from the ABI - edit semantic.toml to improve this)
grain: one row per PoolCreated(address,address,uint256,address) event
columns: token0 (address), token1 (address), feeBps (uint256), pool (address)
⚠ big-int columns (exact text; SUM/AVG of `_dec` is the values that fit, and WHERE NOT
_overflow is that same sum): feeBps → feeBps_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: feeBps
capricorn_pool__swap - `Swap(address,address,int256,int256,uint256,uint256)` events emitted by the `capricorn_pool` contract. (seeded from the ABI - edit semantic.toml to improve this)
grain: one row per Swap(address,address,int256,int256,uint256,uint256) event
columns: sender (address), recipient (address), amount0 (int256), amount1 (int256), reserve0 (uint256), reserve1 (uint256)
⚠ big-int columns (exact text; SUM/AVG of `_dec` is the values that fit, and WHERE NOT _overflow is that same sum): amount0 → amount0_dec, amount1 → amount1_dec, reserve0 → reserve0_dec, reserve1 → reserve1_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: amount0, amount1, reserve0, reserve1
metric_v1_factory__pool_created - `PoolCreated(address,address,address,uint256,address,address,address,address[],(uint256,uint256,uint256,uint256,uint256,uint256),uint256,uint256,uint256,uint256,uint24,uint24,uint24,uint24,address,int24,uint256[],uint256[])` events emitted by the `metric_v1_factory` contract. (seeded from the ABI - edit semantic.toml to improve this)
grain: one row per PoolCreated(address,address,address,uint256,address,address,address,address[],(uint256,uint256,uint256,uint256,uint256,uint256),uint256,uint256,uint256,uint256,uint24,uint24,uint24,uint24,address,int24,uint256[],uint256[]) event
columns: poolAddress (address), token0 (address), token1 (address), poolIdx (uint256), factory (address), admin (address), priceProvider (address), extensions (address[]), extensionOrders (tuple), priceProviderTimelock (uint256), initialScaledAmount0PerE18Shares (uint256), initialScaledAmount1PerE18Shares (uint256), minimalOperationalLiquidity (uint256), spreadProtocolFeeE6 (uint24), protocolNotionalFeeE8 (uint24), adminSpreadFeeE6 (uint24), adminNotionalFeeE8 (uint24), adminFeeDestination (address), curBinDistFromProvidedPriceE6 (int24), nonNegativeBinDataArray (uint256[]), negativeBinDataArray (uint256[])
⚠ big-int columns (exact text; SUM/AVG of `_dec` is the values that fit, and WHERE NOT _overflow is that same sum): poolIdx → poolIdx_dec, priceProviderTimelock → priceProviderTimelock_dec, initialScaledAmount0PerE18Shares → initialScaledAmount0PerE18Shares_dec, initialScaledAmount1PerE18Shares → initialScaledAmount1PerE18Shares_dec, minimalOperationalLiquidity → minimalOperationalLiquidity_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: poolIdx, priceProviderTimelock, initialScaledAmount0PerE18Shares, initialScaledAmount1PerE18Shares, minimalOperationalLiquidity
metric_v1_pool__swap - `Swap(address,address,uint256,uint256,uint256)` events emitted by the `metric_v1_pool` contract. (seeded from the ABI - edit semantic.toml to improve this)
grain: one row per Swap(address,address,uint256,uint256,uint256) event
columns: sender (address), recipient (address), details (uint256), amountDeltas (uint256), platformFees (uint256)
⚠ big-int columns (exact text; SUM/AVG of `_dec` is the values that fit, and WHERE NOT _overflow is that same sum): details → details_dec, amountDeltas → amountDeltas_dec, platformFees → platformFees_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: details, amountDeltas, platformFees
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.