price_observation

5 rows where product_market_id = 13

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: price, source_type, content_hash, parser_version, 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
127 13 13 2025-10-16 2025-10-16T23:04:11 1.99 EUR     1     200 dom_text a5b9632869f0676fbfdbf8b4fd7885cb3bc0a90f16011742a2ba8cec1b716a85 aldi_nord_www_mvp_v10
154 13 13 2025-10-17 2025-10-17T22:17:08 1.99 EUR     1     200 dom_text 84841dd980f92978ecb996ad6e60c9c875b885cfe14b1c39cc3f97317a1d35f0 aldi_nord_www_mvp_v10
187 13 13 2025-10-19 2025-10-19T22:42:16 1.99 EUR     1     200 dom_text d6200d0ae3f456e8ad6295bb03b12d48ba3db741925a4f0e0f2c1112286a57bf aldi_nord_www_mvp_v10
260 13 13 2025-10-20 2025-10-20T15:30:34 1.29 EUR     1 1.99   200 aldi_dom d6200d0ae3f456e8ad6295bb03b12d48ba3db741925a4f0e0f2c1112286a57bf aldi_nord_www_v13
278 13 13 2025-10-21 2025-10-21T20:20:46 1.99 EUR     1     200 dom_text 2b82fd784e7338f12397dcbe620b2ef8e2180c1295485db439d6839f64608f6e aldi_nord_www_mvp_v10

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);