Enriched Transactions
Chain
Bsc TestnetDataset name
bsc_testnet.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_0xbcd8849a0cb3d89991dae089752870dc35a640549a44f3ec0b344a7fc46efd59_1 | 0x9474d63e36a1760e10c8c5196a4b274efd9def4e620cb133b87c296deae72d5d | 1923701 | 0xbcd8849a0cb3d89991dae089752870dc35a640549a44f3ec0b344a7fc46efd59 | 52975440 | 1 | 0x1fd6a75cc72f39147756a663f3ef1fc95ef89495 | 0xff00000000000000000000000000000000005611 | 0 | 0x | 0 | 0 | 3 | 1748560677 | 0 | null | 1 | 0 | null | null | null | null | null | null | |||
| enriched_transaction_0x50727dea0af0bdc5c2ec7dbb58050ef5e3da062524f0d104fa0ae817e01f0b7d_2 | 0xd6b28259123802e5f210df1ffaa1b9833f013b4a610a43b0bee5c8cde066cc1c | 1810048 | 0x50727dea0af0bdc5c2ec7dbb58050ef5e3da062524f0d104fa0ae817e01f0b7d | 52975448 | 2 | 0x08265da01e1a65d62b903c7b34c08cb389bf3d99 | 0x0000000000000000000000000000000000001000 | 0 | 0 | 0xf340fa0100000000000000000000000008265da01e1a65d62b903c7b34c08cb389bf3d99 | null | null | 0 | 1748560683 | 0 | null | 1 | null | null | null | null | null | null | |||
| enriched_transaction_0x816f2a5bc174650b9f118a8ef24c89300f6cbe6fcc9020714a5452fb3918594c_3 | 0x58f46f5f8038660ba243cd5952c0d054b2054a179a148ecfa531ba5fc9928611 | 111845 | 0x816f2a5bc174650b9f118a8ef24c89300f6cbe6fcc9020714a5452fb3918594c | 52975450 | 3 | 0x31d571e0323430adc396781236f97d90f40ab6f5 | 0x0eabbde133fbf3c5eb2bee6f7c8210deeaa0f7db | a¨ | 0x | null | null | 0 | 1748560685 | 0 | 0 | null | 1 | 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 |