Enriched Transactions
Chain
BscDataset name
bsc.raw_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 | receipt_root_hash | receipt_l1_fee | receipt_l1_gas_used | receipt_l1_gas_price | receipt_l1_fee_scalar |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| enriched_transaction_0x597e5ddfac9ffef7aec477092d0b72af04da5ee26a907342e4e784c8be930f4f_50 | 0xca53751fa1daabca55de67d011b4f2f1012d98c6c85e7fc5a76cc77999c1143f | 7 | 0x597e5ddfac9ffef7aec477092d0b72af04da5ee26a907342e4e784c8be930f4f | 38294940 | 50 | 0x09e1f5e2b882d1449a620556a04b5328da3b38d2 | 0x5350265d385f9ce98b939e1121b328b88f2d90a3 | 0 | 67458 | 1000000000 | 0x3ec862a800000000000000000000000009e1f5e2b882d1449a620556a04b5328da3b38d2 | 1000000000 | 1000000000 | 2 | 1714427289 | 3168259 | 67458 | null | 1 | 1000000000 | null | null | null | null | null | null |
| enriched_transaction_0x597e5ddfac9ffef7aec477092d0b72af04da5ee26a907342e4e784c8be930f4f_120 | 0x3903842034ef1761331f076f71a9ca846c7f2294e261fda6e3d7737a329c6ab0 | 80159 | 0x597e5ddfac9ffef7aec477092d0b72af04da5ee26a907342e4e784c8be930f4f | 38294940 | 120 | 0x000000000e9e87cb030a951f10062810bdc1b117 | 0x000000001e40580f5b3018f809caba27f9740f09 | 0 | 250000 | 0 | 0x94655f2be9e7cea3dedca5984780bafc599bd69add087d56000000000000000000000000000000000000000000000000000602eab0c60231020248559cafb2da140bf9a228b930a5c2946d43ab6a49dd41bb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c000f404c271001029961315bab1da4726c37b39b4ce250686bf02c130e09fabb73bd3ade0a17ecc321fd13a19e81ce82000f387c27100000 | null | null | 0 | 1714427289 | 12823265 | 186445 | null | 1 | 0 | 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 | long |
| receipt_root_hash | string |
| receipt_l1_fee | decimal |
| receipt_l1_gas_used | decimal |
| receipt_l1_gas_price | decimal |
| receipt_l1_fee_scalar | double |