polkadot.events

Table description

The events table (e.g. polkadot.events) holds all events that occur on the chain, including their pallet section and method, as well as the decoded data involved in the event. Common queries on the events table will typically filter on block_time, section and method and extract JSON encoded information in data or decoded_data.

Table Schema

Column	Type	Description
`year`	`INTEGER`	Calendar year of the block (partition column)
`month`	`INTEGER`	Calendar month of the block (partition column)
`section`	`VARCHAR`	The pallet (module) that emitted this event (e.g. `Balances`, `System`)
`method`	`VARCHAR`	The event method name within the pallet (e.g. `Transfer`, `ExtrinsicSuccess`)
`block_time`	`TIMESTAMP`	The timestamp of the block containing this event
`block_number`	`BIGINT`	The sequential number of the block containing this event
`extrinsic_id`	`VARCHAR`	Identifier of the extrinsic that triggered this event
`event_id`	`VARCHAR`	Unique identifier for this event (format: `blockNumber-eventIndex`)
`data`	`VARCHAR`	JSON-encoded event data
`extrinsic_hash`	`VARBINARY`	Hash of the extrinsic that triggered this event
`block_hash`	`VARBINARY`	Hash of the block containing this event
`data_decoded`	`VARCHAR`	Human-readable decoded event data
`updated_at`	`TIMESTAMP`	When this record was last updated in the database
`ingested_at`	`TIMESTAMP`	When this record was first ingested into the database

Curated Data

Solana

Hyperliquid

Non-EVM Networks

Protocols

EVM Networks

Other Networks

Protocols

Partner Data

Dune Index

Table description

Table Schema

Table Sample

Curated Data

Solana

Hyperliquid

Non-EVM Networks

Protocols

EVM Networks

Other Networks

Protocols

Partner Data

Dune Index

​Table description

​Table Schema

​Table Sample

Table description

Table Schema

Table Sample