Enriched Transactions
Chain
Zora SepoliaDataset name
zora_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_0xcd141f0ccef013c206b69513f9d085b8676fa00250edec6936395b70bcb83f27_0 | 0xb1c1427860c8930cfd3f9963d7300a0494e2d26fe08cf2c5e13f3ebd6863ade2 | 21 | 0xcd141f0ccef013c206b69513f9d085b8676fa00250edec6936395b70bcb83f27 | 22 | 0 | 0xdeaddeaddeaddeaddeaddeaddeaddeaddead0001 | 0x4200000000000000000000000000000000000015 | 0 | 0x015d8eb900000000000000000000000000000000000000000000000000000000004565cb000000000000000000000000000000000000000000000000000000006536a528000000000000000000000000000000000000000000000000000000000000000eda0d4cfe3bf52b82547479b9fd1154a19c379a23bfe311dc92c047202dd72bf500000000000000000000000000000000000000000000000000000000000000040000000000000000000000003cd868e221a3be64b161d596a7482257a99d857f00000000000000000000000000000000000000000000000000000000000000bc00000000000000000000000000000000000000000000000000000000000a6fe0 | null | null | 126 | 1698080048 | null | 1 | null | null | null | null | null | null | null | null | null | null | null | null | null | null | |||||
| enriched_transaction_v2_0x05e804ce2b7e0b4b01560803cd00362f249a25a4cf067e21152611731da47fc0_0 | 0x636e20f7cbcaf6073f77cf3a5e8f489444ebebeafd216d867c5dcff06d84d701 | 53 | 0x05e804ce2b7e0b4b01560803cd00362f249a25a4cf067e21152611731da47fc0 | 54 | 0 | 0xdeaddeaddeaddeaddeaddeaddeaddeaddead0001 | 0x4200000000000000000000000000000000000015 | 0 | 0x015d8eb900000000000000000000000000000000000000000000000000000000004565d0000000000000000000000000000000000000000000000000000000006536a5700000000000000000000000000000000000000000000000000000000000000011a20057af76f5a1fd236e41b9c991f93c0917e9c31bdab533109b64cac88e29e100000000000000000000000000000000000000000000000000000000000000000000000000000000000000003cd868e221a3be64b161d596a7482257a99d857f00000000000000000000000000000000000000000000000000000000000000bc00000000000000000000000000000000000000000000000000000000000a6fe0 | null | null | 126 | 1698080112 | null | 1 | null | null | null | null | null | null | null | null | null | null | null | null | null | null | |||||
| enriched_transaction_v2_0xc51f1ac2f6b195e93785209d6f063d01d7f26ca2917e956b27208af3a3967252_0 | 0xcc211de12dbfc5e0fbb069d2d910af5148d8b50a1988e4fb6ef1b86758d8dcf7 | 87 | 0xc51f1ac2f6b195e93785209d6f063d01d7f26ca2917e956b27208af3a3967252 | 88 | 0 | 0xdeaddeaddeaddeaddeaddeaddeaddeaddead0001 | 0x4200000000000000000000000000000000000015 | 0 | 0x015d8eb900000000000000000000000000000000000000000000000000000000004565d5000000000000000000000000000000000000000000000000000000006536a5ac000000000000000000000000000000000000000000000000000000000000000f97140c8bc54db1165c1dc37bf76336e3f20dca27eb169db94e480ae1d8303e2a00000000000000000000000000000000000000000000000000000000000000040000000000000000000000003cd868e221a3be64b161d596a7482257a99d857f00000000000000000000000000000000000000000000000000000000000000bc00000000000000000000000000000000000000000000000000000000000a6fe0 | null | null | 126 | 1698080180 | 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 |