Enriched Transactions
Chain
ShapeDataset name
shape.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_0x32f45c36bfce2b52605ab35ecf76bad29c4d64fc1d10773120f2453c981127d3_0 | 0x5745d4244bd8af5889157e12d20178ecbb1c4fb1c9c61894dfc0b4f55e6d4725 | 26 | 0x32f45c36bfce2b52605ab35ecf76bad29c4d64fc1d10773120f2453c981127d3 | 26 | 0 | 0xdeaddeaddeaddeaddeaddeaddeaddeaddead0001 | 0x4200000000000000000000000000000000000015 | 0 | 0x440a5e20000a6fe000000000000000000000000200000000669fbc87000000000136d185000000000000000000000000000000000000000000000000000000024074cf0b000000000000000000000000000000000000000000000000000000000000000139c5c39d44907e00ce8b2e2d12aa0cc7c89bc0a2a47422e8c532abaefffb91e7000000000000000000000000f7ca543d652e38692fd12f989eb55b5327ec9a20 | null | null | 126 | 1721744523 | null | 1 | null | null | null | null | null | null | null | null | null | null | null | null | null | null | |||||
| enriched_transaction_v2_0xd3d69b7551d63bfe7b6c2b327121df5b2ba5f2af35e273bd49dc3b0e298233a1_0 | 0x89c02f9a2df51b3b6044359ce280487950e0a1082f29fae0d30e1d3dfc9761aa | 33 | 0xd3d69b7551d63bfe7b6c2b327121df5b2ba5f2af35e273bd49dc3b0e298233a1 | 33 | 0 | 0xdeaddeaddeaddeaddeaddeaddeaddeaddead0001 | 0x4200000000000000000000000000000000000015 | 0 | 0x440a5e20000a6fe000000000000000000000000300000000669fbc93000000000136d186000000000000000000000000000000000000000000000000000000022f67527e00000000000000000000000000000000000000000000000000000000000000010ad7e67f6fe395b0db83705d3fd4fa2912b77d0e2e907fe91c93b1212d6e5c4b000000000000000000000000f7ca543d652e38692fd12f989eb55b5327ec9a20 | null | null | 126 | 1721744537 | null | 1 | null | null | null | null | null | null | null | null | null | null | null | null | null | null | |||||
| enriched_transaction_v2_0x188ec7b01cbadb50071e2d722de20166e079b5a91dc68b417543bacb50425995_0 | 0x69b2cb5eed1a9720e897a17e74100f9298760d5e0cf89d853ecb4916c8c97b18 | 38 | 0x188ec7b01cbadb50071e2d722de20166e079b5a91dc68b417543bacb50425995 | 38 | 0 | 0xdeaddeaddeaddeaddeaddeaddeaddeaddead0001 | 0x4200000000000000000000000000000000000015 | 0 | 0x440a5e20000a6fe000000000000000000000000200000000669fbc9f000000000136d1870000000000000000000000000000000000000000000000000000000220065e340000000000000000000000000000000000000000000000000000000000000001471b85c7035b268f2649ba2a98d6af893d28973cca8d870f6b0eb01ab4ca7f0f000000000000000000000000f7ca543d652e38692fd12f989eb55b5327ec9a20 | null | null | 126 | 1721744547 | 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 |