Enriched Transactions
Chain
Ethereum HoodiDataset name
eth_hoodi.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_0x062cfd86a9957b7046467011a31afde1188396969db9395dde7e02bb5168f46a_4 | 0x8907c595ca8f7505cda77988d060da422360cb2e7764b68940c5a75ecc5065cd | 4 | 0x062cfd86a9957b7046467011a31afde1188396969db9395dde7e02bb5168f46a | 122 | 4 | 0x9a27d0c715d3f2af2fac39a41c49ed35004a3bcf | 0xca438a718ba35d1571adc458a19fde46845e8055 | 0 | 0 | 0 | 0xcb222302000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000000000000000003e84f80ce44afab1e5e940574f135802e12ad2a5ef0c4356af40cc379b15925fc8c21e52c00f474e8e9d4a24fe19b5e0ed77137012b95b4433293e2ff8efe31320faf8da1492eadf8deb79bd264d7cf214114627ea0e2b27b817dbff94c3da383bb73f8c30b9c2afbda88bedc4f92b444bf3cd3d257cb0c215d46cba1e9b1e5db32da28428f2fb85587bcb785e74c66c2055f6a7a01e102bde8d8d71d1d36667e214e9cc05f7f944d618de85396e669922c2cf6813e806710b651599de9838eb8b2083fec33faaaea5d50ff765a993400cd62b61cfa4bb33b1ddf694ec7421b329234f6868b6b726cf0dd59d5d432ccb8df8f30ddc8dfb07055afa02d44a8a4e25c0542737eb92b4a201f4320a6db6d1fb2d3bac834bdaa95c9a95a23115b0ab94182c5893e1a45140f0f3b6d53105826f99e29f2ac24c41d16105efa4ef9eba61bbcf8cf9055ee8f904d0d8ce0e8ee0bf6d4a58633028a07979d3fed8e9459d0a84d8814087fe36a742296e122c1a20fca3cac3371357bdad3be0df079b73f4d4e99f65ec4b16b684e44f81aeca5ba2b7cf17d119effa0dcbe24d3fa346860be851150358f918d92fc2ca24379ba1eea1dd1ca385fc5c8df7c1c0accc24e1549125b5b3c14d999d3a496afbdb18b6f10a44a4adf1b5918839af860ef64d893408ba91dff6c41af892a89fc5c0bf5c32b5cc89d13ac8092557902ba4de6f83a7e27e14b8f0bf8adfea1cde4c1b984f3f02f997ecff9980b06316de2577d9bb13ae760b0c1057dd892d319631160d32170fbea7d82ce184571773a7997871a6997cce470b079b25fe78faaefadb7249b4940ee485856df150bbe6352f8c749954c9df198cf72976e48994a77cce21e5248fd8198aef29a47cb8bce52de9365508451cd615270ab3a7a3a262a4e49935d002278c76b78fa7f89a14d005f057107755ca18345728e2e3938865c05c13d422310d9421e4da915b73e5289a6b1347a70cb4ff0297102dc549b044c41bd61e22718246ed81fe586097c69412c75cf608c8405aa8249d11d7d2cb0aff72a61df37fd016ee1bd9f180633f8c1c8b85ecb964650f127755a7394f1520183b17c7a907182fd3bceabf71b5885d3c5d482e24e5150fe87c6c509464a8deeb9df9966e9a328ee1195f0b0d3ef9a0a8162abe874b126ee63319384c5f54cbe1c0a3ce609260f02c3f1cc10fcfa15573259b4c0c83645411a2d40f51735b33371d018e2bfe5759c6547634770c20a6301505b567648308a713b6f78a434feeb532d51a374929685801b7e6eabfffca4690183c17ebbc9f96460dc35c2732f5b13e8d6102086fe7f6ee3cb27fc6507e8a43768225b29451199971c0b286a14ec8ee3be73932debd44737dddeafb492752fc64220ddb3e7c9f1d5cccdfdf0000000000000000000000000000000000000000000000000 | 0 | 0 | 2 | 1742214948 | 0 | 0 | null | 1 | 0 | null | null | null | null | null | null | null | null | null | null | null | null | null | null |
| enriched_transaction_v2_0xfff93730081a0ce76241b338a02a2e3df763549345e01cb7d5b4cb23e391cce6_1 | 0x4f5edacba64e2770411d09c1b1d109daf18981e198f3aa462ea122f18dcfa015 | 21 | 0xfff93730081a0ce76241b338a02a2e3df763549345e01cb7d5b4cb23e391cce6 | 123 | 1 | 0x9a27d0c715d3f2af2fac39a41c49ed35004a3bcf | 0xca438a718ba35d1571adc458a19fde46845e8055 | 0 | 0 | 0 | 0xcb222302000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000000000000000003e895daa42ffa9211aaaec7f4b05e9199b895479f383a549f2b38cb2964a39db8c0b720f8572ed0e2a1d77b586a43d2066f1de3fc4d46a57ea91890a100df40c8250797c842167ac05cf9386e59d7feaecd31a47094c6325d357c7331c621d6768ba041916edbe3c041cca6c53e70008640eb8bd897eb99464084712cc955ab7e33540d4ae4ed5838afb9b17f040038598ecb3b308ebc6c6e2c635bacaa3c5298a319397f00656e9c7c441b592d0b7655fa3f12c97270ee31e2840961b0fc2336de7b23eec67a64627ae85c51d04030d0509b2bbd85ca9e32a6629b229b87612d64215f7de69b3d803565185fcb7aa02f94229fd082d6982c7643852b7959dfba5a8197596d1f01a06cae4430f3d763d9c3acbbb1ff24fa1a1c11b2d70af73fa2f80a4e9f2c66f3423bbbbe1b7854fec607745823cf947dd2164bc3ddf75f72af383e8b4895529d576729032e44381a7f8358dd5b1442e14d7968db2bd8607c392f83085e00174e66f828f8c0a7526b90f5c803aa659c8d0307ba33be259bd5e460b00cd6bd0f27bc2e96c8872cb2080d87c9b99e4ed376f9dbe294694ea9c0b1ac023a0d93686c1f120917d6ba3cd072b011d5140069aab4aab0baaa9d8c923bf4cf929a9453000c65c764c668214b4c0339669ba2c9acf7c493940a4a0440bc32da330f4c31e32d5a029eb16faaaf203093d3bb5c30aa36505e30b23dcf95571491de7e57a7e4d3ef20da82abde0a5dad48cc5b0629ec5f0413ae1f6ab39fd1f1312f60b1c02c93efc296112d186d0374c8b1cdf9fe5b6b48258c6aaa4d3069c12ea3173b4092d8ac0ab3a70a1a8707ac4160b64d7b5bcc89036a031fb9484724a8b6fc6de7246f6618f7211e05562e2e3725f641a140a098ec720f65595ae58da61338b46fa77cb6230885c0b8bf291991944d84a88702543b6f9134e39facc078b67265ab44f36761afb0968a1ba2b3646fefad08ebf367c02a66d36a4fa42df5f6b9b8b0cb5cbe4a38cf36cbf66ef15237687b16069882244cebf79018e02cc240667f84444eaf5abd4d7f07da8e119dd6159ed1ead638bd5ebc715344328c0fa002900fc8a55720f9bd81c52f3fd6c6f6ef0d173d3d3f5c38974443f830db65c17a7fa68a1168322fa26d844f1f3db5c32b5ea1c52afa77d87796b8cd34f4801e062fb54e7df64d2ea4607c4744d088a7ff240953f8534f7b6e9c1cb745112a9c2cd3d761fdd7a70fbc969d3f4e30c32f562f1dc67ab6123268fd15648a976af71cda99fa5d95a0f34530d803e67ea76f6d203d8636159651482250a046f799346060a26d8d1d8ce03b8330b316e08ce5841324bcaed338ca7f731ed7dc1cd8b395eab50438cca4b06463da9914ff229085b8b00f6f9927a46bd7f21d30607b579ce9aa03f604000000000000000000000000000000000000000000000000 | .íÐ | 0 | 2 | 1742214960 | 6a6 | 0 | null | 1 | 0 | null | null | null | null | null | null | null | null | null | null | null | null | null | null |
| enriched_transaction_v2_0xfff93730081a0ce76241b338a02a2e3df763549345e01cb7d5b4cb23e391cce6_12 | 0x8f639a0403b20bcd0d595bb3a1e03ec760c48b6d848afd8b0c8195e30e7b81f0 | 32 | 0xfff93730081a0ce76241b338a02a2e3df763549345e01cb7d5b4cb23e391cce6 | 123 | 12 | 0x9a27d0c715d3f2af2fac39a41c49ed35004a3bcf | 0xca438a718ba35d1571adc458a19fde46845e8055 | 0 | 0 | 0 | 0xcb222302000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000000000000000003e8350fa1ad512ab74b7370eddc654497da1be7b5360aa514ec7e16c3d5fae55e5ed5ece1455ffd52c7ce5ff01aba3ca571aaea3e7626f35f7f880ffb40e8ae3f2bfed29d02fe10d453c7098a73b9a2747c934f719cd3fadef7bb30e297f6687ad978a076b7c377be031ac4c50bee7e013d2ada432bcdaa59992112bb05f70898cd022c5a1452a78a1bf79df5d85230b9550876902dfab2ec5dbb1275094fd4fd722456634f6933d0433aa9d2ecd6b823425c541ba886d603f243b3bc689f96e238515077e55dc654e95ef3084dbcb3c89add039e97a35fe2261d125e90dd34f7ed277f588d7543e73d2b6ce676d053f961b049d98d25bc41cc9ea1f644b69a0ac592576f0a012bf122e350c2441f1b5b8e8809d86ad4d3670d1d2a72181e9d694451d5a58c67ed6ac75b041ea20d941218c10b055f0907fe1bbe486ccdaa7e332a54c378fe83ec1565ef60f7ce094bc17cc8ecf5287f10b206f94b4454dd90472b7a524d37e98fc86199219dcbaf617b13aea70f35ad877715e991a4b4a7c0996fe834eae935358532e70920ece990f957922526b494f03fedc7454b02dd020e8c19f7a58976a7850b5ead4daca27943354ed40340cca8d94ac607e0b3de5a2da4726e194c802467892e83ee3577336c1fbef4668a0940d2e19abf0d977bd6a851abc912d1da1d70479ac687c133d3269fec0a1b3f351806b55e93a8bcb47be3acaf71584dedeab3243b83f04529c1b32f4af12de1fb3d916eca0e741c24fcb9ed2bfa9264526bd675aaf392526abe19c10b289194b04a5962dd8bc8cc48c9fbc30844424c8c173b6579c34d2d744a67dbc0caabf9a4ff7ff3cc93ba0fab8edbb6779892f3b3bec7bb9f6b074e1b63142628311395ceafeea5667e7c9026c862cad21b32470e1206e67cb3022e5fe1bbb494dd1aa53e47c795962f0e474a0691c28061118642f2a9e5d56ec8e7672f3d3edcf7dccd0d3d4f60e6ec2aa351dc21f6ee700310f67652be1471fe80dec790ee76bc54198fa4a93c1767dee5c5ba5c16cf395203453280fe780fd069f9b924b9b0c264a847b7cfeca962ac33d8b88133bbc15b6d01a6e6a524ee692e92d7ce9114489a7314ae5887a7676ff9fe80498625d2351c845bbc97f0976cf13fade6e6c305bac8855314857ad52598182700027f6a2e51c356f417d7e8fd10d2a535626bd3a1a87732a9a6635b225b332d91f15532cca517c8a2dcceb5895fabfcd9ece569981ee39e75a1c40f6271a17878a93e60e7336ddb0a6c999330f44506dd7414e835ac6ed44dfab7f5f593ca48c9252eba1749713e8661708ee90ec4adce4b7de04dd79011a86010e23477d7b850af38305c1650dc8d4b6a92e3adbf9dca0c89d7b5f7953a0a21b92e27d5919c0739fa545ede6b74724c000000000000000000000000000000000000000000000000 | .íÐ | 0 | 2 | 1742214960 | 0 | 0 | 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 |