Sui

sui holds the standardized Sui tables, following the Sui schema documented in the family overview. Sui treats everything on the chain as an object with an owner, which sets it apart from the other Move chains. Its blocks rows are checkpoints, the groups it batches transactions into, rather than blocks in the usual sense. The objects, transaction_objects and wrapped_objects tables record every version of every object a transaction touched. Above the raw tables sits the rest of the catalog, and Sui shows up in two parts of it: the list of tokens we know about with their daily prices, and the tokenized assets issued on the chain. Tokens covers the token list and the daily price table. Real-world assets and Stablecoins cover the tokenized assets and their daily tables.

Tables

Table	Since	Description
`blocks`	2023-05	One row per checkpoint.
`transactions`	2023-05	One row per transaction, with its gas costs and effects attached.
`events`	2023-05	One row per event a transaction emitted.
`move_calls`	2023-05	One row per Move call command a transaction executed.
`move_packages`	2023-05	One row per package version published on chain.
`objects`	2023-04	One row per object version a transaction wrote, with the object contents.
`transaction_objects`	2023-05	One row per object a transaction touched, without the contents.
`wrapped_objects`	2023-05	One row per object wrapped inside another object.
`transaction_expirations`	2026-01	One row per transaction that expires by a validity window rather than by epoch.
`funds_withdrawals`	2026-05	One row per address-balance withdrawal a transaction reserved.
`accumulator_writes`	2026-05	One row per accumulator a transaction merged into or split from.

objects starts a few weeks earlier than the rest, on 2023-04-12. Use transaction_objects when the question is which objects a transaction touched, and objects when what was in them matters.

Every table except blocks splits by day on block_timestamp, and blocks on timestamp. Bound that column in every query; without a bound the query reads the whole table.

Sui groups its transactions into checkpoints rather than blocks, and a checkpoint is what this table holds. blocks contains one row per checkpoint.

Column	Type	Description
`timestamp`	TIMESTAMP	The time of the checkpoint. Partition column.
`number`	INT64	The checkpoint sequence number.
`digest`	STRING	The digest of the checkpoint.
`previous_digest`	STRING	The digest of the previous checkpoint.
`epoch`	STRING	The epoch of the checkpoint.
`network_total_transactions`	INT64	The cumulative network transaction count at the checkpoint.
`timestamp_ms`	INT64	The checkpoint timestamp, in Unix milliseconds.
`sequence_number`	INT64	The checkpoint sequence number.
`validator_signature`	STRING	The combined signature of the validators that approved the checkpoint.
`transaction_count`	INT64	The number of transactions in the checkpoint.

Daily checkpoints and transactions

Count checkpoints and the transactions in them per day.

select
    date(timestamp) as day,
    count(*) as checkpoints,
    sum(transaction_count) as transactions
from `sui.blocks`
where timestamp >= timestamp('2026-08-20')
  and timestamp < timestamp('2026-08-21')
group by day

transactions contains one row per transaction, with what it cost to run and its effects, the chain’s own record of everything the transaction changed, attached to the row.

Column	Type	Description
`block_timestamp`	TIMESTAMP	The time of the containing checkpoint. Partition column.
`block_number`	INT64	The sequence number of the containing checkpoint.
`digest`	STRING	The digest of the transaction, the identifier used everywhere else.
`checkpoint`	INT64	The checkpoint sequence number.
`timestamp_ms`	INT64	The checkpoint timestamp, in Unix milliseconds.
`sender`	STRING	The sending address.
`transaction_kind`	STRING	The transaction kind, such as programmable transaction.
`is_system_txn`	BOOL	Whether the transaction is a system transaction.
`is_sponsored_tx`	BOOL	Whether the gas was paid by a sponsor.
`status`	STRING	The execution status: `Success` or `Failure`.
`computation_cost`	BIGNUMERIC	The computation cost, in MIST.
`storage_cost`	BIGNUMERIC	The storage cost, in MIST.
`storage_rebate`	BIGNUMERIC	The storage rebate, in MIST.
`non_refundable_storage_fee`	BIGNUMERIC	The non-refundable part of the storage fee, in MIST.
`total_gas_cost`	BIGNUMERIC	The total gas cost, in MIST.
`gas_budget`	BIGNUMERIC	The gas budget set by the sender.
`gas_price`	BIGNUMERIC	The gas price paid.
`gas_owner`	STRING	The address paying the gas.
`executed_epoch`	INT64	The epoch the transaction executed in.
`expiration_epoch`	INT64	The last epoch the transaction can execute in. NULL for a transaction with no epoch limit.
`transaction_json`	STRING	The sender, kind, expiration kind and gas data, as JSON text.
`effects_json`	STRING	The transaction digest, events digest, Lamport version and dependencies from the execution effects, as JSON text.
`balance_changes_json`	STRING	The balance changes, as JSON text.
`signature_schemes`	ARRAY<STRING>	The scheme of each signature, in order: `Ed25519`, `Secp256k1`, `Secp256r1`, `Multisig`, `Bls12381`, `Zklogin`, `Passkey` or `Mldsa65`.
`signatures`	ARRAY<STRING>	Each signature, serialized and base64-encoded, in order. The first byte is the scheme flag.
`error_kind`	STRING	The error a failed transaction stopped on, such as `MoveAbort` or `InsufficientGas`. NULL on success.
`error_command_index`	INT64	The index of the command that failed. NULL for errors outside a command, such as `InsufficientGas`.
`abort_code`	NUMERIC	The abort code of a `MoveAbort`.
`abort_package`	STRING	The package of the function that aborted.
`abort_module`	STRING	The module of the function that aborted.
`abort_function`	STRING	The name of the function that aborted.
`gas_coins`	ARRAY<STRUCT<object_id STRING, version INT64, digest STRING>>	The coin objects paying for gas, at the version and digest the transaction read. Empty when gas is paid from an address balance.
`gas_object_id`	STRING	The coin object charged for gas, which the other gas coins merge into.
`command_count`	INT64	The number of commands in a programmable transaction.
`input_count`	INT64	The number of inputs to a programmable transaction.
`command_types`	ARRAY<STRING>	The type of each command, in order: `MoveCall`, `TransferObjects`, `SplitCoins`, `MergeCoins`, `Publish`, `MakeMoveVec` or `Upgrade`.
`unchanged_consensus_object_ids`	ARRAY<STRING>	The shared objects the transaction read without changing them.
`transaction_index`	INT64	The position of the transaction in its checkpoint. NULL until the source serves it, and before 2026-01-28.

Daily transactions by kind

Count transactions and successes by transaction kind on one day.

select
    transaction_kind,
    count(*) as transactions,
    countif(status = 'Success') as successful
from `sui.transactions`
where block_timestamp >= timestamp('2026-08-20')
  and block_timestamp < timestamp('2026-08-21')
group by transaction_kind
order by transactions desc

An event is a note that published code writes when something happens inside it. events contains one row per event a transaction produced.

Column	Type	Description
`block_timestamp`	TIMESTAMP	The time of the containing checkpoint. Partition column.
`block_number`	INT64	The sequence number of the containing checkpoint.
`transaction_digest`	STRING	The digest of the emitting transaction.
`checkpoint`	STRING	The checkpoint sequence number as a string.
`epoch`	STRING	The epoch of the event.
`event_index`	INT64	The position of the event within the transaction.
`package_id`	STRING	The package that defines the event type.
`module`	STRING	The module that defines the event type.
`sender`	STRING	The sender of the emitting transaction.
`event_type`	STRING	The Move type of the event.
`event_json`	STRING	The event payload, as JSON text.

Events by module

Rank the modules emitting the most events on one day.

select
    module,
    count(*) as events
from `sui.events`
where block_timestamp >= timestamp('2026-08-20')
  and block_timestamp < timestamp('2026-08-21')
group by module
order by events desc
limit 20

A Sui transaction is a list of commands, and a Move call is the command that runs a function in published code. move_calls contains one row per such call, naming the code and function it ran.

Column	Type	Description
`block_timestamp`	TIMESTAMP	The time of the containing checkpoint. Partition column.
`block_number`	INT64	The sequence number of the containing checkpoint.
`transaction_digest`	STRING	The digest of the calling transaction.
`checkpoint`	STRING	The checkpoint sequence number as a string.
`epoch`	STRING	The epoch of the call.
`cmd_index`	INT64	The position of the command within the transaction.
`package`	STRING	The called package.
`module`	STRING	The called module.
`function`	STRING	The called function.

Most-called functions

Rank the most-called package functions on one day.

select
    package,
    module,
    function,
    count(*) as calls
from `sui.move_calls`
where block_timestamp >= timestamp('2026-08-20')
  and block_timestamp < timestamp('2026-08-21')
group by package, module, function
order by calls desc
limit 20

A package is a published bundle of Move code, and upgrading one publishes a new version of it rather than replacing what was there. move_packages contains one row per version.

Column	Type	Description
`block_timestamp`	TIMESTAMP	The time of the containing checkpoint. Partition column.
`block_number`	INT64	The sequence number of the containing checkpoint.
`transaction_digest`	STRING	The digest of the publishing transaction.
`checkpoint`	STRING	The checkpoint sequence number as a string.
`epoch`	STRING	The epoch of the publish.
`package_id`	STRING	The identifier of the package version.
`package_version`	INT64	The version number of the package.
`original_package_id`	STRING	The identifier of the first version of the package.

Daily package publishes

Count package versions published per day over one week.

select
    date(block_timestamp) as day,
    count(*) as packages_published
from `sui.move_packages`
where block_timestamp >= timestamp('2026-08-16')
  and block_timestamp < timestamp('2026-08-23')
group by day
order by day

On Sui, everything a user holds is an object with an owner, and changing one produces a new version of it rather than editing it in place. objects contains one row per object version a transaction wrote, with the object’s contents on the row.

Column	Type	Description
`block_timestamp`	TIMESTAMP	The time of the containing checkpoint. Partition column.
`block_number`	INT64	The sequence number of the containing checkpoint.
`transaction_digest`	STRING	The digest of the writing transaction.
`checkpoint`	STRING	The checkpoint sequence number as a string.
`object_id`	STRING	The identifier of the object.
`version`	INT64	The version of the object after the write.
`digest_hash`	STRING	The digest of the object version.
`object_status`	STRING	The status of the write, such as created or mutated.
`owner_type`	STRING	The ownership kind, such as address, object or shared.
`owner_address`	STRING	The owning address, when address-owned.
`initial_shared_version`	INT64	The version at which the object became shared.
`storage_rebate`	INT64	The storage rebate held by the object.
`has_public_transfer`	BOOL	Whether the object can be transferred publicly.
`object_type`	STRING	The Move type of the object.
`object_json`	STRING	The object contents, as JSON text.

Object writes by status

Count object writes by status on one day.

select
    object_status,
    count(*) as objects
from `sui.objects`
where block_timestamp >= timestamp('2026-08-20')
  and block_timestamp < timestamp('2026-08-21')
group by object_status
order by objects desc

transaction_objects contains one row per object a transaction touched, without the contents. Use it when the question is which objects were involved rather than what was in them.

Column	Type	Description
`block_timestamp`	TIMESTAMP	The time of the containing checkpoint. Partition column.
`block_number`	INT64	The sequence number of the containing checkpoint.
`transaction_digest`	STRING	The digest of the touching transaction.
`checkpoint`	STRING	The checkpoint sequence number as a string.
`object_id`	STRING	The identifier of the object.
`version`	INT64	The version of the object after the transaction, or the transaction’s version for a deleted object.
`object_status`	STRING	`Created`, `Mutated` or `Deleted`. Before 2026-03-01 a created object is `Mutated`.

Touched objects by status

Count objects touched by status on one day.

select
    object_status,
    count(*) as touches
from `sui.transaction_objects`
where block_timestamp >= timestamp('2026-08-20')
  and block_timestamp < timestamp('2026-08-21')
group by object_status
order by touches desc

An object can be placed inside another object, which is called wrapping: a card held in a deck, say. The inner one then belongs to the outer one instead of to an address. wrapped_objects contains one row per object a transaction wrapped.

Column	Type	Description
`block_timestamp`	TIMESTAMP	The time of the containing checkpoint. Partition column.
`block_number`	INT64	The sequence number of the containing checkpoint.
`transaction_digest`	STRING	The digest of the wrapping transaction.
`checkpoint`	STRING	The checkpoint sequence number as a string.
`object_id`	STRING	The identifier of the wrapped object.
`root_object_id`	STRING	The identifier of the object it is wrapped inside.
`root_object_version`	INT64	The version of the enclosing object.

Daily wraps

Count objects wrapped per day over one week.

select
    date(block_timestamp) as day,
    count(*) as wrapped
from `sui.wrapped_objects`
where block_timestamp >= timestamp('2026-08-16')
  and block_timestamp < timestamp('2026-08-23')
group by day
order by day

A Sui transaction can expire at the end of an epoch or outside a validity window of epochs and timestamps. transaction_expirations contains one row per transaction with a validity window.

Column	Type	Description
`block_timestamp`	TIMESTAMP	The time of the containing checkpoint. Partition column.
`block_number`	INT64	The sequence number of the containing checkpoint.
`transaction_digest`	STRING	The digest of the transaction.
`checkpoint`	INT64	The checkpoint sequence number.
`expiration_kind`	STRING	`ValidDuring` or `Validity`, the same names as `expiration` in the `transaction_json` of `transactions`.
`min_epoch`	INT64	The first epoch the transaction is valid in.
`max_epoch`	INT64	The last epoch the transaction is valid in.
`min_timestamp`	TIMESTAMP	The earliest time the transaction is valid.
`max_timestamp`	TIMESTAMP	The latest time the transaction is valid.
`chain`	STRING	The identifier of the chain the transaction is valid on.
`nonce`	INT64	The nonce that makes the transaction unique within the window.
`allowed_proposers_epoch`	INT64	For `Validity`, the epoch of the allowed proposers.
`allowed_proposers`	ARRAY<INT64>	For `Validity`, the validators allowed to propose the transaction.

Windowed transactions by kind

Count transactions with a validity window by kind on one day.

select
    expiration_kind,
    count(*) as transactions
from `sui.transaction_expirations`
where block_timestamp >= timestamp('2026-08-20')
  and block_timestamp < timestamp('2026-08-21')
group by expiration_kind

A transaction draws on an address balance, rather than on coin objects, by reserving a withdrawal as one of its inputs. funds_withdrawals contains one row per withdrawal input.

Column	Type	Description
`block_timestamp`	TIMESTAMP	The time of the containing checkpoint. Partition column.
`block_number`	INT64	The sequence number of the containing checkpoint.
`transaction_digest`	STRING	The digest of the transaction.
`checkpoint`	INT64	The checkpoint sequence number.
`input_index`	INT64	The position of the withdrawal among the transaction’s inputs.
`amount`	BIGNUMERIC	The most the transaction may withdraw, in the coin’s smallest unit.
`coin_type`	STRING	The coin type withdrawn, such as `0x…0002::sui::SUI`.
`source`	STRING	Whose balance pays: `Sender`, `Sponsor` or `SenderAllowance`.
`funder`	STRING	For `SenderAllowance`, the address whose balance pays.
`allowance`	STRING	For `SenderAllowance`, the allowance object the withdrawal draws on.

Withdrawals by coin

Count withdrawal inputs and reserved amounts by coin type on one day.

select
    coin_type,
    count(*) as withdrawals,
    sum(amount) as reserved
from `sui.funds_withdrawals`
where block_timestamp >= timestamp('2026-08-20')
  and block_timestamp < timestamp('2026-08-21')
group by coin_type
order by withdrawals desc

An accumulator is an object that many transactions add to and take from, such as an address balance of one coin. accumulator_writes contains one row per accumulator a transaction wrote, with the amount it merged or split.

Column	Type	Description
`block_timestamp`	TIMESTAMP	The time of the containing checkpoint. Partition column.
`block_number`	INT64	The sequence number of the containing checkpoint.
`transaction_digest`	STRING	The digest of the transaction.
`checkpoint`	INT64	The checkpoint sequence number.
`object_id`	STRING	The identifier of the accumulator object.
`address`	STRING	The address the accumulator belongs to.
`accumulator_type`	STRING	The Move type of the accumulator, such as `0x…0002::balance::Balance<0x…0002::sui::SUI>`.
`coin_type`	STRING	For an address balance, the coin type it holds. NULL for other accumulators.
`operation`	STRING	`Merge`, which adds to the accumulator, or `Split`, which takes from it.
`integer_value`	BIGNUMERIC	The amount merged or split, in the coin’s smallest unit.
`integer_tuple`	ARRAY<BIGNUMERIC>	For a pair-valued accumulator, the pair. Empty otherwise.
`event_digests`	ARRAY<STRUCT<event_index INT64, digest STRING>>	For an event-stream accumulator, the events added. Empty otherwise.

Address-balance flows by coin

Sum merges and splits into address balances by coin type on one day.

select
    coin_type,
    sum(if(operation = 'Merge', integer_value, 0)) as merged,
    sum(if(operation = 'Split', integer_value, 0)) as split
from `sui.accumulator_writes`
where block_timestamp >= timestamp('2026-08-20')
  and block_timestamp < timestamp('2026-08-21')
  and coin_type is not null
group by coin_type
order by merged desc

Sample queries

Transactions by kind
Priced tokens, daily
Tokenized assets by market cap

Count transactions and gas costs by transaction kind on one day.

select
    transaction_kind,
    count(*) as transactions,
    sum(total_gas_cost) as total_gas_cost_mist
from `sui.transactions`
where block_timestamp >= timestamp('2026-08-20')
  and block_timestamp < timestamp('2026-08-21')
group by transaction_kind
order by transactions desc

Count the Sui tokens that have a daily USD price, day by day.

select
    date(timestamp) as day,
    count(distinct token_id) as priced_tokens
from `metrics_tokens.price_daily`
where timestamp >= timestamp('2026-08-16')
  and timestamp < timestamp('2026-08-23')
  and chain_id = 'sui'
group by day
order by day

Rank the tokenized assets deployed on Sui by circulating market cap.

select
    assets.symbol,
    assets.asset_type,
    daily.market_cap_circulating
from `metrics_asset_tokens.market_cap_circulating_daily` as daily
join `dimensions.asset_tokens` as deployments
    using (asset_token_id)
join `dimensions.assets` as assets
    using (asset_id)
where daily.timestamp >= timestamp('2026-08-22')
  and daily.timestamp < timestamp('2026-08-23')
  and deployments.chain_id = 'sui'
order by daily.market_cap_circulating desc
limit 20

Overview

Popular datasets

Market verticals

Chain ecosystems

Core entities

Tables

Sample queries

​Tables

​Sample queries

Tables

Sample queries