external.bitquery Table: active_users Type: Base Table
What
This model returns the number of active users for each blockchain and as of date. The distinct number of users is from the 30 days prior to the as of date.Columns
| Column Name | Data Type | Description |
|---|---|---|
| BLOCKCHAIN | TEXT | The blockchain where the active users are from. |
| METRIC | TEXT | The metric name - always ‘active_users’. |
| AS_OF_DATE | DATE | The date when the active users are counted. |
| ACTIVE_USERS | TEXT | The number of active users. The distinct number of users is from the 30 days prior to the as of date. |
| _INSERTED_TIMESTAMP | TIMESTAMP_NTZ | _INSERTED_TIMESTAMP column |
| ACTIVE_USERS_ID | TEXT | ACTIVE_USERS_ID column |
| INSERTED_TIMESTAMP | TIMESTAMP_NTZ | INSERTED_TIMESTAMP column |
| MODIFIED_TIMESTAMP | TIMESTAMP_NTZ | MODIFIED_TIMESTAMP column |
| _INVOCATION_ID | TEXT | _INVOCATION_ID column |