Enriched Transactions
Chain
CeloDataset name
celo.receipt_transactionsVersion
1.4.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 | receipt_blob_gas_price | receipt_blob_gas_used |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| enriched_transaction_v3_0x9b4ef37356512d0ef896b587ad94cded293ca610d0d22edf472946168fa99969_7 | 0xec2a79728194ffc6bd81047b261d0a4332225efa5b8e7e841301069975fa16c8 | 108694 | 0x9b4ef37356512d0ef896b587ad94cded293ca610d0d22edf472946168fa99969 | 32231544 | 7 | 0xd389efca52aaaed5ee2c199dfcda289c3a4a4148 | 0x701f141d3b1672ae384023559a02fbedbc1c77ee | 0 | 0 | 0x067ea62e00000000000000000000000000000000000000000000000000000000000000c000000000000000000000000000000000000000000000000000000000000000e00000000000000000000000000000000000000000000000000000000000000100000000000000000000000000000000000000000000000000000000000000012000000000000000000000000000000000000000000000000000000000000002e000000000000000000000000000000000000000000000000000000000000004e000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000c000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000000140000000000000000000000000000000000000000000000000000000000000018000000000000000000000000000000000000000000000003d27a4b907145e0000000000000000000000000000000000000000000000000010405ef1538a8b9b00000000000000000000000000000000000000000000000000000000000000000100000000000000000000000022d9db95e6ae61c104a7b6f6c78d7993b94ec90100000000000000000000000000000000000000000000000000000000000000013135b662c38265d0655177091f1b647b4fef511103d06c016efdf18b46930d2c0000000000000000000000000000000000000000000000000000000000000001000000000000000000000000471ece3750da237f93b8e339c536989b8978a4380000000000000000000000000000000000000000000000000000000000000001000000000000000000000000765de816845861e75a25fca122bb6898b8b1282a000000000000000000000000000000000000000000000000000000000000008000000000000000000000000000000000000000000000000000000000000000a000000000000000000000000000000000000000000000000000000000000000c000000000000000000000000000000000000000000000000000000000000000e00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000008000000000000000000000000000000000000000000000000000000000000000a000000000000000000000000000000000000000000000000000000000000000c000000000000000000000000000000000000000000000000000000000000000e0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000a000000000000000000000000000000000000000000000000000000000000000e000000000000000000000000000000000000000000000000000000000000001400000000000000000000000000000000000000000000000000000000000000160000000000000000000000000000000000000000000000000000000000000018000000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000000000005000000000000000000000000000000000000000000000000000000000000000200000000000000000000000000000000000000000000000000000000000000060000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 | 0 | 0 | 2 | 1744132302 | 0 | 0 | null | 0 | 0 | null | 0 | null | 0 | 0 | null | null | null | 0 | null | null | null | null | null | |||
| enriched_transaction_v3_0x47c93b2576a95d69c5a2632e54b08b0edb859671a79bb9f97bb2a12df35883c4_10 | 0x401e653d29e79195bfb4a41a44924bfcedbeb7a137aabd239552e6ac7642c243 | 50802 | 0x47c93b2576a95d69c5a2632e54b08b0edb859671a79bb9f97bb2a12df35883c4 | 32231545 | 10 | 0xd0d387b82381359c21b3271a907d3da8221219ea | 0xb961cdcaa602612f5fec09220dbd57ad38364a40 | 0 | 0 | 0x000005000000000000000000000000000000000000000000000000000000000000000020000000000000000000000000000000000000000000000000000000000000000a140a0047d632c638a7c65e80d68dce3750da237f93a0368e0cc0f55f86262780648cbe1dd03747d0379abbe7471ece3750da237f93b8e3343b4f6b1dad33c4b81b1bdfc492a0353f4829b4f1a2fc6d5aa5a80a11967f9c02b7789d19638f91a72bc57058b8e65b144907e12428c928259de18614cefbabe82dbfbc938d6a69787ee94f5e4eeed4c7598d7dcc9ee7113d4cab53090f643c12def74a8010e72f5947d57052dfe151734e00c75cb7a1daa8ea519253bb9dcd655b367bd6d2c407337434635493c2d4c7598d7dcc0d5b55b76f3d300f7e9210d17e9ba53360a350eb24c97062444f61e8e07c6e5927d1b9a92f64d4a2756e978ff45ff2a0835af01e6d38194d9fb8d4c7598d7dcc0309b948d4141a54850eb15242e4e705b98d42ecbf6d8e9ea4f1ba11fbf78eb228c928259de18614cefbabe82dbfbc938d6a6978 | 0 | 2 | 1744132303 | 0 | 0 | null | 0 | 0 | null | 0 | null | 0 | 0 | null | null | null | 0 | null | null | null | null | null | ||||
| enriched_transaction_v3_0xbbb2890782befc0f4de0628de7f6f7a835e0aebba9166c18b8d5cb122e29f02e_14 | 0x08a3c9528fae08e8d2522e23ef2f02115371638617889575319e50a14909eed8 | 462943 | 0xbbb2890782befc0f4de0628de7f6f7a835e0aebba9166c18b8d5cb122e29f02e | 32231546 | 14 | 0x4ebc261c3bb07d3d6816fd6072224b6396673444 | 0x2cf8edaaa398177729e8edbefb9cbd026b75eb3d | 64 | Óàlè | 0x02dbe4830000000000000000000000000000000000000000000000000000000000000040000000000000000000000000000000000000000000000000000000000000008000000000000000000000000000000000000000000000000000000000000000010000000000000000000000000e5abc1c8841c67bfa6b83c441f9c5248d1ab87d0000000000000000000000000000000000000000000000000000000000000008000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000000000001c000000000000000000000000000000000000000000000000000000000000002800000000000000000000000000000000000000000000000000000000000000340000000000000000000000000000000000000000000000000000000000000040000000000000000000000000000000000000000000000000000000000000004c000000000000000000000000000000000000000000000000000000000000005800000000000000000000000000000000000000000000000000000000000000640000000000000000000000000000000000000000000000000000000000000009200000000013042a91171eb7d103c4ece00a1777e082fa1746eb78dd9c1fbb515419cf6e538001002471ece3750da237f93b8e339c536989b8978a4381a810e0b6c2dd5629afa2f0c898b9512c6f78846000002ceba9300f2b948710d2653dd7b07f33a8b32118c6cde5f5a192fbf3fd84df983aa6dc30dbd9f8fac00000248065fbbe25f71c9282ddf5e1cd6d6a887483d5e0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000009200000000007c34e901417eea10377b2500bc83c60e853398d263c1d88899cf5a8b408f9654000002471ece3750da237f93b8e339c536989b8978a43861ef8708fc240dc7f9f2c0d81c3124df2fd8829f001002456a3d042c0dbd3db53d5489e98dfb038553b0d06cde5f5a192fbf3fd84df983aa6dc30dbd9f8fac00000248065fbbe25f71c9282ddf5e1cd6d6a887483d5e0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000009200000000002477f90725610d098c55a80038f3c44552a3f6e4d21c8c328ce4904da766d12f001005471ece3750da237f93b8e339c536989b8978a438fed4f77af916b62cb073ad7ad2b2c1794c939023000005e919f65739c26a42616b7b8eedc6b5524d1e3ac4f130f72f8190f662522774c3367e6e8814f5e219000002d8763cba276a3738e6de85b4b3bf5fded6d6ca73000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000920000000000406469014fa2b5098b68b9002e067e0eab7fd31c01473c0f56f3295afb82e461001002471ece3750da237f93b8e339c536989b8978a438b6c8f9490314394cfc6edacb8717bfdc1eb8dab5000002e8537a3d056da446677b9e9d6c5db704eaab4787f130f72f8190f662522774c3367e6e8814f5e219000002d8763cba276a3738e6de85b4b3bf5fded6d6ca73000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000920000000000150ea90c6e688306d6da5a00bd0f6f34baa3c1329448a69bab90111a20756f01001002471ece3750da237f93b8e339c536989b8978a43853b612b32233c80ec439a64325a29766ce95be7f000002833fd14f0fd4eaa47433a07428a46d1ac60fa59121ef97b2d0d7c5fe872d141d48e5c2bc352ab028000002765de816845861e75a25fca122bb6898b8b1282a00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000092000000000003d09900158b5e06d68d5e00f69e376126f5ead7abfa5a4a0351c18fefff8b94000005471ece3750da237f93b8e339c536989b8978a43893887e0fa9f6c375b2765a6fe885593f16f077f9001005122013fd7df1c6f636a5bb8f03108e876548b45521ef97b2d0d7c5fe872d141d48e5c2bc352ab028000002765de816845861e75a25fca122bb6898b8b1282a0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000009200000000000138890003355c06d67e6b00bf939e1c4a5deff958db7b724dbf623e3110d65b001005471ece3750da237f93b8e339c536989b8978a4389e51605ebd0682ef7ee16042a8037cc27d1b5828000005c7144fa865c9f3a6836167a51531a2cc8b0ab5fd21ef97b2d0d7c5fe872d141d48e5c2bc352ab028000002765de816845861e75a25fca122bb6898b8b1282a0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000009200000000000186a900046bdc06d6778f0086a2a2262b87605b6d2a6832423cb606995c8c32001005471ece3750da237f93b8e339c536989b8978a4384a46c053bd5c10a959aea258228217b9d3405f3d000002c16b81af351ba9e64c1a069e3ab18c244a1e304921ef97b2d0d7c5fe872d141d48e5c2bc352ab028000002765de816845861e75a25fca122bb6898b8b1282a0000000000000000000000000000 | null | null | 0 | 1744132304 | =¬ | 0 | null | 1 | 0 | null | 0 | null | 0 | 0 | null | null | null | 0 | 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 |
| receipt_blob_gas_price | decimal |
| receipt_blob_gas_used | decimal |