canton.core Table: fact_round_closes Type: Base Table
What
Description
Tracks SummarizingMiningRound contract creation events, representing when mining rounds close and summarize their results. Contains issuance configuration, reward caps, and amulet price information.Key Use Cases
- Monitoring mining round lifecycle (closing/summary phase)
- Analyzing issuance configuration per round
- Understanding reward percentage allocations
- Tracking amulet price at round close
- Monitoring reward caps for different participant types
Important Relationships
- Counterpart to
core__fact_round_opens(same round_number, different phases) - Amulet price links to various reward calculations
- Issuance config drives reward distribution
Commonly-used Fields
round_number: Sequential round identifieramulet_to_issue_per_year: Annual issuance targetvalidator_reward_percentage: Percentage allocated to validatorsapp_reward_percentage: Percentage allocated to appsvalidator_reward_cap: Maximum validator rewardsfeatured_app_reward_cap: Maximum featured app rewardsunfeatured_app_reward_cap: Maximum unfeatured app rewardsamulet_price_usd: USD price of amulet at round closetick_duration_microseconds: Duration of each tick in the round
Columns
| Column Name | Data Type | Description |
|---|---|---|
| UPDATE_ID | TEXT | UPDATE_ID column |
| MIGRATION_ID | NUMBER | MIGRATION_ID column |
| RECORD_TIME | TIMESTAMP_NTZ | RECORD_TIME column |
| EFFECTIVE_AT | TIMESTAMP_NTZ | EFFECTIVE_AT column |
| EVENT_ID | TEXT | EVENT_ID column |
| EVENT_INDEX | NUMBER | EVENT_INDEX column |
| ROUND_NUMBER | NUMBER | ROUND_NUMBER column |
| AMULET_TO_ISSUE_PER_YEAR | NUMBER | AMULET_TO_ISSUE_PER_YEAR column |
| VALIDATOR_REWARD_PERCENTAGE | NUMBER | VALIDATOR_REWARD_PERCENTAGE column |
| APP_REWARD_PERCENTAGE | NUMBER | APP_REWARD_PERCENTAGE column |
| VALIDATOR_REWARD_CAP | NUMBER | VALIDATOR_REWARD_CAP column |
| FEATURED_APP_REWARD_CAP | NUMBER | FEATURED_APP_REWARD_CAP column |
| UNFEATURED_APP_REWARD_CAP | NUMBER | UNFEATURED_APP_REWARD_CAP column |
| VALIDATOR_FAUCET_CAP | NUMBER | VALIDATOR_FAUCET_CAP column |
| AMULET_PRICE_USD | NUMBER | AMULET_PRICE_USD column |
| TICK_DURATION_MICROSECONDS | NUMBER | TICK_DURATION_MICROSECONDS column |
| DSO_PARTY | TEXT | DSO_PARTY column |
| EVENT_TYPE | TEXT | EVENT_TYPE column |
| CONTRACT_ID | TEXT | CONTRACT_ID column |
| PACKAGE_NAME | TEXT | PACKAGE_NAME column |
| TEMPLATE_ID | TEXT | TEMPLATE_ID column |
| CREATED_AT | TIMESTAMP_NTZ | CREATED_AT column |
| SIGNATORIES | VARIANT | SIGNATORIES column |
| OBSERVERS | VARIANT | OBSERVERS column |
| ISSUANCE_CONFIG | VARIANT | ISSUANCE_CONFIG column |
| EVENT_JSON | VARIANT | EVENT_JSON column |
| FACT_MINING_ROUND_ID | TEXT | FACT_MINING_ROUND_ID column |
| INSERTED_TIMESTAMP | TIMESTAMP_NTZ | INSERTED_TIMESTAMP column |
| MODIFIED_TIMESTAMP | TIMESTAMP_NTZ | MODIFIED_TIMESTAMP column |