Enriched Transactions
Chain
RedstoneDataset name
redstone.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_0xa54dc010430c7394bc4b7d961e894d1db032a23bb2d585f0b2645e0d0188a192_0 | 0xee66952bf08b49ef13fae33d0c8ff014b19f741f60f4739b288a3d0ad34167cb | 4 | 0xa54dc010430c7394bc4b7d961e894d1db032a23bb2d585f0b2645e0d0188a192 | 4 | 0 | 0xdeaddeaddeaddeaddeaddeaddeaddeaddead0001 | 0x4200000000000000000000000000000000000015 | 0 | 0x440a5e2000001def00000000000000000000000400000000660ddf0300000000012abe06000000000000000000000000000000000000000000000000000000054d326c210000000000000000000000000000000000000000000000000000000049026da0b9ec694afdde2e2ed661ed8ec56dace5cf8723801342fa1229e693f2a98af672000000000000000000000000a31cb9bc414601171d4537580f98f66c03aecd43 | null | null | 126 | 1712185099 | null | 1 | null | null | null | null | null | null | null | null | null | null | null | null | null | null | |||||
| enriched_transaction_v2_0x955f2fd4e6a6647b21972288efda243bf172f229b88eaaa1268b9c4e84dffced_0 | 0xda645619a8b52db53dc7540674639cb1a6bbc9ffe9f2ab35246d965906334f27 | 8 | 0x955f2fd4e6a6647b21972288efda243bf172f229b88eaaa1268b9c4e84dffced | 8 | 0 | 0xdeaddeaddeaddeaddeaddeaddeaddeaddead0001 | 0x4200000000000000000000000000000000000015 | 0 | 0x440a5e2000001def00000000000000000000000200000000660ddf0f00000000012abe0700000000000000000000000000000000000000000000000000000005bde8ecc60000000000000000000000000000000000000000000000000000000040e5b6b81f67f5189b0a241f830b16b1d29abd504fb62df88b080d6aa1da8834cc4a38c9000000000000000000000000a31cb9bc414601171d4537580f98f66c03aecd43 | null | null | 126 | 1712185107 | null | 1 | null | null | null | null | null | null | null | null | null | null | null | null | null | null | |||||
| enriched_transaction_v2_0x722fa89617a80b6dd3017c479b877b73eee10fbe9df22fb1a54c0aa9fd34971a_0 | 0x051a01b87d4f32e01d7499d91e7b54c678e1a6a16107e67b769f9ffb432b87d6 | 11 | 0x722fa89617a80b6dd3017c479b877b73eee10fbe9df22fb1a54c0aa9fd34971a | 11 | 0 | 0xdeaddeaddeaddeaddeaddeaddeaddeaddead0001 | 0x4200000000000000000000000000000000000015 | 0 | 0x440a5e2000001def00000000000000000000000500000000660ddf0f00000000012abe0700000000000000000000000000000000000000000000000000000005bde8ecc60000000000000000000000000000000000000000000000000000000040e5b6b81f67f5189b0a241f830b16b1d29abd504fb62df88b080d6aa1da8834cc4a38c9000000000000000000000000a31cb9bc414601171d4537580f98f66c03aecd43 | null | null | 126 | 1712185113 | 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 |