Enriched Transactions
Chain
EthereumDataset name
ethereum.receipt_transactionsVersion
1.2.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_0x6865e8f723cc888be8d567a5c66ad0e98408cb0512c59c7c0586b187701c6c6c_2 | 0xfbc71308e81dcc2b8d156000633108391ac53e194293c3a76db665bafcf17a65 | 4990 | 0x6865e8f723cc888be8d567a5c66ad0e98408cb0512c59c7c0586b187701c6c6c | 20026820 | 2 | 0xa1f4305d4ada78af8f74321fdf93554cc35c1441 | 0x3328f7f4a1d1c57c35df56bbf0c9dcafca309c49 | 0 | 509076 | 59587424756 | 0x75713a0800000000000000000000000030b818b381e5b7fd7172f097a11b3b23656d4403000000000000000000000000c02aaa39b223fe8d0a0e5c4f27ead9083c756cc200000000000000000000000068b3465833fb72a70ecdf485e0e4c7bd8665fc4500000000000000000000000097b824e234c8c001e049f3c85f75a56991658cba00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000c465cc50b7d5a29b9308968f870a4b242a8e18730000000000000000000000000000000000000000000000000000000000000120000000000000000000000000000000000000000000000000000000000000000500000000000000000000000000000000000000000000000000000000000000060000000000000000000000000000000000000000000000000000000000000064000000000000000000000000000000000000000000000000000000000000000100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000006660920f00000000000000000000000000000000000000000000000006107dae12f93188 | 64587424756 | 40000000000 | 2 | 1717604879 | 365954 | 174810 | null | 1 | 59587424756 | null | null | null | null | null | null | null | null | null | null | null | null | null | null |
| enriched_transaction_v2_0x6865e8f723cc888be8d567a5c66ad0e98408cb0512c59c7c0586b187701c6c6c_33 | 0xd6b449c3ca83c2f60039775e2a34d56e6e1442bfebefd1277e04488e8d931408 | 2260036 | 0x6865e8f723cc888be8d567a5c66ad0e98408cb0512c59c7c0586b187701c6c6c | 20026820 | 33 | 0x89e51fa8ca5d66cd220baed62ed01e8951aa7c40 | 0xdac17f958d2ee523a2206206994597c13d831ec7 | 0 | 53497 | 21587424756 | 0x23b872dd00000000000000000000000003b457308d9d1c4df7e2ab9b8514e86e9da8257500000000000000000000000089e51fa8ca5d66cd220baed62ed01e8951aa7c400000000000000000000000000000000000000000000000000000000005f5e100 | 85872859821 | 2000000000 | 2 | 1717604879 | 3871224 | 43694 | null | 1 | 21587424756 | 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 |