Enriched Transactions
Chain
Shape SepoliaDataset name
shape_sepolia.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_0x04c0e96adca0884590d597408ff05efb47f0f9e5fb1ed3a603bb5da1b3a72a9a_0 | 0x35a94473d9ddd01fd34c277b1c5f004cf7af83f983f6faa3beb583c1d8f24f39 | 349184 | 0x04c0e96adca0884590d597408ff05efb47f0f9e5fb1ed3a603bb5da1b3a72a9a | 349184 | 0 | 0xdeaddeaddeaddeaddeaddeaddeaddeaddead0001 | 0x4200000000000000000000000000000000000015 | 0 | 0x440a5e2000000558000c5fc5000000000000000900000000667f8a0800000000005ebfae000000000000000000000000000000000000000000000000000000065d4a4f63000000000000000000000000000000000000000000000000000000000000000149f55b28e34815167102c912640523e52100a6586aff027b5d1ea6c451f187a10000000000000000000000006ff556fa7cafec55ae77c5c1d58a010be75f9991 | null | null | 126 | 1719634528 | null | 1 | null | null | null | null | null | null | null | null | null | null | null | null | null | null | |||||
| enriched_transaction_v2_0x38a7fcb7f6dfff2037e9886d30848b89746a281e23896be775d7889d71c9d862_0 | 0xe69d27977c001de3622c7f59f92fb1de34f91cc6769a4abba667ec905232cacb | 349200 | 0x38a7fcb7f6dfff2037e9886d30848b89746a281e23896be775d7889d71c9d862 | 349200 | 0 | 0xdeaddeaddeaddeaddeaddeaddeaddeaddead0001 | 0x4200000000000000000000000000000000000015 | 0 | 0x440a5e2000000558000c5fc5000000000000000100000000667f8a2c00000000005ebfb100000000000000000000000000000000000000000000000000000005fa62c9c000000000000000000000000000000000000000000000000000000000000000015244ab27158a165b26cf0c79704078347620a0b7ab4345dbd4d95098c5856bb50000000000000000000000006ff556fa7cafec55ae77c5c1d58a010be75f9991 | null | null | 126 | 1719634560 | null | 1 | null | null | null | null | null | null | null | null | null | null | null | null | null | null | |||||
| enriched_transaction_v2_0x5ee89b6704d7255bc684340a1208ccaada3465766361fcc224eb8349eac9658e_0 | 0xb166da082143984ecea32d7345eb5f33416e439adf428a9a09033aa0a220c982 | 349260 | 0x5ee89b6704d7255bc684340a1208ccaada3465766361fcc224eb8349eac9658e | 349260 | 0 | 0xdeaddeaddeaddeaddeaddeaddeaddeaddead0001 | 0x4200000000000000000000000000000000000015 | 0 | 0x440a5e2000000558000c5fc5000000000000000100000000667f8ab000000000005ebfbb00000000000000000000000000000000000000000000000000000005ac93bb450000000000000000000000000000000000000000000000000000000000000001fb4473a01732293e5d3931c300773f07876df0f2d05e5c69654fedbc2cd05b2b0000000000000000000000006ff556fa7cafec55ae77c5c1d58a010be75f9991 | null | null | 126 | 1719634680 | 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 |