Enriched Transactions
Chain
Polygon Amoy TestnetDataset name
polygon_amoy.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_0xafeb875fd18b5114133fc97f5de20bffe3bed8cdfc880759788a5ce279705a3b_0 | 0x8b35038c388e5f7c5ce1657e5875198cec768ab5a0ad98b657b13c40879c9284 | 2107 | 0xafeb875fd18b5114133fc97f5de20bffe3bed8cdfc880759788a5ce279705a3b | 18790732 | 0 | 0x81b807baafe95b225b52481c6b362ecabda0eedf | 0xc1e84bd4baec8bc965725a6ea548ce066ef892b3 | Ç | ÖÊ|e | 0x40d097c3000000000000000000000000a0c0ed35a8308e4bd17ab05b4c42c2b603813be6 | null | null | 0 | 1741094136 | { | { | null | 1 | ÖÊ|e | null | null | null | null | null | null | null | null | null | null | null | null | null | null | |
| enriched_transaction_v2_0x8483890619985aa0e7bbfea0628715681327831c71c38d62b1178f599be5dc01_0 | 0x7fd1cce4d0f8870f9a0b3e99c169ff037a34c3998c6129e6d02a015cad76cc0f | 466946 | 0x8483890619985aa0e7bbfea0628715681327831c71c38d62b1178f599be5dc01 | 18790737 | 0 | 0xf5e8a439c599205c1ab06b535de46681aed1007a | 0x2ca20802fd1fd9649ba8aa7e50f0c82b479f35fe | _0 | ÎF | 0x3161b7f600000000000000000000000000000000000000000000000000000000000000200000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000281d0000000000000000000000000000000000000000000003b1a9e5232fa079b2890000000000000000000000000000000000000000000000000000000300e661000000000000000000000000000000000000000000000000000000000000000010 | null | null | 0 | 1741094148 | null | 1 | ÎF | null | null | null | null | null | null | null | null | null | null | null | null | null | null | |||
| enriched_transaction_v2_0x019b08f06509a0f73bcce40c593d3d1634607404979a082211753b2664e879fe_0 | 0xe74f86ac6e0a1bc8aa6e7d31e6259d59ce57fd18361790fca313b639b6281125 | 352372 | 0x019b08f06509a0f73bcce40c593d3d1634607404979a082211753b2664e879fe | 18790739 | 0 | 0x0e8785a63852b789256ce69fc8c2a53cddbb6b27 | 0xf1764080a314dc6acb3cf84245721b08400fdd1b | ¡ | ÖÊ|e | 0xc9807539000000000000000000000000000000000000000000000000000000000000008000000000000000000000000000000000000000000000000000000000000001a00000000000000000000000000000000000000000000000000000000000000200010000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001000000000000000000000000fc95c970b25c8fefb6adfb2238b7e5ff0002859706030102000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000600000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000308c48a000000000000000000000000000000000000000000000000000000000308d4b07f4000000000000000000000000000000000000000000000000000000308e1ba10a000000000000000000000000000000000000000000000000000000308e5c5b1b0000000000000000000000000000000000000000000000000000000000000002f90b1c5bb113eebe07c759c02956b3ecaa3d986f34eec3eb0abd9ecccb48fd6959ce5a97dfd6eda9d15d83ff6ec0d50130ebdc706ffd7d764c83149b94af295800000000000000000000000000000000000000000000000000000000000000023f3820a35a3310ab930db7bd42f519b2560c727b117dbfce9b6c9b2640b94aaa458026495a5642d4e740384e17ea09164f0b9043692d8dcd4ec6ae7379beb69c | null | null | 0 | 1741094152 | ãÈ | ãÈ | null | 1 | ÖÊ|e | 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 |