Enriched Transactions
Chain
Ethereum Holesky TestnetDataset name
holesky_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 | receipt_root_hash | receipt_l1_fee | receipt_l1_gas_used | receipt_l1_gas_price | receipt_l1_fee_scalar |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| enriched_transaction_0x1be148cee7879c031ee95627c340f365d36aa83a2a754edf3748a746afcefa61_2 | 0x3766dffd2d18effb43e257b4dff3d9dcc99f6e37617b0f280af36da2011d1298 | 2 | 0x1be148cee7879c031ee95627c340f365d36aa83a2a754edf3748a746afcefa61 | 16 | 2 | 0xd3994e4d3202dd23c8497d7f75bf1647d1da1bb1 | 0xb7fb99e86f93dc3047a12932052236d853065173 | 0 | 0 | 0 | 0xcb222302000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000000000000000003e800000000007775ecabd80d075222d5804a057d520000000000791227c0002def47dc5df26fd9f2f800000000007cdeedd7f45c80ce479fff1c4e3791000000000081105ffd4392520dd13c4c70d95d1900000000008887334fad48a81db065ad034b749d000000000088e0120f9e6652cc058aec07564f690000000000916cc1d9da00b38cff415d3d0972cf0000000000933edea24f198114758e45bf9b9f14000000000097432da963a9d18c10763f302b103300000000009a41862f3b2b0c688b7c0d1940511e0000000000a0136c855efb4596d1da5f5b7032620000000000b42d0692e4cde6add2b3bcccde864f0000000000b6257880deb440692177ed8045d1110000000000ba671aae133ee69e5cdc7eb2b039f10000000000bc14115f9f67fde839f285667437bc0000000000c521824eaff97eac7b73b084ef93060000000000d1921aa255cc20daec11a22b7e894d0000000000db4047e0b1237b6a6174b5461401650000000000e002b4e3009de1c7614ae5e1facf7a0000000000e189dd664b9ab08a33c4839953852c0000000000fd699f5f8bc494b69bc5c47433b4eb0000000000fe47608d9bd640467db49de8a57efc000000000103b657da5c0cc7d49169370f751faf000000000104f0502ed66ff55263bc0a29ce522400000000014bfac9cde5abb06a887d8621271cfb000000000161ae794c98f550576edad76b04e58b0000000001936a97e5103368eaa5d3f60fe8b5f90000000002656fbf3141362dbd2ff9582919f49500000000029f7a89722504d452353f8f5846206200000000047476dfaaf929c8c15fd1e4472e7cf600000000051cbce3fd04148cce2c0adc7c6518290000000006f5ded270fb5005b68d07dfd96140ef0000000007448745737b8182f528bb1daabc875f00000000079a2bf7701d039faa681954b428ac43000000000825493440356ab1ab12f7473a0731af0000000008a5f677d64163191f2fc3da269364b10000000009bc9cd0f5cc6fe052598e5c161aff49000000000aac3ea96e7613ffb657da06c40b93f9000000000ac5104f02021da3138d31b0c2f67ead000000000b0ad33651a6ab4c4589ce5fed6042f4000000000b524d20b5d507332c31e8d60a6241e3000000000ba7407ba5b239848b5ca98e1243acac000000000bb5f648cca04f1313b23f243e256f7e000000000cc7e508b4b115e64d71ef374cfb7703000000000ce9873e7ba322d68c75bf50d7c7bb76000000000d1c18a47a23c5826b2567c864a7d414000000000d71b31f9c460f26c45589ec91551969000000000df7b02c054f90c5f93dc25f269e9b6e000000000e3952882af02e7db0f3157bac7c6b51000000000ebd3fe58a49bdb9bb3270c04888d96b000000000000000000000000000000000000000000000000 | 0 | 0 | 2 | 1695902712 | 0 | 0 | null | 1 | 0 | null | null | null | null | null | null |
| enriched_transaction_0xf17af0bb35f31bad6004e855b0286a2a2711b7b08bcecf62d5bef8d3fce61615_2 | 0x88704274f368c9e3229a73e441e2ad0b58b7086934deb439bc9952dc26d0ba44 | 12 | 0xf17af0bb35f31bad6004e855b0286a2a2711b7b08bcecf62d5bef8d3fce61615 | 17 | 2 | 0xd3994e4d3202dd23c8497d7f75bf1647d1da1bb1 | 0xb7fb99e86f93dc3047a12932052236d853065173 | 0 | 0 | 0 | 0xcb222302000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000000000000000003e800015d371146d648a89136ace634096011244cd800017d046e1767553ff31beb6633a7110922d99600018158af9c9e076cfa7afce2cc0e0e603b37e50001922b058c32a0769b94c5b0351ff33581c27d000198005b1003b34856848844f361c14c2b41b30001ab21d1dd9ea23e1ccb46beafbdcb8a8b71260001b26fca71557c2ae50a4bc91dbf94a44127b10001b3b315d520d40520f2d5eef6a5d7564615750001b6afe786714fbe25274fc41f51c85e120b440001b89f9daba9d8fb8ac095302128d609ff8db40001bc50d7dacc2877c7d027c9386145fad772d20001bd3a3c6d13d9d0a14f306038f7638bf6b16c0001c6f8c1d2bf8714d00ad14e1cb23b9165bad00001d21bd8e99a4b23322664bddc544858b76a9a0001e843e2a6367fab8c2dfabeb5a0672286786d0001f66cb18776f6c0e2184b60c4b367a2e08b6e0001fc705de6e305c8b4832032305b504ce4012200022496f3d786064b88cd933ec8d87a5121bc84000240ca1ab0773b7674a1a4a326df454b895d4600024475effd012a797dbdd371078374496b9b1e000245ac9a85d333102f026eacc1420d10860c2300024a010e85183618c0bedc65def0602318f54c000251104ce432bd728a5712f175eff4e446023f000253c8328e0ba0583c03fef6a739313487e3b300025c8820748ac6b627ac738fe1760b90afe4f40002619959c6cf7fdc62d35cabb472b062f82eaf000267c440fb5f581756abb2c78740a26d335fbc00026e0536a4a7da2a740623b6eeb7631fe617e100027006708a703907bbceea5b0f944bfeac6c3800028e5ca3c3af8a219ff69f746cba1859ebfc2100029459833ebe0fc4646358f11fe42ae1ecb7fb0002b36e539ca5a7ab5da448ef39ae7fbf608e660002b99c6d819359e30d9e64ce3a24adabe54de70002cc6a7cec1276e76a76385ad78a76e619dc490002d61d0be439d7a4d3f643a95a9e606b3f8e060002ea37ce89d5b70b39eb48ac88231e50a13b9d0002f2e3c94af8e22df5de8c9a879dc44608c3ff0002f68edde1a8cc089906dfa8b1ce49b406540a0003008235701e71028cc57151b3741e2383dbed0003032c33e6a3133dca0ed5f50580143dc35c3100030d304f349931a42de71207dfee30ffd1f40300030f4b6e66c1e83d36d35be888534dad275bd0000311fb0f2bba149704c6c6f4e9368107bcd6e0000328ba5de08e04db57a31d5357a4fdaca4f91300032a6ef7046257f19e9955bbaef957e3f6320d0003444077ee649d8259eb938f68183021bee957000355d475475a487e682c1940ec45664a32b30800035ffaf83f6929c5d596c55da45cea6c7590cd00037d716dd83f2c4ef0a9ce47965e6f61495165000385a31e765e65dcc721a194d14a608b69ede1000000000000000000000000000000000000000000000000 | 0 | 0 | 2 | 1695902724 | 0 | 0 | null | 1 | 0 | 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 | long |
| receipt_root_hash | string |
| receipt_l1_fee | decimal |
| receipt_l1_gas_used | decimal |
| receipt_l1_gas_price | decimal |
| receipt_l1_fee_scalar | double |