price_observation

4 rows where product_market_id = 19

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: is_promo, source_type, 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
155 19 19 2025-10-17 2025-10-17T22:17:27 0.99 EUR     1     200 dom_text 0511c9932b8e8cb276231a4b9e89b6859689a6a6b184005aa2b509b9e5f3b1c1 aldi_nord_www_mvp_v10
188 19 19 2025-10-19 2025-10-19T22:42:35 0.99 EUR     1     200 dom_text b26bb331c073107eead12f12a476dcb31427de21fe0f32cb4640dd9d72cf1591 aldi_nord_www_mvp_v10
261 19 19 2025-10-20 2025-10-20T15:30:44 0.99 EUR     0     200 aldi_dom bbff556bdc14af90db4d0c0e96e5f0f9b0e381056eec606f6286e44fc275e755 aldi_nord_www_v13
279 19 19 2025-10-21 2025-10-21T20:20:49 0.99 EUR     0     200 dom_text a06dcbc4a3f3cd18e90c7b15cd7bd286b2c211691b79bab9a2bb4ace5d58d38b 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);