data trove market sector performance
Reading
This dataset is a single-record JSON stub describing S&P 500 sector ETF performance since the January 20, 2025 inauguration. With only 1 row and 7 columns — most of which are 'unknown' kind and skipped during profiling — there is very little structured, analyzable data surface available here. The two readable columns (_description and _stub) are fully constant and carry no variation. The meaningful content almost certainly lives inside the nested or unparsed fields (_etf_map, _fields, _key_findings, data), which would need to be unpacked before any real analysis can begin.
citing: row_count · column_count · columns[0].stats.top_value · columns[1].stats.top_value · columns[2].alerts · columns[6].alerts
Charts the summary said to look at first
Show data table
| value | count | share |
|---|---|---|
| S&P 500 sector ETF performance since inauguration (2025-01-20) | 1 | 100.0% |
Show data table
| value | count | share |
|---|---|---|
| True | 1 | 100.0% |
Schema
7 columns| Alerts | ||||
|---|---|---|---|---|
| _stub | categorical | 0.0% | 1 |
long_tail
imbalance
|
| _description | categorical | 0.0% | 1 |
long_tail
imbalance
|
| _sources | unknown | 0.0% | — |
skipped
|
| _fields | unknown | 0.0% | — |
skipped
|
| _etf_map | unknown | 0.0% | — |
skipped
|
| _key_findings | unknown | 0.0% | — |
skipped
|
| data | unknown | 0.0% | — |
skipped
|
_stub
categorical other long_tail imbalanceThis column, '_stub', is a single-row categorical field containing only the value 'True', with a top_rate of 1.0 and cardinality of 1 across n=1 records. It carries zero entropy and zero variance, making it entirely uninformative. The '_stub' name and degenerate structure strongly suggest this is a placeholder or scaffold artifact rather than real data. Treatment: Drop immediately; zero-variance stub column with a single observation provides no modelling or analytical value.
- n
- 1
- nulls
- 0 (0.0%)
- unique
- 1
- top_value
- True
- top_rate
- 1
- cardinality
- 1
- entropy
- 0
- entropy_ratio
- 0
_description
categorical metadata long_tail imbalanceThis column is a single-row dataset description or caption field, containing exactly one unique value: 'S&P 500 sector ETF performance since inauguration (2025-01-20)'. With n=1, cardinality=1, top_rate=1.0, and entropy of 0.0, it carries zero informational variance and is purely a metadata annotation. The 'long_tail' and 'imbalance' alerts are trivially explained by the single-value nature of the column and carry no analytical meaning here. Treatment: Drop before modelling; retain only as a dataset-level annotation or provenance label.
- n
- 1
- nulls
- 0 (0.0%)
- unique
- 1
- top_value
- S&P 500 sector ETF performance since inauguration (2025-01-20)
- top_rate
- 1
- cardinality
- 1
- entropy
- 0
- entropy_ratio
- 0
_sources
unknown metadata skippedThis column contains only a single row and was skipped during profiling, yielding no distributional statistics. It likely represents a metadata or provenance field (e.g., a list or structured object of data sources), but its type is flagged as 'unknown'. With n=1 and no further evidence, nothing meaningful can be inferred about its content or distribution. Treatment: Inspect raw value manually; determine if it is a scalar, list, or JSON blob before deciding whether to expand, drop, or carry as metadata.
- n
- 1
- nulls
- 0 (0.0%)
- unique
- —
_fields
unknown metadata skippedThis column ('_fields') contains only a single row and was skipped during profiling, yielding no distributional statistics. Its name suggests a metadata or schema artifact—possibly a nested/struct field, a JSON blob, or an internal system column—rather than a modellable feature. With n=1 and kind='unknown', no meaningful inference about content or distribution is possible. Treatment: Inspect raw value manually to determine if it encodes nested structure or is a system artifact; drop or unpack before modelling.
- n
- 1
- nulls
- 0 (0.0%)
- unique
- —
_etf_map
unknown other skipped_etf_map appears to be a mapping or metadata column related to ETF (Exchange-Traded Fund) classification, likely storing a dictionary, list, or complex object serialized as a single value. The profile contains only 1 row and no stats were computed (kind marked 'unknown', analysis skipped), making it impossible to characterize value distribution, cardinality, or content. No further inference is possible from the available evidence. Treatment: Inspect raw value to determine structure (e.g. JSON/dict), then flatten or parse before use; re-profile on a full dataset.
- n
- 1
- nulls
- 0 (0.0%)
- unique
- —
_key_findings
unknown other skipped_key_findings is an unclassified column with only 1 row and no computed statistics, meaning saturn skipped profiling it entirely. No distribution, uniqueness, or type information is available. With n=1 the column cannot be meaningfully analysed—it may be a metadata artefact, a header row, or a singleton annotation field. Treatment: Investigate data extraction; with only 1 row this column is unusable for modelling and should be dropped or manually inspected.
- n
- 1
- nulls
- 0 (0.0%)
- unique
- —
data
unknown other skippedThis column contains only a single row and was flagged as 'skipped' by the profiler, likely due to an unrecognized or unsupported data type. No distributional statistics, uniqueness counts, or type information are available, making it impossible to characterize the column's content or role. With n=1 and null_rate=0.0, the dataset itself appears to be a near-empty or singleton record. Treatment: Investigate raw value and data type manually before deciding how to handle; profiler could not parse this column.
- n
- 1
- nulls
- 0 (0.0%)
- unique
- —