...

Occupancy over time data is stored in occupancy-*.parquet files. Each event contains timestamp and occupancy value for the queue / location.

Data schema

binary environment (STRING) - not relevant/not used
binary organization (STRING) - name of organization this event belongs to
binary session (STRING) - ticket identifier for position-related events, guid for other eventsnot relevant/not used
binary app (STRING) - not relevant/not used
binary queueId (STRING) - queue identifier
int32 count - occupancy count at the time of event
binary type (STRING) - constant , value is (positions_inside_store)
int96 date - event date
binary id (STRING) - internal event id, not relevant/not used
int64 timestamp - event timestamp

Enter/exit events

These events are related to occupancy in physical location and reflect people going in and out at the location. Data is stored in exit-*.parquet and enter-*.parquet files.

Data schema:

binary environment (STRING) - not relevant/not used
binary organization (STRING) - name of organization this event belongs to
binary session (STRING) - not relevant/not used
binary app (STRING) - not relevant/not used
binary queueId (STRING) - queue identifier
int32 count - people going in/out count (depending on event type)
binary isManual (STRING) - indicates whether this occupancy change has been triggered manually by the staff using +/- buttons in staff UI
binary type (STRING) -
int96 date - event date
binary id (STRING) - internal event id, not relevant/not used
int64 timestamp - event timestamp