Skip to main content
One row per chain per day. Coverage is reported three ways, by senders, by transactions and by native value, because a low share of addresses can still cover most activity.

Columns

ColumnTypeDescription
chain_idSTRINGChain the day’s senders transacted on.
activity_dateDATEUTC calendar day the senders are counted for. Partition column. The latest date is partial until the UTC day closes and is rewritten by the next run.
active_sendersINT64Distinct senders active on the chain that day.
tx_countINT64Transactions initiated on the chain that day, across every sender.
native_valueNUMERICNative value moved on the chain that day, summed across every sender, in the chain’s smallest unit. Null on solana, which has no transaction-level native value.
attributed_sendersINT64Of those, the senders present in dimensions.accounts.
attributed_shareFLOAT64attributed_senders divided by active_senders, from safe_divide.
regioned_sendersINT64Of the day’s active senders, the ones whose region_confidence on Accounts β–Έ Registry is not null.
regioned_shareFLOAT64regioned_senders divided by active_senders, from safe_divide.
regioned_tx_shareFLOAT64Transactions from regioned senders divided by tx_count, from safe_divide.
regioned_value_shareFLOAT64Native value from regioned senders divided by native_value, from safe_divide.

Sample queries

attributed_share is null rather than a divide error on a day with zero active senders, since the column comes from safe_divide.