Enriched Transactions
Chain
Robinhood Chain MainnetDataset name
robinhood_mainnet.receipt_transactionsVersion
1.1.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_0x544a394bfdf9cd93a5c16682c37bb95bc0933230aec1f56483d845b963345723_1 | 0x93b495f113f3bbfdfcb8f0419d75ee63290b12b051c0030fc393d403566b483e | 0 | 0x544a394bfdf9cd93a5c16682c37bb95bc0933230aec1f56483d845b963345723 | 6 | 1 | 0x00000000000000000000000000000000000a4b05 | 0x00000000000000000000000000000000000a4b05 | 0x9998269e0000000000000000000000000000000000000000000000000000000069f3a55f000000000000000000000000daa526086787d9debe1d7f3ffdb1fe50cf8687f4000000000000000000000000000000000000000000000000000000000000000100000000000000000000000000000000000000000000000000000000000000490000000000000000000000000000000000000000000000000000000000000032000000000000000000000000000000000000000000000000000000000000188a0000000000000000000000000000000000000000000000000000000044315379 | null | null | 106 | 1777575263 | null | 1 | õá | null | null | null | null | null | null | null | null | 24994843 | null | null | null | null | ||||||
| enriched_transaction_v2_0x87ed5ed315de4e7068be7298374b525a99fd321032120e8f71ca93c9789fa53f_1 | 0x1f987d5443d44025a9eaf6d434365739b10366aa57a68826e35f18c4d5d81f00 | 7 | 0x87ed5ed315de4e7068be7298374b525a99fd321032120e8f71ca93c9789fa53f | 13 | 1 | 0xc8451c5de260e7ea1b879e7994967077e71230ca | null | X | õá | 0x6101206040523480156200001257600080fd5b50604051620014e8380380620014e8833981016040819052620000359162000322565b6080849052848484846001600160a01b03841615806200005c57506001600160a01b038216155b806200006f57506001600160a01b038116155b156200008e5760405163d92e233d60e01b815260040160405180910390fd5b6001600160a01b0393841660a05290831660c052821660e0525081166101005260408051600481526024810182526020810180516001600160e01b03166302881c7960e11b17905290516000918291606491620000eb9162000389565b600060405180830381855afa9150503d806000811462000128576040519150601f19603f3d011682016040523d82523d6000602084013e6200012d565b606091505b50915091508115806200014257508051602014155b80620001615750808060200190518101906200015f9190620003ba565b155b1562000180576040516323a7aa6760e11b815260040160405180910390fd5b6001600160a01b038516600114620002f857610100516040516314fc51a960e31b81526001600160a01b038781166004830152600092169063a7e28d48906024016020604051808303816000875af1158015620001e1573d6000803e3d6000fd5b505050506040513d601f19601f82011682018060405250810190620002079190620003d4565b9050806001600160a01b0316856001600160a01b0316146200024c57604051632ee238ef60e21b81526001600160a01b03871660048201526024015b60405180910390fd5b61010051604051635ed004ff60e11b81526001600160a01b038881166004830152600092169063bda009fe90602401602060405180830381865afa15801562000299573d6000803e3d6000fd5b505050506040513d601f19601f82011682018060405250810190620002bf9190620003d4565b90506001600160a01b038116620002f5576040516303f585af60e31b81526001600160a01b038816600482015260240162000243565b50505b50505050505050620003f9565b80516001600160a01b03811681146200031d57600080fd5b919050565b600080600080600060a086880312156200033b57600080fd5b620003468662000305565b9450602086015193506200035d6040870162000305565b92506200036d6060870162000305565b91506200037d6080870162000305565b90509295509295909350565b6000825160005b81811015620003ac576020818601810151858301520162000390565b506000920191825250919050565b600060208284031215620003cd57600080fd5b5051919050565b600060208284031215620003e757600080fd5b620003f28262000305565b9392505050565b60805160a05160c05160e0516101005161105762000491600039600081816101380152818161072301526108750152600081816102680152818161045b01526107ac01526000818160da015281816103be015281816104e20152818161051c0152818161054b015281816106f8015261081001526000818161021f015281816106410152610838015260006105b601526110576000f3fe6080604052600436106100b45760003560e01c806370898f7811610069578063af76af281161004e578063af76af2814610241578063ec46da4414610256578063fbd5dfae1461028a57600080fd5b806370898f78146101e0578063a796efb31461020d57600080fd5b80630bc6d25c1161009a5780630bc6d25c1461015a57806349f426501461018a57806356bdaefe146101b257600080fd5b80622698b6146100c8578063092e57481461012657600080fd5b366100c3576100c161029f565b005b600080fd5b3480156100d457600080fd5b506100fc7f000000000000000000000000000000000000000000000000000000000000000081565b60405173ffffffffffffffffffffffffffffffffffffffff90911681526020015b60405180910390f35b34801561013257600080fd5b506100fc7f000000000000000000000000000000000000000000000000000000000000000081565b34801561016657600080fd5b5061017a610175366004610dd1565b610342565b604051901515815260200161011d565b34801561019657600080fd5b506100fc73eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee81565b3480156101be57600080fd5b506101d26101cd366004610dd1565b610354565b60405190815260200161011d565b3480156101ec57600080fd5b506101d26101fb366004610dd1565b60006020819052908152604090205481565b34801561021957600080fd5b506100fc7f000000000000000000000000000000000000000000000000000000000000000081565b34801561024d57600080fd5b506100c161029f565b34801561026257600080fd5b506100fc7f000000000000000000000000000000000000000000000000000000000000000081565b34801561029657600080fd5b506100c161039b565b476102bd73eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee610342565b80156102c95750600081115b1561033f576102eb73eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee6105b1565b6102f481610604565b60405181815273eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee907fb090d75dece18b4de34535e4c300e242a3126f8eb4572a306e40ba111a5d1341906020015b60405180910390a25b50565b600061034d82610354565b1592915050565b73ffffffffffffffffffffffffffffffffffffffff8116600090815260208190526040812054428111156103915761038c4282610e1d565b610394565b60005b9392505050565b7fffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff7f000000000000000000000000000000000000000000000000000000000000000073ffffffffffffffffffffffffffffffffffffffff160161042a576040517f0b712fcc00000000000000000000000000000000000000000000000000000000815260040160405180910390fd5b6040517f70a082310000000000000000000000000000000000000000000000000000000081523060048201526000907f000000000000000000000000000000000000000000000000000000000000000073ffffffffffffffffffffffffffffffffffffffff16906370a0823190602401602060405180830381865afa1580156104b7573d6000803e3d6000fd5b505050506040513d601f19601f820116820180604052508101906104db9190610e36565b90506105067f0000000000000000000000000000000000000000000000000000000000000000610342565b80156105125750600081115b1561033f576105407f00000000000000000000000000000000000000000000000000000000000000006105b1565b610549816106bb565b7f000000000000000000000000000000000000000000000000000000000000000073ffffffffffffffffffffffffffffffffffffffff167fb090d75dece18b4de34535e4c300e242a3126f8eb4572a306e40ba111a5d13418260405161033691815260200190565b6105db7f000000000000000000000000000000000000000000000000000000000000000042610e4f565b73ffffffffffffffffffffffffffffffffffffffff909116600090815260208190526040902055565b6040517f25e1606300000000000000000000000000000000000000000000000000000000815273ffffffffffffffffffffffffffffffffffffffff7f00000000000000000000000000000000000000000000000000000000000000001660048201526064906325e1606390839060240160206040518083038185885af1158015610692573d6000803e3d6000fd5b50505050506040513d601f19601f820116820180604052508101906106b79190610e36565b5050565b6040517fbda009fe00000000000000000000000000000000000000000000000000000000815273ffffffffffffffffffffffffffffffffffffffff7f0000000000000000000000000000000000000000000000000000000000000000811660048301526000917f00000000000000000000000000000000000000000000000000000000000000009091169063bda009fe90602401602060405180830381865afa15801561076c573d6000803e3d6000fd5b505050506040513d601f19601f820116820180604052508101906107909190610e62565b90506107d373ffffffffffffffffffffffffffffffffffffffff7f0000000000000000000000000000000000000000000000000000000000000000168284610909565b6040517f7b3a3c8b00000000000000000000000000000000000000000000000000000000815273ffffffffffffffffffffffffffffffffffffffff7f0000000000000000000000000000000000000000000000000000000000000000811660048301527f0000000000000000000000000000000000000000000000000000000000000000811660248301526044820184905260806064830152600060848301527f00000000000000000000000000000000000000000000000000000000000000001690637b3a3c8b9060a4016000604051808303816000875af11580156108be573d6000803e3d6000fd5b505050506040513d6000823e601f3d9081017fffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffe01682016040526109049190810190610ed2565b505050565b8015806109a957506040517fdd62ed3e00000000000000000000000000000000000000000000000000000000815230600482015273ffffffffffffffffffffffffffffffffffffffff838116602483015284169063dd62ed3e90604401602060405180830381865afa158015610983573d6000803e3d6000fd5b505050506040513d601f19601f820116820180604052508101906109a79190610e36565b155b610a3a576040517f08c379a000000000000000000000000000000000000000000000000000000000815260206004820152603660248201527f5361666545524332303a20617070726f76652066726f6d206e6f6e2d7a65726f60448201527f20746f206e6f6e2d7a65726f20616c6c6f77616e63650000000000000000000060648201526084015b60405180910390fd5b6040805173ffffffffffffffffffffffffffffffffffffffff848116602483015260448083018590528351808403909101815260649092018352602080830180517bffffffffffffffffffffffffffffffffffffffffffffffffffffffff167f095ea7b30000000000000000000000000000000000000000000000000000000017905283518085019094528084527f5361666545524332303a206c6f772d6c6576656c2063616c6c206661696c65649084015261090492869291600091610b05918516908490610baf565b8051909150156109045780806020019051810190610b239190610f92565b610904576040517f08c379a000000000000000000000000000000000000000000000000000000000815260206004820152602a60248201527f5361666545524332303a204552433230206f7065726174696f6e20646964206e60448201527f6f742073756363656564000000000000000000000000000000000000000000006064820152608401610a31565b6060610bbe8484600085610bc6565b949350505050565b606082471015610c58576040517f08c379a000000000000000000000000000000000000000000000000000000000815260206004820152602660248201527f416464726573733a20696e73756666696369656e742062616c616e636520666f60448201527f722063616c6c00000000000000000000000000000000000000000000000000006064820152608401610a31565b73ffffffffffffffffffffffffffffffffffffffff85163b610cd6576040517f08c379a000000000000000000000000000000000000000000000000000000000815260206004820152601d60248201527f416464726573733a2063616c6c20746f206e6f6e2d636f6e74726163740000006044820152606401610a31565b6000808673ffffffffffffffffffffffffffffffffffffffff168587604051610cff9190610fb4565b60006040518083038185875af1925050503d8060008114610d3c576040519150601f19603f3d011682016040523d82523d6000602084013e610d41565b606091505b5091509150610d51828286610d5c565b979650505050505050565b60608315610d6b575081610394565b825115610d7b5782518084602001fd5b816040517f08c379a0000000000000000000000000000000000000000000000000000000008152600401610a319190610fd0565b73ffffffffffffffffffffffffffffffffffffffff8116811461033f57600080fd5b600060208284031215610de357600080fd5b813561039481610daf565b7f4e487b7100000000000000000000000000000000000000000000000000000000600052601160045260246000fd5b81810381811115610e3057610e30610dee565b92915050565b600060208284031215610e4857600080fd5b5051919050565b80820180821115610e3057610e30610dee565b600060208284031215610e7457600080fd5b815161039481610daf565b7f4e487b7100000000000000000000000000000000000000000000000000000000600052604160045260246000fd5b60005b83811015610ec9578181015183820152602001610eb1565b50506000910152565b600060208284031215610ee457600080fd5b815167ffffffffffffffff80821115610efc57600080fd5b818401915084601f830112610f1057600080fd5b815181811115610f2257610f22610e7f565b604051601f82017fffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffe0908116603f01168101908382118183101715610f6857610f68610e7f565b81604052828152876020848701011115610f8157600080fd5b610d51836020830160208801610eae565b600060208284031215610fa457600080fd5b8151801515811461039457600080fd5b60008251610fc6818460208701610eae565b9190910192915050565b6020815260008251806020840152610fef816040850160208701610eae565b601f017fffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffe016919091016040019291505056fea264697066735822122054e513b097f7339d9317fbfab4dc2ec7b2d035fff6dbacda3b32b66cd829936b64736f6c634300081000330000000000000000000000001afa41c006da1605846271e7bdae942f2787f9410000000000000000000000000000000000000000000000000000000000093a80000000000000000000000000000000000000000000000000000000000000000100000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000000000001 | ' | 2 | 1777577809 | ¶v | ¶v | 0x3e99d9ec0a9fdc384f1d2737514bb518e3b895e8 | 1 | õá | null | null | ù- | null | null | null | null | null | null | 24995052 | null | null | null | null | ||
| enriched_transaction_v2_0x94b2eed09d3b74a4f4a0d716cbc93eeb20a74e5dcf59f450754654edf3cacbb0_0 | 0xf4dca264aa609e00476c4137cff1d2ae390cf448ac968cc657a0d6d5e6e42b04 | 0 | 0x94b2eed09d3b74a4f4a0d716cbc93eeb20a74e5dcf59f450754654edf3cacbb0 | 24 | 0 | 0x00000000000000000000000000000000000a4b05 | 0x00000000000000000000000000000000000a4b05 | 0x6bf6a42d000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000017d64fe00000000000000000000000000000000000000000000000000000000000000180000000000000000000000000000000000000000000000000000000000000001 | null | null | 106 | 1777578017 | null | 1 | õá | null | null | null | null | null | null | null | null | 24995070 | 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 |