Decoded

Human-readable ethereum function signatures and log events.

The decoded schema is nested under the common database. Our decoded bucket of data comprises of 2 tables - function_signatures and event_signatures. Each signature is a mapping between the human-readable function signature and the 4-byte function selector used by EVM. See the official Ethereum Contract ABI documentation for more information.

Function Signatures Table Columns

Column Name	Data Type	Description	Example
text_signature	VARCHAR	The text representation of the function signature	swapExactTokensForTokens(uint256,uint256,address[],address,uint256)
hex_signature	VARCHAR	The hex encoded 4-byte function selector	0x38ed1739

Each signature is a mapping between the human-readable event signature and the 32-byte event selector used by the EVM. See the official Ethereum Contract ABI documentation for more information.

Event Signatures Table Columns

Column Name	Data Type	Description	Example
text_signature	VARCHAR	The text representation of the event signature	Transfer(address,address,uint256)
hex_signature	VARCHAR	The hex encoded 32-byte event selector	0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef