Enriched Transactions
Chain
Public Goods NetworkDataset name
pgn.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_0x4dca90d216cd531dda47f0bea6e5634ada191eb73b3f31087587c5898a85847e_0 | 0xeb571b5b5ee38a33a4d9e0295a24dc357bf2e3bd8784a86bfe4215f2c942dafd | 14234251 | 0x4dca90d216cd531dda47f0bea6e5634ada191eb73b3f31087587c5898a85847e | 14234251 | 0 | 0xdeaddeaddeaddeaddeaddeaddeaddeaddead0001 | 0x4200000000000000000000000000000000000015 | 0 | 1000000 | 0 | 0x440a5e20000a6fe00000000000000000000000000000000066601dff0000000001318c24000000000000000000000000000000000000000000000000000000024233412e0000000000000000000000000000000000000000000000000000000000000001e2be8b2590c2aece7ae6f7fdad7b7fe1384b4db6c0cf7d7def200c97c7efeb2700000000000000000000000099526b0e49a95833e734eb556a6abaffab0ee167 | null | null | 126 | 1717575229 | 52215 | 52215 | null | 1 | 0 | null | null | null | null | null | null | null | null | null | null | null | null | null | null |
| enriched_transaction_v2_0xaf2cbfc7ab294c090acea4d2e70727c866161ebc8dbba0e3f658716e9ccd7fbf_0 | 0x75cbfe7b4c6c8200df179e30f842b3891beaaf3ee6e0ebfe535aa08a38a54c0c | 14234254 | 0xaf2cbfc7ab294c090acea4d2e70727c866161ebc8dbba0e3f658716e9ccd7fbf | 14234254 | 0 | 0xdeaddeaddeaddeaddeaddeaddeaddeaddead0001 | 0x4200000000000000000000000000000000000015 | 0 | 1000000 | 0 | 0x440a5e20000a6fe00000000000000000000000030000000066601dff0000000001318c24000000000000000000000000000000000000000000000000000000024233412e0000000000000000000000000000000000000000000000000000000000000001e2be8b2590c2aece7ae6f7fdad7b7fe1384b4db6c0cf7d7def200c97c7efeb2700000000000000000000000099526b0e49a95833e734eb556a6abaffab0ee167 | null | null | 126 | 1717575235 | 43827 | 43827 | 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 |