Skip to main content

​
Table description

The polkadot.traces table, also known as the “snapshot” table, stores relevant on-chain state data that is otherwise difficult to acquire from base Substrate tables such as extrinsics and events. The traces tables are populated with special scripts modeling key storage elements at the end of the hour or day. Having these snapshots enables Dune analysts to build useful dashboards on Dune such as:

​
Table Schema

ColumnTypeDescription
yearINTEGERCalendar year of the snapshot (partition column)
monthINTEGERCalendar month of the snapshot (partition column)
sectionVARCHARThe pallet (module) of the storage item being traced
storageVARCHARThe specific storage item name being traced
tsTIMESTAMPTimestamp of the state snapshot
block_numberBIGINTThe block number at which the snapshot was taken
block_hashVARBINARYHash of the block at which the snapshot was taken
chain_nameVARCHARName of the Substrate chain (e.g. polkadot, kusama, hydradx)
address_ss58VARCHARSS58-encoded address associated with this trace entry
address_pubkeyVARBINARYPublic key associated with this trace entry
trackVARCHARCategory or governance track for grouping trace data
track_valVARCHARValue associated with the track
kvVARCHARJSON-encoded key-value data from the storage item
pvVARCHARProtocol version or parameter value
sourceVARCHARSource or origin of the trace data
updated_atTIMESTAMPWhen this record was last updated in the database
ingested_atTIMESTAMPWhen this record was first ingested into the database

​
Table Sample