big_data.sql

INSERT INTO Address (Street, City, Country, Postal_code)
VALUES 
('100 King St W', 'Toronto', 'Canada', 'M5X 1A9'),
('25 The West Mall', 'Toronto', 'Canada', 'M9C 1B8'),
('1 Dundas St W', 'Toronto', 'Canada', 'M5G 1Z3'),
('220 Yonge St', 'Toronto', 'Canada', 'M5B 2H1'),
('3401 Dufferin St', 'Toronto', 'Canada', 'M6A 2T9'),
('2 Bloor St W', 'Toronto', 'Canada', 'M4W 3E2'),
('290 Bremner Blvd', 'Toronto', 'Canada', 'M5V 3L9'),
('10 Dundas St E', 'Toronto', 'Canada', 'M5B 2G9'),
('30 Yonge St', 'Toronto', 'Canada', 'M5E 1X8'),
('1 Austin Terrace', 'Toronto', 'Canada', 'M5R 1X8'),
('1600 Pennsylvania Ave NW', 'Washington', 'USA', '20500'),
('350 5th Ave', 'New York', 'USA', '10118'),
('600 E Grand Ave', 'Chicago', 'USA', '60611'),
('100 Universal City Plaza', 'Los Angeles', 'USA', '91608'),
('700 Exposition Park Dr', 'Los Angeles', 'USA', '90037'),
('800 Decatur St', 'New Orleans', 'USA', '70116'),
('2901 Western Ave', 'Seattle', 'USA', '98121'),
('3601 Martin Luther King Jr Blvd', 'Denver', 'USA', '80205'),
('190 Marietta St NW', 'Atlanta', 'USA', '30303'),
('201 Alaskan Way', 'Seattle', 'USA', '98104');

INSERT INTO Users (AID, SIN, Email, Name, DoB, Occupation, Password, Account)
VALUES
(1, '987654321', 'bahar@gmail.com', 'Bahar', '2003-01-25', 'AI Specialist', '1234567', '[ACTIVE]'),
(2, '876543210', 'vaibhav@gmail.com', 'Vaibhav', '2003-05-13', 'Data Scientist', '1234567', '[ACTIVE]'),
(3, '765432109', 'mustafa@gmail.com', 'Mustafa', '2003-05-03', 'Systems Analyst', '123123', '[ACTIVE]'),
(4, '654321098', 'sana@gmail.com', 'Sana', '2003-04-04', 'Database Administrator', '123456789', '[ACTIVE]'),
(5, '543210987', 'shinza@gmail.com', 'Shinza', '2003-06-20', 'Web Developer', '121212', '[ACTIVE]'),
(6, '432109876', 'minjun@gmail.com', 'Minjun', '2003-06-26', 'Software Engineer', '121212', '[ACTIVE]'),
(7, '321098765', 'adam@gmail.com', 'Adam', '2003-01-21', 'Network Engineer', '123123', '[ACTIVE]'),
(8, '210987654', 'ji@gmail.com', 'Ji', '2003-09-30', 'AI Engineer', '123456789', '[ACTIVE]'),
(9, '109876543', 'kody@gmail.com', 'Kody', '2003-09-09', 'UX Designer', '12341234', '[ACTIVE]'),
(10, '098765432', 'aaliyah@gmail.com', 'Aaliyah', '2003-07-19', 'IT Manager', '12341234', '[ACTIVE]'),
(11, '123456789', 'john@example.com', 'John', '2005-05-03', 'Engineer', 'pass123', '[ACTIVE]'),
(12, '234567890', 'emma@example.com', 'Emma', '2004-04-12', 'Teacher', 'pass456', '[ACTIVE]'),
(13, '345678901', 'oliver@example.com', 'Oliver', '2003-06-18', 'Doctor', 'pass789', '[ACTIVE]'),
(14, '456789012', 'ava@example.com', 'Ava', '2002-07-24', 'Nurse', 'pass012', '[ACTIVE]'),
(15, '567890123', 'noah@example.com', 'Noah', '2001-08-30', 'Lawyer', 'pass345', '[ACTIVE]'),
(16, '678901234', 'mia@example.com', 'Mia', '2000-09-15', 'Artist', 'pass678', '[ACTIVE]'),
(17, '789012345', 'liam@example.com', 'Liam', '1999-10-21', 'Architect', 'pass901', '[ACTIVE]'),
(18, '890123456', 'sophia@example.com', 'Sophia', '1998-11-06', 'Scientist', 'pass234', '[ACTIVE]'),
(19, '901234567', 'jackson@example.com', 'Jackson', '1997-12-12', 'Musician', 'pass567', '[ACTIVE]'),
(20, '012345678', 'lily@example.com', 'Lily', '1996-01-18', 'Actor', 'pass890', '[ACTIVE]');

INSERT INTO Guests (UID, payment_info)
VALUES 
(1, 'MasterCard: ****-****-****-1234'),
(2, 'Visa: ****-****-****-2345'),
(5, 'American Express: ****-******-3456'),
(6, 'Discover: ****-****-****-4567'),
(9, 'PayPal: kody@paypal.com'),
(10, 'MasterCard: ****-****-****-5678'),
(13, 'Visa: ****-****-****-6789'),
(14, 'American Express: ****-******-7890'),
(17, 'Discover: ****-****-****-8901'),
(18, 'PayPal: sophia@paypal.com');

INSERT INTO Hosts (UID)
VALUES
(1),
(2),
(3),
(4), 
(7), 
(8), 
(11), 
(12), 
(15), 
(16),
(19), 
(20); 

INSERT INTO Address (Street, City, Country, Postal_code)
VALUES
('150 York St', 'Toronto', 'Canada', 'M5H 3S5'),
('550 Front St W', 'Toronto', 'Canada', 'M5H 1C1'),
('455 Spadina Ave', 'Toronto', 'Canada', 'M5H 2G8'),
('955 Queen St W', 'Toronto', 'Canada', 'M5H 1G9'),
('177 Dundas St W', 'Toronto', 'Canada', 'M5V 1Z8'),
('233 Spadina Ave', 'Toronto', 'Canada', 'M5V 2E2'),
('70 The Pond Rd', 'Toronto', 'Canada', 'M5V 3M6'),
('27 King’s College Cir', 'Toronto', 'Canada', 'M5V 3J3'),
('100 King St W', 'Toronto', 'Canada', 'M4E 1A9'),
('51 Dockside Dr', 'Toronto', 'Canada', 'M4E 0B6'),
('123 Maple Ave', 'Toronto', 'Canada', 'M4E 2A7'),
('789 Birch St', 'Toronto', 'Canada', 'M4E 1C3'),
('456 Pine Rd', 'Toronto', 'Canada', 'M4E 2G5'),
('321 Oak St W', 'Toronto', 'Canada', 'M4E 1H9'),
('432 Willow Blvd', 'Toronto', 'Canada', 'M3J 2E4'),
('55 Spruce St E', 'Toronto', 'Canada', 'M3J 3M5'),
('678 Elm St', 'Toronto', 'Canada', 'M3J 3J2'),
('901 Cherry Lane', 'Toronto', 'Canada', 'M3J 1B7'),
('567 Fir St W', 'Toronto', 'Canada', 'M6G 3J3'),
('765 Poplar Ave', 'Toronto', 'Canada', 'M6G 2L1'),

('11 Wall St', 'New York', 'USA', '10005'),
('770 Riverside Drive', 'New York', 'USA', '10032'),
('420 Broadway', 'New York', 'USA', '10013'), 
('900 7th Ave', 'New York', 'USA', '10019'), 
('350 Grand St', 'New York', 'USA', '10002'), 
('657 W 34th St', 'New York', 'USA', '10001'), 
('201 Broadway', 'New York', 'USA', '10038'),
('802 5th Ave', 'New York', 'USA', '10065'),
('1 Times Square', 'New York', 'USA', '10036'),
('2 Lexington Ave', 'New York', 'USA', '10010'),
('12 Wall St', 'New York', 'USA', '10005'),
('775 Riverside Drive', 'New York', 'USA', '10032'),
('415 Broadway', 'New York', 'USA', '10013'),
('850 7th Ave', 'New York', 'USA', '10019'),
('355 Grand St', 'New York', 'USA', '10002'),
('655 W 34th St', 'New York', 'USA', '10001'),
('200 Broadway', 'New York', 'USA', '10038'),
('800 5th Ave', 'New York', 'USA', '10065'),
('3 Times Square', 'New York', 'USA', '10036'),
('4 Lexington Ave', 'New York', 'USA', '10010'),

('250 Robson St', 'Vancouver', 'Canada', 'V6B 0E7'),
('850 Richards St', 'Vancouver', 'Canada', 'V6B 3A4'),
('420 Granville St', 'Vancouver', 'Canada', 'V6B 1T3'),
('304 E Broadway', 'Vancouver', 'Canada', 'V6B 2E9'),
('355 Burrard St', 'Vancouver', 'Canada', 'V6C 2G8'),
('955 W Georgia St', 'Vancouver', 'Canada', 'V6C 3C9'),
('555 W Hastings St', 'Vancouver', 'Canada', 'V6C 4N6'),
('1111 Alberni St', 'Vancouver', 'Canada', 'V6C 0M6'),
('177 Robson St', 'Vancouver', 'Canada', 'V5Y 6A1'),
('1 Athletes Way', 'Vancouver', 'Canada', 'V5Y 0B1'),
('732 W Broadway', 'Vancouver', 'Canada', 'V5Y 1R4'),
('800 Cambie St', 'Vancouver', 'Canada', 'V5Y 4A7'),
('233 Pender St W', 'Vancouver', 'Canada', 'V6G 1R3'),
('6435 Tisdall St', 'Vancouver', 'Canada', 'V6G 3N4'),
('1755 Robson St', 'Vancouver', 'Canada', 'V6G 3B7'),
('1780 W 3rd Ave', 'Vancouver', 'Canada', 'V6G 4Y1'),
('6213 Oak St', 'Vancouver', 'Canada', 'V6M 2V7'),
('1256 W 57th Ave', 'Vancouver', 'Canada', 'V6M 1J5'),
('3121 Granville St', 'Vancouver', 'Canada', 'V6M 3J3'),
('4885 Slocan St', 'Vancouver', 'Canada', 'V6M 2J8'),

('100 Market St', 'San Francisco', 'USA', '94105'), 
('550 Sutter St', 'San Francisco', 'USA', '94102'), 
('455 Market St', 'San Francisco', 'USA', '94105'), 
('955 Grant Ave', 'San Francisco', 'USA', '94108'), 
('177 3rd St', 'San Francisco', 'USA', '94103'), 
('233 Mission St', 'San Francisco', 'USA', '94105'), 
('300 Market St', 'San Francisco', 'USA', '94111'),
('747 Howard St', 'San Francisco', 'USA', '94103'),
('2 Embarcadero Center', 'San Francisco', 'USA', '94111'),
('350 Rhode Island St', 'San Francisco', 'USA', '94103'),
('400 Montgomery St', 'San Francisco', 'USA', '94104'),
('600 California St', 'San Francisco', 'USA', '94108'),
('800 Market St', 'San Francisco', 'USA', '94102'),
('900 Kearny St', 'San Francisco', 'USA', '94133'),
('1200 Post St', 'San Francisco', 'USA', '94107'),
('1300 Fillmore St', 'San Francisco', 'USA', '94115'),
('1400 Polk St', 'San Francisco', 'USA', '94109'),
('1500 Van Ness Ave', 'San Francisco', 'USA', '94129'),
('1600 Lombard St', 'San Francisco', 'USA', '94123'),
('1700 Union St', 'San Francisco', 'USA', '94100'),

('100 Hollywood Blvd', 'Los Angeles', 'USA', '90046'),
('200 Sunset Ave', 'Los Angeles', 'USA', '90026'),
('300 Melrose Ave', 'Los Angeles', 'USA', '90036'),
('400 Vine St', 'Los Angeles', 'USA', '90038'),
('500 Wilshire Blvd', 'Los Angeles', 'USA', '90017'),
('600 Santa Monica Blvd', 'Los Angeles', 'USA', '90067'),
('700 Rodeo Dr', 'Los Angeles', 'USA', '90210'),
('800 Beverly Blvd', 'Los Angeles', 'USA', '90048'),
('900 Pacific Coast Hwy', 'Los Angeles', 'USA', '90401'),
('1000 Larchmont Blvd', 'Los Angeles', 'USA', '90004'),
('1100 Sunset Blvd', 'Los Angeles', 'USA', '90012'),
('1200 Fairfax Ave', 'Los Angeles', 'USA', '90046'),
('1300 Beverly Glen Blvd', 'Los Angeles', 'USA', '90077'),
('1400 Olympic Blvd', 'Los Angeles', 'USA', '90015'),
('1500 Figueroa St', 'Los Angeles', 'USA', '90015'),
('1600 Glendale Blvd', 'Los Angeles', 'USA', '90026'),
('1700 Pico Blvd', 'Los Angeles', 'USA', '90035'),
('1800 Venice Blvd', 'Los Angeles', 'USA', '90006'),
('1900 Wilshire Blvd', 'Los Angeles', 'USA', '90057'),
('2000 Hollywood Blvd', 'Los Angeles', 'USA', '90028'),

('150 Istiklal Caddesi', 'Istanbul', 'Turkey', '34430'),
('550 Bagdat Caddesi', 'Istanbul', 'Turkey', '34740'),
('455 Abdi Ipekci Caddesi', 'Istanbul', 'Turkey', '34367'),
('955 Nispetiye Caddesi', 'Istanbul', 'Turkey', '34340'),
('177 Barbaros Bulvari', 'Istanbul', 'Turkey', '34353'),
('233 Valikonagi Caddesi', 'Istanbul', 'Turkey', '34365'),
('70 Kennedy Caddesi', 'Istanbul', 'Turkey', '34400'),
('27 Cumhuriyet Caddesi', 'Istanbul', 'Turkey', '34380'),
('100 Halaskargazi Caddesi', 'Istanbul', 'Turkey', '34371'),
('51 Tesvikiye Caddesi', 'Istanbul', 'Turkey', '34367'),

('100 Anna Salai', 'Chennai', 'India', '601002'),
('200 Mount Road', 'Chennai', 'India', '601006'),
('300 GST Road', 'Chennai', 'India', '600045'),
('400 T Nagar', 'Chennai', 'India', '600017'),
('500 Cathedral Road', 'Chennai', 'India', '600086'),
('600 Velachery', 'Chennai', 'India', '600042'),
('700 Mylapore', 'Chennai', 'India', '601004'),
('800 Nungambakkam', 'Chennai', 'India', '600034'),
('900 Egmore', 'Chennai', 'India', '600108'),
('1000 Adyar', 'Chennai', 'India', '600020');


INSERT INTO Listings (AID, UID, Type, Longitude, Latitude, Status)
VALUES 
(21, 3, 'House', -79.3953, 43.6499, '[ACTIVE]'),  
(22, 7, 'House', -79.3984, 43.6556, '[ACTIVE]'),  
(23, 3, 'House', -79.3885, 43.6652, '[ACTIVE]'),   
(24, 7, 'House', -79.4645, 43.6370, '[ACTIVE]'),  
(25, 3, 'House', -79.3442, 43.6876, '[ACTIVE]'),  
(26, 4, 'House', -79.2735, 43.6370, '[ACTIVE]'),  
(27, 3, 'House', -79.5507, 43.6271, '[ACTIVE]'),   
(28, 12, 'House', -79.5410, 43.7460, '[ACTIVE]'),
(29, 3, 'House', -79.5420, 43.7420, '[ACTIVE]'),
(30, 7, 'House', -79.5460, 43.7450, '[ACTIVE]'),
(31, 7, 'House', -79.5400, 43.7430, '[ACTIVE]'),
(32, 3, 'House', -79.5430, 43.7470, '[ACTIVE]'),
(33, 11, 'House', -79.5390, 43.7410, '[ACTIVE]'),
(34, 20, 'House', -79.5420, 43.7400, '[ACTIVE]'),
(35, 7, 'House', -79.5410, 43.7480, '[ACTIVE]'),
(36, 3, 'House', -79.3720, 43.6520, '[ACTIVE]'),
(37, 16, 'House', -79.3870, 43.6470, '[ACTIVE]'),
(38, 7, 'House', -79.3920, 43.6510, '[ACTIVE]'),
(39, 11, 'Hotel', -79.3770, 43.6490, '[ACTIVE]'),
(40, 19, 'Guesthouse', -79.3830, 43.6500, '[ACTIVE]'),

(41, 12, 'Apartment', -73.9805, 40.7630, '[ACTIVE]'),       
(42, 7, 'Apartment', -73.9905, 40.7530, '[ACTIVE]'),       
(43, 11, 'Apartment', -74.0105, 40.7780, '[ACTIVE]'),       
(44, 12, 'Apartment', -74.0155, 40.7480, '[ACTIVE]'),       
(45, 12, 'Apartment', -74.0855, 40.9080, '[ACTIVE]'),   
(46, 19, 'Apartment', -74.1005, 40.9080, '[ACTIVE]'),  
(47, 11, 'Apartment', -74.0955, 40.9080, '[ACTIVE]'),   
(48, 4, 'Apartment', -74.1105, 40.9080, '[ACTIVE]'),    
(49, 12, 'Apartment', -74.1155, 40.9080, '[ACTIVE]'),  
(50, 8, 'Apartment', -74.1205, 40.9080, '[ACTIVE]'),   
(51, 12, 'Apartment', -74.1255, 40.9080, '[ACTIVE]'),  
(52, 15, 'Apartment', -74.1305, 40.9080, '[ACTIVE]'),  
(53, 11, 'Apartment', -74.1355, 40.9080, '[ACTIVE]'),       
(54, 15, 'Apartment', -74.1405, 40.9080, '[ACTIVE]'),       
(55, 11, 'Apartment', -74.1455, 40.9080, '[ACTIVE]'),      
(56, 16, 'Apartment', -74.1505, 40.9080, '[ACTIVE]'),       
(57, 19, 'Apartment', -74.1555, 40.9080, '[ACTIVE]'),   
(58, 11, 'Apartment', -74.1605, 40.9080, '[ACTIVE]'),  
(59, 11, 'Apartment', -74.1655, 40.9080, '[ACTIVE]'),   
(60, 16, 'Tiny home', -74.1705, 40.9080, '[ACTIVE]'),

(61, 8, 'House', -123.1216, 49.2827, '[ACTIVE]'),
(62, 4, 'House', -123.1302, 49.2776, '[ACTIVE]'),
(63, 8, 'House', -123.1113, 49.2878, '[ACTIVE]'),
(64, 4, 'House', -123.1329, 49.2793, '[ACTIVE]'),
(65, 8, 'Apartment', -123.1159, 49.2756, '[ACTIVE]'),
(66, 8, 'Apartment', -123.1193, 49.2694, '[ACTIVE]'),
(67, 4, 'Apartment', -123.1306, 49.2267, '[ACTIVE]'),
(68, 15, 'Apartment', -123.1324, 49.2872, '[ACTIVE]'),
(69, 8, 'Guesthouse', -123.1040, 49.2725, '[ACTIVE]'),
(70, 8, 'Guesthouse', -123.1115, 49.2857, '[ACTIVE]'),
(71, 4, 'Guesthouse', -123.1333, 49.2811, '[ACTIVE]'),
(72, 8, 'Guesthouse', -123.1219, 49.2734, '[ACTIVE]'),
(73, 4, 'Hotel', -123.1390, 49.2865, '[ACTIVE]'),
(74, 3, 'Hotel', -123.1254, 49.2789, '[ACTIVE]'),
(75, 4, 'Hotel', -123.1347, 49.2742, '[ACTIVE]'),
(76, 8, 'Hotel', -123.1124, 49.2678, '[ACTIVE]'),
(77, 4, 'Tiny home', -123.1205, 49.2293, '[ACTIVE]'),
(78, 12, 'Tiny home', -123.1310, 49.2883, '[ACTIVE]'),
(79, 8, 'Tiny home', -123.1027, 49.2710, '[ACTIVE]'),
(80, 3, 'Tiny home', -123.1132, 49.2841, '[ACTIVE]'),

(81, 20, 'House', -122.4194, 37.7749, '[ACTIVE]'),
(82, 16, 'House', -122.4104, 37.7824, '[ACTIVE]'),
(83, 19, 'House', -122.4040, 37.7890, '[ACTIVE]'),
(84, 4, 'House', -122.4177, 37.7837, '[ACTIVE]'),
(85, 20, 'Apartment', -122.4095, 37.7654, '[ACTIVE]'),
(86, 20, 'Apartment', -122.4032, 37.7793, '[ACTIVE]'),
(87, 4, 'Apartment', -122.4099, 37.7813, '[ACTIVE]'),
(88, 7, 'Apartment', -122.4017, 37.7833, '[ACTIVE]'),
(89, 19, 'Guesthouse', -122.3962, 37.7945, '[ACTIVE]'),
(90, 8, 'Guesthouse', -122.4026, 37.7655, '[ACTIVE]'),
(91, 8, 'Guesthouse', -122.4170, 37.7981, '[ACTIVE]'),
(92, 19, 'Guesthouse', -122.4091, 37.7940, '[ACTIVE]'),
(93, 19, 'Hotel', -122.4239, 37.7801, '[ACTIVE]'),
(94, 7, 'Hotel', -122.4075, 37.7896, '[ACTIVE]'),
(95, 19, 'Hotel', -122.4186, 37.7843, '[ACTIVE]'),
(96, 8, 'Hotel', -122.4048, 37.7765, '[ACTIVE]'),
(97, 16, 'Tiny home', -122.3924, 37.7849, '[ACTIVE]'),
(98, 8, 'Tiny home', -122.4152, 37.8004, '[ACTIVE]'),
(99, 19, 'Tiny home', -122.3941, 37.7972, '[ACTIVE]'),
(100, 20, 'Tiny home', -122.4070, 37.7910, '[ACTIVE]'),

(101, 16, 'House', -122.4170, 37.7981, '[ACTIVE]'),
(102, 4, 'House', -122.4091, 37.7940, '[ACTIVE]'),
(103, 16, 'House', -122.4239, 37.7801, '[ACTIVE]'),
(104, 4, 'House', -122.4075, 37.7896, '[ACTIVE]'),
(105, 16, 'Guesthouse', -122.4186, 37.7843, '[ACTIVE]'),
(106, 7, 'Guesthouse', -122.4048, 37.7765, '[ACTIVE]'),
(107, 20, 'Guesthouse', -122.3924, 37.7849, '[ACTIVE]'),
(108, 16, 'Guesthouse', -122.4152, 37.8004, '[ACTIVE]'),
(109, 16, 'Apartment', -122.3941, 37.7972, '[ACTIVE]'),
(110, 7, 'Apartment', -122.4070, 37.7910, '[ACTIVE]'),
(111, 7, 'Apartment', -122.4162, 37.7986, '[ACTIVE]'),
(112, 2, 'Apartment', -122.4083, 37.7948, '[ACTIVE]'),
(113, 16, 'Hotel', -122.4231, 37.7804, '[ACTIVE]'),
(114, 4, 'Hotel', -122.4067, 37.7898, '[ACTIVE]'),
(115, 16, 'Hotel', -122.4192, 37.7847, '[ACTIVE]'),
(116, 2, 'Hotel', -122.4040, 37.7769, '[ACTIVE]'),
(117, 20, 'Tiny home', -122.3921, 37.7846, '[ACTIVE]'),
(118, 4, 'Tiny home', -122.4148, 37.8008, '[ACTIVE]'),
(119, 7, 'Tiny home', -122.3946, 37.7978, '[ACTIVE]'),
(120, 12, 'Tiny home', -122.4064, 37.7913, '[ACTIVE]'),

(121, 1, 'House', 28.9760, 41.0382, '[ACTIVE]'),
(122, 1, 'House', 29.0950, 40.9881, '[ACTIVE]'),
(123, 1, 'Hotel', 28.9921, 41.0495, '[ACTIVE]'),
(124, 1, 'Hotel', 29.0212, 41.0648, '[ACTIVE]'),
(125, 1, 'Guesthouse', 29.0087, 41.0510, '[ACTIVE]'),
(126, 1, 'Tiny home', 28.9846, 41.0442, '[ACTIVE]'),
(127, 1, 'Hotel', 28.9965, 41.0543, '[ACTIVE]'),
(128, 1, 'Apartment', 29.0118, 41.0596, '[ACTIVE]'),
(129, 1, 'House', 29.0232, 41.0671, '[ACTIVE]'),
(130, 1, 'Hotel', 28.9934, 41.0527, '[ACTIVE]'),

(131, 2, 'Apartment', 80.2575, 13.0647, '[ACTIVE]'),
(132, 2, 'House', 80.2464, 13.0518, '[ACTIVE]'),
(133, 2, 'Hotel', 80.2792, 13.0674, '[ACTIVE]'),
(134, 2, 'Hotel', 80.2561, 13.0696, '[ACTIVE]'),
(135, 2, 'Apartment', 80.2578, 13.0589, '[ACTIVE]'),
(136, 2, 'Guesthouse', 80.2502, 13.0745, '[ACTIVE]'),
(137, 2, 'House', 80.2405, 13.0679, '[ACTIVE]'),
(138, 2, 'Apartment', 80.2706, 13.0543, '[ACTIVE]'),
(139, 2, 'Hotel', 80.2459, 13.0621, '[ACTIVE]'),
(140, 2, 'House', 80.2543, 13.0495, '[ACTIVE]');

INSERT INTO Calendar (LID, Date, Price, Availability)
VALUES
(1, '2022-06-01', 120.00, '[OPEN]'),
(1, '2022-06-02', 120.00, '[OPEN]'),
(1, '2022-06-03', 120.00, '[OPEN]'),
-- July
(1, '2023-07-01', 140.00, '[RESERVED]'),
(1, '2023-07-02', 140.00, '[RESERVED]'),
(1, '2023-07-03', 140.00, '[RESERVED]'),
(1, '2023-07-04', 140.00, '[OPEN]'),
(1, '2023-07-05', 140.00, '[OPEN]'),
-- August
(1, '2023-08-10', 140.00, '[OPEN]'),
(1, '2023-08-11', 140.00, '[RESERVED]'),
(1, '2023-08-12', 140.00, '[RESERVED]'),
(1, '2023-08-13', 140.00, '[RESERVED]'),
(1, '2023-08-14', 140.00, '[OPEN]'),
(1, '2023-08-15', 140.00, '[OPEN]'),
-- September
(1, '2023-09-01', 140.00, '[OPEN]'),
(1, '2023-09-02', 140.00, '[OPEN]'),
(1, '2023-09-03', 140.00, '[OPEN]'),
(1, '2023-09-04', 140.00, '[RESERVED]'),
(1, '2023-09-05', 140.00, '[RESERVED]'),

(2, '2022-06-01', 100.00, '[OPEN]'),
(2, '2022-06-02', 100.00, '[OPEN]'),
(2, '2022-06-03', 100.00, '[OPEN]'),
-- July
(2, '2023-07-01', 120.00, '[OPEN]'),
(2, '2023-07-02', 120.00, '[RESERVED]'),
(2, '2023-07-03', 120.00, '[RESERVED]'),
(2, '2023-07-04', 120.00, '[OPEN]'),
(2, '2023-07-05', 120.00, '[OPEN]'),
-- August
(2, '2023-08-10', 120.00, '[OPEN]'),
(2, '2023-08-11', 120.00, '[RESERVED]'),
(2, '2023-08-12', 120.00, '[RESERVED]'),
(2, '2023-08-13', 120.00, '[OPEN]'),
(2, '2023-08-14', 120.00, '[OPEN]'),
(2, '2023-08-15', 120.00, '[BLOCKED]'),
-- September
(2, '2023-09-01', 120.00, '[OPEN]'),
(2, '2023-09-02', 120.00, '[RESERVED]'),
(2, '2023-09-03', 120.00, '[RESERVED]'),
(2, '2023-09-04', 120.00, '[OPEN]'),
(2, '2023-09-05', 120.00, '[OPEN]'),

(3, '2022-06-01', 160.00, '[OPEN]'),
(3, '2022-06-02', 160.00, '[OPEN]'),
(3, '2022-06-03', 160.00, '[OPEN]'),
-- July
(3, '2023-07-01', 180.00, '[OPEN]'),
(3, '2023-07-02', 180.00, '[RESERVED]'),
(3, '2023-07-03', 180.00, '[RESERVED]'),
(3, '2023-07-04', 180.00, '[RESERVED]'),
(3, '2023-07-05', 180.00, '[OPEN]'),
-- August
(3, '2023-08-10', 180.00, '[OPEN]'),
(3, '2023-08-11', 180.00, '[RESERVED]'),
(3, '2023-08-12', 180.00, '[RESERVED]'),
(3, '2023-08-13', 180.00, '[OPEN]'),
(3, '2023-08-14', 180.00, '[RESERVED]'),
(3, '2023-08-15', 180.00, '[RESERVED]'),
-- September
(3, '2023-09-01', 180.00, '[OPEN]'),
(3, '2023-09-02', 180.00, '[OPEN]'),
(3, '2023-09-03', 180.00, '[OPEN]'),
(3, '2023-09-04', 180.00, '[RESERVED]'),
(3, '2023-09-05', 180.00, '[RESERVED]'),

(4, '2022-06-01', 80.00, '[OPEN]'),
(4, '2022-06-02', 80.00, '[OPEN]'),
(4, '2022-06-03', 80.00, '[OPEN]'),
-- July
(4, '2023-07-01', 100.00, '[OPEN]'),
(4, '2023-07-02', 100.00, '[RESERVED]'),
(4, '2023-07-03', 100.00, '[RESERVED]'),
(4, '2023-07-04', 100.00, '[OPEN]'),
(4, '2023-07-05', 100.00, '[RESERVED]'),
-- August
(4, '2023-08-10', 100.00, '[OPEN]'),
(4, '2023-08-11', 100.00, '[RESERVED]'),
(4, '2023-08-12', 100.00, '[RESERVED]'),
(4, '2023-08-13', 100.00, '[RESERVED]'),
(4, '2023-08-14', 100.00, '[RESERVED]'),
(4, '2023-08-15', 100.00, '[OPEN]'),
-- September
(4, '2023-09-01', 100.00, '[RESERVED]'),
(4, '2023-09-02', 100.00, '[RESERVED]'),
(4, '2023-09-03', 100.00, '[OPEN]'),
(4, '2023-09-04', 100.00, '[OPEN]'),
(4, '2023-09-05', 100.00, '[OPEN]'),

(5, '2022-06-01', 70.00, '[OPEN]'),
(5, '2022-06-02', 70.00, '[OPEN]'),
(5, '2022-06-03', 70.00, '[OPEN]'),
-- July
(5, '2023-07-01', 90.00, '[RESERVED]'),
(5, '2023-07-02', 90.00, '[OPEN]'),
(5, '2023-07-03', 90.00, '[RESERVED]'),
(5, '2023-07-04', 90.00, '[OPEN]'),
(5, '2023-07-05', 90.00, '[OPEN]'),
-- August
(5, '2023-08-10', 90.00, '[OPEN]'),
(5, '2023-08-11', 90.00, '[RESERVED]'),
(5, '2023-08-12', 90.00, '[RESERVED]'),
(5, '2023-08-13', 90.00, '[OPEN]'),
(5, '2023-08-14', 90.00, '[OPEN]'),
(5, '2023-08-15', 90.00, '[OPEN]'),
-- September
(5, '2023-09-01', 90.00, '[OPEN]'),
(5, '2023-09-02', 90.00, '[OPEN]'),
(5, '2023-09-03', 90.00, '[OPEN]'),
(5, '2023-09-04', 90.00, '[OPEN]'),
(5, '2023-09-05', 90.00, '[OPEN]'),

(6, '2022-06-01', 90.00, '[OPEN]'),
(6, '2022-06-02', 90.00, '[OPEN]'),
(6, '2022-06-03', 90.00, '[OPEN]'),
-- July
(6, '2023-07-01', 110.00, '[RESERVED]'),
(6, '2023-07-02', 110.00, '[RESERVED]'),
(6, '2023-07-03', 110.00, '[RESERVED]'),
(6, '2023-07-04', 110.00, '[RESERVED]'),
(6, '2023-07-05', 110.00, '[RESERVED]'),
-- August
(6, '2023-08-10', 110.00, '[OPEN]'),
(6, '2023-08-11', 110.00, '[OPEN]'),
(6, '2023-08-12', 110.00, '[OPEN]'),
(6, '2023-08-13', 110.00, '[RESERVED]'),
(6, '2023-08-14', 110.00, '[RESERVED]'),
(6, '2023-08-15', 110.00, '[OPEN]'),
-- September
(6, '2023-09-01', 110.00, '[OPEN]'),
(6, '2023-09-02', 110.00, '[OPEN]'),
(6, '2023-09-03', 110.00, '[OPEN]'),
(6, '2023-09-04', 110.00, '[RESERVED]'),
(6, '2023-09-05', 110.00, '[RESERVED]'),

(7, '2022-06-01', 105.00, '[OPEN]'),
(7, '2022-06-02', 105.00, '[OPEN]'),
(7, '2022-06-03', 105.00, '[OPEN]'),
-- July
(7, '2023-07-01', 125.00, '[RESERVED]'),
(7, '2023-07-02', 125.00, '[RESERVED]'),
(7, '2023-07-03', 125.00, '[OPEN]'),
(7, '2023-07-04', 125.00, '[OPEN]'),
(7, '2023-07-05', 125.00, '[OPEN]'),
-- August
(7, '2023-08-10', 125.00, '[OPEN]'),
(7, '2023-08-11', 125.00, '[RESERVED]'),
(7, '2023-08-12', 125.00, '[RESERVED]'),
(7, '2023-08-13', 125.00, '[OPEN]'),
(7, '2023-08-14', 125.00, '[OPEN]'),
(7, '2023-08-15', 125.00, '[OPEN]'),
-- September
(7, '2023-09-01', 125.00, '[OPEN]'),
(7, '2023-09-02', 125.00, '[RESERVED]'),
(7, '2023-09-03', 125.00, '[RESERVED]'),
(7, '2023-09-04', 125.00, '[OPEN]'),
(7, '2023-09-05', 125.00, '[OPEN]'),

(8, '2022-06-01', 80.00, '[OPEN]'),
(8, '2022-06-02', 80.00, '[OPEN]'),
(8, '2022-06-03', 80.00, '[OPEN]'),
-- July
(8, '2023-07-01', 100.00, '[OPEN]'),
(8, '2023-07-02', 100.00, '[RESERVED]'),
(8, '2023-07-03', 100.00, '[RESERVED]'),
(8, '2023-07-04', 100.00, '[RESERVED]'),
(8, '2023-07-05', 100.00, '[OPEN]'),
-- August
(8, '2023-08-10', 100.00, '[OPEN]'),
(8, '2023-08-11', 100.00, '[OPEN]'),
(8, '2023-08-12', 100.00, '[RESERVED]'),
(8, '2023-08-13', 100.00, '[RESERVED]'),
(8, '2023-08-14', 100.00, '[OPEN]'),
(8, '2023-08-15', 100.00, '[OPEN]'),
-- September
(8, '2023-09-01', 100.00, '[OPEN]'),
(8, '2023-09-02', 100.00, '[BLOCKED]'),
(8, '2023-09-03', 100.00, '[OPEN]'),
(8, '2023-09-04', 100.00, '[BLOCKED]'),
(8, '2023-09-05', 100.00, '[OPEN]'),

(9, '2022-06-01', 60.00, '[OPEN]'),
(9, '2022-06-02', 60.00, '[OPEN]'),
(9, '2022-06-03', 60.00, '[OPEN]'),
-- July
(9, '2023-07-01', 80.00, '[RESERVED]'),
(9, '2023-07-02', 80.00, '[RESERVED]'),
(9, '2023-07-03', 80.00, '[RESERVED]'),
(9, '2023-07-04', 80.00, '[OPEN]'),
(9, '2023-07-05', 80.00, '[OPEN]'),
-- August
(9, '2023-08-10', 80.00, '[BLOCKED]'),
(9, '2023-08-11', 80.00, '[OPEN]'),
(9, '2023-08-12', 80.00, '[OPEN]'),
(9, '2023-08-13', 80.00, '[OPEN]'),
(9, '2023-08-14', 80.00, '[OPEN]'),
(9, '2023-08-15', 80.00, '[BLOCKED]'),
-- September
(9, '2023-09-01', 80.00, '[OPEN]'),
(9, '2023-09-02', 80.00, '[RESERVED]'),
(9, '2023-09-03', 80.00, '[RESERVED]'),
(9, '2023-09-04', 80.00, '[OPEN]'),
(9, '2023-09-05', 80.00, '[OPEN]'),

(10, '2022-06-01', 115.00, '[OPEN]'),
(10, '2022-06-02', 115.00, '[OPEN]'),
(10, '2022-06-03', 115.00, '[OPEN]'),
-- July
(10, '2023-07-01', 135.00, '[RESERVED]'),
(10, '2023-07-02', 135.00, '[RESERVED]'),
(10, '2023-07-03', 135.00, '[OPEN]'),
(10, '2023-07-04', 135.00, '[RESERVED]'),
(10, '2023-07-05', 135.00, '[RESERVED]'),
-- August
(10, '2023-08-10', 135.00, '[OPEN]'),
(10, '2023-08-11', 135.00, '[OPEN]'),
(10, '2023-08-12', 135.00, '[RESERVED]'),
(10, '2023-08-13', 135.00, '[RESERVED]'),
(10, '2023-08-14', 135.00, '[OPEN]'),
(10, '2023-08-15', 135.00, '[OPEN]'),
-- September
(10, '2023-09-01', 135.00, '[BLOCKED]'),
(10, '2023-09-02', 135.00, '[OPEN]'),
(10, '2023-09-03', 135.00, '[BLOCKED]'),
(10, '2023-09-04', 135.00, '[OPEN]'),
(10, '2023-09-05', 135.00, '[OPEN]'),

(11, '2022-06-01', 160.00, '[OPEN]'),
(11, '2022-06-02', 160.00, '[OPEN]'),
(11, '2022-06-03', 160.00, '[OPEN]'),
-- July
(11, '2023-07-01', 180.00, '[RESERVED]'),
(11, '2023-07-02', 180.00, '[RESERVED]'),
(11, '2023-07-03', 180.00, '[OPEN]'),
(11, '2023-07-04', 180.00, '[OPEN]'),
(11, '2023-07-05', 180.00, '[OPEN]'),
-- August
(11, '2023-08-10', 180.00, '[OPEN]'),
(11, '2023-08-11', 180.00, '[OPEN]'),
(11, '2023-08-12', 180.00, '[OPEN]'),
(11, '2023-08-13', 180.00, '[OPEN]'),
(11, '2023-08-14', 180.00, '[RESERVED]'),
(11, '2023-08-15', 180.00, '[RESERVED]'),
-- September
(11, '2023-09-01', 180.00, '[OPEN]'),
(11, '2023-09-02', 180.00, '[OPEN]'),
(11, '2023-09-03', 180.00, '[RESERVED]'),
(11, '2023-09-04', 180.00, '[RESERVED]'),
(11, '2023-09-05', 180.00, '[OPEN]'),

(12, '2022-06-01', 180.00, '[OPEN]'),
(12, '2022-06-02', 180.00, '[OPEN]'),
(12, '2022-06-03', 180.00, '[OPEN]'),
-- July
(12, '2023-07-01', 200.00, '[RESERVED]'),
(12, '2023-07-02', 200.00, '[RESERVED]'),
(12, '2023-07-03', 200.00, '[OPEN]'),
(12, '2023-07-04', 200.00, '[RESERVED]'),
(12, '2023-07-05', 200.00, '[RESERVED]'),
-- August
(12, '2023-08-10', 200.00, '[RESERVED]'),
(12, '2023-08-11', 200.00, '[RESERVED]'),
(12, '2023-08-12', 200.00, '[OPEN]'),
(12, '2023-08-13', 200.00, '[RESERVED]'),
(12, '2023-08-14', 200.00, '[RESERVED]'),
(12, '2023-08-15', 200.00, '[OPEN]'),
-- September
(12, '2023-09-01', 200.00, '[OPEN]'),
(12, '2023-09-02', 200.00, '[BLOCKED]'),
(12, '2023-09-03', 200.00, '[OPEN]'),
(12, '2023-09-04', 200.00, '[OPEN]'),
(12, '2023-09-05', 200.00, '[BLOCKED]'),

(13, '2022-06-01', 75.00, '[OPEN]'),
(13, '2022-06-02', 75.00, '[OPEN]'),
(13, '2022-06-03', 75.00, '[OPEN]'),
-- July
(13, '2023-07-01', 95.00, '[RESERVED]'),
(13, '2023-07-02', 95.00, '[RESERVED]'),
(13, '2023-07-03', 95.00, '[OPEN]'),
(13, '2023-07-04', 95.00, '[RESERVED]'),
(13, '2023-07-05', 95.00, '[RESERVED]'),
-- August
(13, '2023-08-10', 95.00, '[OPEN]'),
(13, '2023-08-11', 95.00, '[OPEN]'),
(13, '2023-08-12', 95.00, '[RESERVED]'),
(13, '2023-08-13', 95.00, '[RESERVED]'),
(13, '2023-08-14', 95.00, '[OPEN]'),
(13, '2023-08-15', 95.00, '[OPEN]'),
-- September
(13, '2023-09-01', 95.00, '[OPEN]'),
(13, '2023-09-02', 95.00, '[OPEN]'),
(13, '2023-09-03', 95.00, '[RESERVED]'),
(13, '2023-09-04', 95.00, '[OPEN]'),
(13, '2023-09-05', 95.00, '[OPEN]'),

(14, '2022-06-01', 115.00, '[OPEN]'),
(14, '2022-06-02', 115.00, '[OPEN]'),
(14, '2022-06-03', 115.00, '[OPEN]'),
-- July
(14, '2023-07-01', 135.00, '[RESERVED]'),
(14, '2023-07-02', 135.00, '[RESERVED]'),
(14, '2023-07-03', 135.00, '[RESERVED]'),
(14, '2023-07-04', 135.00, '[RESERVED]'),
(14, '2023-07-05', 135.00, '[RESERVED]'),
-- August
(14, '2023-08-10', 135.00, '[OPEN]'),
(14, '2023-08-11', 135.00, '[OPEN]'),
(14, '2023-08-12', 135.00, '[RESERVED]'),
(14, '2023-08-13', 135.00, '[RESERVED]'),
(14, '2023-08-14', 135.00, '[RESERVED]'),
(14, '2023-08-15', 135.00, '[OPEN]'),
-- September
(14, '2023-09-01', 135.00, '[OPEN]'),
(14, '2023-09-02', 135.00, '[BLOCKED]'),
(14, '2023-09-03', 135.00, '[BLOCKED]'),
(14, '2023-09-04', 135.00, '[OPEN]'),
(14, '2023-09-05', 135.00, '[OPEN]'),

(15, '2022-06-01', 95.00, '[OPEN]'),
(15, '2022-06-02', 95.00, '[OPEN]'),
(15, '2022-06-03', 95.00, '[OPEN]'),
-- July
(15, '2023-07-01', 150.00, '[RESERVED]'),
(15, '2023-07-02', 150.00, '[RESERVED]'),
(15, '2023-07-03', 150.00, '[OPEN]'),
(15, '2023-07-04', 150.00, '[OPEN]'),
(15, '2023-07-05', 150.00, '[OPEN]'),
-- August
(15, '2023-08-10', 150.00, '[OPEN]'),
(15, '2023-08-11', 150.00, '[RESERVED]'),
(15, '2023-08-12', 150.00, '[RESERVED]'),
(15, '2023-08-13', 150.00, '[OPEN]'),
(15, '2023-08-14', 150.00, '[OPEN]'),
(15, '2023-08-15', 150.00, '[OPEN]'),
-- September
(15, '2023-09-01', 150.00, '[OPEN]'),
(15, '2023-09-02', 150.00, '[OPEN]'),
(15, '2023-09-03', 150.00, '[OPEN]'),
(15, '2023-09-04', 150.00, '[OPEN]'),

-- July
(16, '2023-07-01', 120.00, '[RESERVED]'),
(16, '2023-07-02', 120.00, '[RESERVED]'),
(16, '2023-07-03', 120.00, '[RESERVED]'),
(16, '2023-07-04', 120.00, '[OPEN]'),
(16, '2023-07-05', 120.00, '[OPEN]'),
-- August
(16, '2023-08-10', 120.00, '[OPEN]'),
(16, '2023-08-11', 120.00, '[OPEN]'),
(16, '2023-08-12', 120.00, '[OPEN]'),
(16, '2023-08-13', 120.00, '[OPEN]'),
(16, '2023-08-14', 120.00, '[RESERVED]'),
(16, '2023-08-15', 120.00, '[RESERVED]'),
-- September
(16, '2023-09-01', 120.00, '[OPEN]'),
(16, '2023-09-02', 120.00, '[OPEN]'),
(16, '2023-09-03', 120.00, '[OPEN]'),
(16, '2023-09-04', 120.00, '[OPEN]'),
(16, '2023-09-05', 120.00, '[OPEN]'),

-- July
(17, '2023-07-01', 110.00, '[OPEN]'),
(17, '2023-07-02', 110.00, '[RESERVED]'),
(17, '2023-07-03', 110.00, '[RESERVED]'),
(17, '2023-07-04', 110.00, '[RESERVED]'),
(17, '2023-07-05', 110.00, '[OPEN]'),
-- August
(17, '2023-08-10', 110.00, '[OPEN]'),
(17, '2023-08-11', 110.00, '[OPEN]'),
(17, '2023-08-12', 110.00, '[OPEN]'),
(17, '2023-08-13', 110.00, '[OPEN]'),
(17, '2023-08-14', 110.00, '[OPEN]'),
(17, '2023-08-15', 110.00, '[OPEN]'),
-- September
(17, '2023-09-01', 110.00, '[OPEN]'),
(17, '2023-09-02', 110.00, '[RESERVED]'),
(17, '2023-09-03', 110.00, '[RESERVED]'),
(17, '2023-09-04', 110.00, '[OPEN]'),
(17, '2023-09-05', 110.00, '[OPEN]'),

-- July
(18, '2023-07-01', 90.00, '[OPEN]'),
(18, '2023-07-02', 90.00, '[RESERVED]'),
(18, '2023-07-03', 90.00, '[RESERVED]'),
(18, '2023-07-04', 90.00, '[OPEN]'),
(18, '2023-07-05', 90.00, '[OPEN]'),
-- August
(18, '2023-08-10', 90.00, '[OPEN]'),
(18, '2023-08-11', 90.00, '[OPEN]'),
(18, '2023-08-12', 90.00, '[OPEN]'),
(18, '2023-08-13', 90.00, '[OPEN]'),
(18, '2023-08-14', 90.00, '[OPEN]'),
(18, '2023-08-15', 90.00, '[OPEN]'),
-- September
(18, '2023-09-01', 90.00, '[OPEN]'),
(18, '2023-09-02', 90.00, '[OPEN]'),
(18, '2023-09-03', 90.00, '[RESERVED]'),
(18, '2023-09-04', 90.00, '[RESERVED]'),
(18, '2023-09-05', 90.00, '[RESERVED]'),

-- July
(19, '2023-07-01', 130.00, '[OPEN]'),
(19, '2023-07-02', 130.00, '[OPEN]'),
(19, '2023-07-03', 130.00, '[OPEN]'),
(19, '2023-07-04', 130.00, '[OPEN]'),
(19, '2023-07-05', 130.00, '[OPEN]'),
-- August
(19, '2023-08-10', 130.00, '[OPEN]'),
(19, '2023-08-11', 130.00, '[OPEN]'),
(19, '2023-08-12', 130.00, '[OPEN]'),
(19, '2023-08-13', 130.00, '[OPEN]'),
(19, '2023-08-14', 130.00, '[OPEN]'),
(19, '2023-08-15', 130.00, '[OPEN]'),
-- September
(19, '2023-09-01', 130.00, '[OPEN]'),
(19, '2023-09-02', 130.00, '[OPEN]'),
(19, '2023-09-03', 130.00, '[OPEN]'),
(19, '2023-09-04', 130.00, '[OPEN]'),
(19, '2023-09-05', 130.00, '[OPEN]'),

-- July
(20, '2023-07-01', 95.00, '[OPEN]'),
(20, '2023-07-02', 95.00, '[OPEN]'),
(20, '2023-07-03', 95.00, '[OPEN]'),
(20, '2023-07-04', 95.00, '[RESERVED]'),
(20, '2023-07-05', 95.00, '[RESERVED]'),
-- August
(20, '2023-08-10', 95.00, '[OPEN]'),
(20, '2023-08-11', 95.00, '[RESERVED]'),
(20, '2023-08-12', 95.00, '[RESERVED]'),
(20, '2023-08-13', 95.00, '[OPEN]'),
(20, '2023-08-14', 95.00, '[OPEN]'),
(20, '2023-08-15', 95.00, '[OPEN]'),
-- September
(20, '2023-09-01', 95.00, '[OPEN]'),
(20, '2023-09-02', 95.00, '[OPEN]'),
(20, '2023-09-03', 95.00, '[OPEN]'),
(20, '2023-09-04', 95.00, '[OPEN]'),
(20, '2023-09-05', 95.00, '[OPEN]'),

-- July
(21, '2023-07-01', 200.00, '[RESERVED]'),
(21, '2023-07-02', 200.00, '[RESERVED]'),
(21, '2023-07-03', 200.00, '[RESERVED]'),
(21, '2023-07-04', 200.00, '[RESERVED]'),
(21, '2023-07-05', 200.00, '[OPEN]'),
-- August
(21, '2023-08-10', 200.00, '[OPEN]'),
(21, '2023-08-11', 200.00, '[OPEN]'),
(21, '2023-08-12', 200.00, '[OPEN]'),
(21, '2023-08-13', 200.00, '[OPEN]'),
(21, '2023-08-14', 200.00, '[OPEN]'),
(21, '2023-08-15', 200.00, '[OPEN]'),
-- September
(21, '2023-09-01', 200.00, '[RESERVED]'),
(21, '2023-09-02', 200.00, '[RESERVED]'),
(21, '2023-09-03', 200.00, '[OPEN]'),
(21, '2023-09-04', 200.00, '[OPEN]'),
(21, '2023-09-05', 200.00, '[OPEN]'),

-- July
(22, '2023-07-01', 210.00, '[RESERVED]'),
(22, '2023-07-02', 210.00, '[OPEN]'),
(22, '2023-07-03', 210.00, '[RESERVED]'),
(22, '2023-07-04', 210.00, '[RESERVED]'),
(22, '2023-07-05', 210.00, '[OPEN]'),
-- August
(22, '2023-08-10', 210.00, '[OPEN]'),
(22, '2023-08-11', 210.00, '[OPEN]'),
(22, '2023-08-12', 210.00, '[RESERVED]'),
(22, '2023-08-13', 210.00, '[RESERVED]'),
(22, '2023-08-14', 210.00, '[RESERVED]'),
(22, '2023-08-15', 210.00, '[OPEN]'),
-- September
(22, '2023-09-01', 210.00, '[OPEN]'),
(22, '2023-09-02', 210.00, '[OPEN]'),
(22, '2023-09-03', 210.00, '[OPEN]'),
(22, '2023-09-04', 210.00, '[OPEN]'),
(22, '2023-09-05', 210.00, '[OPEN]'),

-- July
(23, '2023-07-01', 180.00, '[RESERVED]'),
(23, '2023-07-02', 180.00, '[RESERVED]'),
(23, '2023-07-03', 180.00, '[RESERVED]'),
(23, '2023-07-04', 180.00, '[OPEN]'),
(23, '2023-07-05', 180.00, '[OPEN]'),
-- August
(23, '2023-08-10', 180.00, '[OPEN]'),
(23, '2023-08-11', 180.00, '[RESERVED]'),
(23, '2023-08-12', 180.00, '[RESERVED]'),
(23, '2023-08-13', 180.00, '[OPEN]'),
(23, '2023-08-14', 180.00, '[OPEN]'),
(23, '2023-08-15', 180.00, '[OPEN]'),
-- September
(23, '2023-09-01', 180.00, '[OPEN]'),
(23, '2023-09-02', 180.00, '[OPEN]'),
(23, '2023-09-03', 180.00, '[RESERVED]'),
(23, '2023-09-04', 180.00, '[OPEN]'),
(23, '2023-09-05', 180.00, '[OPEN]'),

-- July
(24, '2023-07-01', 195.00, '[RESERVED]'),
(24, '2023-07-02', 195.00, '[RESERVED]'),
(24, '2023-07-03', 195.00, '[RESERVED]'),
(24, '2023-07-04', 195.00, '[OPEN]'),
(24, '2023-07-05', 195.00, '[OPEN]'),
-- August
(24, '2023-08-10', 195.00, '[RESERVED]'),
(24, '2023-08-11', 195.00, '[RESERVED]'),
(24, '2023-08-12', 195.00, '[OPEN]'),
(24, '2023-08-13', 195.00, '[OPEN]'),
(24, '2023-08-14', 195.00, '[OPEN]'),
(24, '2023-08-15', 195.00, '[OPEN]'),
-- September
(24, '2023-09-01', 195.00, '[RESERVED]'),
(24, '2023-09-02', 195.00, '[OPEN]'),
(24, '2023-09-03', 195.00, '[OPEN]'),
(24, '2023-09-04', 195.00, '[RESERVED]'),
(24, '2023-09-05', 195.00, '[OPEN]'),

-- July
(25, '2023-07-01', 170.00, '[RESERVED]'),
(25, '2023-07-02', 170.00, '[OPEN]'),
(25, '2023-07-03', 170.00, '[RESERVED]'),
(25, '2023-07-04', 170.00, '[OPEN]'),
(25, '2023-07-05', 170.00, '[OPEN]'),
-- August
(25, '2023-08-10', 170.00, '[OPEN]'),
(25, '2023-08-11', 170.00, '[RESERVED]'),
(25, '2023-08-12', 170.00, '[RESERVED]'),
(25, '2023-08-13', 170.00, '[OPEN]'),
(25, '2023-08-14', 170.00, '[OPEN]'),
(25, '2023-08-15', 170.00, '[OPEN]'),
-- September
(25, '2023-09-01', 170.00, '[OPEN]'),
(25, '2023-09-02', 170.00, '[OPEN]'),
(25, '2023-09-03', 170.00, '[OPEN]'),
(25, '2023-09-04', 170.00, '[OPEN]'),
(25, '2023-09-05', 170.00, '[OPEN]'),

-- July
(26, '2023-07-01', 160.00, '[RESERVED]'),
(26, '2023-07-02', 160.00, '[OPEN]'),
(26, '2023-07-03', 160.00, '[RESERVED]'),
(26, '2023-07-04', 160.00, '[OPEN]'),
(26, '2023-07-05', 160.00, '[RESERVED]'),
-- August
(26, '2023-08-10', 160.00, '[OPEN]'),
(26, '2023-08-11', 160.00, '[RESERVED]'),
(26, '2023-08-12', 160.00, '[RESERVED]'),
(26, '2023-08-13', 160.00, '[OPEN]'),
(26, '2023-08-14', 160.00, '[OPEN]'),
(26, '2023-08-15', 160.00, '[OPEN]'),
-- September
(26, '2023-09-01', 160.00, '[OPEN]'),
(26, '2023-09-02', 160.00, '[OPEN]'),
(26, '2023-09-03', 160.00, '[OPEN]'),
(26, '2023-09-04', 160.00, '[OPEN]'),
(26, '2023-09-05', 160.00, '[OPEN]'),

-- July
(27, '2023-07-01', 215.00, '[OPEN]'),
(27, '2023-07-02', 215.00, '[OPEN]'),
(27, '2023-07-03', 215.00, '[OPEN]'),
(27, '2023-07-04', 215.00, '[OPEN]'),
(27, '2023-07-05', 215.00, '[OPEN]'),
-- August
(27, '2023-08-10', 215.00, '[OPEN]'),
(27, '2023-08-11', 215.00, '[OPEN]'),
(27, '2023-08-12', 215.00, '[OPEN]'),
(27, '2023-08-13', 215.00, '[OPEN]'),
(27, '2023-08-14', 215.00, '[OPEN]'),
(27, '2023-08-15', 215.00, '[OPEN]'),
-- September
(27, '2023-09-01', 215.00, '[OPEN]'),
(27, '2023-09-02', 215.00, '[OPEN]'),
(27, '2023-09-03', 215.00, '[OPEN]'),
(27, '2023-09-04', 215.00, '[OPEN]'),
(27, '2023-09-05', 215.00, '[OPEN]'),

-- July
(28, '2023-07-01', 200.00, '[OPEN]'),
(28, '2023-07-02', 200.00, '[OPEN]'),
(28, '2023-07-03', 200.00, '[OPEN]'),
(28, '2023-07-04', 200.00, '[OPEN]'),
(28, '2023-07-05', 200.00, '[OPEN]'),
-- August
(28, '2023-08-10', 200.00, '[OPEN]'),
(28, '2023-08-11', 200.00, '[OPEN]'),
(28, '2023-08-12', 200.00, '[OPEN]'),
(28, '2023-08-13', 200.00, '[OPEN]'),
(28, '2023-08-14', 200.00, '[OPEN]'),
(28, '2023-08-15', 200.00, '[OPEN]'),
-- September
(28, '2023-09-01', 200.00, '[OPEN]'),
(28, '2023-09-02', 200.00, '[OPEN]'),
(28, '2023-09-03', 200.00, '[OPEN]'),
(28, '2023-09-04', 200.00, '[OPEN]'),
(28, '2023-09-05', 200.00, '[OPEN]'),

-- July
(29, '2023-07-01', 240.00, '[OPEN]'),
(29, '2023-07-02', 240.00, '[OPEN]'),
(29, '2023-07-03', 240.00, '[OPEN]'),
(29, '2023-07-04', 240.00, '[OPEN]'),
(29, '2023-07-05', 240.00, '[OPEN]'),
-- August
(29, '2023-08-10', 240.00, '[OPEN]'),
(29, '2023-08-11', 240.00, '[OPEN]'),
(29, '2023-08-12', 240.00, '[OPEN]'),
(29, '2023-08-13', 240.00, '[OPEN]'),
(29, '2023-08-14', 240.00, '[OPEN]'),
(29, '2023-08-15', 240.00, '[OPEN]'),
-- September
(29, '2023-09-01', 240.00, '[OPEN]'),
(29, '2023-09-02', 240.00, '[OPEN]'),
(29, '2023-09-03', 240.00, '[OPEN]'),
(29, '2023-09-04', 240.00, '[OPEN]'),
(29, '2023-09-05', 240.00, '[OPEN]'),

-- July
(30, '2023-07-01', 220.00, '[OPEN]'),
(30, '2023-07-02', 220.00, '[OPEN]'),
(30, '2023-07-03', 220.00, '[OPEN]'),
(30, '2023-07-04', 220.00, '[OPEN]'),
(30, '2023-07-05', 220.00, '[OPEN]'),
-- August
(30, '2023-08-10', 220.00, '[OPEN]'),
(30, '2023-08-11', 220.00, '[OPEN]'),
(30, '2023-08-12', 220.00, '[OPEN]'),
(30, '2023-08-13', 220.00, '[OPEN]'),
(30, '2023-08-14', 220.00, '[OPEN]'),
(30, '2023-08-15', 220.00, '[OPEN]'),
-- September
(30, '2023-09-01', 220.00, '[OPEN]'),
(30, '2023-09-02', 220.00, '[OPEN]'),
(30, '2023-09-03', 220.00, '[OPEN]'),
(30, '2023-09-04', 220.00, '[OPEN]'),
(30, '2023-09-05', 220.00, '[OPEN]'),

-- July
(31, '2023-07-01', 260.00, '[OPEN]'),
(31, '2023-07-02', 260.00, '[OPEN]'),
(31, '2023-07-03', 260.00, '[OPEN]'),
(31, '2023-07-04', 260.00, '[OPEN]'),
(31, '2023-07-05', 260.00, '[OPEN]'),
-- August
(31, '2023-08-10', 260.00, '[OPEN]'),
(31, '2023-08-11', 260.00, '[OPEN]'),
(31, '2023-08-12', 260.00, '[OPEN]'),
(31, '2023-08-13', 260.00, '[OPEN]'),
(31, '2023-08-14', 260.00, '[OPEN]'),
(31, '2023-08-15', 260.00, '[OPEN]'),
-- September
(31, '2023-09-01', 260.00, '[OPEN]'),
(31, '2023-09-02', 260.00, '[OPEN]'),
(31, '2023-09-03', 260.00, '[OPEN]'),
(31, '2023-09-04', 260.00, '[OPEN]'),
(31, '2023-09-05', 260.00, '[OPEN]'),

-- July
(32, '2023-07-01', 225.00, '[OPEN]'),
(32, '2023-07-02', 225.00, '[OPEN]'),
(32, '2023-07-03', 225.00, '[OPEN]'),
(32, '2023-07-04', 225.00, '[OPEN]'),
(32, '2023-07-05', 225.00, '[OPEN]'),
-- August
(32, '2023-08-10', 225.00, '[OPEN]'),
(32, '2023-08-11', 225.00, '[OPEN]'),
(32, '2023-08-12', 225.00, '[OPEN]'),
(32, '2023-08-13', 225.00, '[OPEN]'),
(32, '2023-08-14', 225.00, '[OPEN]'),
(32, '2023-08-15', 225.00, '[OPEN]'),
-- September
(32, '2023-09-01', 225.00, '[OPEN]'),
(32, '2023-09-02', 225.00, '[OPEN]'),
(32, '2023-09-03', 225.00, '[OPEN]'),
(32, '2023-09-04', 225.00, '[OPEN]'),
(32, '2023-09-05', 225.00, '[OPEN]'),

-- July
(33, '2023-07-01', 215.00, '[OPEN]'),
(33, '2023-07-02', 215.00, '[OPEN]'),
(33, '2023-07-03', 215.00, '[OPEN]'),
(33, '2023-07-04', 215.00, '[OPEN]'),
(33, '2023-07-05', 215.00, '[OPEN]'),
-- August
(33, '2023-08-10', 215.00, '[OPEN]'),
(33, '2023-08-11', 215.00, '[OPEN]'),
(33, '2023-08-12', 215.00, '[OPEN]'),
(33, '2023-08-13', 215.00, '[OPEN]'),
(33, '2023-08-14', 215.00, '[OPEN]'),
(33, '2023-08-15', 215.00, '[OPEN]'),
-- September
(33, '2023-09-01', 215.00, '[OPEN]'),
(33, '2023-09-02', 215.00, '[OPEN]'),
(33, '2023-09-03', 215.00, '[OPEN]'),
(33, '2023-09-04', 215.00, '[OPEN]'),
(33, '2023-09-05', 215.00, '[OPEN]'),

-- July
(34, '2023-07-01', 230.00, '[OPEN]'),
(34, '2023-07-02', 230.00, '[OPEN]'),
(34, '2023-07-03', 230.00, '[OPEN]'),
(34, '2023-07-04', 230.00, '[OPEN]'),
(34, '2023-07-05', 230.00, '[OPEN]'),
-- August
(34, '2023-08-10', 230.00, '[OPEN]'),
(34, '2023-08-11', 230.00, '[OPEN]'),
(34, '2023-08-12', 230.00, '[OPEN]'),
(34, '2023-08-13', 230.00, '[OPEN]'),
(34, '2023-08-14', 230.00, '[OPEN]'),
(34, '2023-08-15', 230.00, '[OPEN]'),
-- September
(34, '2023-09-01', 230.00, '[OPEN]'),
(34, '2023-09-02', 230.00, '[OPEN]'),
(34, '2023-09-03', 230.00, '[OPEN]'),
(34, '2023-09-04', 230.00, '[OPEN]'),
(34, '2023-09-05', 230.00, '[OPEN]'),

-- July
(35, '2023-07-01', 245.00, '[OPEN]'),
(35, '2023-07-02', 245.00, '[OPEN]'),
(35, '2023-07-03', 245.00, '[OPEN]'),
(35, '2023-07-04', 245.00, '[OPEN]'),
(35, '2023-07-05', 245.00, '[OPEN]'),
-- August
(35, '2023-08-10', 245.00, '[OPEN]'),
(35, '2023-08-11', 245.00, '[OPEN]'),
(35, '2023-08-12', 245.00, '[OPEN]'),
(35, '2023-08-13', 245.00, '[OPEN]'),
(35, '2023-08-14', 245.00, '[OPEN]'),
(35, '2023-08-15', 245.00, '[OPEN]'),
-- September
(35, '2023-09-01', 245.00, '[OPEN]'),
(35, '2023-09-02', 245.00, '[OPEN]'),
(35, '2023-09-03', 245.00, '[OPEN]'),
(35, '2023-09-04', 245.00, '[OPEN]'),
(35, '2023-09-05', 245.00, '[OPEN]'),

-- July
(36, '2023-07-01', 240.00, '[OPEN]'),
(36, '2023-07-02', 240.00, '[OPEN]'),
(36, '2023-07-03', 240.00, '[OPEN]'),
(36, '2023-07-04', 240.00, '[OPEN]'),
(36, '2023-07-05', 240.00, '[OPEN]'),
-- August
(36, '2023-08-10', 240.00, '[OPEN]'),
(36, '2023-08-11', 240.00, '[OPEN]'),
(36, '2023-08-12', 240.00, '[OPEN]'),
(36, '2023-08-13', 240.00, '[OPEN]'),
(36, '2023-08-14', 240.00, '[OPEN]'),
(36, '2023-08-15', 240.00, '[OPEN]'),
-- September
(36, '2023-09-01', 240.00, '[OPEN]'),
(36, '2023-09-02', 240.00, '[OPEN]'),
(36, '2023-09-03', 240.00, '[OPEN]'),
(36, '2023-09-04', 240.00, '[OPEN]'),
(36, '2023-09-05', 240.00, '[OPEN]'),

-- July
(37, '2023-07-01', 185.00, '[OPEN]'),
(37, '2023-07-02', 185.00, '[OPEN]'),
(37, '2023-07-03', 185.00, '[OPEN]'),
(37, '2023-07-04', 185.00, '[OPEN]'),
(37, '2023-07-05', 185.00, '[OPEN]'),
-- August
(37, '2023-08-10', 185.00, '[OPEN]'),
(37, '2023-08-11', 185.00, '[OPEN]'),
(37, '2023-08-12', 185.00, '[OPEN]'),
(37, '2023-08-13', 185.00, '[OPEN]'),
(37, '2023-08-14', 185.00, '[OPEN]'),
(37, '2023-08-15', 185.00, '[OPEN]'),
-- September
(37, '2023-09-01', 185.00, '[OPEN]'),
(37, '2023-09-02', 185.00, '[OPEN]'),
(37, '2023-09-03', 185.00, '[OPEN]'),
(37, '2023-09-04', 185.00, '[OPEN]'),
(37, '2023-09-05', 185.00, '[OPEN]'),

-- July
(38, '2023-07-01', 160.00, '[OPEN]'),
(38, '2023-07-02', 160.00, '[OPEN]'),
(38, '2023-07-03', 160.00, '[OPEN]'),
(38, '2023-07-04', 160.00, '[OPEN]'),
(38, '2023-07-05', 160.00, '[OPEN]'),
-- August
(38, '2023-08-10', 160.00, '[OPEN]'),
(38, '2023-08-11', 160.00, '[OPEN]'),
(38, '2023-08-12', 160.00, '[OPEN]'),
(38, '2023-08-13', 160.00, '[OPEN]'),
(38, '2023-08-14', 160.00, '[OPEN]'),
(38, '2023-08-15', 160.00, '[OPEN]'),
-- September
(38, '2023-09-01', 160.00, '[OPEN]'),
(38, '2023-09-02', 160.00, '[OPEN]'),
(38, '2023-09-03', 160.00, '[OPEN]'),
(38, '2023-09-04', 160.00, '[OPEN]'),
(38, '2023-09-05', 160.00, '[OPEN]'),

-- July
(39, '2023-07-01', 190.00, '[OPEN]'),
(39, '2023-07-02', 190.00, '[OPEN]'),
(39, '2023-07-03', 190.00, '[OPEN]'),
(39, '2023-07-04', 190.00, '[OPEN]'),
(39, '2023-07-05', 190.00, '[OPEN]'),
-- August
(39, '2023-08-10', 190.00, '[OPEN]'),
(39, '2023-08-11', 190.00, '[OPEN]'),
(39, '2023-08-12', 190.00, '[OPEN]'),
(39, '2023-08-13', 190.00, '[OPEN]'),
(39, '2023-08-14', 190.00, '[OPEN]'),
(39, '2023-08-15', 190.00, '[OPEN]'),
-- September
(39, '2023-09-01', 190.00, '[OPEN]'),
(39, '2023-09-02', 190.00, '[OPEN]'),
(39, '2023-09-03', 190.00, '[OPEN]'),
(39, '2023-09-04', 190.00, '[OPEN]'),
(39, '2023-09-05', 190.00, '[OPEN]'),

-- July
(40, '2023-07-01', 156.00, '[OPEN]'),
(40, '2023-07-02', 156.00, '[OPEN]'),
(40, '2023-07-03', 156.00, '[OPEN]'),
(40, '2023-07-04', 156.00, '[OPEN]'),
(40, '2023-07-05', 156.00, '[OPEN]'),
-- August
(40, '2023-08-10', 156.00, '[OPEN]'),
(40, '2023-08-11', 156.00, '[OPEN]'),
(40, '2023-08-12', 156.00, '[OPEN]'),
(40, '2023-08-13', 156.00, '[OPEN]'),
(40, '2023-08-14', 156.00, '[OPEN]'),
(40, '2023-08-15', 156.00, '[OPEN]'),
-- September
(40, '2023-09-01', 156.00, '[OPEN]'),
(40, '2023-09-02', 156.00, '[OPEN]'),
(40, '2023-09-03', 156.00, '[OPEN]'),
(40, '2023-09-04', 156.00, '[OPEN]'),
(40, '2023-09-05', 156.00, '[OPEN]'),

-- July
(41, '2023-07-01', 156.00, '[OPEN]'),
(41, '2023-07-02', 156.00, '[OPEN]'),
(41, '2023-07-03', 156.00, '[OPEN]'),
(41, '2023-07-04', 156.00, '[OPEN]'),
(41, '2023-07-05', 156.00, '[OPEN]'),
-- August
(41, '2023-08-10', 156.00, '[OPEN]'),
(41, '2023-08-11', 156.00, '[OPEN]'),
(41, '2023-08-12', 156.00, '[OPEN]'),
(41, '2023-08-13', 156.00, '[OPEN]'),
(41, '2023-08-14', 156.00, '[OPEN]'),
(41, '2023-08-15', 156.00, '[OPEN]'),
-- September
(41, '2023-09-01', 156.00, '[OPEN]'),
(41, '2023-09-02', 156.00, '[OPEN]'),
(41, '2023-09-03', 156.00, '[OPEN]'),
(41, '2023-09-04', 156.00, '[OPEN]'),
(41, '2023-09-05', 156.00, '[OPEN]'),

-- July
(42, '2023-07-01', 198.00, '[OPEN]'),
(42, '2023-07-02', 198.00, '[OPEN]'),
(42, '2023-07-03', 198.00, '[OPEN]'),
(42, '2023-07-04', 198.00, '[OPEN]'),
(42, '2023-07-05', 198.00, '[OPEN]'),
-- August
(42, '2023-08-10', 198.00, '[OPEN]'),
(42, '2023-08-11', 198.00, '[OPEN]'),
(42, '2023-08-12', 198.00, '[OPEN]'),
(42, '2023-08-13', 198.00, '[OPEN]'),
(42, '2023-08-14', 198.00, '[OPEN]'),
(42, '2023-08-15', 198.00, '[OPEN]'),
-- September
(42, '2023-09-01', 198.00, '[OPEN]'),
(42, '2023-09-02', 198.00, '[OPEN]'),
(42, '2023-09-03', 198.00, '[OPEN]'),
(42, '2023-09-04', 198.00, '[OPEN]'),
(42, '2023-09-05', 198.00, '[OPEN]'),

-- July
(43, '2023-07-01', 256.00, '[OPEN]'),
(43, '2023-07-02', 256.00, '[OPEN]'),
(43, '2023-07-03', 256.00, '[OPEN]'),
(43, '2023-07-04', 256.00, '[OPEN]'),
(43, '2023-07-05', 256.00, '[OPEN]'),
-- August
(43, '2023-08-10', 256.00, '[OPEN]'),
(43, '2023-08-11', 256.00, '[OPEN]'),
(43, '2023-08-12', 256.00, '[OPEN]'),
(43, '2023-08-13', 256.00, '[OPEN]'),
(43, '2023-08-14', 256.00, '[OPEN]'),
(43, '2023-08-15', 256.00, '[OPEN]'),
-- September
(43, '2023-09-01', 256.00, '[OPEN]'),
(43, '2023-09-02', 256.00, '[OPEN]'),
(43, '2023-09-03', 256.00, '[OPEN]'),
(43, '2023-09-04', 256.00, '[OPEN]'),
(43, '2023-09-05', 256.00, '[OPEN]'),

-- July
(44, '2023-07-01', 123.00, '[OPEN]'),
(44, '2023-07-02', 123.00, '[OPEN]'),
(44, '2023-07-03', 123.00, '[OPEN]'),
(44, '2023-07-04', 123.00, '[OPEN]'),
(44, '2023-07-05', 123.00, '[OPEN]'),
-- August
(44, '2023-08-10', 123.00, '[OPEN]'),
(44, '2023-08-11', 123.00, '[OPEN]'),
(44, '2023-08-12', 123.00, '[OPEN]'),
(44, '2023-08-13', 123.00, '[OPEN]'),
(44, '2023-08-14', 123.00, '[OPEN]'),
(44, '2023-08-15', 123.00, '[OPEN]'),
-- September
(44, '2023-09-01', 123.00, '[OPEN]'),
(44, '2023-09-02', 123.00, '[OPEN]'),
(44, '2023-09-03', 123.00, '[OPEN]'),
(44, '2023-09-04', 123.00, '[OPEN]'),
(44, '2023-09-05', 123.00, '[OPEN]'),

-- July
(45, '2023-07-01', 96.00, '[OPEN]'),
(45, '2023-07-02', 96.00, '[OPEN]'),
(45, '2023-07-03', 96.00, '[OPEN]'),
(45, '2023-07-04', 96.00, '[OPEN]'),
(45, '2023-07-05', 96.00, '[OPEN]'),
-- August
(45, '2023-08-10', 96.00, '[OPEN]'),
(45, '2023-08-11', 96.00, '[OPEN]'),
(45, '2023-08-12', 96.00, '[OPEN]'),
(45, '2023-08-13', 96.00, '[OPEN]'),
(45, '2023-08-14', 96.00, '[OPEN]'),
(45, '2023-08-15', 96.00, '[OPEN]'),
-- September
(45, '2023-09-01', 96.00, '[OPEN]'),
(45, '2023-09-02', 96.00, '[OPEN]'),
(45, '2023-09-03', 96.00, '[OPEN]'),
(45, '2023-09-04', 96.00, '[OPEN]'),
(45, '2023-09-05', 96.00, '[OPEN]'),

-- July
(46, '2023-07-01', 78.00, '[OPEN]'),
(46, '2023-07-02', 78.00, '[OPEN]'),
(46, '2023-07-03', 78.00, '[OPEN]'),
(46, '2023-07-04', 78.00, '[OPEN]'),
(46, '2023-07-05', 78.00, '[OPEN]'),
-- August
(46, '2023-08-10', 78.00, '[OPEN]'),
(46, '2023-08-11', 78.00, '[OPEN]'),
(46, '2023-08-12', 78.00, '[OPEN]'),
(46, '2023-08-13', 78.00, '[OPEN]'),
(46, '2023-08-14', 78.00, '[OPEN]'),
(46, '2023-08-15', 78.00, '[OPEN]'),
-- September
(46, '2023-09-01', 78.00, '[OPEN]'),
(46, '2023-09-02', 78.00, '[OPEN]'),
(46, '2023-09-03', 78.00, '[OPEN]'),
(46, '2023-09-04', 78.00, '[OPEN]'),
(46, '2023-09-05', 78.00, '[OPEN]'),

-- July
(47, '2023-07-01', 128.00, '[OPEN]'),
(47, '2023-07-02', 128.00, '[OPEN]'),
(47, '2023-07-03', 128.00, '[OPEN]'),
(47, '2023-07-04', 128.00, '[OPEN]'),
(47, '2023-07-05', 128.00, '[OPEN]'),
-- August
(47, '2023-08-10', 128.00, '[OPEN]'),
(47, '2023-08-11', 128.00, '[OPEN]'),
(47, '2023-08-12', 128.00, '[OPEN]'),
(47, '2023-08-13', 128.00, '[OPEN]'),
(47, '2023-08-14', 128.00, '[OPEN]'),
(47, '2023-08-15', 128.00, '[OPEN]'),
-- September
(47, '2023-09-01', 128.00, '[OPEN]'),
(47, '2023-09-02', 128.00, '[OPEN]'),
(47, '2023-09-03', 128.00, '[OPEN]'),
(47, '2023-09-04', 128.00, '[OPEN]'),
(47, '2023-09-05', 128.00, '[OPEN]'),

-- July
(48, '2023-07-01', 68.00, '[OPEN]'),
(48, '2023-07-02', 68.00, '[OPEN]'),
(48, '2023-07-03', 68.00, '[OPEN]'),
(48, '2023-07-04', 68.00, '[OPEN]'),
(48, '2023-07-05', 68.00, '[OPEN]'),
-- August
(48, '2023-08-10', 68.00, '[OPEN]'),
(48, '2023-08-11', 68.00, '[OPEN]'),
(48, '2023-08-12', 68.00, '[OPEN]'),
(48, '2023-08-13', 68.00, '[OPEN]'),
(48, '2023-08-14', 68.00, '[OPEN]'),
(48, '2023-08-15', 68.00, '[OPEN]'),
-- September
(48, '2023-09-01', 68.00, '[OPEN]'),
(48, '2023-09-02', 68.00, '[OPEN]'),
(48, '2023-09-03', 68.00, '[OPEN]'),
(48, '2023-09-04', 68.00, '[OPEN]'),
(48, '2023-09-05', 68.00, '[OPEN]'),

-- July
(49, '2023-07-01', 143.00, '[OPEN]'),
(49, '2023-07-02', 143.00, '[OPEN]'),
(49, '2023-07-03', 143.00, '[OPEN]'),
(49, '2023-07-04', 143.00, '[OPEN]'),
(49, '2023-07-05', 143.00, '[OPEN]'),
-- August
(49, '2023-08-10', 143.00, '[OPEN]'),
(49, '2023-08-11', 143.00, '[OPEN]'),
(49, '2023-08-12', 143.00, '[OPEN]'),
(49, '2023-08-13', 143.00, '[OPEN]'),
(49, '2023-08-14', 143.00, '[OPEN]'),
(49, '2023-08-15', 143.00, '[OPEN]'),
-- September
(49, '2023-09-01', 143.00, '[OPEN]'),
(49, '2023-09-02', 143.00, '[OPEN]'),
(49, '2023-09-03', 143.00, '[OPEN]'),
(49, '2023-09-04', 143.00, '[OPEN]'),
(49, '2023-09-05', 143.00, '[OPEN]'),

-- July
(50, '2023-07-01', 148.00, '[OPEN]'),
(50, '2023-07-02', 148.00, '[OPEN]'),
(50, '2023-07-03', 148.00, '[OPEN]'),
(50, '2023-07-04', 148.00, '[OPEN]'),
(50, '2023-07-05', 148.00, '[OPEN]'),
-- August
(50, '2023-08-10', 148.00, '[OPEN]'),
(50, '2023-08-11', 148.00, '[OPEN]'),
(50, '2023-08-12', 148.00, '[OPEN]'),
(50, '2023-08-13', 148.00, '[OPEN]'),
(50, '2023-08-14', 148.00, '[OPEN]'),
(50, '2023-08-15', 148.00, '[OPEN]'),
-- September
(50, '2023-09-01', 148.00, '[OPEN]'),
(50, '2023-09-02', 148.00, '[OPEN]'),
(50, '2023-09-03', 148.00, '[OPEN]'),
(50, '2023-09-04', 148.00, '[OPEN]'),
(50, '2023-09-05', 148.00, '[OPEN]'),

-- July
(51, '2023-07-01', 162.00, '[OPEN]'),
(51, '2023-07-02', 162.00, '[OPEN]'),
(51, '2023-07-03', 162.00, '[OPEN]'),
(51, '2023-07-04', 162.00, '[OPEN]'),
(51, '2023-07-05', 162.00, '[OPEN]'),
-- August
(51, '2023-08-10', 162.00, '[OPEN]'),
(51, '2023-08-11', 162.00, '[OPEN]'),
(51, '2023-08-12', 162.00, '[OPEN]'),
(51, '2023-08-13', 162.00, '[OPEN]'),
(51, '2023-08-14', 162.00, '[OPEN]'),
(51, '2023-08-15', 162.00, '[OPEN]'),
-- September
(51, '2023-09-01', 162.00, '[OPEN]'),
(51, '2023-09-02', 162.00, '[OPEN]'),
(51, '2023-09-03', 162.00, '[OPEN]'),
(51, '2023-09-04', 162.00, '[OPEN]'),
(51, '2023-09-05', 162.00, '[OPEN]'),

-- July
(52, '2023-07-01', 174.00, '[OPEN]'),
(52, '2023-07-02', 174.00, '[OPEN]'),
(52, '2023-07-03', 174.00, '[OPEN]'),
(52, '2023-07-04', 174.00, '[OPEN]'),
(52, '2023-07-05', 174.00, '[OPEN]'),
-- August
(52, '2023-08-10', 174.00, '[OPEN]'),
(52, '2023-08-11', 174.00, '[OPEN]'),
(52, '2023-08-12', 174.00, '[OPEN]'),
(52, '2023-08-13', 174.00, '[OPEN]'),
(52, '2023-08-14', 174.00, '[OPEN]'),
(52, '2023-08-15', 174.00, '[OPEN]'),
-- September
(52, '2023-09-01', 174.00, '[OPEN]'),
(52, '2023-09-02', 174.00, '[OPEN]'),
(52, '2023-09-03', 174.00, '[OPEN]'),
(52, '2023-09-04', 174.00, '[OPEN]'),
(52, '2023-09-05', 174.00, '[OPEN]'),

-- July
(53, '2023-07-01', 189.00, '[OPEN]'),
(53, '2023-07-02', 189.00, '[OPEN]'),
(53, '2023-07-03', 189.00, '[OPEN]'),
(53, '2023-07-04', 189.00, '[OPEN]'),
(53, '2023-07-05', 189.00, '[OPEN]'),
-- August
(53, '2023-08-10', 189.00, '[OPEN]'),
(53, '2023-08-11', 189.00, '[OPEN]'),
(53, '2023-08-12', 189.00, '[OPEN]'),
(53, '2023-08-13', 189.00, '[OPEN]'),
(53, '2023-08-14', 189.00, '[OPEN]'),
(53, '2023-08-15', 189.00, '[OPEN]'),
-- September
(53, '2023-09-01', 189.00, '[OPEN]'),
(53, '2023-09-02', 189.00, '[OPEN]'),
(53, '2023-09-03', 189.00, '[OPEN]'),
(53, '2023-09-04', 189.00, '[OPEN]'),
(53, '2023-09-05', 189.00, '[OPEN]'),

-- July
(54, '2023-07-01', 203.00, '[OPEN]'),
(54, '2023-07-02', 203.00, '[OPEN]'),
(54, '2023-07-03', 203.00, '[OPEN]'),
(54, '2023-07-04', 203.00, '[OPEN]'),
(54, '2023-07-05', 203.00, '[OPEN]'),
-- August
(54, '2023-08-10', 203.00, '[OPEN]'),
(54, '2023-08-11', 203.00, '[OPEN]'),
(54, '2023-08-12', 203.00, '[OPEN]'),
(54, '2023-08-13', 203.00, '[OPEN]'),
(54, '2023-08-14', 203.00, '[OPEN]'),
(54, '2023-08-15', 203.00, '[OPEN]'),
-- September
(54, '2023-09-01', 203.00, '[OPEN]'),
(54, '2023-09-02', 203.00, '[OPEN]'),
(54, '2023-09-03', 203.00, '[OPEN]'),
(54, '2023-09-04', 203.00, '[OPEN]'),
(54, '2023-09-05', 203.00, '[OPEN]'),

-- July
(55, '2023-07-01', 198.00, '[OPEN]'),
(55, '2023-07-02', 198.00, '[OPEN]'),
(55, '2023-07-03', 198.00, '[OPEN]'),
(55, '2023-07-04', 198.00, '[OPEN]'),
(55, '2023-07-05', 198.00, '[OPEN]'),
-- August
(55, '2023-08-10', 198.00, '[OPEN]'),
(55, '2023-08-11', 198.00, '[OPEN]'),
(55, '2023-08-12', 198.00, '[OPEN]'),
(55, '2023-08-13', 198.00, '[OPEN]'),
(55, '2023-08-14', 198.00, '[OPEN]'),
(55, '2023-08-15', 198.00, '[OPEN]'),
-- September
(55, '2023-09-01', 198.00, '[OPEN]'),
(55, '2023-09-02', 198.00, '[OPEN]'),
(55, '2023-09-03', 198.00, '[OPEN]'),
(55, '2023-09-04', 198.00, '[OPEN]'),
(55, '2023-09-05', 198.00, '[OPEN]'),

-- July
(56, '2023-07-01', 146.00, '[OPEN]'),
(56, '2023-07-02', 146.00, '[OPEN]'),
(56, '2023-07-03', 146.00, '[OPEN]'),
(56, '2023-07-04', 146.00, '[OPEN]'),
(56, '2023-07-05', 146.00, '[OPEN]'),
-- August
(56, '2023-08-10', 146.00, '[OPEN]'),
(56, '2023-08-11', 146.00, '[OPEN]'),
(56, '2023-08-12', 146.00, '[OPEN]'),
(56, '2023-08-13', 146.00, '[OPEN]'),
(56, '2023-08-14', 146.00, '[OPEN]'),
(56, '2023-08-15', 146.00, '[OPEN]'),
-- September
(56, '2023-09-01', 146.00, '[OPEN]'),
(56, '2023-09-02', 146.00, '[OPEN]'),
(56, '2023-09-03', 146.00, '[OPEN]'),
(56, '2023-09-04', 146.00, '[OPEN]'),
(56, '2023-09-05', 146.00, '[OPEN]'),

-- July
(57, '2023-07-01', 74.00, '[OPEN]'),
(57, '2023-07-02', 74.00, '[OPEN]'),
(57, '2023-07-03', 74.00, '[OPEN]'),
(57, '2023-07-04', 74.00, '[OPEN]'),
(57, '2023-07-05', 74.00, '[OPEN]'),
-- August
(57, '2023-08-10', 74.00, '[OPEN]'),
(57, '2023-08-11', 74.00, '[OPEN]'),
(57, '2023-08-12', 74.00, '[OPEN]'),
(57, '2023-08-13', 74.00, '[OPEN]'),
(57, '2023-08-14', 74.00, '[OPEN]'),
(57, '2023-08-15', 74.00, '[OPEN]'),
-- September
(57, '2023-09-01', 74.00, '[OPEN]'),
(57, '2023-09-02', 74.00, '[OPEN]'),
(57, '2023-09-03', 74.00, '[OPEN]'),
(57, '2023-09-04', 74.00, '[OPEN]'),
(57, '2023-09-05', 74.00, '[OPEN]'),

-- July
(58, '2023-07-01', 192.00, '[OPEN]'),
(58, '2023-07-02', 192.00, '[OPEN]'),
(58, '2023-07-03', 192.00, '[OPEN]'),
(58, '2023-07-04', 192.00, '[OPEN]'),
(58, '2023-07-05', 192.00, '[OPEN]'),
-- August
(58, '2023-08-10', 192.00, '[OPEN]'),
(58, '2023-08-11', 192.00, '[OPEN]'),
(58, '2023-08-12', 192.00, '[OPEN]'),
(58, '2023-08-13', 192.00, '[OPEN]'),
(58, '2023-08-14', 192.00, '[OPEN]'),
(58, '2023-08-15', 192.00, '[OPEN]'),
-- September
(58, '2023-09-01', 192.00, '[OPEN]'),
(58, '2023-09-02', 192.00, '[OPEN]'),
(58, '2023-09-03', 192.00, '[OPEN]'),
(58, '2023-09-04', 192.00, '[OPEN]'),
(58, '2023-09-05', 192.00, '[OPEN]'),

-- July
(59, '2023-07-01', 125.00, '[OPEN]'),
(59, '2023-07-02', 125.00, '[OPEN]'),
(59, '2023-07-03', 125.00, '[OPEN]'),
(59, '2023-07-04', 125.00, '[OPEN]'),
(59, '2023-07-05', 125.00, '[OPEN]'),
-- August
(59, '2023-08-10', 125.00, '[OPEN]'),
(59, '2023-08-11', 125.00, '[OPEN]'),
(59, '2023-08-12', 125.00, '[OPEN]'),
(59, '2023-08-13', 125.00, '[OPEN]'),
(59, '2023-08-14', 125.00, '[OPEN]'),
(59, '2023-08-15', 125.00, '[OPEN]'),
-- September
(59, '2023-09-01', 125.00, '[OPEN]'),
(59, '2023-09-02', 125.00, '[OPEN]'),
(59, '2023-09-03', 125.00, '[OPEN]'),
(59, '2023-09-04', 125.00, '[OPEN]'),
(59, '2023-09-05', 125.00, '[OPEN]'),

-- July
(60, '2023-07-01', 108.00, '[OPEN]'),
(60, '2023-07-02', 108.00, '[OPEN]'),
(60, '2023-07-03', 108.00, '[OPEN]'),
(60, '2023-07-04', 108.00, '[OPEN]'),
(60, '2023-07-05', 108.00, '[OPEN]'),
-- August
(60, '2023-08-10', 108.00, '[OPEN]'),
(60, '2023-08-11', 108.00, '[OPEN]'),
(60, '2023-08-12', 108.00, '[OPEN]'),
(60, '2023-08-13', 108.00, '[OPEN]'),
(60, '2023-08-14', 108.00, '[OPEN]'),
(60, '2023-08-15', 108.00, '[OPEN]'),
-- September
(60, '2023-09-01', 108.00, '[OPEN]'),
(60, '2023-09-02', 108.00, '[OPEN]'),
(60, '2023-09-03', 108.00, '[OPEN]'),
(60, '2023-09-04', 108.00, '[OPEN]'),
(60, '2023-09-05', 108.00, '[OPEN]'),

-- July
(61, '2023-07-01', 255.00, '[OPEN]'),
(61, '2023-07-02', 255.00, '[OPEN]'),
(61, '2023-07-03', 255.00, '[OPEN]'),
(61, '2023-07-04', 255.00, '[OPEN]'),
(61, '2023-07-05', 255.00, '[OPEN]'),
-- August
(61, '2023-08-10', 255.00, '[OPEN]'),
(61, '2023-08-11', 255.00, '[OPEN]'),
(61, '2023-08-12', 255.00, '[OPEN]'),
(61, '2023-08-13', 255.00, '[OPEN]'),
(61, '2023-08-14', 255.00, '[OPEN]'),
(61, '2023-08-15', 255.00, '[OPEN]'),
-- September
(61, '2023-09-01', 255.00, '[OPEN]'),
(61, '2023-09-02', 255.00, '[OPEN]'),
(61, '2023-09-03', 255.00, '[OPEN]'),
(61, '2023-09-04', 255.00, '[OPEN]'),
(61, '2023-09-05', 255.00, '[OPEN]'),

-- July
(62, '2023-07-01', 275.00, '[OPEN]'),
(62, '2023-07-02', 275.00, '[OPEN]'),
(62, '2023-07-03', 275.00, '[OPEN]'),
(62, '2023-07-04', 275.00, '[OPEN]'),
(62, '2023-07-05', 275.00, '[OPEN]'),
-- August
(62, '2023-08-10', 275.00, '[OPEN]'),
(62, '2023-08-11', 275.00, '[OPEN]'),
(62, '2023-08-12', 275.00, '[OPEN]'),
(62, '2023-08-13', 275.00, '[OPEN]'),
(62, '2023-08-14', 275.00, '[OPEN]'),
(62, '2023-08-15', 275.00, '[OPEN]'),
-- September
(62, '2023-09-01', 275.00, '[OPEN]'),
(62, '2023-09-02', 275.00, '[OPEN]'),
(62, '2023-09-03', 275.00, '[OPEN]'),
(62, '2023-09-04', 275.00, '[OPEN]'),
(62, '2023-09-05', 275.00, '[OPEN]'),

-- July
(63, '2023-07-01', 284.00, '[OPEN]'),
(63, '2023-07-02', 284.00, '[OPEN]'),
(63, '2023-07-03', 284.00, '[OPEN]'),
(63, '2023-07-04', 284.00, '[OPEN]'),
(63, '2023-07-05', 284.00, '[OPEN]'),
-- August
(63, '2023-08-10', 284.00, '[OPEN]'),
(63, '2023-08-11', 284.00, '[OPEN]'),
(63, '2023-08-12', 284.00, '[OPEN]'),
(63, '2023-08-13', 284.00, '[OPEN]'),
(63, '2023-08-14', 284.00, '[OPEN]'),
(63, '2023-08-15', 284.00, '[OPEN]'),
-- September
(63, '2023-09-01', 284.00, '[OPEN]'),
(63, '2023-09-02', 284.00, '[OPEN]'),
(63, '2023-09-03', 284.00, '[OPEN]'),
(63, '2023-09-04', 284.00, '[OPEN]'),
(63, '2023-09-05', 284.00, '[OPEN]'),

-- July
(64, '2023-07-01', 289.00, '[OPEN]'),
(64, '2023-07-02', 289.00, '[OPEN]'),
(64, '2023-07-03', 289.00, '[OPEN]'),
(64, '2023-07-04', 289.00, '[OPEN]'),
(64, '2023-07-05', 289.00, '[OPEN]'),
-- August
(64, '2023-08-10', 289.00, '[OPEN]'),
(64, '2023-08-11', 289.00, '[OPEN]'),
(64, '2023-08-12', 289.00, '[OPEN]'),
(64, '2023-08-13', 289.00, '[OPEN]'),
(64, '2023-08-14', 289.00, '[OPEN]'),
(64, '2023-08-15', 289.00, '[OPEN]'),
-- September
(64, '2023-09-01', 289.00, '[OPEN]'),
(64, '2023-09-02', 289.00, '[OPEN]'),
(64, '2023-09-03', 289.00, '[OPEN]'),
(64, '2023-09-04', 289.00, '[OPEN]'),
(64, '2023-09-05', 289.00, '[OPEN]'),

-- July
(65, '2023-07-01', 167.00, '[OPEN]'),
(65, '2023-07-02', 167.00, '[OPEN]'),
(65, '2023-07-03', 167.00, '[OPEN]'),
(65, '2023-07-04', 167.00, '[OPEN]'),
(65, '2023-07-05', 167.00, '[OPEN]'),
-- August
(65, '2023-08-10', 167.00, '[OPEN]'),
(65, '2023-08-11', 167.00, '[OPEN]'),
(65, '2023-08-12', 167.00, '[OPEN]'),
(65, '2023-08-13', 167.00, '[OPEN]'),
(65, '2023-08-14', 167.00, '[OPEN]'),
(65, '2023-08-15', 167.00, '[OPEN]'),
-- September
(65, '2023-09-01', 167.00, '[OPEN]'),
(65, '2023-09-02', 167.00, '[OPEN]'),
(65, '2023-09-03', 167.00, '[OPEN]'),
(65, '2023-09-04', 167.00, '[OPEN]'),
(65, '2023-09-05', 167.00, '[OPEN]'),

-- July
(66, '2023-07-01', 146.00, '[OPEN]'),
(66, '2023-07-02', 146.00, '[OPEN]'),
(66, '2023-07-03', 146.00, '[OPEN]'),
(66, '2023-07-04', 146.00, '[OPEN]'),
(66, '2023-07-05', 146.00, '[OPEN]'),
-- August
(66, '2023-08-10', 146.00, '[OPEN]'),
(66, '2023-08-11', 146.00, '[OPEN]'),
(66, '2023-08-12', 146.00, '[OPEN]'),
(66, '2023-08-13', 146.00, '[OPEN]'),
(66, '2023-08-14', 146.00, '[OPEN]'),
(66, '2023-08-15', 146.00, '[OPEN]'),
-- September
(66, '2023-09-01', 146.00, '[OPEN]'),
(66, '2023-09-02', 146.00, '[OPEN]'),
(66, '2023-09-03', 146.00, '[OPEN]'),
(66, '2023-09-04', 146.00, '[OPEN]'),
(66, '2023-09-05', 146.00, '[OPEN]'),

-- July
(67, '2023-07-01', 172.00, '[OPEN]'),
(67, '2023-07-02', 172.00, '[OPEN]'),
(67, '2023-07-03', 172.00, '[OPEN]'),
(67, '2023-07-04', 172.00, '[OPEN]'),
(67, '2023-07-05', 172.00, '[OPEN]'),
-- August
(67, '2023-08-10', 172.00, '[OPEN]'),
(67, '2023-08-11', 172.00, '[OPEN]'),
(67, '2023-08-12', 172.00, '[OPEN]'),
(67, '2023-08-13', 172.00, '[OPEN]'),
(67, '2023-08-14', 172.00, '[OPEN]'),
(67, '2023-08-15', 172.00, '[OPEN]'),
-- September
(67, '2023-09-01', 172.00, '[OPEN]'),
(67, '2023-09-02', 172.00, '[OPEN]'),
(67, '2023-09-03', 172.00, '[OPEN]'),
(67, '2023-09-04', 172.00, '[OPEN]'),
(67, '2023-09-05', 172.00, '[OPEN]'),

-- July
(68, '2023-07-01', 190.00, '[OPEN]'),
(68, '2023-07-02', 190.00, '[OPEN]'),
(68, '2023-07-03', 190.00, '[OPEN]'),
(68, '2023-07-04', 190.00, '[OPEN]'),
(68, '2023-07-05', 190.00, '[OPEN]'),
-- August
(68, '2023-08-10', 190.00, '[OPEN]'),
(68, '2023-08-11', 190.00, '[OPEN]'),
(68, '2023-08-12', 190.00, '[OPEN]'),
(68, '2023-08-13', 190.00, '[OPEN]'),
(68, '2023-08-14', 190.00, '[OPEN]'),
(68, '2023-08-15', 190.00, '[OPEN]'),
-- September
(68, '2023-09-01', 190.00, '[OPEN]'),
(68, '2023-09-02', 190.00, '[OPEN]'),
(68, '2023-09-03', 190.00, '[OPEN]'),
(68, '2023-09-04', 190.00, '[OPEN]'),
(68, '2023-09-05', 190.00, '[OPEN]'),

-- July
(69, '2023-07-01', 222.00, '[OPEN]'),
(69, '2023-07-02', 222.00, '[OPEN]'),
(69, '2023-07-03', 222.00, '[OPEN]'),
(69, '2023-07-04', 222.00, '[OPEN]'),
(69, '2023-07-05', 222.00, '[OPEN]'),
-- August
(69, '2023-08-10', 222.00, '[OPEN]'),
(69, '2023-08-11', 222.00, '[OPEN]'),
(69, '2023-08-12', 222.00, '[OPEN]'),
(69, '2023-08-13', 222.00, '[OPEN]'),
(69, '2023-08-14', 222.00, '[OPEN]'),
(69, '2023-08-15', 222.00, '[OPEN]'),
-- September
(69, '2023-09-01', 222.00, '[OPEN]'),
(69, '2023-09-02', 222.00, '[OPEN]'),
(69, '2023-09-03', 222.00, '[OPEN]'),
(69, '2023-09-04', 222.00, '[OPEN]'),
(69, '2023-09-05', 222.00, '[OPEN]'),

-- July
(70, '2023-07-01', 201.00, '[OPEN]'),
(70, '2023-07-02', 201.00, '[OPEN]'),
(70, '2023-07-03', 201.00, '[OPEN]'),
(70, '2023-07-04', 201.00, '[OPEN]'),
(70, '2023-07-05', 201.00, '[OPEN]'),
-- August
(70, '2023-08-10', 201.00, '[OPEN]'),
(70, '2023-08-11', 201.00, '[OPEN]'),
(70, '2023-08-12', 201.00, '[OPEN]'),
(70, '2023-08-13', 201.00, '[OPEN]'),
(70, '2023-08-14', 201.00, '[OPEN]'),
(70, '2023-08-15', 201.00, '[OPEN]'),
-- September
(70, '2023-09-01', 201.00, '[OPEN]'),
(70, '2023-09-02', 201.00, '[OPEN]'),
(70, '2023-09-03', 201.00, '[OPEN]'),
(70, '2023-09-04', 201.00, '[OPEN]'),
(70, '2023-09-05', 201.00, '[OPEN]'),

-- July
(71, '2023-07-01', 213.00, '[OPEN]'),
(71, '2023-07-02', 213.00, '[OPEN]'),
(71, '2023-07-03', 213.00, '[OPEN]'),
(71, '2023-07-04', 213.00, '[OPEN]'),
(71, '2023-07-05', 213.00, '[OPEN]'),
-- August
(71, '2023-08-10', 213.00, '[OPEN]'),
(71, '2023-08-11', 213.00, '[OPEN]'),
(71, '2023-08-12', 213.00, '[OPEN]'),
(71, '2023-08-13', 213.00, '[OPEN]'),
(71, '2023-08-14', 213.00, '[OPEN]'),
(71, '2023-08-15', 213.00, '[OPEN]'),
-- September
(71, '2023-09-01', 213.00, '[OPEN]'),
(71, '2023-09-02', 213.00, '[OPEN]'),
(71, '2023-09-03', 213.00, '[OPEN]'),
(71, '2023-09-04', 213.00, '[OPEN]'),
(71, '2023-09-05', 213.00, '[OPEN]'),

-- July
(72, '2023-07-01', 125.00, '[OPEN]'),
(72, '2023-07-02', 125.00, '[OPEN]'),
(72, '2023-07-03', 125.00, '[OPEN]'),
(72, '2023-07-04', 125.00, '[OPEN]'),
(72, '2023-07-05', 125.00, '[OPEN]'),
-- August
(72, '2023-08-10', 125.00, '[OPEN]'),
(72, '2023-08-11', 125.00, '[OPEN]'),
(72, '2023-08-12', 125.00, '[OPEN]'),
(72, '2023-08-13', 125.00, '[OPEN]'),
(72, '2023-08-14', 125.00, '[OPEN]'),
(72, '2023-08-15', 125.00, '[OPEN]'),
-- September
(72, '2023-09-01', 125.00, '[OPEN]'),
(72, '2023-09-02', 125.00, '[OPEN]'),
(72, '2023-09-03', 125.00, '[OPEN]'),
(72, '2023-09-04', 125.00, '[OPEN]'),
(72, '2023-09-05', 125.00, '[OPEN]'),

-- July
(73, '2023-07-01', 289.00, '[OPEN]'),
(73, '2023-07-02', 289.00, '[OPEN]'),
(73, '2023-07-03', 289.00, '[OPEN]'),
(73, '2023-07-04', 289.00, '[OPEN]'),
(73, '2023-07-05', 289.00, '[OPEN]'),
-- August
(73, '2023-08-10', 289.00, '[OPEN]'),
(73, '2023-08-11', 289.00, '[OPEN]'),
(73, '2023-08-12', 289.00, '[OPEN]'),
(73, '2023-08-13', 289.00, '[OPEN]'),
(73, '2023-08-14', 289.00, '[OPEN]'),
(73, '2023-08-15', 289.00, '[OPEN]'),
-- September
(73, '2023-09-01', 289.00, '[OPEN]'),
(73, '2023-09-02', 289.00, '[OPEN]'),
(73, '2023-09-03', 289.00, '[OPEN]'),
(73, '2023-09-04', 289.00, '[OPEN]'),
(73, '2023-09-05', 289.00, '[OPEN]'),

-- July
(74, '2023-07-01', 295.00, '[OPEN]'),
(74, '2023-07-02', 295.00, '[OPEN]'),
(74, '2023-07-03', 295.00, '[OPEN]'),
(74, '2023-07-04', 295.00, '[OPEN]'),
(74, '2023-07-05', 295.00, '[OPEN]'),
-- August
(74, '2023-08-10', 295.00, '[OPEN]'),
(74, '2023-08-11', 295.00, '[OPEN]'),
(74, '2023-08-12', 295.00, '[OPEN]'),
(74, '2023-08-13', 295.00, '[OPEN]'),
(74, '2023-08-14', 295.00, '[OPEN]'),
(74, '2023-08-15', 295.00, '[OPEN]'),
-- September
(74, '2023-09-01', 295.00, '[OPEN]'),
(74, '2023-09-02', 295.00, '[OPEN]'),
(74, '2023-09-03', 295.00, '[OPEN]'),
(74, '2023-09-04', 295.00, '[OPEN]'),
(74, '2023-09-05', 295.00, '[OPEN]'),

-- July
(75, '2023-07-01', 276.00, '[OPEN]'),
(75, '2023-07-02', 276.00, '[OPEN]'),
(75, '2023-07-03', 276.00, '[OPEN]'),
(75, '2023-07-04', 276.00, '[OPEN]'),
(75, '2023-07-05', 276.00, '[OPEN]'),
-- August
(75, '2023-08-10', 276.00, '[OPEN]'),
(75, '2023-08-11', 276.00, '[OPEN]'),
(75, '2023-08-12', 276.00, '[OPEN]'),
(75, '2023-08-13', 276.00, '[OPEN]'),
(75, '2023-08-14', 276.00, '[OPEN]'),
(75, '2023-08-15', 276.00, '[OPEN]'),
-- September
(75, '2023-09-01', 276.00, '[OPEN]'),
(75, '2023-09-02', 276.00, '[OPEN]'),
(75, '2023-09-03', 276.00, '[OPEN]'),
(75, '2023-09-04', 276.00, '[OPEN]'),
(75, '2023-09-05', 276.00, '[OPEN]'),

-- July
(76, '2023-07-01', 211.00, '[OPEN]'),
(76, '2023-07-02', 211.00, '[OPEN]'),
(76, '2023-07-03', 211.00, '[OPEN]'),
(76, '2023-07-04', 211.00, '[OPEN]'),
(76, '2023-07-05', 211.00, '[OPEN]'),
-- August
(76, '2023-08-10', 211.00, '[OPEN]'),
(76, '2023-08-11', 211.00, '[OPEN]'),
(76, '2023-08-12', 211.00, '[OPEN]'),
(76, '2023-08-13', 211.00, '[OPEN]'),
(76, '2023-08-14', 211.00, '[OPEN]'),
(76, '2023-08-15', 211.00, '[OPEN]'),
-- September
(76, '2023-09-01', 211.00, '[OPEN]'),
(76, '2023-09-02', 211.00, '[OPEN]'),
(76, '2023-09-03', 211.00, '[OPEN]'),
(76, '2023-09-04', 211.00, '[OPEN]'),
(76, '2023-09-05', 211.00, '[OPEN]'),

-- July
(77, '2023-07-01', 198.00, '[OPEN]'),
(77, '2023-07-02', 198.00, '[OPEN]'),
(77, '2023-07-03', 198.00, '[OPEN]'),
(77, '2023-07-04', 198.00, '[OPEN]'),
(77, '2023-07-05', 198.00, '[OPEN]'),
-- August
(77, '2023-08-10', 198.00, '[OPEN]'),
(77, '2023-08-11', 198.00, '[OPEN]'),
(77, '2023-08-12', 198.00, '[OPEN]'),
(77, '2023-08-13', 198.00, '[OPEN]'),
(77, '2023-08-14', 198.00, '[OPEN]'),
(77, '2023-08-15', 198.00, '[OPEN]'),
-- September
(77, '2023-09-01', 198.00, '[OPEN]'),
(77, '2023-09-02', 198.00, '[OPEN]'),
(77, '2023-09-03', 198.00, '[OPEN]'),
(77, '2023-09-04', 198.00, '[OPEN]'),
(77, '2023-09-05', 198.00, '[OPEN]'),

-- July
(78, '2023-07-01', 287.00, '[OPEN]'),
(78, '2023-07-02', 287.00, '[OPEN]'),
(78, '2023-07-03', 287.00, '[OPEN]'),
(78, '2023-07-04', 287.00, '[OPEN]'),
(78, '2023-07-05', 287.00, '[OPEN]'),
-- August
(78, '2023-08-10', 287.00, '[OPEN]'),
(78, '2023-08-11', 287.00, '[OPEN]'),
(78, '2023-08-12', 287.00, '[OPEN]'),
(78, '2023-08-13', 287.00, '[OPEN]'),
(78, '2023-08-14', 287.00, '[OPEN]'),
(78, '2023-08-15', 287.00, '[OPEN]'),
-- September
(78, '2023-09-01', 287.00, '[OPEN]'),
(78, '2023-09-02', 287.00, '[OPEN]'),
(78, '2023-09-03', 287.00, '[OPEN]'),
(78, '2023-09-04', 287.00, '[OPEN]'),
(78, '2023-09-05', 287.00, '[OPEN]'),

-- July
(79, '2023-07-01', 213.00, '[OPEN]'),
(79, '2023-07-02', 213.00, '[OPEN]'),
(79, '2023-07-03', 213.00, '[OPEN]'),
(79, '2023-07-04', 213.00, '[OPEN]'),
(79, '2023-07-05', 213.00, '[OPEN]'),
-- August
(79, '2023-08-10', 213.00, '[OPEN]'),
(79, '2023-08-11', 213.00, '[OPEN]'),
(79, '2023-08-12', 213.00, '[OPEN]'),
(79, '2023-08-13', 213.00, '[OPEN]'),
(79, '2023-08-14', 213.00, '[OPEN]'),
(79, '2023-08-15', 213.00, '[OPEN]'),
-- September
(79, '2023-09-01', 213.00, '[OPEN]'),
(79, '2023-09-02', 213.00, '[OPEN]'),
(79, '2023-09-03', 213.00, '[OPEN]'),
(79, '2023-09-04', 213.00, '[OPEN]'),
(79, '2023-09-05', 213.00, '[OPEN]'),

-- July
(80, '2023-07-01', 258.00, '[OPEN]'),
(80, '2023-07-02', 258.00, '[OPEN]'),
(80, '2023-07-03', 258.00, '[OPEN]'),
(80, '2023-07-04', 258.00, '[OPEN]'),
(80, '2023-07-05', 258.00, '[OPEN]'),
-- August
(80, '2023-08-10', 258.00, '[OPEN]'),
(80, '2023-08-11', 258.00, '[OPEN]'),
(80, '2023-08-12', 258.00, '[OPEN]'),
(80, '2023-08-13', 258.00, '[OPEN]'),
(80, '2023-08-14', 258.00, '[OPEN]'),
(80, '2023-08-15', 258.00, '[OPEN]'),
-- September
(80, '2023-09-01', 258.00, '[OPEN]'),
(80, '2023-09-02', 258.00, '[OPEN]'),
(80, '2023-09-03', 258.00, '[OPEN]'),
(80, '2023-09-04', 258.00, '[OPEN]'),
(80, '2023-09-05', 258.00, '[OPEN]'),

-- July
(81, '2023-07-01', 358.00, '[OPEN]'),
(81, '2023-07-02', 358.00, '[OPEN]'),
(81, '2023-07-03', 358.00, '[OPEN]'),
(81, '2023-07-04', 358.00, '[OPEN]'),
(81, '2023-07-05', 358.00, '[OPEN]'),
-- August
(81, '2023-08-10', 358.00, '[OPEN]'),
(81, '2023-08-11', 358.00, '[OPEN]'),
(81, '2023-08-12', 358.00, '[OPEN]'),
(81, '2023-08-13', 358.00, '[OPEN]'),
(81, '2023-08-14', 358.00, '[OPEN]'),
(81, '2023-08-15', 358.00, '[OPEN]'),
-- September
(81, '2023-09-01', 358.00, '[OPEN]'),
(81, '2023-09-02', 358.00, '[OPEN]'),
(81, '2023-09-03', 358.00, '[OPEN]'),
(81, '2023-09-04', 358.00, '[OPEN]'),
(81, '2023-09-05', 358.00, '[OPEN]'),

-- July
(82, '2023-07-01', 398.00, '[OPEN]'),
(82, '2023-07-02', 398.00, '[OPEN]'),
(82, '2023-07-03', 398.00, '[OPEN]'),
(82, '2023-07-04', 398.00, '[OPEN]'),
(82, '2023-07-05', 398.00, '[OPEN]'),
-- August
(82, '2023-08-10', 398.00, '[OPEN]'),
(82, '2023-08-11', 398.00, '[OPEN]'),
(82, '2023-08-12', 398.00, '[OPEN]'),
(82, '2023-08-13', 398.00, '[OPEN]'),
(82, '2023-08-14', 398.00, '[OPEN]'),
(82, '2023-08-15', 398.00, '[OPEN]'),
-- September
(82, '2023-09-01', 398.00, '[OPEN]'),
(82, '2023-09-02', 398.00, '[OPEN]'),
(82, '2023-09-03', 398.00, '[OPEN]'),
(82, '2023-09-04', 398.00, '[OPEN]'),
(82, '2023-09-05', 398.00, '[OPEN]'),

-- July
(83, '2023-07-01', 402.00, '[OPEN]'),
(83, '2023-07-02', 402.00, '[OPEN]'),
(83, '2023-07-03', 402.00, '[OPEN]'),
(83, '2023-07-04', 402.00, '[OPEN]'),
(83, '2023-07-05', 402.00, '[OPEN]'),
-- August
(83, '2023-08-10', 402.00, '[OPEN]'),
(83, '2023-08-11', 402.00, '[OPEN]'),
(83, '2023-08-12', 402.00, '[OPEN]'),
(83, '2023-08-13', 402.00, '[OPEN]'),
(83, '2023-08-14', 402.00, '[OPEN]'),
(83, '2023-08-15', 402.00, '[OPEN]'),
-- September
(83, '2023-09-01', 402.00, '[OPEN]'),
(83, '2023-09-02', 402.00, '[OPEN]'),
(83, '2023-09-03', 402.00, '[OPEN]'),
(83, '2023-09-04', 402.00, '[OPEN]'),
(83, '2023-09-05', 402.00, '[OPEN]'),

-- July
(84, '2023-07-01', 387.00, '[OPEN]'),
(84, '2023-07-02', 387.00, '[OPEN]'),
(84, '2023-07-03', 387.00, '[OPEN]'),
(84, '2023-07-04', 387.00, '[OPEN]'),
(84, '2023-07-05', 387.00, '[OPEN]'),
-- August
(84, '2023-08-10', 387.00, '[OPEN]'),
(84, '2023-08-11', 387.00, '[OPEN]'),
(84, '2023-08-12', 387.00, '[OPEN]'),
(84, '2023-08-13', 387.00, '[OPEN]'),
(84, '2023-08-14', 387.00, '[OPEN]'),
(84, '2023-08-15', 387.00, '[OPEN]'),
-- September
(84, '2023-09-01', 387.00, '[OPEN]'),
(84, '2023-09-02', 387.00, '[OPEN]'),
(84, '2023-09-03', 387.00, '[OPEN]'),
(84, '2023-09-04', 387.00, '[OPEN]'),
(84, '2023-09-05', 387.00, '[OPEN]'),

-- July
(85, '2023-07-01', 289.00, '[OPEN]'),
(85, '2023-07-02', 289.00, '[OPEN]'),
(85, '2023-07-03', 289.00, '[OPEN]'),
(85, '2023-07-04', 289.00, '[OPEN]'),
(85, '2023-07-05', 289.00, '[OPEN]'),
-- August
(85, '2023-08-10', 289.00, '[OPEN]'),
(85, '2023-08-11', 289.00, '[OPEN]'),
(85, '2023-08-12', 289.00, '[OPEN]'),
(85, '2023-08-13', 289.00, '[OPEN]'),
(85, '2023-08-14', 289.00, '[OPEN]'),
(85, '2023-08-15', 289.00, '[OPEN]'),
-- September
(85, '2023-09-01', 289.00, '[OPEN]'),
(85, '2023-09-02', 289.00, '[OPEN]'),
(85, '2023-09-03', 289.00, '[OPEN]'),
(85, '2023-09-04', 289.00, '[OPEN]'),
(85, '2023-09-05', 289.00, '[OPEN]'),

-- July
(86, '2023-07-01', 250.00, '[OPEN]'),
(86, '2023-07-02', 250.00, '[OPEN]'),
(86, '2023-07-03', 250.00, '[OPEN]'),
(86, '2023-07-04', 250.00, '[OPEN]'),
(86, '2023-07-05', 250.00, '[OPEN]'),
-- August
(86, '2023-08-10', 250.00, '[OPEN]'),
(86, '2023-08-11', 250.00, '[OPEN]'),
(86, '2023-08-12', 250.00, '[OPEN]'),
(86, '2023-08-13', 250.00, '[OPEN]'),
(86, '2023-08-14', 250.00, '[OPEN]'),
(86, '2023-08-15', 250.00, '[OPEN]'),
-- September
(86, '2023-09-01', 250.00, '[OPEN]'),
(86, '2023-09-02', 250.00, '[OPEN]'),
(86, '2023-09-03', 250.00, '[OPEN]'),
(86, '2023-09-04', 250.00, '[OPEN]'),
(86, '2023-09-05', 250.00, '[OPEN]'),

-- July
(87, '2023-07-01', 210.00, '[OPEN]'),
(87, '2023-07-02', 210.00, '[OPEN]'),
(87, '2023-07-03', 210.00, '[OPEN]'),
(87, '2023-07-04', 210.00, '[OPEN]'),
(87, '2023-07-05', 210.00, '[OPEN]'),
-- August
(87, '2023-08-10', 210.00, '[OPEN]'),
(87, '2023-08-11', 210.00, '[OPEN]'),
(87, '2023-08-12', 210.00, '[OPEN]'),
(87, '2023-08-13', 210.00, '[OPEN]'),
(87, '2023-08-14', 210.00, '[OPEN]'),
(87, '2023-08-15', 210.00, '[OPEN]'),
-- September
(87, '2023-09-01', 210.00, '[OPEN]'),
(87, '2023-09-02', 210.00, '[OPEN]'),
(87, '2023-09-03', 210.00, '[OPEN]'),
(87, '2023-09-04', 210.00, '[OPEN]'),
(87, '2023-09-05', 210.00, '[OPEN]'),

-- July
(88, '2023-07-01', 195.00, '[OPEN]'),
(88, '2023-07-02', 195.00, '[OPEN]'),
(88, '2023-07-03', 195.00, '[OPEN]'),
(88, '2023-07-04', 195.00, '[OPEN]'),
(88, '2023-07-05', 195.00, '[OPEN]'),
-- August
(88, '2023-08-10', 195.00, '[OPEN]'),
(88, '2023-08-11', 195.00, '[OPEN]'),
(88, '2023-08-12', 195.00, '[OPEN]'),
(88, '2023-08-13', 195.00, '[OPEN]'),
(88, '2023-08-14', 195.00, '[OPEN]'),
(88, '2023-08-15', 195.00, '[OPEN]'),
-- September
(88, '2023-09-01', 195.00, '[OPEN]'),
(88, '2023-09-02', 195.00, '[OPEN]'),
(88, '2023-09-03', 195.00, '[OPEN]'),
(88, '2023-09-04', 195.00, '[OPEN]'),
(88, '2023-09-05', 195.00, '[OPEN]'),

-- July
(89, '2023-07-01', 158.00, '[OPEN]'),
(89, '2023-07-02', 158.00, '[OPEN]'),
(89, '2023-07-03', 158.00, '[OPEN]'),
(89, '2023-07-04', 158.00, '[OPEN]'),
(89, '2023-07-05', 158.00, '[OPEN]'),
-- August
(89, '2023-08-10', 158.00, '[OPEN]'),
(89, '2023-08-11', 158.00, '[OPEN]'),
(89, '2023-08-12', 158.00, '[OPEN]'),
(89, '2023-08-13', 158.00, '[OPEN]'),
(89, '2023-08-14', 158.00, '[OPEN]'),
(89, '2023-08-15', 158.00, '[OPEN]'),
-- September
(89, '2023-09-01', 158.00, '[OPEN]'),
(89, '2023-09-02', 158.00, '[OPEN]'),
(89, '2023-09-03', 158.00, '[OPEN]'),
(89, '2023-09-04', 158.00, '[OPEN]'),
(89, '2023-09-05', 158.00, '[OPEN]'),

-- July
(90, '2023-07-01', 198.00, '[OPEN]'),
(90, '2023-07-02', 198.00, '[OPEN]'),
(90, '2023-07-03', 198.00, '[OPEN]'),
(90, '2023-07-04', 198.00, '[OPEN]'),
(90, '2023-07-05', 198.00, '[OPEN]'),
-- August
(90, '2023-08-10', 198.00, '[OPEN]'),
(90, '2023-08-11', 198.00, '[OPEN]'),
(90, '2023-08-12', 198.00, '[OPEN]'),
(90, '2023-08-13', 198.00, '[OPEN]'),
(90, '2023-08-14', 198.00, '[OPEN]'),
(90, '2023-08-15', 198.00, '[OPEN]'),
-- September
(90, '2023-09-01', 198.00, '[OPEN]'),
(90, '2023-09-02', 198.00, '[OPEN]'),
(90, '2023-09-03', 198.00, '[OPEN]'),
(90, '2023-09-04', 198.00, '[OPEN]'),
(90, '2023-09-05', 198.00, '[OPEN]'),

-- July
(91, '2023-07-01', 178.00, '[OPEN]'),
(91, '2023-07-02', 178.00, '[OPEN]'),
(91, '2023-07-03', 178.00, '[OPEN]'),
(91, '2023-07-04', 178.00, '[OPEN]'),
(91, '2023-07-05', 178.00, '[OPEN]'),
-- August
(91, '2023-08-10', 178.00, '[OPEN]'),
(91, '2023-08-11', 178.00, '[OPEN]'),
(91, '2023-08-12', 178.00, '[OPEN]'),
(91, '2023-08-13', 178.00, '[OPEN]'),
(91, '2023-08-14', 178.00, '[OPEN]'),
(91, '2023-08-15', 178.00, '[OPEN]'),
-- September
(91, '2023-09-01', 178.00, '[OPEN]'),
(91, '2023-09-02', 178.00, '[OPEN]'),
(91, '2023-09-03', 178.00, '[OPEN]'),
(91, '2023-09-04', 178.00, '[OPEN]'),
(91, '2023-09-05', 178.00, '[OPEN]'),

-- July
(92, '2023-07-01', 170.00, '[OPEN]'),
(92, '2023-07-02', 170.00, '[OPEN]'),
(92, '2023-07-03', 170.00, '[OPEN]'),
(92, '2023-07-04', 170.00, '[OPEN]'),
(92, '2023-07-05', 170.00, '[OPEN]'),
-- August
(92, '2023-08-10', 170.00, '[OPEN]'),
(92, '2023-08-11', 170.00, '[OPEN]'),
(92, '2023-08-12', 170.00, '[OPEN]'),
(92, '2023-08-13', 170.00, '[OPEN]'),
(92, '2023-08-14', 170.00, '[OPEN]'),
(92, '2023-08-15', 170.00, '[OPEN]'),
-- September
(92, '2023-09-01', 170.00, '[OPEN]'),
(92, '2023-09-02', 170.00, '[OPEN]'),
(92, '2023-09-03', 170.00, '[OPEN]'),
(92, '2023-09-04', 170.00, '[OPEN]'),
(92, '2023-09-05', 170.00, '[OPEN]'),

-- July
(93, '2023-07-01', 402.00, '[OPEN]'),
(93, '2023-07-02', 402.00, '[OPEN]'),
(93, '2023-07-03', 402.00, '[OPEN]'),
(93, '2023-07-04', 402.00, '[OPEN]'),
(93, '2023-07-05', 402.00, '[OPEN]'),
-- August
(93, '2023-08-10', 402.00, '[OPEN]'),
(93, '2023-08-11', 402.00, '[OPEN]'),
(93, '2023-08-12', 402.00, '[OPEN]'),
(93, '2023-08-13', 402.00, '[OPEN]'),
(93, '2023-08-14', 402.00, '[OPEN]'),
(93, '2023-08-15', 402.00, '[OPEN]'),
-- September
(93, '2023-09-01', 402.00, '[OPEN]'),
(93, '2023-09-02', 402.00, '[OPEN]'),
(93, '2023-09-03', 402.00, '[OPEN]'),
(93, '2023-09-04', 402.00, '[OPEN]'),
(93, '2023-09-05', 402.00, '[OPEN]'),

-- July
(94, '2023-07-01', 359.00, '[OPEN]'),
(94, '2023-07-02', 359.00, '[OPEN]'),
(94, '2023-07-03', 359.00, '[OPEN]'),
(94, '2023-07-04', 359.00, '[OPEN]'),
(94, '2023-07-05', 359.00, '[OPEN]'),
-- August
(94, '2023-08-10', 359.00, '[OPEN]'),
(94, '2023-08-11', 359.00, '[OPEN]'),
(94, '2023-08-12', 359.00, '[OPEN]'),
(94, '2023-08-13', 359.00, '[OPEN]'),
(94, '2023-08-14', 359.00, '[OPEN]'),
(94, '2023-08-15', 359.00, '[OPEN]'),
-- September
(94, '2023-09-01', 359.00, '[OPEN]'),
(94, '2023-09-02', 359.00, '[OPEN]'),
(94, '2023-09-03', 359.00, '[OPEN]'),
(94, '2023-09-04', 359.00, '[OPEN]'),
(94, '2023-09-05', 359.00, '[OPEN]'),

-- July
(95, '2023-07-01', 329.00, '[OPEN]'),
(95, '2023-07-02', 329.00, '[OPEN]'),
(95, '2023-07-03', 329.00, '[OPEN]'),
(95, '2023-07-04', 329.00, '[OPEN]'),
(95, '2023-07-05', 329.00, '[OPEN]'),
-- August
(95, '2023-08-10', 329.00, '[OPEN]'),
(95, '2023-08-11', 329.00, '[OPEN]'),
(95, '2023-08-12', 329.00, '[OPEN]'),
(95, '2023-08-13', 329.00, '[OPEN]'),
(95, '2023-08-14', 329.00, '[OPEN]'),
(95, '2023-08-15', 329.00, '[OPEN]'),
-- September
(95, '2023-09-01', 329.00, '[OPEN]'),
(95, '2023-09-02', 329.00, '[OPEN]'),
(95, '2023-09-03', 329.00, '[OPEN]'),
(95, '2023-09-04', 329.00, '[OPEN]'),
(95, '2023-09-05', 329.00, '[OPEN]'),

-- July
(96, '2023-07-01', 302.00, '[OPEN]'),
(96, '2023-07-02', 302.00, '[OPEN]'),
(96, '2023-07-03', 302.00, '[OPEN]'),
(96, '2023-07-04', 302.00, '[OPEN]'),
(96, '2023-07-05', 302.00, '[OPEN]'),
-- August
(96, '2023-08-10', 302.00, '[OPEN]'),
(96, '2023-08-11', 302.00, '[OPEN]'),
(96, '2023-08-12', 302.00, '[OPEN]'),
(96, '2023-08-13', 302.00, '[OPEN]'),
(96, '2023-08-14', 302.00, '[OPEN]'),
(96, '2023-08-15', 302.00, '[OPEN]'),
-- September
(96, '2023-09-01', 302.00, '[OPEN]'),
(96, '2023-09-02', 302.00, '[OPEN]'),
(96, '2023-09-03', 302.00, '[OPEN]'),
(96, '2023-09-04', 302.00, '[OPEN]'),
(96, '2023-09-05', 302.00, '[OPEN]'),

-- July
(97, '2023-07-01', 257.00, '[OPEN]'),
(97, '2023-07-02', 257.00, '[OPEN]'),
(97, '2023-07-03', 257.00, '[OPEN]'),
(97, '2023-07-04', 257.00, '[OPEN]'),
(97, '2023-07-05', 257.00, '[OPEN]'),
-- August
(97, '2023-08-10', 257.00, '[OPEN]'),
(97, '2023-08-11', 257.00, '[OPEN]'),
(97, '2023-08-12', 257.00, '[OPEN]'),
(97, '2023-08-13', 257.00, '[OPEN]'),
(97, '2023-08-14', 257.00, '[OPEN]'),
(97, '2023-08-15', 257.00, '[OPEN]'),
-- September
(97, '2023-09-01', 257.00, '[OPEN]'),
(97, '2023-09-02', 257.00, '[OPEN]'),
(97, '2023-09-03', 257.00, '[OPEN]'),
(97, '2023-09-04', 257.00, '[OPEN]'),
(97, '2023-09-05', 257.00, '[OPEN]'),

-- July
(98, '2023-07-01', 245.00, '[OPEN]'),
(98, '2023-07-02', 245.00, '[OPEN]'),
(98, '2023-07-03', 245.00, '[OPEN]'),
(98, '2023-07-04', 245.00, '[OPEN]'),
(98, '2023-07-05', 245.00, '[OPEN]'),
-- August
(98, '2023-08-10', 245.00, '[OPEN]'),
(98, '2023-08-11', 245.00, '[OPEN]'),
(98, '2023-08-12', 245.00, '[OPEN]'),
(98, '2023-08-13', 245.00, '[OPEN]'),
(98, '2023-08-14', 245.00, '[OPEN]'),
(98, '2023-08-15', 245.00, '[OPEN]'),
-- September
(98, '2023-09-01', 245.00, '[OPEN]'),
(98, '2023-09-02', 245.00, '[OPEN]'),
(98, '2023-09-03', 245.00, '[OPEN]'),
(98, '2023-09-04', 245.00, '[OPEN]'),
(98, '2023-09-05', 245.00, '[OPEN]'),

-- July
(99, '2023-07-01', 178.00, '[OPEN]'),
(99, '2023-07-02', 178.00, '[OPEN]'),
(99, '2023-07-03', 178.00, '[OPEN]'),
(99, '2023-07-04', 178.00, '[OPEN]'),
(99, '2023-07-05', 178.00, '[OPEN]'),
-- August
(99, '2023-08-10', 178.00, '[OPEN]'),
(99, '2023-08-11', 178.00, '[OPEN]'),
(99, '2023-08-12', 178.00, '[OPEN]'),
(99, '2023-08-13', 178.00, '[OPEN]'),
(99, '2023-08-14', 178.00, '[OPEN]'),
(99, '2023-08-15', 178.00, '[OPEN]'),
-- September
(99, '2023-09-01', 178.00, '[OPEN]'),
(99, '2023-09-02', 178.00, '[OPEN]'),
(99, '2023-09-03', 178.00, '[OPEN]'),
(99, '2023-09-04', 178.00, '[OPEN]'),
(99, '2023-09-05', 178.00, '[OPEN]'),

-- July
(100, '2023-07-01', 188.00, '[OPEN]'),
(100, '2023-07-02', 188.00, '[OPEN]'),
(100, '2023-07-03', 188.00, '[OPEN]'),
(100, '2023-07-04', 188.00, '[OPEN]'),
(100, '2023-07-05', 188.00, '[OPEN]'),
-- August
(100, '2023-08-10', 188.00, '[OPEN]'),
(100, '2023-08-11', 188.00, '[OPEN]'),
(100, '2023-08-12', 188.00, '[OPEN]'),
(100, '2023-08-13', 188.00, '[OPEN]'),
(100, '2023-08-14', 188.00, '[OPEN]'),
(100, '2023-08-15', 188.00, '[OPEN]'),
-- September
(100, '2023-09-01', 188.00, '[OPEN]'),
(100, '2023-09-02', 188.00, '[OPEN]'),
(100, '2023-09-03', 188.00, '[OPEN]'),
(100, '2023-09-04', 188.00, '[OPEN]'),
(100, '2023-09-05', 188.00, '[OPEN]');

INSERT INTO Reservation (LID, UID, Price, Availability, StartDate, EndDate, CanceledBy, Rating, Comment)
VALUES
(1, 1, 120.00, '[CANCELED]', '2022-06-01', '2022-06-03', '[GUEST]', NULL, NULL),
(1, 1, 140.00, '[PAST RESERVATION]', '2023-07-01', '2023-07-01', NULL, 5, 'Satisfactory experience, easy reservation, good facilities.'),
(1, 2, 140.00, '[PAST RESERVATION]', '2023-07-02', '2023-07-02', NULL, 4, 'Smooth reservation, minor issues with facilities.'),
(1, 5, 140.00, '[PAST RESERVATION]', '2023-07-03', '2023-07-03', NULL, 5, 'Excellent experience, easy reservation, top-notch facilities.'),
(1, 1, 140.00, '[RESERVED]', '2023-08-11', '2023-08-11', NULL,  NULL, NULL),
(1, 9, 140.00, '[RESERVED]', '2023-08-12', '2023-08-12', NULL,  NULL, NULL),
(1, 10, 140.00, '[RESERVED]', '2023-08-13', '2023-08-13', NULL,  NULL, NULL),
(1, 1, 140.00, '[RESERVED]', '2023-09-04', '2023-09-04', NULL,  NULL, NULL),
(1, 14, 140.00, '[RESERVED]', '2023-09-05', '2023-09-05', NULL,  NULL, NULL),
(1, 6, 140.00, '[CANCELED]', '2023-08-14', '2023-08-15', '[GUEST]', NULL, NULL),
(1, 5, 140.00, '[CANCELED]', '2023-09-01', '2023-09-03', '[HOST]', NULL, NULL),

(2, 1, 100.00, '[CANCELED]', '2022-06-01', '2022-06-03', '[GUEST]', NULL, NULL),
(2, 1, 120.00, '[PAST RESERVATION]', '2023-07-02', '2023-07-02', NULL,  4, 'Good experience, straightforward reservation, facilities need improvement.'),
(2, 2, 120.00, '[PAST RESERVATION]', '2023-07-03', '2023-07-03', NULL,  5, 'Excellent experience, effortless reservation, outstanding facilities.'),
(2, 5, 120.00, '[RESERVED]', '2023-08-10', '2023-08-10', NULL,  NULL, NULL),
(2, 6, 120.00, '[RESERVED]', '2023-08-11', '2023-08-11', NULL,  NULL, NULL),
(2, 1, 120.00, '[RESERVED]', '2023-09-02', '2023-09-02', NULL,  NULL, NULL),
(2, 2, 120.00, '[RESERVED]', '2023-09-03', '2023-09-03', NULL,  NULL, NULL),
(2, 6, 120.00, '[CANCELED]', '2023-08-14', '2023-08-15', '[GUEST]', NULL, NULL),
(2, 5, 120.00, '[CANCELED]', '2023-09-04', '2023-09-05', '[HOST]', NULL, NULL),

(3, 1, 160.00, '[CANCELED]', '2022-06-01', '2022-06-03', '[GUEST]', NULL, NULL),
(3, 1, 180.00, '[PAST RESERVATION]', '2023-07-02', '2023-07-03', NULL,  NULL, NULL),
(3, 2, 180.00, '[PAST RESERVATION]', '2023-07-04', '2023-07-04', NULL,  NULL, NULL),
(3, 18, 180.00, '[RESERVED]', '2023-08-11', '2023-08-12', NULL,  NULL, NULL),
(3, 17, 180.00, '[RESERVED]', '2023-08-14', '2023-08-15', NULL,  NULL, NULL),
(3, 1, 180.00, '[RESERVED]', '2023-09-04', '2023-09-05', NULL,  NULL, NULL),
(3, 6, 180.00, '[CANCELED]', '2023-08-10', '2023-08-10', '[GUEST]', NULL, NULL),
(3, 5, 180.00, '[CANCELED]', '2023-09-02', '2023-09-03', '[HOST]', NULL, NULL),

(4, 1, 80.00, '[CANCELED]', '2022-06-01', '2022-06-03', '[GUEST]', NULL, NULL),
(4, 1, 100.00, '[PAST RESERVATION]', '2023-07-02', '2023-07-03', NULL,  NULL, NULL),
(4, 5, 100.00, '[PAST RESERVATION]', '2023-07-05', '2023-07-05', NULL,  NULL, NULL),
(4, 2, 100.00, '[RESERVED]', '2023-08-11', '2023-08-11', NULL,  NULL, NULL),
(4, 14, 100.00, '[RESERVED]', '2023-08-12', '2023-08-12', NULL,  NULL, NULL),
(4, 17, 100.00, '[RESERVED]', '2023-08-13', '2023-08-13', NULL,  NULL, NULL),
(4, 1, 100.00, '[RESERVED]', '2023-08-14', '2023-08-14', NULL,  NULL, NULL),
(4, 6, 100.00, '[RESERVED]', '2023-09-01', '2023-09-01',  NULL, NULL, NULL),
(4, 9, 100.00, '[RESERVED]', '2023-09-02', '2023-09-02',  NULL, NULL, NULL),
(4, 6, 100.00, '[CANCELED]', '2023-09-03', '2023-09-03', '[GUEST]', NULL, NULL),
(4, 5, 100.00, '[CANCELED]', '2023-09-04', '2023-09-05', '[HOST]', NULL, NULL),

(5, 1, 70.00, '[CANCELED]', '2022-06-01', '2022-06-03', '[GUEST]', NULL, NULL),
(5, 1, 90.00, '[PAST RESERVATION]', '2023-07-01', '2023-07-01', NULL,  NULL, NULL),
(5, 5, 90.00, '[PAST RESERVATION]', '2023-07-03', '2023-07-03', NULL,  NULL, NULL),
(5, 6, 90.00, '[RESERVED]', '2023-08-11', '2023-08-11', NULL,  NULL, NULL),
(5, 13, 90.00, '[RESERVED]', '2023-08-12', '2023-08-12', NULL,  NULL, NULL),
(5, 6, 90.00, '[CANCELED]', '2023-08-14', '2023-08-15', '[GUEST]', NULL, NULL),
(5, 5, 90.00, '[CANCELED]', '2023-09-04', '2023-09-05', '[HOST]', NULL, NULL),

(6, 1, 90.00, '[CANCELED]', '2022-06-01', '2022-06-03', '[HOST]', NULL, NULL),
(6, 5, 110.00, '[PAST RESERVATION]', '2023-07-01', '2023-07-02', NULL,  5, 'Good experience, efficient reservation, adequate facilities.'),
(6, 2, 110.00, '[PAST RESERVATION]', '2023-07-03', '2023-07-03', NULL,  4, 'Good experience, smooth reservation, adequate facilities.'),
(6, 1, 110.00, '[PAST RESERVATION]', '2023-07-04', '2023-07-05', NULL,  5, 'Good experience, efficient reservation, adequate facilities.'),
(6, 10, 110.00, '[RESERVED]', '2023-08-13', '2023-08-13', NULL,  NULL, NULL),
(6, 1, 110.00, '[RESERVED]', '2023-08-14', '2023-08-14', NULL,  NULL, NULL),
(6, 14, 110.00, '[RESERVED]', '2023-09-04', '2023-09-05', NULL,  NULL, NULL),
(6, 6, 110.00, '[CANCELED]', '2023-08-15', '2023-08-15', '[GUEST]', NULL, NULL),
(6, 5, 110.00, '[CANCELED]', '2023-09-01', '2023-09-03', '[HOST]', NULL, NULL),

(7, 1, 105.00, '[CANCELED]', '2022-06-01', '2022-06-03', '[HOST]', NULL, NULL),
(7, 1, 125.00, '[PAST RESERVATION]', '2023-07-01', '2023-07-01', NULL,  4, 'Excellent experience, smooth reservation, adequate facilities.'),
(7, 5, 125.00, '[PAST RESERVATION]', '2023-07-02', '2023-07-02', NULL,  5, 'Excellent experience, effortless reservation, top-notch facilities.'),
(7, 6, 125.00, '[RESERVED]', '2023-08-11', '2023-08-11', NULL,  NULL, NULL),
(7, 9, 125.00, '[RESERVED]', '2023-08-12', '2023-08-12', NULL,  NULL, NULL),
(7, 10, 125.00, '[RESERVED]', '2023-09-02', '2023-09-02', NULL,  NULL, NULL),
(7, 13, 125.00, '[RESERVED]', '2023-09-03', '2023-09-03', NULL,  NULL, NULL),
(7, 6, 125.00, '[CANCELED]', '2023-08-14', '2023-08-15', '[GUEST]', NULL, NULL),
(7, 5, 125.00, '[CANCELED]', '2023-09-04', '2023-09-05', '[HOST]', NULL, NULL),

(8, 1, 80.00, '[CANCELED]', '2022-06-01', '2022-06-03', '[HOST]', NULL, NULL),
(8, 2, 100.00, '[PAST RESERVATION]', '2023-07-02', '2023-07-02', NULL,  NULL, NULL),
(8, 5, 100.00, '[PAST RESERVATION]', '2023-07-03', '2023-07-03', NULL,  NULL, NULL),
(8, 9, 100.00, '[RESERVED]', '2023-07-04', '2023-07-04', NULL,  NULL, NULL),
(8, 10, 100.00, '[RESERVED]', '2023-08-12', '2023-08-12', NULL,  NULL, NULL),
(8, 13, 100.00, '[RESERVED]', '2023-08-13', '2023-08-13', NULL,  NULL, NULL),
(8, 6, 100.00, '[CANCELED]', '2023-08-14', '2023-08-15', '[GUEST]', NULL, NULL),
(8, 5, 100.00, '[CANCELED]', '2023-09-04', '2023-09-05', '[HOST]', NULL, NULL),

(9, 1, 60.00, '[CANCELED]', '2022-06-01', '2022-06-03', '[HOST]', NULL, NULL),
(9, 1, 80.00, '[PAST RESERVATION]', '2023-07-01', '2023-07-01', NULL,  NULL, NULL),
(9, 5, 80.00, '[PAST RESERVATION]', '2023-07-02', '2023-07-02', NULL,  NULL, NULL),
(9, 2, 80.00, '[PAST RESERVATION]', '2023-07-03', '2023-07-03', NULL,  NULL, NULL),
(9, 6, 80.00, '[RESERVED]', '2023-09-02', '2023-09-02', NULL,  NULL, NULL),
(9, 9, 80.00, '[RESERVED]', '2023-09-03', '2023-09-03', NULL,  NULL, NULL),
(9, 6, 80.00, '[CANCELED]', '2023-08-14', '2023-08-15', '[GUEST]', NULL, NULL),
(9, 5, 80.00, '[CANCELED]', '2023-09-04', '2023-09-05', '[HOST]', NULL, NULL),

(10, 1, 115.00, '[CANCELED]', '2022-06-01', '2022-06-03', '[GUEST]', NULL, NULL),
(10, 1, 135.00, '[PAST RESERVATION]', '2023-07-01', '2023-07-03', NULL,  NULL, NULL),
(10, 5, 135.00, '[PAST RESERVATION]', '2023-07-03', '2023-07-04', NULL,  NULL, NULL),
(10, 2, 135.00, '[PAST RESERVATION]', '2023-07-05', '2023-07-05', NULL,  NULL, NULL),
(10, 6, 135.00, '[RESERVED]', '2023-08-12', '2023-08-12', NULL,  NULL, NULL),
(10, 9, 135.00, '[RESERVED]', '2023-08-13', '2023-08-13', NULL,  NULL, NULL),
(10, 6, 140.00, '[CANCELED]', '2023-08-14', '2023-08-15', '[GUEST]', NULL, NULL),
(10, 5, 140.00, '[CANCELED]', '2023-09-04', '2023-09-05', '[HOST]', NULL, NULL),

(11, 1, 160.00, '[CANCELED]', '2022-06-01', '2022-06-03', '[GUEST]', NULL, NULL),
(11, 5, 180.00, '[PAST RESERVATION]', '2023-07-01', '2023-07-01', NULL,  4, 'Good experience, easy reservation, acceptable facilities.'),
(11, 6, 180.00, '[PAST RESERVATION]', '2023-07-02', '2023-07-02', NULL,  5, 'Impressive experience, easy reservation, excellent facilities.'),
(11, 2, 180.00, '[RESERVED]', '2023-08-14', '2023-08-14', NULL,  NULL, NULL),
(11, 14, 180.00, '[RESERVED]', '2023-08-15', '2023-08-15', NULL,  NULL, NULL),
(11, 17, 180.00, '[RESERVED]', '2023-09-03', '2023-09-03', NULL,  NULL, NULL),
(11, 18, 180.00, '[RESERVED]', '2023-09-04', '2023-09-04', NULL,  NULL, NULL),
(11, 5, 180.00, '[CANCELED]', '2023-08-10', '2023-08-10', '[GUEST]', NULL, NULL),
(11, 6, 180.00, '[CANCELED]', '2023-09-02', '2023-09-02', '[HOST]', NULL, NULL),

(12, 1, 180.00, '[CANCELED]', '2022-06-01', '2022-06-03', '[GUEST]', NULL, NULL),
(12, 10, 200.00, '[PAST RESERVATION]', '2023-07-01', '2023-07-02', NULL,  4, 'The reservation was simple; facilities met basic needs.'),
(12, 9, 200.00, '[PAST RESERVATION]', '2023-07-04', '2023-07-05', NULL,  5, 'Efficient reservation process, the facilities were top-notch.'),
(12, 13, 200.00, '[RESERVED]', '2023-08-10', '2023-08-11', NULL,  NULL, NULL),
(12, 14, 200.00, '[RESERVED]', '2023-08-13', '2023-08-14', NULL,  NULL, NULL),
(12, 5, 200.00, '[CANCELED]', '2023-08-14', '2023-08-15', '[GUEST]', NULL, NULL),
(12, 6, 200.00, '[CANCELED]', '2023-09-04', '2023-09-05', '[HOST]', NULL, NULL),

(13, 1, 75.00, '[CANCELED]', '2022-06-01', '2022-06-03', '[GUEST]', NULL, NULL),
(13, 17, 95.00, '[PAST RESERVATION]', '2023-07-01', '2023-07-02', NULL,  5, 'Satisfactory reservation experience; the facilities were just as expected.'),
(13, 18, 95.00, '[PAST RESERVATION]', '2023-07-04', '2023-07-05', NULL,  4, 'Reservation was easy, some facilities could be improved.'),
(13, 10, 95.00, '[RESERVED]', '2023-08-12', '2023-08-12', NULL,  NULL, NULL),
(13, 9, 95.00, '[RESERVED]', '2023-08-13', '2023-08-13', NULL,  NULL, NULL),
(13, 6, 95.00, '[RESERVED]', '2023-09-03', '2023-09-03', NULL,  NULL, NULL),
(13, 5, 95.00, '[CANCELED]', '2023-09-04', '2023-09-04', '[GUEST]', NULL, NULL),

(14, 1, 115.00, '[CANCELED]', '2022-06-01', '2022-06-03', '[HOST]', NULL, NULL),
(14, 1, 135.00, '[PAST RESERVATION]', '2023-07-01', '2023-07-01', NULL,  4, 'Good process, satisfactory reservation, satisfactory facilities.'),
(14, 2, 135.00, '[PAST RESERVATION]', '2023-07-02', '2023-07-02', NULL,  5, 'Excellent process, smooth reservation, outstanding facilities.'),
(14, 5, 135.00, '[PAST RESERVATION]', '2023-07-03', '2023-07-03', NULL,  4, 'Standard process, decent reservation, satisfactory facilities.'),
(14, 6, 135.00, '[PAST RESERVATION]', '2023-07-04', '2023-07-04', NULL,  5, 'Impressive process, quick reservation, superior facilities.'),
(14, 10, 135.00, '[PAST RESERVATION]', '2023-07-05', '2023-07-05', NULL,  4, 'Good process, effortless reservation, average facilities.'),
(14, 13, 135.00, '[RESERVED]', '2023-08-12', '2023-08-12', NULL,  NULL, NULL),
(14, 14, 135.00, '[RESERVED]', '2023-08-13', '2023-08-13', NULL,  NULL, NULL),
(14, 18, 135.00, '[RESERVED]', '2023-08-14', '2023-08-14', NULL,  NULL, NULL),
(14, 5, 135.00, '[CANCELED]', '2023-08-11', '2023-08-11', '[GUEST]', NULL, NULL),
(14, 6, 135.00, '[CANCELED]', '2023-09-04', '2023-09-05', '[HOST]', NULL, NULL),

(15, 1, 95.00, '[CANCELED]', '2022-06-01', '2022-06-03', '[HOST]', NULL, NULL),
(15, 2, 150.00, '[PAST RESERVATION]', '2023-07-01', '2023-07-01', NULL,  5, 'Reservation was effortless, facilities were top-class.'),
(15, 5, 150.00, '[PAST RESERVATION]', '2023-07-02', '2023-07-02', NULL,  4, 'Smooth reservation, facilities were good but lacked some details.'),
(15, 6, 150.00, '[RESERVED]', '2023-08-11', '2023-08-11', NULL,  NULL, NULL),
(15, 18, 150.00, '[RESERVED]', '2023-08-12', '2023-08-12', NULL,  NULL, NULL),
(15, 2, 150.00, '[CANCELED]', '2023-08-14', '2023-08-15', '[GUEST]', NULL, NULL),
(15, 1, 150.00, '[CANCELED]', '2023-09-04', '2023-09-05', '[HOST]', NULL, NULL),

(16, 14, 120.00, '[PAST RESERVATION]', '2023-07-01', '2023-07-01', NULL,  5, 'Reservation experience was superb, the facilities exceeded expectations.'),
(16, 9, 120.00, '[PAST RESERVATION]', '2023-07-02', '2023-07-02',  NULL, 4, 'Reservation was straightforward, facilities were nice but room for improvement.'),
(16, 6, 120.00, '[PAST RESERVATION]', '2023-07-03', '2023-07-03', NULL,  5, 'Excellent reservation process, the facilities were top-tier.'),
(16, 5, 120.00, '[RESERVED]', '2023-08-14', '2023-08-15', NULL,  NULL, NULL),
(16, 6, 120.00, '[CANCELED]', '2023-08-12', '2023-08-13', '[GUEST]', NULL, NULL),
(16, 5, 120.00, '[CANCELED]', '2023-09-04', '2023-09-05', '[HOST]', NULL, NULL),

(17, 6, 110.00, '[PAST RESERVATION]', '2023-07-02', '2023-07-02', NULL,  4, 'Reservation was quick; facilities were decent but could be better.'),
(17, 18, 110.00, '[PAST RESERVATION]', '2023-07-03', '2023-07-03', NULL,  5, 'Smooth reservation experience; facilities met all expectations.'),
(17, 14, 110.00, '[PAST RESERVATION]', '2023-07-04', '2023-07-04', NULL,  4, 'Reservation was efficient; facilities were satisfactory.'),
(17, 13, 110.00, '[RESERVED]', '2023-09-02', '2023-09-02', NULL,  NULL, NULL),
(17, 10, 110.00, '[RESERVED]', '2023-09-03', '2023-09-03', NULL,  NULL, NULL),
(17, 6, 110.00, '[CANCELED]', '2023-08-14', '2023-08-15', '[GUEST]', NULL, NULL),
(17, 5, 110.00, '[CANCELED]', '2023-09-04', '2023-09-05', '[HOST]', NULL, NULL),

(18, 9, 90.00, '[PAST RESERVATION]', '2023-07-02', '2023-07-02', NULL,  4, 'Reservation process was smooth; facilities were adequate but unremarkable.'),
(18, 6, 90.00, '[PAST RESERVATION]', '2023-07-03', '2023-07-03', NULL,  5, 'Reservation was effortless; facilities were well-maintained and clean.'),
(18, 10, 90.00, '[RESERVED]', '2023-09-04', '2023-09-04', NULL,  NULL, NULL),
(18, 17, 90.00, '[RESERVED]', '2023-09-05', '2023-09-05', NULL,  NULL, NULL),
(18, 6, 90.00, '[CANCELED]', '2023-08-14', '2023-08-15', '[GUEST]', NULL, NULL),
(18, 5, 90.00, '[CANCELED]', '2023-09-01', '2023-09-02', '[HOST]', NULL, NULL),

(19, 1, 130.00, '[PAST RESERVATION]', '2023-07-01', '2023-07-01', NULL,  NULL, NULL),
(19, 2, 130.00, '[PAST RESERVATION]', '2023-07-02', '2023-07-02', NULL,  NULL, NULL),

(20, 5, 95.00, '[PAST RESERVATION]', '2023-07-04', '2023-07-04', NULL,  2, 'Reservation was confusing, facilities were disappointing and lacked cleanliness.'),
(20, 13, 95.00, '[PAST RESERVATION]', '2023-07-05', '2023-07-05', NULL,  3, 'Reservation took longer than expected, facilities were mediocre and could use updates.'),
(20, 14, 95.00, '[RESERVED]', '2023-08-11', '2023-08-11', NULL,  NULL, NULL),
(20, 6, 95.00, '[RESERVED]', '2023-08-12', '2023-08-12', NULL,  NULL, NULL),

(21, 10, 200.00, '[PAST RESERVATION]', '2023-07-01', '2023-07-01', NULL,  3, 'Reservation was okay; facilities were somewhat dated.'),
(21, 13, 200.00, '[PAST RESERVATION]', '2023-07-02', '2023-07-02', NULL,  2, 'Reservation was cumbersome, facilities were unclean and in need of maintenance.'),
(21, 6, 200.00, '[PAST RESERVATION]', '2023-07-03', '2023-07-03', NULL,  1, 'Reservation process was frustrating; facilities were very poor.'),
(21, 9, 200.00, '[PAST RESERVATION]', '2023-07-04', '2023-07-04', NULL,  3, 'Reservation was fine, but the facilities lacked attention to detail.'),
(21, 17, 200.00, '[RESERVED]', '2023-09-01', '2023-09-01', NULL,  NULL, NULL),
(21, 18, 200.00, '[RESERVED]', '2023-09-02', '2023-09-02', NULL,  NULL, NULL),

(22, 1, 210.00, '[PAST RESERVATION]', '2023-07-01', '2023-07-01', NULL,  3, 'Reservation easy, facilities standard.'),
(22, 2, 210.00, '[PAST RESERVATION]', '2023-07-03', '2023-07-04', NULL,  4, 'Reservation smooth, facilities good.'),
(22, 5, 210.00, '[PAST RESERVATION]', '2023-07-04', '2023-07-04', NULL,  3, 'Reservation okay, facilities unremarkable.'),
(22, 13, 210.00, '[RESERVED]', '2023-08-12', '2023-08-14', NULL,  NULL, NULL),

(23, 1, 180.00, '[PAST RESERVATION]', '2023-07-01', '2023-07-01', NULL,  3, 'Reservation simple, facilities dirty, lacked luxury.'),
(23, 2, 180.00, '[PAST RESERVATION]', '2023-07-02', '2023-07-02', NULL,  4, 'Reservation efficient, facilities uncomfortable, well-kept.'),
(23, 5, 180.00, '[PAST RESERVATION]', '2023-07-03', '2023-07-03', NULL,  3, 'Reservation satisfactory, facilities outdated, needs upgrades.'),
(23, 6, 180.00, '[RESERVED]', '2023-08-11', '2023-08-11', NULL,  NULL, NULL),
(23, 1, 180.00, '[RESERVED]', '2023-08-12', '2023-08-12', NULL,  NULL, NULL),
(23, 10, 180.00, '[RESERVED]', '2023-09-04', '2023-09-04', NULL,  NULL, NULL),
(23, 6, 180.00, '[CANCELED]', '2023-08-14', '2023-08-15', '[GUEST]', NULL, NULL),
(23, 5, 180.00, '[CANCELED]', '2023-09-03', '2023-09-03', '[HOST]', NULL, NULL),

(24, 1, 195.00, '[PAST RESERVATION]', '2023-07-01', '2023-07-01', NULL,  1, 'Difficult process, complicated reservation, poor facilities.'),
(24, 2, 195.00, '[PAST RESERVATION]', '2023-07-02', '2023-07-02', NULL,  2, 'Cumbersome process, tedious reservation, dirty facilities.'),
(24, 5, 195.00, '[PAST RESERVATION]', '2023-07-03', '2023-07-03', NULL,  1, 'Complex process, hassle reservation, substandard facilities.'),
(24, 6, 195.00, '[RESERVED]', '2023-08-10', '2023-08-10', NULL,  NULL, NULL),
(24, 9, 195.00, '[RESERVED]', '2023-08-11', '2023-08-11', NULL,  NULL, NULL),
(24, 10, 195.00, '[RESERVED]', '2023-09-01', '2023-09-01', NULL,  NULL, NULL),
(24, 13, 195.00, '[RESERVED]', '2023-09-04', '2023-09-04', NULL,  NULL, NULL),
(24, 6, 195.00, '[CANCELED]', '2023-08-14', '2023-08-15', '[GUEST]', NULL, NULL),
(24, 5, 195.00, '[CANCELED]', '2023-09-01', '2023-09-02', '[HOST]', NULL, NULL),

(25, 1, 170.00, '[PAST RESERVATION]', '2023-07-01', '2023-07-01', NULL,  NULL, NULL),
(25, 2, 170.00, '[PAST RESERVATION]', '2023-07-03', '2023-07-03', NULL,  NULL, NULL),
(25, 14, 170.00, '[RESERVED]', '2023-08-11', '2023-08-11', NULL,  NULL, NULL),
(25, 17, 170.00, '[RESERVED]', '2023-08-12', '2023-08-12', NULL,  NULL, NULL),
(25, 18, 170.00, '[RESERVED]', '2023-09-04', '2023-09-04', NULL,  NULL, NULL),
(25, 6, 170.00, '[CANCELED]', '2023-08-14', '2023-08-15', '[GUEST]', NULL, NULL),
(25, 5, 170.00, '[CANCELED]', '2023-09-02', '2023-09-03', '[HOST]', NULL, NULL),

(26, 5, 160.00, '[PAST RESERVATION]', '2023-07-01', '2023-07-01', NULL,  NULL, NULL),
(26, 1, 160.00, '[PAST RESERVATION]', '2023-07-03', '2023-07-03', NULL,  NULL, NULL),
(26, 2, 160.00, '[PAST RESERVATION]', '2023-07-05', '2023-07-05', NULL,  NULL, NULL),
(26, 13, 160.00, '[RESERVED]', '2023-08-11', '2023-08-12', NULL,  NULL, NULL),
(26, 6, 160.00, '[CANCELED]', '2023-08-14', '2023-08-15', '[GUEST]', NULL, NULL),
(26, 5, 160.00, '[CANCELED]', '2023-09-04', '2023-09-05', '[HOST]', NULL, NULL);



INSERT INTO Category (Category_Name)
VALUES
('Essentials'),
('Standout'),
('Safety');

INSERT INTO Amenities (Category_ID, Amenity_Name)
VALUES
(1, 'Wifi'),
(1, 'TV'),
(1, 'Kitchen'),
(1, 'Washer'),
(1, 'Free Parking'),
(1, 'Air Conditioner'),
(1, 'Dedicated Workspace'),
(2, 'Pool'),
(2, 'Hot Tub'),
(2, 'Outdoor Dining Area'),
(2, 'Beach Access'),
(2, 'Lake Access'),
(2, 'Gym'),
(2, 'Prime Location'),
(2, 'Public Transport Access'),
(3, 'Smoke Alarm'),
(3, 'First Aid Kit'),
(3, 'Fire Extinguisher'),
(3, 'CO Alarm');

INSERT INTO Revenue (Amenity_Name, Percentage)
VALUES
('Wifi', 4.0),
('TV', 2.0),
('Kitchen', 5.0),
('Washer', 5.0),
('Free Parking', 4.0),
('Air Conditioner', 3.0),
('Dedicated Workspace', 2.0),
('Pool', 10.0),
('Hot Tub', 5.0),
('Outdoor Dining Area', 3.0),
('Beach Access', 10.0),
('Lake Access', 10.0),
('Gym', 6.0),
('Prime Location', 10.0),
('Public Transport Access', 10.0),
('Smoke Alarm', 2.0),
('First Aid Kit', 2.0),
('Fire Extinguisher', 3.0),
('CO Alarm', 3.0);

INSERT INTO AmenitiesListing (LID, Amenities_ID)
VALUES 
(1, 2),
(1, 3),
(1, 4),
(1, 16),

(2, 2),
(2, 3),
(2, 4),
(2, 16),

(3, 8), 
(3, 2),  
(3, 3),   
(3, 4),   
(3, 5),   
(3, 16),  

(4, 2),
(4, 5),
(4, 7),

(5, 2),
(5, 5),
(5, 7),

(6, 9), 
(6, 4),   
(6, 3), 
(6, 5),   
(6, 16),  

(7, 4),   
(7, 3),   
(7, 13),  
(7, 5),   
(7, 16),  

(8, 2),
(8, 3),
(8, 4),
(8, 16),

(9, 2),
(9, 5),
(9, 7), 

(10, 13),   
(10, 15),   
(10, 2),    
(10, 3),    
(10, 4),    
(10, 16),  

(11, 8),    
(11, 2),    
(11, 3),    
(11, 4),    
(11, 9),    
(11, 19),   
(11, 16),   

(12, 1),    
(12, 2),    
(12, 3),    
(12, 4),    
(12, 11),   
(12, 16),   

(13, 1),    
(13, 2),   
(13, 3),    
(13, 4),    
(13, 16),   

(14, 8),   
(14, 2),    
(14, 3),    
(14, 4),    
(14, 9),    
(14, 19),  
(14, 16),   

(15, 13),   
(15, 15),  
(15, 2),   
(15, 3),    
(15, 4),   
(15, 16),  

(16, 1),   
(16, 2),    
(16, 13),   
(16, 4),   
(16, 3),    

(17, 15),   
(17, 2),    
(17, 4),    
(17, 16),   
(17, 3),    

(18, 2),    
(18, 4),    
(18, 16),   
(18, 3),    

(19, 2),
(19, 4),
(19, 16),

(20, 2),
(20, 4),
(20, 9),
(20, 16),

(21, 1),
(21, 2),
(21, 3),
(21, 19),
(21, 13),

(22, 1),
(22, 2),
(22, 3),
(22, 19),
(22, 13),

(23, 4),
(23, 3),
(23, 5),
(23, 19),

(24, 4),
(24, 3),
(24, 5),
(24, 19),

(25, 1),
(25, 2),
(25, 3),
(25, 19),
(25, 13),

(26, 4),
(26, 3),
(26, 5),
(26, 19),

(27, 9),
(27, 1),
(27, 2),
(27, 3),
(27, 4),
(27, 19),

(28, 1),
(28, 8),
(28, 2),
(28, 3),
(28, 6),
(28, 16),

(29, 13),
(29, 14),
(29, 1),
(29, 2),
(29, 3),
(29, 19),
(29, 20),

(30, 9),
(30, 1),
(30, 2),
(30, 5),
(30, 19),
(30, 20),

(31, 8),
(31, 1),
(31, 2),
(31, 3),
(31, 4),
(31, 6),
(31, 16),
(31, 14),

(32, 13),
(32, 15),
(32, 1),
(32, 2),
(32, 3),
(32, 4),
(32, 7),

(33, 10),
(33, 1),
(33, 2),
(33, 3),
(33, 6),
(33, 7),

(34, 13),
(34, 1),
(34, 2),
(34, 3),
(34, 4),
(34, 5),

(35, 10),
(35, 14),
(35, 1),
(35, 2),
(35, 3),

(36, 15),
(36, 1),
(36, 2),
(36, 18),
(36, 16),

(37, 1),
(37, 2),
(37, 3),
(37, 20),
(37, 17),

(38, 2),
(38, 3),
(38, 4),
(38, 5),

(39, 4),
(39, 5),
(39, 6),
(39, 7),
(39, 19),

(40, 3),
(40, 4),
(40, 5),
(40, 6),
(40, 7),
(40, 9),
(40, 19),

(41, 3),
(41, 4),
(41, 5),
(41, 6),
(41, 7),
(41, 8),
(41, 19),

(42, 1),
(42, 4),
(42, 5),
(42, 7),
(42, 9),
(42, 11),
(42, 15),
(42, 16),
(42, 18),
(42, 19),

(43, 1),
(43, 4),
(43, 5),
(43, 6),
(43, 7),
(43, 9),
(43, 11),
(43, 15),
(43, 16),
(43, 18),
(43, 19),

(44, 3),
(44, 4),
(44, 5),
(44, 18),
(44, 19),

(45, 2),
(45, 4),
(45, 9),

(46, 2),
(46, 4),

(47, 2),
(47, 4),
(47, 9),
(47, 11),

(48, 2),

(49, 3),
(49, 4),
(49, 5),
(49, 6),
(49, 7),
(49, 9),
(49, 19),

(50, 3),
(50, 4),
(50, 5),
(50, 6),
(50, 7),
(50, 9),
(50, 19),

(51, 3),
(51, 4),
(51, 5),
(51, 6),
(51, 7),
(51, 9),
(51, 19),

(52, 3),
(52, 4),
(52, 5),
(52, 6),
(52, 7),
(52, 9),
(52, 10),
(52, 19),

(53, 3),
(53, 4),
(53, 5),
(53, 6),
(53, 7),
(53, 9),
(53, 10),
(53, 11),
(53, 19),

(54, 1),
(54, 4),
(54, 5),
(54, 6),
(54, 7),
(54, 9),
(54, 10),
(54, 11),
(54, 19),

(55, 1),
(55, 4),
(55, 5),
(55, 7),
(55, 9),
(55, 11),
(55, 15),
(55, 18),
(55, 19),

(56, 3),
(56, 4),
(56, 5),
(56, 6),
(56, 7),
(56, 9),
(56, 19),

(57, 2),
(57, 4),

(58, 3),
(58, 4),
(58, 5),
(58, 6),
(58, 7),
(58, 9),
(58, 10),
(58, 11),

(59, 2),
(59, 4),
(59, 9),
(59, 19),

(60, 2),
(60, 4),
(60, 9),

(61, 1),
(61, 4),
(61, 5),
(61, 6),
(61, 7),
(61, 9),
(61, 14),
(61, 16),
(61, 18),

(62, 1),
(62, 4),
(62, 5),
(62, 6),
(62, 7),
(62, 9),
(62, 14),
(62, 16),
(62, 18),
(62, 19),
(62, 20),

(63, 1),
(63, 4),
(63, 5),
(63, 6),
(63, 7),
(63, 9),
(63, 14),
(63, 16),
(63, 18),
(63, 19),
(63, 20),

(64, 1),
(64, 4),
(64, 5),
(64, 6),
(64, 7),
(64, 9),
(64, 14),
(64, 16),
(64, 18),
(64, 19),
(64, 20),
(64, 21),

(65, 3),
(65, 4),
(65, 5),
(65, 6),
(65, 7),
(65, 9),
(65, 10),
(65, 19),

(66, 3),
(66, 4),
(66, 5),
(66, 7),
(66, 9),
(66, 19),

(67, 3),
(67, 4),
(67, 5),
(67, 6),
(67, 7),
(67, 9),
(67, 10),
(67, 11),
(67, 19),

(68, 3),
(68, 4),
(68, 5),
(68, 6),
(68, 7),
(68, 9),
(68, 10),
(68, 11),
(68, 19),

(69, 1),
(69, 4),
(69, 5),
(69, 6),
(69, 7),
(69, 9),
(69, 10),
(69, 11),
(69, 13),
(69, 12),
(69, 19),

(70, 1),
(70, 4),
(70, 5),
(70, 6),
(70, 7),
(70, 9),
(70, 14),
(70, 16),
(70, 18);