Enriched Transactions
Chain
Celo DangoDataset name
celo_dango.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_0xbe6b74864588e167f1d115b94b30e96acf2334b30dd3e04cf7096bac2db5e31f_0 | 0x9d53cffdaca78cd60d060b469cee233cceeea294162f87fc5131ff9603c06581 | 3 | 0xbe6b74864588e167f1d115b94b30e96acf2334b30dd3e04cf7096bac2db5e31f | 24940105 | 0 | 0xdeaddeaddeaddeaddeaddeaddeaddeaddead0001 | 0x4200000000000000000000000000000000000015 | 0 | 0x440a5e20000f4240000000000000000000000000000000006686a87c00000000001c6cac0000000000000000000000000000000000000000000000000000000000000009000000000000000000000000000000000000000000000000000000000000000149953424750f9f4dcb0b1f1a5909d7e19e2db75e61c90ecba17fb3760fef3b92000000000000000000000000f8a9f4028b65fc77c3e73c180052066df01a9b93 | null | null | 126 | 1720104724 | null | 1 | null | null | null | null | null | null | null | null | null | null | null | null | null | null | |||||
| enriched_transaction_v2_0x4c4acb8d66d40d0c3a928af61bb451e27e0ec582ff6382d767e0bcd16f4b1b58_0 | 0xa9e055602cbf8495f684a7bb873cffd0c32c7626746a6e55500a99249a36df7e | 10 | 0x4c4acb8d66d40d0c3a928af61bb451e27e0ec582ff6382d767e0bcd16f4b1b58 | 24940112 | 0 | 0xdeaddeaddeaddeaddeaddeaddeaddeaddead0001 | 0x4200000000000000000000000000000000000015 | 0 | 0x440a5e20000f4240000000000000000000000000000000006686a8d000000000001c6cb300000000000000000000000000000000000000000000000000000000000000080000000000000000000000000000000000000000000000000000000000000001e9681df8fca409108a422ae11d37d3cf269fc9c5cd02361ebf916d2413cecbbf000000000000000000000000f8a9f4028b65fc77c3e73c180052066df01a9b93 | null | null | 126 | 1720104738 | null | 1 | null | null | null | null | null | null | null | null | null | null | null | null | null | null | |||||
| enriched_transaction_v2_0xc699ed9a8d0b834d3777479575c63a4e1baff5aaa973ece962d527e8b5d5ddf1_0 | 0x596e5ab6043e6c9b2cfd660376b6ce327721408f135f04c4a87293af06d51cca | 11 | 0xc699ed9a8d0b834d3777479575c63a4e1baff5aaa973ece962d527e8b5d5ddf1 | 24940113 | 0 | 0xdeaddeaddeaddeaddeaddeaddeaddeaddead0001 | 0x4200000000000000000000000000000000000015 | 0 | 0x440a5e20000f4240000000000000000000000000000000006686a8dc00000000001c6cb400000000000000000000000000000000000000000000000000000000000000080000000000000000000000000000000000000000000000000000000000000001663352a9c70c295039421d7798fecf8b3913d1cff1a18b0e4acfc59247635558000000000000000000000000f8a9f4028b65fc77c3e73c180052066df01a9b93 | null | null | 126 | 1720104740 | null | 1 | 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 |