Transactions are cryptographically signed instructions from accounts. An account will initiate a transaction to update the state of the Ethereum network. Transactions will always originate from externally owned accounts, a smart contract cannot initiate a transaction.
Transactions need to be broadcast to the whole network. Any node can broadcast a request for a transaction to be executed on the EVM; after this happens, a miner will execute the transaction and propagate the resulting state change to the rest of the network.
ETL data class
Column Name Data Type Note receipt_cumulative_gas_used
receipt_effective_gas_price
Examples
Copy {
"hash" : "0x35c6f6ec2ddb2530a8f01a6dc05666da248b6c1d7124a3f7c80d5e557596e9a7" ,
"nonce" : 154 ,
"transaction_index" : 4 ,
"from_address" : "0x634de605fea9f9c3245034129ea30c2cee399972" ,
"to_address" : "0xa44155ffbce68c9c848f8ea6f28c40311085125e" ,
"value" : 0 ,
"gas" : 1219916 ,
"gas_price" : 84899924 ,
"input": "0x733f53280000000000000000000000000000000000000000000000000000000000000040000000000000000000000000000000000000000000000000000000000000016000000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000000000020000000000000000000000000000000000000000000000000000000000000006d00000000000000000000000000000000000000000000000000000000000000a00fd0ba716e314ca66bd0c6fb8d27f6da149ab7808057bf36616f42be663d8cce00000000000000000000000000000000000000000000000001593477e4ffffff0000000000000000000000000000000000000000000000000000018bc9c817120000000000000000000000000000000000000000000000000000000000000004302e303200000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000100000000000000000000000000000000000000000000000000000000000000200000000000000000000000000000000000000000000000000000000000000041c3c950926b7e0bf4e7ba1d5c1f367c05ba3bb7036020c2ca1bd65747ac597e0c034b42e85aab0bbebaaa7610e20a676b64b8858af2d1a4437a53a07abeacc6eb1b00000000000000000000000000000000000000000000000000000000000000",
"receipt_cumulative_gas_used" : 2368079 ,
"receipt_gas_used" : 1102725 ,
"receipt_contract_address" : null ,
"receipt_root" : null ,
"receipt_status" : 1 ,
"block_timestamp" : "2023-11-13T09:43:49.000Z" ,
"block_number" : 567347 ,
"block_hash" : "0xf06ba757ac30de0d45c3d3e68c697c39246747009e93ebb528b818297f0c9438" ,
"max_fee_per_gas" : 1671037270 ,
"max_priority_fee_per_gas" : 100000 ,
"transaction_type" : 2 ,
"receipt_effective_gas_price" : 84899924 ,
"receipt_l1_fee" : 698092851650339 ,
"receipt_l1_gas_used" : 7676 ,
"receipt_l1_gas_price" : 69957595267 ,
"receipt_l1_fee_scalar" : 1.3
}
Model in the Database
Column Name Data Type Note receipt_cumulative_gas_used
receipt_effective_gas_price
generated always as (substr(((input)::character varying)::text, 3, 8)) stored
Examples
Copy {
"hash" : "E'\\\\x35C6F6EC2DDB2530A8F01A6DC05666DA248B6C1D7124A3F7C80D5E557596E9A7'" ,
"transaction_index" : 0 ,
"from_address" : "E'\\\\x634DE605FEA9F9C3245034129EA30C2CEE399972'" ,
"to_address" : "E'\\\\xA44155FFBCE68C9C848F8EA6F28C40311085125E'" ,
"value" : 0 ,
"transaction_type" : 2 ,
"input": "E'\\\\x733F53280000000000000000000000000000000000000000000000000000000000000040000000000000000000000000000000000000000000000000000000000000016000000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000000000020000000000000000000000000000000000000000000000000000000000000006D00000000000000000000000000000000000000000000000000000000000000A00FD0BA716E314CA66BD0C6FB8D27F6DA149AB7808057BF36616F42BE663D8CCE00000000000000000000000000000000000000000000000001593477E4FFFFFF0000000000000000000000000000000000000000000000000000018BC9C817120000000000000000000000000000000000000000000000000000000000000004302E303200000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000100000000000000000000000000000000000000000000000000000000000000200000000000000000000000000000000000000000000000000000000000000041C3C950926B7E0BF4E7BA1D5C1F367C05BA3BB7036020C2CA1BD65747AC597E0C034B42E85AAB0BBEBAAA7610E20A676B64B8858AF2D1A4437A53A07ABEACC6EB1B00000000000000000000000000000000000000000000000000000000000000'",
"nonce" : 154 ,
"block_hash" : "E'\\\\xF06BA757AC30DE0D45C3D3E68C697C39246747009E93EBB528B818297F0C9438'" ,
"block_number" : 567347 ,
"block_timestamp" : "2023-11-13 09:43:49.000000" ,
"gas" : 1219916 ,
"gas_price" : 84899924 ,
"max_fee_per_gas" : 1671037270 ,
"max_priority_fee_per_gas" : 100000 ,
"receipt_root" : null ,
"receipt_status" : 1 ,
"receipt_gas_used" : 1102725 ,
"receipt_cumulative_gas_used" : 2368079 ,
"receipt_effective_gas_price" : 84899924 ,
"receipt_l1_fee" : 698092851650339 ,
"receipt_l1_fee_scalar" : 1.3 ,
"receipt_l1_gas_used" : 7676 ,
"receipt_l1_gas_price" : 69957595267 ,
"receipt_blob_gas_used" : null ,
"receipt_blob_gas_price" : null ,
"blob_versioned_hashes" : null ,
"receipt_contract_address" : null ,
"exist_error" : false ,
"error" : null ,
"revert_reason" : null ,
"create_time" : "2024-08-12 13:38:46.949956" ,
"update_time" : null ,
"reorg" : false ,
"method_id" : "733f5328"
}
Copy 0x35C6F6EC2DDB2530A8F01A6DC05666DA248B6C1D7124A3F7C80D5E557596E9A7,0,0x634DE605FEA9F9C3245034129EA30C2CEE399972,0xA44155FFBCE68C9C848F8EA6F28C40311085125E,0,2,0x733F53280000000000000000000000000000000000000000000000000000000000000040000000000000000000000000000000000000000000000000000000000000016000000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000000000020000000000000000000000000000000000000000000000000000000000000006D00000000000000000000000000000000000000000000000000000000000000A00FD0BA716E314CA66BD0C6FB8D27F6DA149AB7808057BF36616F42BE663D8CCE00000000000000000000000000000000000000000000000001593477E4FFFFFF0000000000000000000000000000000000000000000000000000018BC9C817120000000000000000000000000000000000000000000000000000000000000004302E303200000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000100000000000000000000000000000000000000000000000000000000000000200000000000000000000000000000000000000000000000000000000000000041C3C950926B7E0BF4E7BA1D5C1F367C05BA3BB7036020C2CA1BD65747AC597E0C034B42E85AAB0BBEBAAA7610E20A676B64B8858AF2D1A4437A53A07ABEACC6EB1B00000000000000000000000000000000000000000000000000000000000000,154,0xF06BA757AC30DE0D45C3D3E68C697C39246747009E93EBB528B818297F0C9438,567347,2023-11-13 09:43:49.000000,1219916,84899924,1671037270,100000,null,1,1102725,2368079,84899924,698092851650339,1.3,7676,69957595267,null,null,null,null,false,null,null,2024-08-12 13:38:46.949956,null,false,733f5328