Enriched Transactions
Chain
RaceDataset name
race.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_0x16e4bb3711238023ebbe6b1748d400c1969553a1494b4bee9580daf9e57f69a8_0 | 0xa423e37c026a686495d3fffd1bf01ece53dddeed69717144a617fcda77bb4e03 | 2741347 | 0x16e4bb3711238023ebbe6b1748d400c1969553a1494b4bee9580daf9e57f69a8 | 2741348 | 0 | 0xdeaddeaddeaddeaddeaddeaddeaddeaddead0001 | 0x4200000000000000000000000000000000000015 | 0 | 0x440a5e200000044d000a118b00000000000000040000000066df355300000000013c149f00000000000000000000000000000000000000000000000000000001a1b51a0900000000000000000000000000000000000000000000000000000000000000011c26ba4e40da2ef9cf66fa7004f3a9df056bb5a8c4bfa465503bc687d2c7bc020000000000000000000000008cda8351236199af7532bad53d683ddd9b275d89 | null | null | 126 | 1725904287 | null | 1 | null | null | null | null | null | null | null | null | null | null | null | null | null | null | |||||
| enriched_transaction_v2_0x9c679bb152c0c7afebdcfe6d7a3d648ef777e65f7a18c1ac2e69416ca5fb96a0_0 | 0xec91686f4b79220e6ff90c5aea4c09b809de3f9812356d6b37eb6cd457f018c7 | 2741348 | 0x9c679bb152c0c7afebdcfe6d7a3d648ef777e65f7a18c1ac2e69416ca5fb96a0 | 2741349 | 0 | 0xdeaddeaddeaddeaddeaddeaddeaddeaddead0001 | 0x4200000000000000000000000000000000000015 | 0 | 0x440a5e200000044d000a118b00000000000000000000000066df355f00000000013c14a000000000000000000000000000000000000000000000000000000001cb9264b5000000000000000000000000000000000000000000000000000000000000000156f43052bb6c267e0c85f1fdedcb05fd926c6ad18c96588050a45c6ed949bdcc0000000000000000000000008cda8351236199af7532bad53d683ddd9b275d89 | null | null | 126 | 1725904289 | null | 1 | null | null | null | null | null | null | null | null | null | null | null | null | null | null | |||||
| enriched_transaction_v2_0xbdc18ee64120e289fa5d613e4217f28e8cb06ca8fddb1af740fb0476e10909b0_0 | 0xf0633199f5652a94ec629b6ee3f72f40a8e54e4ed6fc988aed06de44d4ffe253 | 2741353 | 0xbdc18ee64120e289fa5d613e4217f28e8cb06ca8fddb1af740fb0476e10909b0 | 2741354 | 0 | 0xdeaddeaddeaddeaddeaddeaddeaddeaddead0001 | 0x4200000000000000000000000000000000000015 | 0 | 0x440a5e200000044d000a118b00000000000000050000000066df355f00000000013c14a000000000000000000000000000000000000000000000000000000001cb9264b5000000000000000000000000000000000000000000000000000000000000000156f43052bb6c267e0c85f1fdedcb05fd926c6ad18c96588050a45c6ed949bdcc0000000000000000000000008cda8351236199af7532bad53d683ddd9b275d89 | null | null | 126 | 1725904299 | null | 1 | null | 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 |