Columns
| Column | Type | Description |
|---|---|---|
chain_id | STRING | Chain the dayβs senders transacted on. |
activity_date | DATE | UTC 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_senders | INT64 | Distinct senders active on the chain that day. |
tx_count | INT64 | Transactions initiated on the chain that day, across every sender. |
native_value | NUMERIC | Native 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_senders | INT64 | Of those, the senders present in dimensions.accounts. |
attributed_share | FLOAT64 | attributed_senders divided by active_senders, from safe_divide. |
regioned_senders | INT64 | Of the dayβs active senders, the ones whose region_confidence on Accounts βΈ Registry is not null. |
regioned_share | FLOAT64 | regioned_senders divided by active_senders, from safe_divide. |
regioned_tx_share | FLOAT64 | Transactions from regioned senders divided by tx_count, from safe_divide. |
regioned_value_share | FLOAT64 | Native value from regioned senders divided by native_value, from safe_divide. |
Sample queries
- One chain, one day
- 30-day trend for one chain
attributed_share is null rather than a divide error on a day with zero active senders, since the column comes from safe_divide.