Enriched Transactions
Chain
Abstract TestnetDataset name
abstract_testnet.receipt_transactionsVersion
1.0.0Description
Transaction data including input, value, from and to address, and metadata for the block, gas, and receipts.
Example data
| id | hash | nonce | block_hash | block_number | transaction_index | from_address | to_address | value | gas | gas_price | input | max_fee_per_gas | max_priority_fee_per_gas | transaction_type | block_timestamp | receipt_cumulative_gas_used | receipt_gas_used | receipt_contract_address | receipt_status | receipt_effective_gas_price | receipt_root_hash | receipt_l1_fee | receipt_l1_gas_used | receipt_l1_gas_price | receipt_l1_fee_scalar | receipt_l1_blob_base_fee | receipt_l1_blob_base_fee_scalar | blob_versioned_hashes | max_fee_per_blob_gas | receipt_l1_block_number | receipt_l1_base_fee_scalar | gateway_fee | fee_currency | gateway_fee_recipient |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| enriched_transaction_v2_0xfbb449463d9f1ec874d597d80d911f60857cc2fbf93f8ac83c70f8cfa2220a74_1 | 0xd293d83ab69850755eed7eb92883dba2368411c9efa7298425603c0fb4b1a4ae | 0 | 0xfbb449463d9f1ec874d597d80d911f60857cc2fbf93f8ac83c70f8cfa2220a74 | 1 | 1 | 0xd64e136566a9e04eb05b30184ff577f52682d182 | 0x0000000000000000000000000000000000000000 | 0 | 0 | 0x | 0 | 255 | 1718635197 | 0 | null | 1 | 0 | 0xfbb449463d9f1ec874d597d80d911f60857cc2fbf93f8ac83c70f8cfa2220a74 | null | null | null | null | null | null | null | null | null | null | null | null | null | |||
| enriched_transaction_v2_0xfbb449463d9f1ec874d597d80d911f60857cc2fbf93f8ac83c70f8cfa2220a74_3 | 0xac0e4cc5e7dcc0274281ea35cf89cbfbea83383a87914db9e781410049e47006 | 0 | 0xfbb449463d9f1ec874d597d80d911f60857cc2fbf93f8ac83c70f8cfa2220a74 | 1 | 3 | 0xd64e136566a9e04eb05b30184ff577f52682d182 | 0x0000000000000000000000000000000000008006 | 0 | 0 | 0x3cda335100000000000000000000000000000000000000000000000000000000000000000100015d49d29767b868317d524a1ef8985652932d4be89964953a01931026c9000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000001200000000000000000000000007c3386e35f3bc7e84183a4e87dddafe7d5253cac0000000000000000000000004a8ba1340b514cb3ef8f474db72b7e62c915ad7400000000000000000000000000000000000000000000000000000000000000600000000000000000000000000000000000000000000000000000000000000084a31ee5b00000000000000000000000003e8b2fe58675126ed30d0d12dea2a9bda72d18ae0000000000000000000000002ae09702f77a4940621572fbcdae2382d44a2cba010001211b0c33353cdf7a320f768e3dc40bce1326d639fcac099bba9ecd8e340000000000000000000000004a8ba1340b514cb3ef8f474db72b7e62c915ad7400000000000000000000000000000000000000000000000000000000 | 0 | 255 | 1718635197 | 0 | 0xec089e40c40b12dd4577e0c5381d877b613040ec | 1 | 0 | 0xfbb449463d9f1ec874d597d80d911f60857cc2fbf93f8ac83c70f8cfa2220a74 | null | null | null | null | null | null | null | null | null | null | null | null | null | |||
| enriched_transaction_v2_0x63d461094de5ab8f2a9d205e9919e41bd70540a720916a996eac7187e5d34640_0 | 0x42de9f8d315175b237fdb90f126aff8c05c044367ddedc7e161ca15728d5f9a5 | 2 | 0x63d461094de5ab8f2a9d205e9919e41bd70540a720916a996eac7187e5d34640 | 15 | 0 | 0xe85b66fca403bc35bcae17ce7758e942aea65dc0 | 0xe85b66fca403bc35bcae17ce7758e942aea65dc0 | 0 | 0 | 0 | 0x | 0 | 0 | 0 | 1718726061 | 0 | null | 1 | 0 | 0x63d461094de5ab8f2a9d205e9919e41bd70540a720916a996eac7187e5d34640 | null | null | null | null | null | null | null | null | null | null | null | null | null |
Schema
| Column | Type |
|---|---|
| id | string |
| hash | string |
| nonce | long |
| block_hash | string |
| block_number | long |
| transaction_index | long |
| from_address | string |
| to_address | string |
| value | decimal |
| gas | decimal |
| gas_price | decimal |
| input | string |
| max_fee_per_gas | decimal |
| max_priority_fee_per_gas | decimal |
| transaction_type | long |
| block_timestamp | long |
| receipt_cumulative_gas_used | decimal |
| receipt_gas_used | decimal |
| receipt_contract_address | string |
| receipt_status | long |
| receipt_effective_gas_price | decimal |
| receipt_root_hash | string |
| receipt_l1_fee | decimal |
| receipt_l1_gas_used | decimal |
| receipt_l1_gas_price | decimal |
| receipt_l1_fee_scalar | double |
| receipt_l1_blob_base_fee | decimal |
| receipt_l1_blob_base_fee_scalar | long |
| blob_versioned_hashes | array |
| max_fee_per_blob_gas | decimal |
| receipt_l1_block_number | long |
| receipt_l1_base_fee_scalar | long |
| gateway_fee | long |
| fee_currency | string |
| gateway_fee_recipient | string |