Skip to main content
All transactions, starting from genesis.

Table Details

PropertyValue
Table Namecosmos.raw.transactions
Table StatusProduction-Ready
Unique Keyblock_timestamp, hash
Clustering Key(s)to_date("block_timestamp")
Search Optimizationblock_height, hash

Table Columns

Column NameData TypeDescription
block_heightNUMBER(38,0)The sequential number of the block in the blockchain.
block_timestampTIMESTAMP_NTZ(9)The timestamp when the block was created.
block_hashVARCHAR(16777216)The hash of the block containing the transaction.
hashVARCHAR(16777216)The hash of the transaction.
transaction_indexNUMBER(38,0)The index of the transaction within the block.
codeNUMBER(38,0)The code returned after the transaction execution (e.g., 0 for success).
codespaceVARCHAR(16777216)The namespace for the error codes.
gas_usedVARCHAR(16777216)The amount of gas used for the transaction.
gas_wantedVARCHAR(16777216)The amount of gas requested for the transaction.
tx_acc_seqVARCHAR(16777216)The sequence number of the account used in the transaction.
tx_fee_payerVARCHAR(16777216)The address of the account paying the transaction fee.
tx_fee_rawVARCHAR(16777216)The raw fee data for the transaction, containing both amount and denomination.
fee_amountVARCHAR(16777216)The fee amount for the transaction.
fee_denomVARCHAR(16777216)The denomination of the fee amount.
event_countNUMBER(38,0)The number of events associated with the transaction.
logVARCHAR(16777216)The log of the transaction execution in string format. Use try_parse_json to fetch the log details.
infoVARCHAR(16777216)Additional information about the transaction.
txVARCHAR(16777216)The transaction details in a serialized format.
dataVARCHAR(16777216)The data returned from the transaction execution.
_created_atTIMESTAMP_NTZ(9)The timestamp when the entry was created.
_updated_atTIMESTAMP_NTZ(9)The timestamp when the entry was updated.