price_observation

4 rows where product_market_id = 15

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: price, 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
139 15 15 2025-10-17 2025-10-17T08:29:41 0.99 EUR     0     200 dom_attr 17adb8a4316704fb708fd158067542f320988716ae7939d3ffe92e457454fba9 aldi_sued_www_mvp_v2
167 15 15 2025-10-18 2025-10-18T08:09:56 0.99 EUR     0     200 dom_attr 76893291ca8238fcf98b8c180f02d1ce5a60945891652376928aaa6593f785bf aldi_sued_www_mvp_v2
184 15 15 2025-10-19 2025-10-19T22:30:57 0.99 EUR     0     200 dom_attr 76893291ca8238fcf98b8c180f02d1ce5a60945891652376928aaa6593f785bf aldi_sued_www_mvp_v2
196 15 15 2025-10-20 2025-10-20T07:57:00 1.59 EUR     0     200 dom_attr c81bc590e4671921cee8c1da72e31ad4f101e83a593fe6716f765499164dead1 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);