price_observation
26 rows where product_market_id = 34
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 296 | 34 34 | 2025-10-21 | 2025-10-21T20:31:05 | 1.19 | EUR | 0 | 200 | json_ld | 2613f9eb123ed7bf1dd27151de5069dbd5f34d7fdb735cb623bff31ebac1217a | aldi_sued_www_mvp_v2 | ||||
| 326 | 34 34 | 2025-10-25 | 2025-10-25T10:48:45 | 1.19 | EUR | 0 | 200 | json_ld | 66adc252ac669fc260d9497fd3526d5cc72766ca7fddb95edf4085b2bcb89ee1 | aldi_sued_www_mvp_v2 | ||||
| 345 | 34 34 | 2025-10-26 | 2025-10-26T06:46:54 | 1.19 | EUR | 0 | 200 | json_ld | 66adc252ac669fc260d9497fd3526d5cc72766ca7fddb95edf4085b2bcb89ee1 | aldi_sued_www_mvp_v2 | ||||
| 366 | 34 34 | 2025-10-27 | 2025-10-27T06:25:44 | 1.19 | EUR | 0 | 200 | json_ld | 5c93dfe24993f5c2703be779bcd4c0d7e4291ffe4a84d8fdc8fb23cf6f148be9 | aldi_sued_www_mvp_v2 | ||||
| 387 | 34 34 | 2025-10-29 | 2025-10-29T06:53:29 | 1.19 | EUR | 0 | 200 | json_ld | 5c93dfe24993f5c2703be779bcd4c0d7e4291ffe4a84d8fdc8fb23cf6f148be9 | aldi_sued_www_mvp_v2 | ||||
| 408 | 34 34 | 2025-11-02 | 2025-11-02T06:45:46 | 1.19 | EUR | 0 | 200 | json_ld | 2ff3964bc0ea6fcd38aa508a1ff6c30679c04570f4e7f188ff1d871538d27062 | aldi_sued_www_mvp_v2 | ||||
| 429 | 34 34 | 2025-11-03 | 2025-11-03T06:06:56 | 0.55 | EUR | 0 | 200 | json_ld | e1f5396c7779eb5f1fb1765d1a142db6b893810fe5c203f33da810c787074982 | aldi_sued_www_mvp_v2 | ||||
| 450 | 34 34 | 2025-11-05 | 2025-11-05T06:15:43 | 0.55 | EUR | 0 | 200 | json_ld | 454624792059a6e27e65458000214ef0631ad6ade1ce722700d7ce59bd72db87 | aldi_sued_www_mvp_v2 | ||||
| 471 | 34 34 | 2025-11-09 | 2025-11-09T07:07:08 | 0.55 | EUR | 0 | 200 | json_ld | 816b76ab4847ac55d58037cc5a69cb2050e1b72c560e3a8fa857e485798f6c99 | aldi_sued_www_mvp_v2 | ||||
| 492 | 34 34 | 2025-11-10 | 2025-11-10T06:42:28 | 1.19 | EUR | 0 | 200 | json_ld | 48281d498ef3cf42a510689bb0d5bcc3f96caca463d570212d224cccaf746f8f | aldi_sued_www_mvp_v2 | ||||
| 513 | 34 34 | 2025-11-12 | 2025-11-12T06:21:04 | 1.19 | EUR | 0 | 200 | json_ld | cabf08bb2c7c97789e7232431859fd4732d8f9c1a73109cc3ea821f1db69dc97 | aldi_sued_www_mvp_v2 | ||||
| 534 | 34 34 | 2025-11-16 | 2025-11-16T06:38:57 | 1.19 | EUR | 0 | 200 | json_ld | 3262794a5d2c00b9ec46052e8fcda50476cff74d0bbdc6a642f9255540a00822 | aldi_sued_www_mvp_v2 | ||||
| 555 | 34 34 | 2025-11-17 | 2025-11-17T07:07:31 | 1.19 | EUR | 0 | 200 | json_ld | 661dd06d7f47790854d067b185840439466d7818cb8727bef803c2fa1791bbfd | aldi_sued_www_mvp_v2 | ||||
| 576 | 34 34 | 2025-11-19 | 2025-11-19T06:13:54 | 1.19 | EUR | 0 | 200 | json_ld | fb6a236a072d1def0258de5ad65b585f74ac58cc66dce7b02d86e428ea2f5101 | aldi_sued_www_mvp_v2 | ||||
| 597 | 34 34 | 2025-11-23 | 2025-11-23T06:39:11 | 1.19 | EUR | 0 | 200 | json_ld | 642db81bbcc9f6bf937ee31270fd9086ff243e1872eb61d63182729000e6a9f6 | aldi_sued_www_mvp_v2 | ||||
| 618 | 34 34 | 2025-11-24 | 2025-11-24T06:28:25 | 1.19 | EUR | 0 | 200 | json_ld | 73bcb7300e131373faf6a7e2f2ee3d5cf5604c40cd09eb4a8e5f06e1ccc6f6ad | aldi_sued_www_mvp_v2 | ||||
| 639 | 34 34 | 2025-11-26 | 2025-11-26T06:36:41 | 1.19 | EUR | 0 | 200 | json_ld | 73bcb7300e131373faf6a7e2f2ee3d5cf5604c40cd09eb4a8e5f06e1ccc6f6ad | aldi_sued_www_mvp_v2 | ||||
| 660 | 34 34 | 2025-11-30 | 2025-11-30T07:06:28 | 1.19 | EUR | 0 | 200 | json_ld | dc0370b1e93a16466cb2d5abc609da6b5660ed93bd943719c5d6ef4742dc1d8e | aldi_sued_www_mvp_v2 | ||||
| 681 | 34 34 | 2025-12-01 | 2025-12-01T07:04:25 | 1.19 | EUR | 0 | 200 | json_ld | 712505087f92494ec0b7598c5dfb3a8cc892e93dcb1ade2794dd35ceb5c1a22d | aldi_sued_www_mvp_v2 | ||||
| 702 | 34 34 | 2025-12-03 | 2025-12-03T06:51:45 | 1.19 | EUR | 0 | 200 | json_ld | c07f139a9597ce94a989073320ff29e76ae1cec5b754689d73a1447ffaeeb680 | aldi_sued_www_mvp_v2 | ||||
| 723 | 34 34 | 2025-12-07 | 2025-12-07T06:44:56 | 1.19 | EUR | 0 | 200 | json_ld | 875fde996945387b40646dd2ae8a07f28032355751633e16303cf0249e944579 | aldi_sued_www_mvp_v2 | ||||
| 744 | 34 34 | 2025-12-08 | 2025-12-08T07:03:20 | 1.19 | EUR | 0 | 200 | json_ld | c83eb8756c104321588d70becd58db2126b054d2a1e21b3c1835deb1827b96e0 | aldi_sued_www_mvp_v2 | ||||
| 765 | 34 34 | 2025-12-10 | 2025-12-10T06:44:26 | 1.19 | EUR | 0 | 200 | json_ld | c83eb8756c104321588d70becd58db2126b054d2a1e21b3c1835deb1827b96e0 | aldi_sued_www_mvp_v2 | ||||
| 786 | 34 34 | 2025-12-14 | 2025-12-14T07:05:48 | 1.19 | EUR | 0 | 200 | json_ld | 498ad54323f126db9becf80d618a3a1f84aaf73153187b2e9fe6bcdfad101f2b | aldi_sued_www_mvp_v2 | ||||
| 807 | 34 34 | 2025-12-15 | 2025-12-15T06:50:06 | 1.19 | EUR | 0 | 200 | json_ld | 8c999426b1f6feb14986683fb5c9380466b634e50c56fa9be70e809782bedb82 | aldi_sued_www_mvp_v2 | ||||
| 828 | 34 34 | 2025-12-17 | 2025-12-17T07:06:36 | 1.19 | EUR | 0 | 200 | json_ld | 8c999426b1f6feb14986683fb5c9380466b634e50c56fa9be70e809782bedb82 | 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);