Enriched Transactions
Chain
GnosisDataset name
gnosis.receipt_transactionsVersion
1.3.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_0x9a03006322cdbe25970c767d97208af48231063abac3e3dbd5172fd4dbfa074f_5 | 0xccad19baf3a7f64f7e52a8305a68b8cca5b80d5f5f1a575a4a0a63d7408424fe | 107 | 0x9a03006322cdbe25970c767d97208af48231063abac3e3dbd5172fd4dbfa074f | 36883660 | 5 | 0xfa4a45d755ea1c2b72dd581b3e05dde3bfc13fad | 0x6a000f20005980200259b80c5102003040001068 | 0 | 0 | 0xe3ead59e00000000000000000000000000c600b30fb0400701010f4b080409018b9006e0000000000000000000000000177127622c4a00f3d409b75571e12cb3c8973d3c000000000000000000000000eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee000000000000000000000000000000000000000000000002b5e3af16b18800000000000000000000000000000000000000000000000000011cbe24039064d8940000000000000000000000000000000000000000000000011d071b97f0a272cf9f6e113c05c34d538476d16a07163e600000000000000000000000000232ccc8000000000000000000000000000000000000000000000000000000000000000081037e7be71bce9591de0c54bb485ad3e048b8de10000000000000000000000f000000000000000000000000000000000000000000000000000000000000016000000000000000000000000000000000000000000000000000000000000001800000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000072000000000000000000000000000000000000000000000000000000000000000200000000000000000000000000000000000000000000000000000000000000720000000000000000000000000000006c000000000000000000000000000002710ba12222222228d8ba445958a75a0704d566bf2c8000001e001640144ff00000b0000000000000000000000000000000000000000000000000000000052bbbe2900000000000000000000000000000000000000000000000000000000000000e000000000000000000000000000c600b30fb0400701010f4b080409018b9006e0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000c600b30fb0400701010f4b080409018b9006e000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000006734815a21d4c792ea7e38e0d0819c2011a2b1cb7252bd9900020000000000000000001e0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000177127622c4a00f3d409b75571e12cb3c8973d3c0000000000000000000000009c58bacc331c9aa871afd802db6379a98e80cedb000000000000000000000000000000000000000000000002b5e3af16b188000000000000000000000000000000000000000000000000000000000000000000c0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000040003a4018c000a000b0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000000000000000003a00000000000000000000000000000016000000000000001200000000000000fa0ffb643e73f280b97809a8b41f7232ab401a04ee10000014000840000ff00000300000000000000000000000000000000000000000000000000000000c04b8d59000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000000000000000000a000000000000000000000000000c600b30fb0400701010f4b080409018b9006e0000000000000000000000000000000000000000000000000000000006734815a000000000000000000000000000000000000000000000000008004fb0f2cccae000000000000000000000000000000000000000000000000000000000000000100000000000000000000000000000000000000000000000000000000000000289c58bacc331c9aa871afd802db6379a98e80cedbe91d153e0b41518a2ce8dd3d7944fa863463a97d00000000000000000000000000000000000000000000000000000000000000000000000000000200000000000000016c0000000000001770ba12222222228d8ba445958a75a0704d566bf2c8000001e001640000ff0000030000000000000000000000000000000000000000000000000000000052bbbe2900000000000000000000000000000000000000000000000000000000000000e000000000000000000000000000c600b30fb0400701010f4b080409018b9006e0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000c600b30fb0400701010f4b080409018b9006e000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000006734815a8189c4c96826d016a99986394103dfa9ae41e7ee0002000000000000000000aa00000000000000000000000000000000000000000000000000000000000000000000000000000000000000009c58bacc331c9aa871afd802db6379a98e80cedb000000000000000000000000e91d153e0b41518a2ce8dd3d7944fa863463a97d00000000000000000000000000000000000000000000000000c0077896c3330400000000000000000000000000000000000000000000000000000000000000c00000000000000000000000000000000000000000000000000000000000000000e91d153e0b41518a2ce8dd3d7944fa863463a97d0000004000040000ff000007000000000000000000000000000000000000000000000000000000002e1a7d4d0000000000000000000000000000000000000000000000011d071b97f0a272cf6a000f20005980200259b80c51020030400010680000002000000000ff0400090000000000000000000000000000000000000000000000000000000000000000 | null | null | 0 | 1730889445 | 0 | 0 | null | 1 | 0 | null | null | null | null | null | null | null | null | null | null | null | null | null | null | |
| enriched_transaction_v2_0xe7fea1436036a0de8aa2e151662ff9c12df44416aa5d34e06050d9c6b3b29a9f_2 | 0x70a06b158599811b946a2516db59b4d7c267525357d1e9ed824bf22dcd00e2fb | 131105 | 0xe7fea1436036a0de8aa2e151662ff9c12df44416aa5d34e06050d9c6b3b29a9f | 36883661 | 2 | 0x82e2de20848e58cddfea53ad56cab0471ae8bdcf | 0x29b914b44169b04262ae11173149d7f1131791bc | 0 | 0 | 0xc9807539000000000000000000000000000000000000000000000000000000000000008000000000000000000000000000000000000000000000000000000000000002600000000000000000000000000000000000000000000000000000000000000300000101010000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001c000000000000000000000008f539ff51f0a5a383026cf96dae3256300033afa0405020108030607090004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000060000000000000000000000000000000000000000000000000000000000000000a00000000000000000000000000000000000000000000000000000000366490c000000000000000000000000000000000000000000000000000000000366622c5000000000000000000000000000000000000000000000000000000003666b260000000000000000000000000000000000000000000000000000000003666b26000000000000000000000000000000000000000000000000000000000366780d700000000000000000000000000000000000000000000000000000000366780d700000000000000000000000000000000000000000000000000000000366780d70000000000000000000000000000000000000000000000000000000036679cc00000000000000000000000000000000000000000000000000000000036679e87000000000000000000000000000000000000000000000000000000003668e8c80000000000000000000000000000000000000000000000000000000000000004ee505a19a7c053e29c21518c33ba5b0c9eb15b07ffd4ca977b053024378b5b426a72746b6295cc358cb1f480ae1c929eca875ef330824cc1a1125325b8c075a5a62ba0296fb363b99f21b497670c744014df633f3196251da7c7e1e12712844f06d705e163086fe097fe64fec73d175c00a4b0884e8afbf36bd66f1d00356d1e0000000000000000000000000000000000000000000000000000000000000004205d04bc18021d173af1e7a698a0313d91cc805c8d82482ac5c2bd737eaacfba0d6760bfdf2f2392480b258a627e21c60d4d27c01bb426dae84d97316ad014554a373c50a556c886d7f06116fc89253d63f52a7de93819777e3ea506cd22e18060bb53ab79d6355a16b29881bc360f0d1c669f4f5fa08da075f5d184a1d68ac7 | null | null | 0 | 1730889450 | 0 | 0 | null | 1 | 0 | null | null | null | null | null | null | null | null | null | null | null | null | null | null | |
| enriched_transaction_v2_0x0b27e9be1c819eee0b5b6ca7b817d338e67d94f0f2e13190e5dfe8c6f6465642_8 | 0x53d7c35bc072591fcbdd1cc8314583c967fe5371d76c78e594ff89d81668a99a | 886356 | 0x0b27e9be1c819eee0b5b6ca7b817d338e67d94f0f2e13190e5dfe8c6f6465642 | 36883663 | 8 | 0x05a18bb159a574390fef060d2f2d394b93f8fe58 | 0xf5b1216d1c1c1c075f7a11f44a975c291a291869 | 0 | 0 | 0x91e658040000000000000000000000007f3f3f19c4e4015fd9db2f22e653c766154091ef00000000000000000000000000000000000000000000000000000000000000400000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000001000000000000000000000000001189168e0a1690caaf7296658b3255d77d134fa300000000000000000000000000000000000000000000000000000000000000400000000000000000000000000000000000000000000000000000000000000003000000000000000000000000000000000000000000000000000001276d33f4a20000000000000000000000000000000000000000000000000000017a068596ad00000000000000000000000000000000000000000000000000000186acb88aaa0000000000000000000000001189168e0a1690caaf7296658b3255d77cb4b0c20000000000000000000000000000000000000000000000000000000000000040000000000000000000000000000000000000000000000000000000000000000200000000000000000000000000000000000000000000000000000164be3ecff90000000000000000000000000000000000000000000000000000029e5150f479 | 0 | 2 | 1730889460 | 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 |