Documentation: installations_ts_daily
Rate limit: 300 requests per minute. Once the limit is exceeded, any further requests will result in a 429 (Too Many Requests) response.
| Row Name | Type | Example |
|---|---|---|
|
metering_date * UTC calendar day the metrics were aggregated over (time_bucket '1 day' on metered_at)
|
date |
2022-01-01 |
|
device_uid * organization_id + manufacturer + serial_number
|
string |
a2ei-grid01 |
|
uid Last observed uid of the underlying installations_ts rows (device_uid + their metered_at) within the day |
string |
a2ei-grid01_2022-01-01T13:00:00.000+00:00 |
|
output_energy_interval_wh Daily SUM of output energy per interval (Wh) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
2960.4 |
|
ac_input_energy_interval_wh Daily SUM of AC input energy per interval (Wh) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
2960.4 |
|
dc_input_energy_interval_wh Daily SUM of DC input energy per interval (Wh) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
2960.4 |
|
battery_energy_charged_interval_wh Daily SUM of battery energy charged per interval (Wh) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
2960.4 |
|
battery_energy_discharged_interval_wh Daily SUM of battery energy discharged per interval (Wh) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
2960.4 |
|
output_energy_cumulative_wh_delta Gap-aware daily delta (last - first) of cumulative output energy (Wh) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
2961.4 |
|
ac_input_energy_cumulative_wh_delta Gap-aware daily delta (last - first) of cumulative AC input energy (Wh) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
2961.4 |
|
ac_input_energy_cumulative_phase1_wh_delta Gap-aware daily delta (last - first) of cumulative AC input energy phase 1 (Wh) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
987.1 |
|
ac_input_energy_cumulative_phase2_wh_delta Gap-aware daily delta (last - first) of cumulative AC input energy phase 2 (Wh) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
987.1 |
|
ac_input_energy_cumulative_phase3_wh_delta Gap-aware daily delta (last - first) of cumulative AC input energy phase 3 (Wh) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
987.1 |
|
dc_input_energy_cumulative_wh_delta Gap-aware daily delta (last - first) of cumulative DC input energy (Wh) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
2222.2 |
|
battery_energy_charged_cumulative_wh_delta Gap-aware daily delta (last - first) of cumulative battery energy charged (Wh) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
372.5 |
|
battery_energy_discharged_cumulative_wh_delta Gap-aware daily delta (last - first) of cumulative battery energy discharged (Wh) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
340.2 |
|
output_voltage_v_avg Daily AVG of output voltage (V) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
164.65 |
|
output_voltage_v_max Daily MAX of output voltage (V) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
172.1 |
|
output_voltage_v_min Daily MIN of output voltage (V) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
158.3 |
|
output_voltage_v_stddev Daily sample STDDEV of output voltage (V) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
2.15 |
|
ac_input_voltage_v_avg Daily AVG of AC input voltage (V) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
164.65 |
|
ac_input_voltage_v_max Daily MAX of AC input voltage (V) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
172.1 |
|
ac_input_voltage_v_min Daily MIN of AC input voltage (V) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
158.3 |
|
ac_input_voltage_v_stddev Daily sample STDDEV of AC input voltage (V) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
2.15 |
|
ac_input_voltage_phase1_v_avg Daily AVG of AC input voltage phase 1 (V) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
164.65 |
|
ac_input_voltage_phase1_v_max Daily MAX of AC input voltage phase 1 (V) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
172.1 |
|
ac_input_voltage_phase1_v_min Daily MIN of AC input voltage phase 1 (V) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
158.3 |
|
ac_input_voltage_phase1_v_stddev Daily sample STDDEV of AC input voltage phase 1 (V) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
2.15 |
|
ac_input_voltage_phase2_v_avg Daily AVG of AC input voltage phase 2 (V) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
164.65 |
|
ac_input_voltage_phase2_v_max Daily MAX of AC input voltage phase 2 (V) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
172.1 |
|
ac_input_voltage_phase2_v_min Daily MIN of AC input voltage phase 2 (V) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
158.3 |
|
ac_input_voltage_phase2_v_stddev Daily sample STDDEV of AC input voltage phase 2 (V) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
2.15 |
|
ac_input_voltage_phase3_v_avg Daily AVG of AC input voltage phase 3 (V) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
164.65 |
|
ac_input_voltage_phase3_v_max Daily MAX of AC input voltage phase 3 (V) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
172.1 |
|
ac_input_voltage_phase3_v_min Daily MIN of AC input voltage phase 3 (V) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
158.3 |
|
ac_input_voltage_phase3_v_stddev Daily sample STDDEV of AC input voltage phase 3 (V) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
2.15 |
|
dc_input_voltage_v_avg Daily AVG of DC input voltage (V) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
164.65 |
|
dc_input_voltage_v_max Daily MAX of DC input voltage (V) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
172.1 |
|
dc_input_voltage_v_min Daily MIN of DC input voltage (V) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
158.3 |
|
dc_input_voltage_v_stddev Daily sample STDDEV of DC input voltage (V) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
2.15 |
|
battery_voltage_v_avg Daily AVG of battery voltage (V) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
23.6 |
|
battery_voltage_v_max Daily MAX of battery voltage (V) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
25.1 |
|
battery_voltage_v_min Daily MIN of battery voltage (V) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
22.0 |
|
battery_voltage_v_stddev Daily sample STDDEV of battery voltage (V) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
0.65 |
|
output_current_a_avg Daily AVG of output current (A) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
22.61 |
|
output_current_a_max Daily MAX of output current (A) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
28.4 |
|
output_current_a_min Daily MIN of output current (A) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
18.05 |
|
output_current_a_stddev Daily sample STDDEV of output current (A) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
1.1 |
|
ac_input_current_a_avg Daily AVG of AC input current (A) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
22.61 |
|
ac_input_current_a_max Daily MAX of AC input current (A) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
28.4 |
|
ac_input_current_a_min Daily MIN of AC input current (A) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
18.05 |
|
ac_input_current_a_stddev Daily sample STDDEV of AC input current (A) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
1.1 |
|
ac_input_current_phase1_a_avg Daily AVG of AC input current phase 1 (A) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
22.61 |
|
ac_input_current_phase1_a_max Daily MAX of AC input current phase 1 (A) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
28.4 |
|
ac_input_current_phase1_a_min Daily MIN of AC input current phase 1 (A) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
18.05 |
|
ac_input_current_phase1_a_stddev Daily sample STDDEV of AC input current phase 1 (A) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
1.1 |
|
ac_input_current_phase2_a_avg Daily AVG of AC input current phase 2 (A) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
22.61 |
|
ac_input_current_phase2_a_max Daily MAX of AC input current phase 2 (A) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
28.4 |
|
ac_input_current_phase2_a_min Daily MIN of AC input current phase 2 (A) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
18.05 |
|
ac_input_current_phase2_a_stddev Daily sample STDDEV of AC input current phase 2 (A) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
1.1 |
|
ac_input_current_phase3_a_avg Daily AVG of AC input current phase 3 (A) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
22.61 |
|
ac_input_current_phase3_a_max Daily MAX of AC input current phase 3 (A) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
28.4 |
|
ac_input_current_phase3_a_min Daily MIN of AC input current phase 3 (A) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
18.05 |
|
ac_input_current_phase3_a_stddev Daily sample STDDEV of AC input current phase 3 (A) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
1.1 |
|
dc_input_current_a_avg Daily AVG of DC input current (A) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
22.61 |
|
dc_input_current_a_max Daily MAX of DC input current (A) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
28.4 |
|
dc_input_current_a_min Daily MIN of DC input current (A) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
18.05 |
|
dc_input_current_a_stddev Daily sample STDDEV of DC input current (A) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
1.1 |
|
battery_current_io_a_avg Daily AVG of battery I/O current (A) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
10.1 |
|
battery_current_io_a_max Daily MAX of battery I/O current (A) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
15.4 |
|
battery_current_io_a_min Daily MIN of battery I/O current (A) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
-12.2 |
|
battery_current_io_a_stddev Daily sample STDDEV of battery I/O current (A) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
3.05 |
|
output_power_w_avg Daily AVG of output power (W) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
1489.6 |
|
output_power_w_max Daily MAX of output power (W) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
1820.0 |
|
output_power_w_min Daily MIN of output power (W) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
1120.5 |
|
output_power_w_stddev Daily sample STDDEV of output power (W) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
95.2 |
|
ac_input_power_w_avg Daily AVG of AC input power (W) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
1489.6 |
|
ac_input_power_w_max Daily MAX of AC input power (W) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
1820.0 |
|
ac_input_power_w_min Daily MIN of AC input power (W) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
1120.5 |
|
ac_input_power_w_stddev Daily sample STDDEV of AC input power (W) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
95.2 |
|
dc_input_power_w_avg Daily AVG of DC input power (W) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
1489.6 |
|
dc_input_power_w_max Daily MAX of DC input power (W) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
1820.0 |
|
dc_input_power_w_min Daily MIN of DC input power (W) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
1120.5 |
|
dc_input_power_w_stddev Daily sample STDDEV of DC input power (W) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
95.2 |
|
battery_power_io_w_avg Daily AVG of battery I/O power (W, >0 charging) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
-37.58 |
|
battery_power_io_w_max Daily MAX of battery I/O power (W, >0 charging) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
240.0 |
|
battery_power_io_w_min Daily MIN of battery I/O power (W, >0 charging) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
-310.5 |
|
battery_power_io_w_stddev Daily sample STDDEV of battery I/O power (W) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
88.4 |
|
ac_input_power_factor_avg Daily AVG of AC input power factor (0-1) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
0.45 |
|
ac_input_power_factor_max Daily MAX of AC input power factor (0-1) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
0.62 |
|
ac_input_power_factor_min Daily MIN of AC input power factor (0-1) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
0.31 |
|
ac_input_power_factor_stddev Daily sample STDDEV of AC input power factor (0-1) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
0.05 |
|
ac_input_power_factor_phase1_avg Daily AVG of AC input power factor phase 1 (0-1) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
0.45 |
|
ac_input_power_factor_phase1_max Daily MAX of AC input power factor phase 1 (0-1) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
0.62 |
|
ac_input_power_factor_phase1_min Daily MIN of AC input power factor phase 1 (0-1) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
0.31 |
|
ac_input_power_factor_phase1_stddev Daily sample STDDEV of AC input power factor phase 1 (0-1) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
0.05 |
|
ac_input_power_factor_phase2_avg Daily AVG of AC input power factor phase 2 (0-1) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
0.45 |
|
ac_input_power_factor_phase2_max Daily MAX of AC input power factor phase 2 (0-1) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
0.62 |
|
ac_input_power_factor_phase2_min Daily MIN of AC input power factor phase 2 (0-1) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
0.31 |
|
ac_input_power_factor_phase2_stddev Daily sample STDDEV of AC input power factor phase 2 (0-1) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
0.05 |
|
ac_input_power_factor_phase3_avg Daily AVG of AC input power factor phase 3 (0-1) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
0.45 |
|
ac_input_power_factor_phase3_max Daily MAX of AC input power factor phase 3 (0-1) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
0.62 |
|
ac_input_power_factor_phase3_min Daily MIN of AC input power factor phase 3 (0-1) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
0.31 |
|
ac_input_power_factor_phase3_stddev Daily sample STDDEV of AC input power factor phase 3 (0-1) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
0.05 |
|
output_frequency_hz_avg Daily AVG of output frequency (Hz) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
58.93 |
|
output_frequency_hz_max Daily MAX of output frequency (Hz) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
60.05 |
|
output_frequency_hz_min Daily MIN of output frequency (Hz) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
57.8 |
|
output_frequency_hz_stddev Daily sample STDDEV of output frequency (Hz) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
0.35 |
|
ac_input_frequency_hz_avg Daily AVG of AC input frequency (Hz) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
58.93 |
|
ac_input_frequency_hz_max Daily MAX of AC input frequency (Hz) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
60.05 |
|
ac_input_frequency_hz_min Daily MIN of AC input frequency (Hz) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
57.8 |
|
ac_input_frequency_hz_stddev Daily sample STDDEV of AC input frequency (Hz) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
0.35 |
|
battery_state_of_charge_percent_avg Daily AVG of battery state of charge (%) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
76.8 |
|
battery_state_of_charge_percent_max Daily MAX of battery state of charge (%) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
99.0 |
|
battery_state_of_charge_percent_min Daily MIN of battery state of charge (%) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
41.2 |
|
battery_state_of_charge_percent_stddev Daily sample STDDEV of battery state of charge (%) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
12.4 |
|
battery_temperature_celsius_avg Daily AVG of battery temperature (C) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
34.2 |
|
battery_temperature_celsius_max Daily MAX of battery temperature (C) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
41.0 |
|
battery_temperature_celsius_min Daily MIN of battery temperature (C) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
28.5 |
|
battery_temperature_celsius_stddev Daily sample STDDEV of battery temperature (C) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
3.1 |
|
interval_seconds Last observed interval between measurements in seconds Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
3600 |
|
serial_number Serial of the installed device (last observed) |
string |
SHS/123 |
|
manufacturer The manufacturer of the device (last observed) |
string |
Mobisol |
|
ac_input_phase Last observed reported AC input phase |
enum: 1, 2, 3, agg |
2 |
|
paygo_account_status Last observed paygo account status |
string |
active |
|
paygo_unlocked_until Last observed date the paygo account will be locked |
datetime |
2022-01-01T00:03:00.585+00:00 |
|
paygo_days_left Last observed days left until next payment Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
integer |
7 |
|
is_locked Last observed lock state (no energy coming through) |
boolean |
false |
|
created_at Timestamp when row was inserted
|
datetime |
2021-05-03 6:23:55 |
|
updated_at Timestamp when row was updated
|
datetime |
2021-05-03 6:23:55 |
|
source_id References Source of data
|
integer |
1 |
|
organization_id References Organization of data
|
integer |
1 |
|
data_origin Origin of the data, generic or name of the api
|
string |
generic |