Enriched Transactions
Chain
0G MainnetDataset name
0g.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_0x000492ff0fc53bcd78ee75e316c6e0707bda1d72a1f422e3c517100add4d08bb_3 | 0x60a65fa3d784b48cf5a05d582f612791f90e4f93369a8c3b238d6a4b59e252b2 | 0 | 0x000492ff0fc53bcd78ee75e316c6e0707bda1d72a1f422e3c517100add4d08bb | 35078 | 3 | 0x873cd27b6833e6394c34a00c37b260aca5abc0b6 | null | 0 | Hvè | 0x60c0604052600a6080908152695772617070656420304760b01b60a0526000906200002b908262000124565b5060408051808201909152600381526257304760e81b602082015260019062000055908262000124565b50600280546001600160a81b031916621002121790553480156200007857600080fd5b50620001f0565b634e487b7160e01b600052604160045260246000fd5b600181811c90821680620000aa57607f821691505b602082108103620000cb57634e487b7160e01b600052602260045260246000fd5b50919050565b601f8211156200011f57600081815260208120601f850160051c81016020861015620000fa5750805b601f850160051c820191505b818110156200011b5782815560010162000106565b5050505b505050565b81516001600160401b038111156200014057620001406200007f565b620001588162000151845462000095565b84620000d1565b602080601f831160018114620001905760008415620001775750858301515b600019600386901b1c1916600185901b1785556200011b565b600085815260208120601f198616915b82811015620001c157888601518255948401946001909101908401620001a0565b5085821015620001e05787850151600019600388901b60f8161c191681555b5050505050600190811b01905550565b610cff80620002006000396000f3fe6080604052600436106100f75760003560e01c806370a082311161008a578063a9059cbb11610059578063a9059cbb14610291578063c8dd1a26146102b1578063d0e30db0146102ee578063dd62ed3e146102f657600080fd5b806370a082311461022f57806379cc67901461025c57806395d89b411461027c5780639dc29fac1461025c57600080fd5b80632e1a7d4d116100c65780632e1a7d4d146101a3578063313ce567146101c357806340c10f19146101ef57806342966c681461020f57600080fd5b806306fdde031461010b578063095ea7b31461013657806318160ddd1461016657806323b872dd1461018357600080fd5b366101065761010461032e565b005b600080fd5b34801561011757600080fd5b50610120610389565b60405161012d9190610b1b565b60405180910390f35b34801561014257600080fd5b50610156610151366004610b6a565b610417565b604051901515815260200161012d565b34801561017257600080fd5b50475b60405190815260200161012d565b34801561018f57600080fd5b5061015661019e366004610b94565b610484565b3480156101af57600080fd5b506101046101be366004610bd0565b61068c565b3480156101cf57600080fd5b506002546101dd9060ff1681565b60405160ff909116815260200161012d565b3480156101fb57600080fd5b5061010461020a366004610b6a565b610716565b34801561021b57600080fd5b5061010461022a366004610bd0565b610879565b34801561023b57600080fd5b5061017561024a366004610be9565b60036020526000908152604090205481565b34801561026857600080fd5b50610104610277366004610b6a565b610886565b34801561028857600080fd5b50610120610894565b34801561029d57600080fd5b506101566102ac366004610b6a565b6108a1565b3480156102bd57600080fd5b506002546102d69061010090046001600160a01b031681565b6040516001600160a01b03909116815260200161012d565b61010461032e565b34801561030257600080fd5b50610175610311366004610c04565b600460209081526000928352604080842090915290825290205481565b336000908152600360205260408120805434929061034d908490610c4d565b909155505060405134815233907fe1fffcc4923d04b559f4d29a8bfc6cda04eb5b0d3c460751c2402c5c5cc9109c9060200160405180910390a2565b6000805461039690610c60565b80601f01602080910402602001604051908101604052809291908181526020018280546103c290610c60565b801561040f5780601f106103e45761010080835404028352916020019161040f565b820191906000526020600020905b8154815290600101906020018083116103f257829003601f168201915b505050505081565b3360008181526004602090815260408083206001600160a01b038716808552925280832085905551919290917f8c5be1e5ebec7d5bd14f71427d1e84f3dd0314c0f7b2291e5b200ac8c7c3b925906104729086815260200190565b60405180910390a35060015b92915050565b6001600160a01b0383166000908152600360205260408120548211156104f15760405162461bcd60e51b815260206004820152601860248201527f73726320696e73756666696369656e742062616c616e6365000000000000000060448201526064015b60405180910390fd5b6001600160a01b038416331480159061052f57506001600160a01b038416600090815260046020908152604080832033845290915290205460001914155b156105d9576001600160a01b03841660009081526004602090815260408083203384529091529020548211156105a05760405162461bcd60e51b8152602060048201526016602482015275696e73756666696369656e7420616c6c6f77616e636560501b60448201526064016104e8565b6001600160a01b0384166000908152600460209081526040808320338452909152812080548492906105d3908490610c9a565b90915550505b6001600160a01b03841660009081526003602052604081208054849290610601908490610c9a565b90915550506001600160a01b0383166000908152600360205260408120805484929061062e908490610c4d565b92505081905550826001600160a01b0316846001600160a01b03167fddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef8460405161067a91815260200190565b60405180910390a35060019392505050565b33600090815260036020526040812080548392906106ab908490610c9a565b9091555050604051339082156108fc029083906000818181858888f193505050501580156106dd573d6000803e3d6000fd5b5060405181815233907f7fcf532c15f0a6db0bd6d0e038bea71d30d808c7d98cb3bf7268a95bf5081b659060200160405180910390a250565b6002546040513360248201526044810183905260009161010090046001600160a01b03169060640160408051601f198184030181529181526020820180516001600160e01b03166340c10f1960e01b179052516107739190610cad565b6000604051808303816000865af19150503d80600081146107b0576040519150601f19603f3d011682016040523d82523d6000602084013e6107b5565b606091505b50509050806108065760405162461bcd60e51b815260206004820152601d60248201527f7772617070656420613067692062617365206d696e74206661696c656400000060448201526064016104e8565b6001600160a01b0383166000908152600360205260408120805484929061082e908490610c4d565b90915550506040518281526001600160a01b0384169033907fab8530f87dc9b59234c4623bf917212bb2536d647574c8e7e5da92c2ede0c9f8906020015b60405180910390a3505050565b61088333826108b5565b50565b61089082826108b5565b5050565b6001805461039690610c60565b60006108ae338484610484565b9392505050565b6002546040513360248201526044810183905260009161010090046001600160a01b03169060640160408051601f198184030181529181526020820180516001600160e01b0316632770a7eb60e21b179052516109129190610cad565b6000604051808303816000865af19150503d806000811461094f576040519150601f19603f3d011682016040523d82523d6000602084013e610954565b606091505b50509050806109a55760405162461bcd60e51b815260206004820152601d60248201527f7772617070656420613067692062617365206275726e206661696c656400000060448201526064016104e8565b6001600160a01b03831633148015906109e357506001600160a01b038316600090815260046020908152604080832033845290915290205460001914155b15610a8d576001600160a01b0383166000908152600460209081526040808320338452909152902054821115610a545760405162461bcd60e51b8152602060048201526016602482015275696e73756666696369656e7420616c6c6f77616e636560501b60448201526064016104e8565b6001600160a01b038316600090815260046020908152604080832033845290915281208054849290610a87908490610c9a565b90915550505b6001600160a01b03831660009081526003602052604081208054849290610ab5908490610c9a565b90915550506040518281526001600160a01b0384169033907fbac40739b0d4ca32fa2d82fc91630465ba3eddd1598da6fca393b26fb63b94539060200161086c565b60005b83811015610b12578181015183820152602001610afa565b50506000910152565b6020815260008251806020840152610b3a816040850160208701610af7565b601f01601f19169190910160400192915050565b80356001600160a01b0381168114610b6557600080fd5b919050565b60008060408385031215610b7d57600080fd5b610b8683610b4e565b946020939093013593505050565b600080600060608486031215610ba957600080fd5b610bb284610b4e565b9250610bc060208501610b4e565b9150604084013590509250925092565b600060208284031215610be257600080fd5b5035919050565b600060208284031215610bfb57600080fd5b6108ae82610b4e565b60008060408385031215610c1757600080fd5b610c2083610b4e565b9150610c2e60208401610b4e565b90509250929050565b634e487b7160e01b600052601160045260246000fd5b8082018082111561047e5761047e610c37565b600181811c90821680610c7457607f821691505b602082108103610c9457634e487b7160e01b600052602260045260246000fd5b50919050565b8181038181111561047e5761047e610c37565b60008251610cbf818460208701610af7565b919091019291505056fea264697066735822122080c200ae2c72d1ee9f70b1d5822f2914ed1b18a1dca9ee54e252e5303ee6fcdb64736f6c63430008140033 | null | null | 0 | 1755926415 | 1 | é | 0x1cd0690ff9a693f5ef2dd976660a8dafc81a109c | 1 | Hvè | null | null | null | null | null | null | null | null | null | null | null | null | null | null | |
| enriched_transaction_v2_0xf7c5ace62fc4942569c0290f960d5f0a42d03f4f4890a846011f0157a78fe4af_0 | 0x294cc3c9f252da1cbd60a36b219ba258bd8e3315f37322fba44694cf2b0cebef | 7 | 0xf7c5ace62fc4942569c0290f960d5f0a42d03f4f4890a846011f0157a78fe4af | 36695 | 0 | 0x7a58d9a1cb44c05a240c18dff1f1d17de42f1954 | null | n | 0x60a06040908082526104808038038091610019828561028f565b8339810182828203126101e05761002f826102c6565b60208084015191939091906001600160401b0382116101e057019180601f840112156101e0578251610060816102da565b9361006d8751958661028f565b818552838501928483830101116101e057815f9285809301855e85010152833b1561026f577fa3f0ad74e5423aebfd80d3ef4346578335a9a72aeaee59ff6cb3582b35133d5080546001600160a01b0319166001600160a01b038681169182179092558651635c60da1b60e01b8082529193928582600481885afa918215610265575f9261022e575b50813b156102155750508651837f1cf3b03a6cf19fa2baba4df148e9dcabedea7f8a5c07840e207e5c089be95d3e5f80a28551156101f557508390600488518095819382525afa9182156101eb575f926101a7575b505f8091610184955190845af4903d1561019e573d610169816102da565b906101768851928361028f565b81525f81943d92013e6102f5565b505b60805251610127908161035982396080518160180152f35b606092506102f5565b9391508284813d83116101e4575b6101bf818361028f565b810103126101e0575f80916101d6610184966102c6565b939550915061014b565b5f80fd5b503d6101b5565b86513d5f823e3d90fd5b945050505050346102065750610186565b63b398979f60e01b8152600490fd5b8851634c9c8ce360e01b81529116600482015260249150fd5b9091508581813d831161025e575b610246818361028f565b810103126101e057610257906102c6565b905f6100f6565b503d61023c565b89513d5f823e3d90fd5b8451631933b43b60e21b81526001600160a01b0385166004820152602490fd5b601f909101601f19168101906001600160401b038211908210176102b257604052565b634e487b7160e01b5f52604160045260245ffd5b51906001600160a01b03821682036101e057565b6001600160401b0381116102b257601f01601f191660200190565b9061031c575080511561030a57805190602001fd5b60405163d6bda27560e01b8152600490fd5b8151158061034f575b61032d575090565b604051639996b31560e01b81526001600160a01b039091166004820152602490fd5b50803b1561032556fe60806040819052635c60da1b60e01b81526020816004817f00000000000000000000000000000000000000000000000000000000000000006001600160a01b03165afa90811560a6575f916053575b5060d5565b905060203d60201160a0575b601f8101601f191682019167ffffffffffffffff831181841017608c576087926040520160b1565b5f604e565b634e487b7160e01b5f52604160045260245ffd5b503d605f565b6040513d5f823e3d90fd5b602090607f19011260d1576080516001600160a01b038116810360d15790565b5f80fd5b5f8091368280378136915af43d5f803e1560ed573d5ff35b3d5ffdfea2646970667358221220f84a977137ff48af4034eb3a704b7c19c3b690aabc0e997a1e49c087ee4a075f64736f6c634300081900330000000000000000000000003a7e357602fd8128ad11ef950c21f281a0b201f500000000000000000000000000000000000000000000000000000000000000400000000000000000000000000000000000000000000000000000000000000044485cc955000000000000000000000000d2422ecd886684142005f9d554fdbb9ba5bd4616000000000000000000000000d5ab0ed30d65f01ec6d6a4baca6e466f395334b600000000000000000000000000000000000000000000000000000000 | 2 | 1755927084 | | | 0x56563413cca3fb2dc8354be3fb2aa9dee106d1e5 | 1 | null | null | null | null | null | null | null | null | null | null | null | null | null | null | |||||
| enriched_transaction_v2_0x46d02ff97f8ff9fb21bbf3b8957fccdac413b722642c8ef0c806974346a968ca_0 | 0x303ce0bfed1c65b7ad1e36bfa759ee78b019ad38186713666c1c5b664cd872cd | 1 | 0x46d02ff97f8ff9fb21bbf3b8957fccdac413b722642c8ef0c806974346a968ca | 2001339 | 0 | 0x9ebcb8b25c7baa850ee4c3294d350edfbf211737 | 0x0e56a2094a3c41e1c5593cf6b12ad6a8a15c90af | )Ði | R | w5 | 0x | w5 | 2 | 1756735822 | R | R | null | 1 | w5 | 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 |