Enriched Transactions
Chain
Flare TestnetDataset name
flare_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_0x9ea5df3710c196a0858daf56c2363d2d6f6939edab1f10c41b14578bb34682e4_0 | 0xc563c46fdbf35cda506838df969d8a70825483829c702f961435bdb506556d37 | 0 | 0x9ea5df3710c196a0858daf56c2363d2d6f6939edab1f10c41b14578bb34682e4 | 10 | 0 | 0xfffec6c83c8bf5c3f4ae0ccf8c45ce20e4560bd7 | 0x1000000000000000000000000000000000000002 | 0 | 0 | 0x689c499900000000000000000000000000000000000000000000000000000000000000200000000000000000000000000000000000000000000000000000000000000000 | null | null | 0 | 1662554798 | 0 | 0 | null | 1 | 0 | null | null | null | null | null | null | null | null | null | null | null | null | null | null | |
| enriched_transaction_v2_0xfaf88911d9e1fda83c25dbda728def61f657d417af8475559dfc025b86cfc4fb_0 | 0x6b103699b744c4f61bbae099960afb736d3c779d30a4085610ac9c6a67ee93e2 | 4 | 0xfaf88911d9e1fda83c25dbda728def61f657d417af8475559dfc025b86cfc4fb | 12 | 0 | 0x99e0770aa23caa9071b6112208297e7a8d8f8a4a | 0x1000000000000000000000000000000000000003 | 0 | 0xc9f960eb | null | null | 0 | 1662554802 | null | 1 | 0 | null | null | null | null | null | null | null | null | null | null | null | null | null | null | ||||
| enriched_transaction_v2_0x9f47c0b91d7eabe22e229e5d3f14f4c7a0666782e50bf9bc64380f8a4adc6a7a_0 | 0x8c497d0b87acbaccf8db7adde4b226c96477adc6ce80ed5120ed2167d37e0be4 | 7 | 0x9f47c0b91d7eabe22e229e5d3f14f4c7a0666782e50bf9bc64380f8a4adc6a7a | 15 | 0 | 0x99e0770aa23caa9071b6112208297e7a8d8f8a4a | 0x1000000000000000000000000000000000000006 | 0 | 0xc9f960eb | null | null | 0 | 1662554808 | null | 1 | 0 | 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 |