State Diffs 🌱

Column Name	Data Type	Description
block_timestamp	TIMESTAMP_NTZ(9)	Timestamp (UTC) of the block that contains this record.
block_number	NUMBER(38,0)	Sequential number of the block that contains this record. Starts at 0 (genesis block) and increments by 1 for each new block.
block_hash	VARCHAR(16777216)	Cryptographic hash of the block header that contains this record. Uniquely identifies a block.
transaction_hash	VARCHAR(16777216)	Hash of the transaction that produced this record. Uniquely identifies a transaction within the blockchain.
address	VARCHAR(16777216)	Wallet or contract address of the account. On EVM chains, a 42-character hex string (0x-prefixed). On other chains, the native address format applies.
output	VARCHAR(16777216)	ABI-encoded return value of a function call. Null if the call reverted or produced no output.
property	VARCHAR(16777216)	State property that changed (e.g. balance, nonce, code, storage).
storage_key	VARCHAR(16777216)	Storage slot key that changed, for storage-type diffs.
change_type	VARCHAR(16777216)	Type of state change (e.g. create, update, delete).
from_value	VARCHAR(16777216)	Value of the property before the transaction.
to_value	VARCHAR(16777216)	Value of the property after the transaction.
state_diff	VARIANT	Structured representation of the full state change.
unique_id	VARCHAR(16777216)	Allium’s deterministic unique identifier for this row. Generated from the fields that uniquely identify the record (e.g. transaction hash + log index). Stable across full refreshes.