mirror of
https://github.com/FlipsideCrypto/external-models.git
synced 2026-02-06 13:57:17 +00:00
71 lines
2.3 KiB
YAML
71 lines
2.3 KiB
YAML
version: 2
|
||
|
||
models:
|
||
- name: avalanche__fact_p_blocks
|
||
description: "Avalanche P-Chain Blocks. Please visit https://discord.gg/avax for any questions."
|
||
columns:
|
||
- name: L1_VALIDATOR_ACTIVE_COUNT
|
||
description: "Count of active validators on the L1 at the time of block creation"
|
||
|
||
- name: PROPOSER_ID
|
||
description: "Identifier for the entity that proposed the block"
|
||
|
||
- name: PARENT_HASH
|
||
description: "Hash of the parent block in the chain"
|
||
|
||
- name: BLOCK_SIZE
|
||
description: ""
|
||
|
||
- name: TX_COUNT
|
||
description: "Number of transactions included in the block"
|
||
|
||
- name: TYPE
|
||
description: "Type of block (e.g., proposal, commit, abort, etc.)"
|
||
|
||
- name: TIMESTAMP
|
||
description: "Timestamp when the block was produced"
|
||
|
||
- name: BLOCK_INDEX
|
||
description: "Sequential index of the block within the chain"
|
||
|
||
- name: BLOCK_HASH
|
||
description: "Unique identifier (hash) for the block"
|
||
|
||
- name: L1_VALIDATOR_EXCESS_GAS
|
||
description: ""
|
||
|
||
- name: L1_VALIDATOR_ACCRUED_FEES
|
||
description: "A fee counter that applies to the balance of all active Avalanche L1 Validators (non-primary network)"
|
||
|
||
- name: CURRENT_SUPPLY
|
||
description: "Current supply of AVAX (or chain native token) following block issuance (stored as VARCHAR for precision/format reasons)"
|
||
|
||
- name: FEE_STATE_EXCESS
|
||
description: ""
|
||
|
||
- name: FEE_STATE_CAPACITY
|
||
description: ""
|
||
|
||
- name: GAS_PRICE
|
||
description: "Gas price used for transactions within the block"
|
||
|
||
- name: PROPOSER_PARENT_ID
|
||
description: ""
|
||
|
||
- name: PROPOSER_NODE_ID
|
||
description: "Unique node ID of the block proposer"
|
||
|
||
- name: PROPOSER_P_CHAIN_HEIGHT
|
||
description: "The P‑Chain height as reported by the proposer (useful for cross-chain consistency checks)"
|
||
|
||
- name: PROPOSER_TIMESTAMP
|
||
description: "Timestamp recorded by the proposer when creating the block"
|
||
|
||
- name: LAST_UPDATED
|
||
description: "Timestamp of the last update to this record"
|
||
|
||
- name: LOAD_TIMESTAMP
|
||
description: "Timestamp when the block data was loaded into Snowflake"
|
||
|
||
- name: BLOCK_HEIGHT
|
||
description: "Block height on the chain indicating its position in the ledger" |