window_end, region and confidence tier. senders counts every address in that band over the window, including the region null at a null confidence.
Columns
| Column | Type | Description |
|---|---|---|
chain_id | STRING | Chain the senders transacted on. |
window_end | DATE | Last UTC day of the trailing 90-day window the row summarizes. Partition column. |
region | STRING | One of seven UTC-offset bands: utc-11..-9, utc-8..-5, utc-4..-2, utc-1..+2, utc+3..+6, utc+7..+9, utc+10..+12. Null when region_confidence is null. |
region_confidence | STRING | high, medium or low, from the same thresholds as Accounts ▸ Registry’s region_confidence, and null where region is null. |
senders | INT64 | Senders on that chain, in that window, region and confidence tier. |
tx_count | INT64 | Transactions those senders initiated over the window. |
sender_share | FLOAT64 | senders divided by the window’s total senders on the chain, from safe_divide. |
tx_share | FLOAT64 | tx_count divided by the window’s total transactions on the chain, from safe_divide. |
Sample queries
- One chain's latest snapshot
- Chain name alongside the distribution
Each row is one region and confidence pair for the window ending
window_end; the null region at a null confidence is the share with no signal.