Enriched Transactions
Chain
Robinhood Chain TestnetDataset name
robinhood_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_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_0xaaae9e67718f9dde9d581a60de05bdcc949939ed210347fec8b5ae94f307b40c_0 | 0x77ee9876a9fe01baded13e739bd204bfc088b7c68cfece55f6fd83f3d98379c0 | 0 | 0xaaae9e67718f9dde9d581a60de05bdcc949939ed210347fec8b5ae94f307b40c | 6 | 0 | 0x00000000000000000000000000000000000a4b05 | 0x00000000000000000000000000000000000a4b05 | 0x6bf6a42d00000000000000000000000000000000000000000000000000000000424a485400000000000000000000000000000000000000000000000000000000009bb56400000000000000000000000000000000000000000000000000000000000000060000000000000000000000000000000000000000000000000000000000000000 | null | null | 106 | 1770393660 | null | 1 | õá | null | null | null | null | null | null | null | null | 10204516 | null | null | null | null | ||||||
| enriched_transaction_v2_0x77542891b0286b4ab3caa87f0e4ce3f2e36fac5c5d972342a6bd0e0dd1e066b4_1 | 0x91fb03717707b8e731f4bebaaf68eafb71fd4d09567b62d2dfe7992667c89d6e | 0 | 0x77542891b0286b4ab3caa87f0e4ce3f2e36fac5c5d972342a6bd0e0dd1e066b4 | 7 | 1 | 0xe6bd692ad897742efe44d54fda338b244fc7e0c7 | 0x000000000000000000000000000000000000006e | R | õá | 0xc9f95d32000000000000000000000000000000000000000000000000000000000000000700000000000000000000000000000000000000000000000000000000424a4854000000000000000000000000000000000000000000000000011c3ae6f6049360000000000000000000000000000000000000000000000000011c37937e0800000000000000000000000000000000000000000000000000000000000005f5e10000000000000000000000000000000000000000000000000000000000000052080000000000000000000000000000000000000000000000000000016a863b8b60000000000000000000000000f17cc77336e201c4c08751918a4bb99ddf0e2d08000000000000000000000000f17cc77336e201c4c08751918a4bb99ddf0e2d08000000000000000000000000a990077c3205cbdf861e17fa532eeb069ce9ff9600000000000000000000000000000000000000000000000000000000000001600000000000000000000000000000000000000000000000000000000000000000 | õá | null | 105 | 1770393660 | R | R | null | 1 | õá | null | null | null | null | null | null | null | null | 10204516 | null | null | null | null | ||
| enriched_transaction_v2_0x19558a7f5b7980c52aaed14769b6bd645a269238becc9b7e23c77e5533864780_0 | 0xc0769aa0acb00954bc9c1e27dbbbcea62f41ddf563a2bda28ff8d2209f64e525 | 0 | 0x19558a7f5b7980c52aaed14769b6bd645a269238becc9b7e23c77e5533864780 | 18 | 0 | 0x00000000000000000000000000000000000a4b05 | 0x00000000000000000000000000000000000a4b05 | 0x6bf6a42d000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000009bba0800000000000000000000000000000000000000000000000000000000000000120000000000000000000000000000000000000000000000000000000000000002 | null | null | 106 | 1770408377 | null | 1 | null | null | null | null | null | null | null | null | 10205704 | 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 |