price_observation
26 rows where product_market_id = 40
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 302 | 40 40 | 2025-10-21 | 2025-10-21T20:31:27 | 1.19 | EUR | 0 | 200 | dom_attr | 604ff334b059bb0736cc3a5bb904942c0b40290ef6db8134ebf0bb4f548a99c8 | aldi_sued_www_mvp_v2 | ||||
| 332 | 40 40 | 2025-10-25 | 2025-10-25T10:49:05 | 1.19 | EUR | 0 | 200 | dom_attr | f046161d5715d27babab6f808bf4de012b88883bde2e8a5d50460f8b96e4dcbf | aldi_sued_www_mvp_v2 | ||||
| 351 | 40 40 | 2025-10-26 | 2025-10-26T06:47:15 | 1.19 | EUR | 0 | 200 | dom_attr | f046161d5715d27babab6f808bf4de012b88883bde2e8a5d50460f8b96e4dcbf | aldi_sued_www_mvp_v2 | ||||
| 372 | 40 40 | 2025-10-27 | 2025-10-27T06:26:06 | 1.19 | EUR | 0 | 200 | dom_attr | f18c10262443324a840f318a45b77c9b788ae0fc6e22ae853da6a0d0923c95a1 | aldi_sued_www_mvp_v2 | ||||
| 393 | 40 40 | 2025-10-29 | 2025-10-29T06:53:48 | 1.19 | EUR | 0 | 200 | dom_attr | f18c10262443324a840f318a45b77c9b788ae0fc6e22ae853da6a0d0923c95a1 | aldi_sued_www_mvp_v2 | ||||
| 414 | 40 40 | 2025-11-02 | 2025-11-02T06:46:07 | 1.19 | EUR | 0 | 200 | dom_attr | 9c7c19bfecce2b5020f24e5ef7ef248ff8b2f23c8827ef7356933c7b66712fa0 | aldi_sued_www_mvp_v2 | ||||
| 435 | 40 40 | 2025-11-03 | 2025-11-03T06:07:18 | 1.19 | EUR | 0 | 200 | dom_attr | 734dd67ee863780635b2cbb76f9f0671358e7ae59d7ef71651e4d99fb87dad9c | aldi_sued_www_mvp_v2 | ||||
| 456 | 40 40 | 2025-11-05 | 2025-11-05T06:16:05 | 1.19 | EUR | 0 | 200 | dom_attr | 2e07af4387ce8f5f1c78dbafd44a0289ce2ff95b7ffa9097035e9ee42e62c5e9 | aldi_sued_www_mvp_v2 | ||||
| 477 | 40 40 | 2025-11-09 | 2025-11-09T07:07:28 | 1.19 | EUR | 0 | 200 | dom_attr | aa45fba69a35a6e43600c0f162e69c0aa1ddd724ac6b11606d03792d480bb3ff | aldi_sued_www_mvp_v2 | ||||
| 498 | 40 40 | 2025-11-10 | 2025-11-10T06:42:50 | 1.19 | EUR | 0 | 200 | dom_attr | cff48ef108398b8453a5f6c19fe13c981b08bbf24a699a086c1b0e21f8df98e0 | aldi_sued_www_mvp_v2 | ||||
| 519 | 40 40 | 2025-11-12 | 2025-11-12T06:21:27 | 1.19 | EUR | 0 | 200 | dom_attr | 9e07350db64731cbc1806699ace331bb35bfd4fc19e9e3d3435e2769655307ea | aldi_sued_www_mvp_v2 | ||||
| 540 | 40 40 | 2025-11-16 | 2025-11-16T06:39:17 | 1.19 | EUR | 0 | 200 | dom_attr | a8305e1eec5b6c369f2c94597003c3993101f77c8c86f4f6df8351ce0e660440 | aldi_sued_www_mvp_v2 | ||||
| 561 | 40 40 | 2025-11-17 | 2025-11-17T07:07:53 | 1.19 | EUR | 0 | 200 | dom_attr | 63c8108d6c435658b30c2e5ae7d34edd10eb7d9bdeb0be54bb10dab2ebbfc316 | aldi_sued_www_mvp_v2 | ||||
| 582 | 40 40 | 2025-11-19 | 2025-11-19T06:14:15 | 1.19 | EUR | 0 | 200 | dom_attr | 3f8dd1c0cb40534870f5b3d0e0ccbbece1e3a0a9b6502ddc7e55168cd16c00da | aldi_sued_www_mvp_v2 | ||||
| 603 | 40 40 | 2025-11-23 | 2025-11-23T06:39:32 | 1.19 | EUR | 0 | 200 | dom_attr | 606e5f5954b9b8c7023a56ae7b1951c33b016f07a3d058a212427b79c9e9a44d | aldi_sued_www_mvp_v2 | ||||
| 624 | 40 40 | 2025-11-24 | 2025-11-24T06:28:46 | 1.19 | EUR | 0 | 200 | dom_attr | eeb1f544d90209b9683a71614a5152574616224a55dedb516e47bef608472038 | aldi_sued_www_mvp_v2 | ||||
| 645 | 40 40 | 2025-11-26 | 2025-11-26T06:37:04 | 1.19 | EUR | 0 | 200 | dom_attr | eeb1f544d90209b9683a71614a5152574616224a55dedb516e47bef608472038 | aldi_sued_www_mvp_v2 | ||||
| 666 | 40 40 | 2025-11-30 | 2025-11-30T07:06:50 | 1.19 | EUR | 0 | 200 | dom_attr | 4276c8e4fba2346baebad1eca0c2b6e48662397f1f706a59f9d1f772ce130e4b | aldi_sued_www_mvp_v2 | ||||
| 687 | 40 40 | 2025-12-01 | 2025-12-01T07:04:45 | 1.19 | EUR | 0 | 200 | dom_attr | e9f026fe5c020a893479378c7c5d98fffc529ae9aef37cbb329e0a73093861ca | aldi_sued_www_mvp_v2 | ||||
| 708 | 40 40 | 2025-12-03 | 2025-12-03T06:52:06 | 1.19 | EUR | 0 | 200 | dom_attr | 4c2dccc5e0b1862a8eb2a7de22ce009cef3a9ebe4aa0d970b45889f8aaa04e46 | aldi_sued_www_mvp_v2 | ||||
| 729 | 40 40 | 2025-12-07 | 2025-12-07T06:45:18 | 1.19 | EUR | 0 | 200 | dom_attr | 257162ede84c8c83896153e02c3c98a9ee72424c2bf03e06b3d848a69de35401 | aldi_sued_www_mvp_v2 | ||||
| 750 | 40 40 | 2025-12-08 | 2025-12-08T07:03:41 | 1.19 | EUR | 0 | 200 | dom_attr | 2a9419fc30fdfa2b189c0332f0d23d8b9ef9781edfc545bbb4ce202b2dc4426a | aldi_sued_www_mvp_v2 | ||||
| 771 | 40 40 | 2025-12-10 | 2025-12-10T06:44:46 | 1.19 | EUR | 0 | 200 | dom_attr | 2a9419fc30fdfa2b189c0332f0d23d8b9ef9781edfc545bbb4ce202b2dc4426a | aldi_sued_www_mvp_v2 | ||||
| 792 | 40 40 | 2025-12-14 | 2025-12-14T07:06:08 | 1.19 | EUR | 0 | 200 | dom_attr | a356e074f45bd502906f01875e8a191d6818e8e69036491b2840fa2d3913d372 | aldi_sued_www_mvp_v2 | ||||
| 813 | 40 40 | 2025-12-15 | 2025-12-15T06:50:25 | 1.19 | EUR | 0 | 200 | dom_attr | 66f909d6acdf32eb388806176bd49aa15c2123c8ebf36a15262c0ea7d370901a | aldi_sued_www_mvp_v2 | ||||
| 834 | 40 40 | 2025-12-17 | 2025-12-17T07:06:56 | 1.19 | EUR | 0 | 200 | dom_attr | 66f909d6acdf32eb388806176bd49aa15c2123c8ebf36a15262c0ea7d370901a | aldi_sued_www_mvp_v2 |
Advanced export
JSON shape: default, array, newline-delimited, object
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);