Recent Price Changes

Shows price changes in the last 30 days across all items and stores, comparing old and new prices

Custom SQL query returning 7 rows (hide) 

WITH recent_prices AS (SELECT item_id, store_id, base_price, delivery_price, effective_date, LAG(base_price / 100.0) OVER (PARTITION BY item_id, store_id ORDER BY effective_date) AS previous_base_price, LAG(delivery_price / 100.0)  OVER (PARTITION BY item_id, store_id ORDER BY effective_date) AS previous_delivery_price, LAG(effective_date) OVER (PARTITION BY item_id, store_id ORDER BY effective_date) AS previous_date FROM item_prices WHERE effective_date >= date('now', '-30 days')) SELECT m.name, s.store_name, rp.previous_base_price AS old_base_price, rp.base_price / 100.0 AS new_base_price, rp.previous_delivery_price AS old_delivery_price, rp.delivery_price / 100.0 AS new_delivery_price, rp.previous_date AS old_date, rp.effective_date AS new_date FROM recent_prices rp JOIN menu_items m ON rp.item_id = m.id JOIN stores s ON rp.store_id = s.id WHERE rp.previous_base_price IS NOT NULL ORDER BY rp.effective_date DESC LIMIT 20

Edit SQL

This data as json, CSV

namestore_nameold_base_pricenew_base_priceold_delivery_pricenew_delivery_priceold_datenew_date
Coffee Traveller ION Orchard 31.5 33.6 32.0 34.1 2024-10-20 2024-10-27
Gourmet Mushroom Veggie Puff ION Orchard 5.8 5.9 6.3 6.4 2024-10-06 2024-10-20
K-inspired Gochujang Chicken Pie ION Orchard 7.8 7.9 8.3 8.4 2024-10-06 2024-10-20
Pumpkin Spice Latte ION Orchard 7.9 8.2 8.4 8.7 2024-10-13 2024-10-20
Iced Pumpkin Spice Latte ION Orchard 7.9 8.2 8.4 8.7 2024-10-13 2024-10-20
Pumpkin Spice Frappuccino® ION Orchard 8.4 8.7 8.9 9.2 2024-10-13 2024-10-20
Pumpkin Spice Cream Cold Brew ION Orchard 7.5 7.8 8.0 8.3 2024-10-13 2024-10-20