SIM_STATS_DAILY_SUMMARY

Daily SIM usage totals by SIM and speed class.

SIM_STATS_DAILY_SUMMARY contains pre-aggregated daily traffic totals per SIM and speed class. Prefer it over raw SIM_STATS records whenever you are aggregating daily usage counts or traffic totals and the included dimensions are enough. Those dimensions include SIM, IMSI, operator, date, speed class, and the MISC usage attributes; in Global/SNG tables, SPEED_CLASS can also carry a three-letter country code. Aggregate across SPEED_CLASS when users ask for total daily usage per SIM.

Do not assume SPEED_CLASS is only a plan code. In Global/SNG tables, SPEED_CLASS can be prefixed with a three-letter uppercase country code and hyphen, such as USA-plan01s or MUS-plan01s. It can be empty for non-SIM entries, and the country prefix can be omitted when it does not make sense, such as a planArc01 WireGuard connection. JP entries usually omit the country prefix because JP coverage supports Japan only.

The MISC column contains optional service usage counters and VPG usage attributes.

Public Contract

• Rows are limited to the current SORACOM Query request context.

Data Freshness

Updated daily.

Columns

Column	Type	Description
SIM_ID	TEXT	SIM identifier.
IMSI	TEXT	IMSI used by the SIM or device identifier for non-SIM devices.
OPERATOR_ID	TEXT	Operator identifier associated with the row.
DATE	TEXT	Usage date in YYYYMMDD format.
SPEED_CLASS	TEXT	Speed class for the aggregated usage. Global/SNG values can include a three-letter uppercase country code prefix and hyphen, such as USA-plan01s.
DOWNLINK_BYTES	NUMBER	Total bytes downloaded for the day and speed class.
UPLINK_BYTES	NUMBER	Total bytes uploaded for the day and speed class.
DOWNLINK_PKTS	NUMBER	Total packets downloaded for the day and speed class.
UPLINK_PKTS	NUMBER	Total packets uploaded for the day and speed class.
MISC	OBJECT	Additional service usage counters and VPG usage attributes.

JSON / VARIANT Fields

MISC contains optional service usage counters. Fields appear only when the corresponding usage exists.

Common fields include:

Field	Type	Description
beamStatsMap.inHttp.count	number	Beam inbound HTTP request count.
beamStatsMap.outHttp.count	number	Beam outbound HTTP request count.
beamStatsMap.inHttps.count	number	Beam inbound HTTPS request count.
beamStatsMap.outHttps.count	number	Beam outbound HTTPS request count.
beamStatsMap.inTcp.count	number	Beam inbound TCP request count.
beamStatsMap.outTcp.count	number	Beam outbound TCP request count.
beamStatsMap.inUdp.count	number	Beam inbound UDP request count.
beamStatsMap.outUdp.count	number	Beam outbound UDP request count.
beamStatsMap.inMqtt.count	number	Beam inbound MQTT request count.
beamStatsMap.outMqtt.count	number	Beam outbound MQTT request count.
harvestStatsMap.harvest_inHttp.count	number	Harvest inbound HTTP request count.
harvestStatsMap.harvest_inTcp.count	number	Harvest inbound TCP request count.
harvestStatsMap.harvest_inUdp.count	number	Harvest inbound UDP request count.
harvestStatsMap.harvest_inMqtt.count	number	Harvest inbound MQTT request count.
harvestStatsMap.harvest_outPlain.count	number	Harvest outbound plain request count.
funkStatsMap.funk_outAwsLambda.count	number	Funk AWS Lambda invocation count.
funnelStatsMap.<funnelType>.outputCount	number	Funnel output count for the funnel type.
inVPGStats	object	Usage counters for traffic through VPG.

Example:

SELECT
  SIM_ID,
  DATE,
  MISC:beamStatsMap.inHttp.count::NUMBER AS beam_in_http
FROM SIM_STATS_DAILY_SUMMARY
WHERE MISC:beamStatsMap IS NOT NULL;

Common Queries

SIM_STATS_DAILY_SUMMARY provides daily traffic totals per SIM and SPEED_CLASS. Column names match the SIM_STATS convention: DOWNLINK_BYTES, UPLINK_BYTES, DOWNLINK_PKTS, and UPLINK_PKTS.

Daily traffic by SIM, aggregated across speed classes:

SELECT
  SIM_ID,
  DATE,
  SUM(DOWNLINK_BYTES) AS total_downlink_bytes,
  SUM(UPLINK_BYTES) AS total_uplink_bytes
FROM SIM_STATS_DAILY_SUMMARY
GROUP BY SIM_ID, DATE
ORDER BY DATE, total_downlink_bytes DESC;

Top SIMs for a specific day, aggregated across speed classes:

SELECT
  SIM_ID,
  IMSI,
  SUM(DOWNLINK_BYTES + UPLINK_BYTES) AS total_bytes
FROM SIM_STATS_DAILY_SUMMARY
WHERE DATE = '20250101'
GROUP BY SIM_ID, IMSI
ORDER BY total_bytes DESC
LIMIT 100;