price_observation

4 rows where product_market_id = 16

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: content_hash, observed_date (date), scraped_at (date)

id ▼ product_market_id observed_date scraped_at price currency unit_price availability is_promo original_price promo_text http_status source_type content_hash parser_version
138 16 16 2025-10-17 2025-10-17T08:29:38 1.39 EUR     0     200 json_ld 948976790a2f7ffa50b436a849a0fb847f3d4b756a085b4b5cb5833e34affe1a aldi_sued_www_mvp_v2
166 16 16 2025-10-18 2025-10-18T08:09:54 1.39 EUR     0     200 json_ld 0cae8131b8978b46ca8e987028b1d9221562ea5b33cbe3355da82f71fe3a3afb aldi_sued_www_mvp_v2
183 16 16 2025-10-19 2025-10-19T22:30:54 1.39 EUR     0     200 json_ld 0cae8131b8978b46ca8e987028b1d9221562ea5b33cbe3355da82f71fe3a3afb aldi_sued_www_mvp_v2
195 16 16 2025-10-20 2025-10-20T07:56:57 1.39 EUR     0     200 json_ld 33ea36957c4f2be15a3374ae8bb404e3833b2266fdc7beab9547570a925c7b1f aldi_sued_www_mvp_v2

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE price_observation (
  id INTEGER PRIMARY KEY,
  product_market_id INTEGER NOT NULL REFERENCES product_market(id),
  observed_date DATE NOT NULL,
  scraped_at TIMESTAMP NOT NULL,
  price NUMERIC,
  currency TEXT DEFAULT 'EUR',
  unit_price NUMERIC,
  availability TEXT,
  is_promo INTEGER DEFAULT 0,
  original_price NUMERIC,
  promo_text TEXT,
  http_status INTEGER,
  source_type TEXT,
  content_hash TEXT,
  parser_version TEXT,
  UNIQUE(product_market_id, observed_date)
);
CREATE INDEX idx_obs_pm_date
  ON price_observation(product_market_id, observed_date);