Enriched Transactions
Chain
Stable MainnetDataset name
stable.receipt_transactionsVersion
1.1.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_0x882a90fd3af57a2baa5bfabdd50b6ee7c0e7d5950d1f537034f46cf444c9f6e4_0 | 0x48dfc36a82a77529f1e42d06051f42738532d255711fbe71587695d927378efa | 23391 | 0x882a90fd3af57a2baa5bfabdd50b6ee7c0e7d5950d1f537034f46cf444c9f6e4 | 13605828 | 0 | 0x01726847a184fff6f65ac14a322108260b51e81f | 0x6165211bef5bf1fe2697dbaa912d907e9fd4c5b1 | 0 | w5 | 0xb7a1625100000000000000000000000000000000000000000000000000000000000000200000000000000000000000000000000000000000000000000000000000000002465853000000000000000000000000000000000000000000000000000000000058415574000000000000000000000000000000000000000000000000000000004658530000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000420fb4b019c6a93ff50000000200000011597908818cbf24fb53cbec27ffb204add4c127a613c3b7da595e5a05e5d621448213a0509f81c04c5a23a5364e40c2e9b07175f56b8d979c41e7c90f2eb74361b4658530000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000420fb4b019c6a93ff5000000020000001ae213e3be7d266553308180ce794cf04858630d184045c9c591dd8e7ad028177220229a7898ed588abfaa656f89b80c3a3bf89208b1425247f893a3bbfe0452e1b4658530000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000420fb4b019c6a93ff5000000020000001d999d6c48294f1da3aaa2667766541ae508d91210e079e6d5c28634e102115c06753b3f06d193acfe0c2427a959e3d7e0b9e606788dabe0b5fbe421f88ef179a1b584155740000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000071f9ac36fc019c6a93ff5000000020000001aaa49eef3257de4a66245d3cbb6fb9e5d20e425d3e17b25f1e791f9367312da556616ac8a229a007fbb705850f83e807ef05ab1f5997cbf3a428a6fc3b8956ab1b584155740000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000071f9ac36fc019c6a93ff500000002000000155277330d430e03228fbdf7cf9913d10a2ce5d19439ef8edaa9ac1522f384d6e580cc11e8f71cf9d83175f06b44b5a08416fdfcc6970a4ec2a8279421128cf2b1c584155740000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000071f9ac36fc019c6a93ff50000000200000014e43144995da9de3b9d2f272c45fb908209d4e26a8ee24dca45addaae989d8593b41d0feb1fc8230c6d218e7af5c741e8b64ce2a1bd4c321073f47ce29d2494a1b00063137373133313436313337383823302e392e3023646174612d7061636b616765732d77726170706572000029000002ed57011e0000 | ;Ê | 2 | 1771314613 | ¡ | ¡ | null | 1 | w5 | null | null | null | null | null | null | null | null | null | null | null | null | null | null | ||
| enriched_transaction_v2_0x09074d068728b03f4e1c607d4019a92f0e0c9514dabd2e87e4629cab6212d99d_1 | 0x1682c4efca7d8626b5cec91cbc334160bca6d1e77ac13344ce94e1cd3d5acfe2 | 238443 | 0x09074d068728b03f4e1c607d4019a92f0e0c9514dabd2e87e4629cab6212d99d | 13606045 | 1 | 0x339d413ccefd986b1b3647a9cfa9cbbe70a30749 | 0x3c2269811836af69497e5f486a85d7316753cf62 | _0 | Pw] | 0x3161b7f60000000000000000000000000000000000000000000000000000000000000020000000000000000000000000000000000000000000000000000000000000000100000000000000000000000000000000000000000000000000000000000000a1000000000000000000000000000000000000000000000000117070cb3807d80c00000000000000000000000000000000000000000000000000000000ffea301c0000000000000000000000000000000000000000000000000000000000000010 | null | null | 0 | 1771314764 | ¯ | ¯ | null | 1 | Pw] | null | null | null | null | null | null | null | null | null | null | null | null | null | null | |
| enriched_transaction_v2_0xde785c5ec49d2c0635aff8a1e5fa46428b56478d9593755af56756b05d1a996c_0 | 0xe7d57e5f6c03332ff3893c12b2a575de5deb9f886e08f7cbed5684dda2840ba7 | 238445 | 0xde785c5ec49d2c0635aff8a1e5fa46428b56478d9593755af56756b05d1a996c | 13606050 | 0 | 0x339d413ccefd986b1b3647a9cfa9cbbe70a30749 | 0x3c2269811836af69497e5f486a85d7316753cf62 | _0 | XM@ | 0x3161b7f600000000000000000000000000000000000000000000000000000000000000200000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000016a000000000000000000000000000000000000000000000003a09c5a5f2b9e6a4c00000000000000000000000000000000000000000000000000000000000044e80000000000000000000000000000000000000000000000000000000000000010 | null | null | 0 | 1771314768 | ¯ | ¯ | null | 1 | XM@ | 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 |