Transactions
Table Columns
Unique Key: hash
| Column Name | Data Type | Description |
|---|---|---|
| hash | VARCHAR | Unique identifier of a transaction. |
| transaction_index | BIGINT | The position of this transaction in the block that it belongs to. The first transaction has index 0. |
| sender_address | VARCHAR | The address of the account that sent the transaction. |
| nonce | BIGINT | The transaction nonce, unique to the wallet |
| type | VARCHAR | The type of transaction |
| execution_status | VARCHAR | The execution status of the transaction |
| finality_status | VARCHAR | The finality status of the transaction |
| messages_sent | VARIANT | Array of messages sent by this transaction. |
| revert_reason | VARCHAR | The reason for transaction revert, if applicable. |
| receipt_type | VARCHAR | The type of transaction receipt. |
| account_deployment_data | VARIANT | Data related to account deployment, if this is a deploy transaction. |
| calldata | VARIANT | The calldata passed to the transaction. |
| paymaster_data | VARIANT | Data related to paymaster functionality, if used. |
| actual_fee_amount | BIGINT | The actual fee amount paid for the transaction. |
| actual_fee_unit | VARCHAR | The unit of the actual fee (e.g., ‘WEI’, ‘FRI’). |
| receipt_l1_data_gas | BIGINT | The L1 data gas consumed by this transaction. |
| receipt_l1_gas | BIGINT | The L1 gas consumed by this transaction. |
| receipt_l2_gas | BIGINT | The L2 gas consumed by this transaction. |
| max_fee | BIGINT | The maximum fee the sender is willing to pay. |
| l1_data_gas_max_amount | BIGINT | The maximum L1 data gas amount the sender is willing to consume. |
| l1_data_gas_max_price_per_unit | BIGINT | The maximum price per unit for L1 data gas. |
| l1_gas_max_amount | BIGINT | The maximum L1 gas amount the sender is willing to consume. |
| l1_gas_max_price_per_unit | BIGINT | The maximum price per unit for L1 gas. |
| l2_gas_max_amount | BIGINT | The maximum L2 gas amount the sender is willing to consume. |
| l2_gas_max_price_per_unit | BIGINT | The maximum price per unit for L2 gas. |
| signature | VARIANT | The transaction signature(s). |
| tip | BIGINT | The tip amount paid to the sequencer. |
| fee_data_availability_mode | VARCHAR | The data availability mode for fee payment. |
| nonce_data_availability_mode | VARCHAR | The data availability mode for nonce. |
| class_hash | VARCHAR | The hash of the contract class being declared or deployed. |
| contract_address | VARCHAR | The address of the deployed contract, if applicable. |
| contract_address_salt | VARCHAR | The salt used for contract address calculation. |
| constructor_calldata | VARIANT | The calldata passed to the constructor during deployment. |
| entry_point_selector | VARCHAR | The entry point selector for the function being called. |
| compiled_class_hash | VARCHAR | The hash of the compiled contract class. |
| version | BIGINT | The transaction version. |
| event_count | BIGINT | Number of events emitted by this transaction. |
| l1_message_count | BIGINT | Number of L1 messages sent by this transaction. |
| l2_message_count | BIGINT | Number of L2 messages sent by this transaction. |
| block_hash | VARCHAR | Unique identifier of the block that includes this transaction. |
| block_number | BIGINT | The length of the chain, in blocks. |
| block_timestamp | TIMESTAMP_NTZ(9) | The time when the block that contains this transaction was included on the blockchain. |
| _created_at | TIMESTAMP_NTZ(9) | Timestamp of the entry creation. |
| _updated_at | TIMESTAMP_NTZ(9) | Timestamp of the entry update. |
Transactions
Table Columns
Unique Key: hash
| Column Name | Data Type | Description |
|---|---|---|
| hash | VARCHAR | Unique identifier of a transaction. |
| transaction_index | BIGINT | The position of this transaction in the block that it belongs to. The first transaction has index 0. |
| sender_address | VARCHAR | The address of the account that sent the transaction. |
| nonce | BIGINT | The transaction nonce, unique to the wallet |
| type | VARCHAR | The type of transaction |
| execution_status | VARCHAR | The execution status of the transaction |
| finality_status | VARCHAR | The finality status of the transaction |
| messages_sent | VARIANT | Array of messages sent by this transaction. |
| revert_reason | VARCHAR | The reason for transaction revert, if applicable. |
| receipt_type | VARCHAR | The type of transaction receipt. |
| account_deployment_data | VARIANT | Data related to account deployment, if this is a deploy transaction. |
| calldata | VARIANT | The calldata passed to the transaction. |
| paymaster_data | VARIANT | Data related to paymaster functionality, if used. |
| actual_fee_amount | BIGINT | The actual fee amount paid for the transaction. |
| actual_fee_unit | VARCHAR | The unit of the actual fee (e.g., ‘WEI’, ‘FRI’). |
| receipt_l1_data_gas | BIGINT | The L1 data gas consumed by this transaction. |
| receipt_l1_gas | BIGINT | The L1 gas consumed by this transaction. |
| receipt_l2_gas | BIGINT | The L2 gas consumed by this transaction. |
| max_fee | BIGINT | The maximum fee the sender is willing to pay. |
| l1_data_gas_max_amount | BIGINT | The maximum L1 data gas amount the sender is willing to consume. |
| l1_data_gas_max_price_per_unit | BIGINT | The maximum price per unit for L1 data gas. |
| l1_gas_max_amount | BIGINT | The maximum L1 gas amount the sender is willing to consume. |
| l1_gas_max_price_per_unit | BIGINT | The maximum price per unit for L1 gas. |
| l2_gas_max_amount | BIGINT | The maximum L2 gas amount the sender is willing to consume. |
| l2_gas_max_price_per_unit | BIGINT | The maximum price per unit for L2 gas. |
| signature | VARIANT | The transaction signature(s). |
| tip | BIGINT | The tip amount paid to the sequencer. |
| fee_data_availability_mode | VARCHAR | The data availability mode for fee payment. |
| nonce_data_availability_mode | VARCHAR | The data availability mode for nonce. |
| class_hash | VARCHAR | The hash of the contract class being declared or deployed. |
| contract_address | VARCHAR | The address of the deployed contract, if applicable. |
| contract_address_salt | VARCHAR | The salt used for contract address calculation. |
| constructor_calldata | VARIANT | The calldata passed to the constructor during deployment. |
| entry_point_selector | VARCHAR | The entry point selector for the function being called. |
| compiled_class_hash | VARCHAR | The hash of the compiled contract class. |
| version | BIGINT | The transaction version. |
| event_count | BIGINT | Number of events emitted by this transaction. |
| l1_message_count | BIGINT | Number of L1 messages sent by this transaction. |
| l2_message_count | BIGINT | Number of L2 messages sent by this transaction. |
| block_hash | VARCHAR | Unique identifier of the block that includes this transaction. |
| block_number | BIGINT | The length of the chain, in blocks. |
| block_timestamp | TIMESTAMP_NTZ(9) | The time when the block that contains this transaction was included on the blockchain. |
| _created_at | TIMESTAMP_NTZ(9) | Timestamp of the entry creation. |
| _updated_at | TIMESTAMP_NTZ(9) | Timestamp of the entry update. |