| TRANSACTION_HASH | TEXT | Unique identifier for the transaction |
| TIMESTAMP | TIMESTAMP_NTZ | Timestamp of the transaction |
| TYPE | TEXT | Type of transaction (e.g. import, export, reward, etc.) |
| BLOCK_HASH | TEXT | Hash of the block containing the transaction |
| BLOCK_INDEX | NUMBER | Index of the block in which the transaction occured |
| BLOCK_HEIGHT | NUMBER | Height of the block in the blockchain |
| MEMO | TEXT | Optional memo associated with the transaction |
| FEE | NUMBER | Minimum amount of nAVAX that must be burned for a transaction to be accepted |
| SOURCE_CHAIN | TEXT | Source chain for cross-chain transactions |
| DESTINATION_CHAIN | TEXT | Destination chain for cross-chain transactions |
| REWARDED | BOOLEAN | Indicates if the transaction earned staking rewards |
| POTENTIAL_REWARD | NUMBER | Potential reward amount for staking transactions |
| SUBNET_ID | TEXT | Subnet ID associated with the transaction |
| START_TIME | TIMESTAMP_NTZ | Timestamp of the start of the transaction |
| END_TIME | TIMESTAMP_NTZ | Timestamp of the end of the transaction |
| METADATA | TEXT | Metadata associated with the transaction |
| BYTES | BINARY | Binary data associated with the transaction |
| LAST_UPDATED | TIMESTAMP_NTZ | Timestamp of the last update to this record |
| LOAD_TIMESTAMP | TIMESTAMP_NTZ | Timestamp when data was loaded into Snowflake |
| IS_LINEAR | BOOLEAN | Indicates if the transaction is linear |
| TX_BLOCK_POSITION | NUMBER | Position of the transaction in the block |
| REMOVAL_TIME | TIMESTAMP_NTZ | Timestamp of the removal of the validator |
| REMOVAL_TX_HASH | TEXT | Hash of the removal transaction |
| STAKING_TX_HASH | TEXT | Hash of the staking transaction |
| NODE_ID | TEXT | Validator node ID associated with staking transactions |
| REWARD_ADDRESSES | VARIANT | List of addresses receiving staking rewards |
| L1_VALIDATOR_REMAINING_BALANCE_OWNER_BYTES | BINARY | Binary representation of the remaining balance owner |
| L1_MANAGER_BLOCKCHAIN_ID | TEXT | Blockchain ID of the L1 manager |
| L1_MANAGER_CONTRACT_ADDRESS | TEXT | Address of the L1 manager contract |
| L1_VALIDATION_ID | TEXT | Unique identifier for an Avalanche L1 Valdiator (not primary network) |
| L1_VALIDATOR_IS_ACTIVE | BOOLEAN | Indicates if the validator is currently active |
| L1_VALIDATOR_PAYG_BALANCE | NUMBER | Registered Avalanche L1 Validator (not primary network) pay-as-you-go balance in the transaction |
| L1_VALIDATOR_WEIGHT | NUMBER | Stake weight of the validator |
| L1_VALIDATOR_END_ACCUMULATED_FEE | NUMBER | The value of the accrued fee for a given L1 Validator when its full balance has been reached. |
| L1_VALIDATOR_ACCRUED_FEES | NUMBER | A fee counter that applies to the balance of all active Avalanche L1 Validators (non-primary network) |
| L1_VALIDATOR_ACTIVE_COUNT | NUMBER | Active validators at the time of transaction |
| GAS_USED | NUMBER | The total amount of gas or computational units expended by a transaction. Data provided post Etna Upgrade (12/16/24) |
