-
-
Save MGCodesandStats/55c69fa56a117746ecef02b02f7ab129 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
stocks_hotels=# select brand, cast(avg(revpar) as decimal(5,2)) from hilton group by brand order by avg(revpar); | |
brand | avg | |
----------------------------------+-------- | |
Tru by Hilton | 65.58 | |
DoubleTree by Hilton | 66.54 | |
Tapestry Collection by Hilton | 69.00 | |
Canopy by Hilton | 70.26 | |
Hampton by Hilton | 71.26 | |
Hilton Garden Inn | 72.57 | |
Home2 Suites by Hilton | 81.26 | |
Hilton Hotels & Resorts | 83.66 | |
Embassy Suites by Hilton | 90.71 | |
Homewood Suites by Hilton | 93.25 | |
Curio Collection by Hilton | 104.53 | |
Conrad Hotels & Resorts | 121.90 | |
Waldorf Astoria Hotels & Resorts | 214.83 | |
(13 rows) | |
stocks_hotels=# select * from hilton order by brand, year, period; | |
brand | adr | revpar | quarter | year | period | |
----------------------------------+--------+--------+---------+------+-------- | |
Canopy by Hilton | 183.78 | 93.72 | Q1 2020 | 2020 | Q1 | |
Canopy by Hilton | 129.14 | 11.82 | Q2 2020 | 2020 | Q2 | |
Canopy by Hilton | 139.40 | 43.94 | Q3 2020 | 2020 | Q3 | |
Canopy by Hilton | 133.02 | 33.06 | Q4 2020 | 2020 | Q4 | |
Canopy by Hilton | 116.77 | 34.73 | Q1 2021 | 2021 | Q1 | |
Canopy by Hilton | 146.28 | 65.35 | Q2 2021 | 2021 | Q2 | |
Canopy by Hilton | 166.30 | 96.44 | Q3 2021 | 2021 | Q3 | |
Canopy by Hilton | 155.67 | 91.83 | Q4 2021 | 2021 | Q4 | |
Canopy by Hilton | 186.89 | 99.89 | Q1 2022 | 2022 | Q1 | |
Canopy by Hilton | 200.88 | 131.86 | Q2 2022 | 2022 | Q2 | |
Conrad Hotels & Resorts | 266.04 | 193.96 | Q1 2019 | 2019 | Q1 | |
Conrad Hotels & Resorts | 279.32 | 212.91 | Q2 2019 | 2019 | Q2 | |
Conrad Hotels & Resorts | 259.13 | 198.89 | Q3 2019 | 2019 | Q3 | |
Conrad Hotels & Resorts | 264.15 | 195.86 | Q4 2019 | 2019 | Q4 | |
Conrad Hotels & Resorts | 230.99 | 105.68 | Q1 2020 | 2020 | Q1 | |
Conrad Hotels & Resorts | 134.88 | 25.69 | Q2 2020 | 2020 | Q2 | |
Conrad Hotels & Resorts | 178.63 | 55.58 | Q3 2020 | 2020 | Q3 | |
Conrad Hotels & Resorts | 216.95 | 79.69 | Q4 2020 | 2020 | Q4 | |
Conrad Hotels & Resorts | 182.93 | 57.81 | Q1 2021 | 2021 | Q1 | |
Conrad Hotels & Resorts | 202.85 | 82.88 | Q2 2021 | 2021 | Q2 | |
Conrad Hotels & Resorts | 220.71 | 103.96 | Q3 2021 | 2021 | Q3 | |
Conrad Hotels & Resorts | 238.27 | 132.32 | Q4 2021 | 2021 | Q4 | |
Conrad Hotels & Resorts | 229.69 | 105.21 | Q1 2022 | 2022 | Q1 | |
Conrad Hotels & Resorts | 273.10 | 156.16 | Q2 2022 | 2022 | Q2 | |
Curio Collection by Hilton | 218.54 | 151.36 | Q1 2019 | 2019 | Q1 | |
Curio Collection by Hilton | 221.50 | 168.71 | Q2 2019 | 2019 | Q2 | |
Curio Collection by Hilton | 198.14 | 144.00 | Q3 2019 | 2019 | Q3 | |
Curio Collection by Hilton | 200.97 | 140.87 | Q4 2019 | 2019 | Q4 | |
Curio Collection by Hilton | 206.15 | 106.71 | Q1 2020 | 2020 | Q1 | |
Curio Collection by Hilton | 111.51 | 16.35 | Q2 2020 | 2020 | Q2 | |
Curio Collection by Hilton | 147.95 | 40.05 | Q3 2020 | 2020 | Q3 | |
Curio Collection by Hilton | 140.97 | 39.83 | Q4 2020 | 2020 | Q4 | |
Curio Collection by Hilton | 172.34 | 59.99 | Q1 2021 | 2021 | Q1 | |
Curio Collection by Hilton | 190.58 | 93.02 | Q2 2021 | 2021 | Q2 | |
Curio Collection by Hilton | 203.87 | 114.70 | Q3 2021 | 2021 | Q3 | |
Curio Collection by Hilton | 212.69 | 125.62 | Q4 2021 | 2021 | Q4 | |
Curio Collection by Hilton | 214.50 | 112.83 | Q1 2022 | 2022 | Q1 | |
Curio Collection by Hilton | 230.02 | 149.34 | Q2 2022 | 2022 | Q2 | |
DoubleTree by Hilton | 130.74 | 91.85 | Q1 2019 | 2019 | Q1 | |
DoubleTree by Hilton | 134.84 | 104.24 | Q2 2019 | 2019 | Q2 | |
DoubleTree by Hilton | 130.69 | 101.90 | Q3 2019 | 2019 | Q3 | |
DoubleTree by Hilton | 128.76 | 91.98 | Q4 2019 | 2019 | Q4 | |
DoubleTree by Hilton | 127.86 | 64.75 | Q1 2020 | 2020 | Q1 | |
DoubleTree by Hilton | 90.78 | 15.71 | Q2 2020 | 2020 | Q2 | |
DoubleTree by Hilton | 97.67 | 34.53 | Q3 2020 | 2020 | Q3 | |
DoubleTree by Hilton | 91.65 | 31.33 | Q4 2020 | 2020 | Q4 | |
DoubleTree by Hilton | 96.58 | 34.89 | Q1 2021 | 2021 | Q1 | |
DoubleTree by Hilton | 113.09 | 57.29 | Q2 2021 | 2021 | Q2 | |
DoubleTree by Hilton | 128.09 | 73.72 | Q3 2021 | 2021 | Q3 | |
DoubleTree by Hilton | 124.55 | 69.55 | Q4 2021 | 2021 | Q4 | |
DoubleTree by Hilton | 127.02 | 67.24 | Q1 2022 | 2022 | Q1 | |
DoubleTree by Hilton | 139.89 | 92.55 | Q2 2022 | 2022 | Q2 | |
Embassy Suites by Hilton | 163.98 | 124.61 | Q1 2019 | 2019 | Q1 | |
Embassy Suites by Hilton | 168.37 | 138.22 | Q2 2019 | 2019 | Q2 | |
Embassy Suites by Hilton | 164.00 | 131.83 | Q3 2019 | 2019 | Q3 | |
Embassy Suites by Hilton | 157.23 | 116.86 | Q4 2019 | 2019 | Q4 | |
Embassy Suites by Hilton | 156.20 | 93.67 | Q1 2020 | 2020 | Q1 | |
Embassy Suites by Hilton | 113.09 | 18.95 | Q2 2020 | 2020 | Q2 | |
Embassy Suites by Hilton | 122.61 | 44.81 | Q3 2020 | 2020 | Q3 | |
Embassy Suites by Hilton | 113.91 | 40.51 | Q4 2020 | 2020 | Q4 | |
Embassy Suites by Hilton | 119.98 | 51.91 | Q1 2021 | 2021 | Q1 | |
Embassy Suites by Hilton | 144.06 | 84.17 | Q2 2021 | 2021 | Q2 | |
Embassy Suites by Hilton | 162.46 | 101.93 | Q3 2021 | 2021 | Q3 | |
Embassy Suites by Hilton | 155.14 | 95.45 | Q4 2021 | 2021 | Q4 | |
Embassy Suites by Hilton | 161.99 | 96.52 | Q1 2022 | 2022 | Q1 | |
Embassy Suites by Hilton | 178.27 | 130.52 | Q2 2022 | 2022 | Q2 | |
Hampton by Hilton | 118.58 | 81.35 | Q1 2019 | 2019 | Q1 | |
Hampton by Hilton | 125.50 | 98.68 | Q2 2019 | 2019 | Q2 | |
Hampton by Hilton | 125.00 | 97.98 | Q3 2019 | 2019 | Q3 | |
Hampton by Hilton | 116.82 | 81.40 | Q4 2019 | 2019 | Q4 | |
Hampton by Hilton | 113.25 | 63.13 | Q1 2020 | 2020 | Q1 | |
Hampton by Hilton | 92.08 | 25.07 | Q2 2020 | 2020 | Q2 | |
Hampton by Hilton | 98.62 | 50.46 | Q3 2020 | 2020 | Q3 | |
Hampton by Hilton | 91.48 | 42.28 | Q4 2020 | 2020 | Q4 | |
Hampton by Hilton | 92.47 | 46.38 | Q1 2021 | 2021 | Q1 | |
Hampton by Hilton | 112.20 | 74.67 | Q2 2021 | 2021 | Q2 | |
Hampton by Hilton | 127.17 | 90.41 | Q3 2021 | 2021 | Q3 | |
Hampton by Hilton | 118.35 | 76.69 | Q4 2021 | 2021 | Q4 | |
Hampton by Hilton | 118.90 | 71.98 | Q1 2022 | 2022 | Q1 | |
Hampton by Hilton | 133.46 | 97.19 | Q2 2022 | 2022 | Q2 | |
Hilton Garden Inn | 127.77 | 91.57 | Q1 2019 | 2019 | Q1 | |
Hilton Garden Inn | 136.75 | 109.11 | Q2 2019 | 2019 | Q2 | |
Hilton Garden Inn | 132.94 | 105.37 | Q3 2019 | 2019 | Q3 | |
Hilton Garden Inn | 128.27 | 92.24 | Q4 2019 | 2019 | Q4 | |
Hilton Garden Inn | 121.82 | 69.02 | Q1 2020 | 2020 | Q1 | |
Hilton Garden Inn | 90.46 | 20.22 | Q2 2020 | 2020 | Q2 | |
Hilton Garden Inn | 96.43 | 41.23 | Q3 2020 | 2020 | Q3 | |
Hilton Garden Inn | 89.32 | 36.14 | Q4 2020 | 2020 | Q4 | |
Hilton Garden Inn | 92.66 | 42.51 | Q1 2021 | 2021 | Q1 | |
Hilton Garden Inn | 113.90 | 68.61 | Q2 2021 | 2021 | Q2 | |
Hilton Garden Inn | 130.36 | 86.55 | Q3 2021 | 2021 | Q3 | |
Hilton Garden Inn | 124.40 | 76.92 | Q4 2021 | 2021 | Q4 | |
Hilton Garden Inn | 124.60 | 73.56 | Q1 2022 | 2022 | Q1 | |
Hilton Garden Inn | 143.48 | 102.91 | Q2 2022 | 2022 | Q2 | |
Hilton Hotels & Resorts | 168.73 | 121.76 | Q1 2019 | 2019 | Q1 | |
Hilton Hotels & Resorts | 175.44 | 139.31 | Q2 2019 | 2019 | Q2 | |
Hilton Hotels & Resorts | 170.83 | 135.70 | Q3 2019 | 2019 | Q3 | |
Hilton Hotels & Resorts | 168.37 | 125.06 | Q4 2019 | 2019 | Q4 | |
Hilton Hotels & Resorts | 164.17 | 88.46 | Q1 2020 | 2020 | Q1 | |
Hilton Hotels & Resorts | 107.65 | 14.04 | Q2 2020 | 2020 | Q2 | |
Hilton Hotels & Resorts | 121.24 | 34.93 | Q3 2020 | 2020 | Q3 | |
Hilton Hotels & Resorts | 119.33 | 35.40 | Q4 2020 | 2020 | Q4 | |
Hilton Hotels & Resorts | 125.83 | 37.90 | Q1 2021 | 2021 | Q1 | |
Hilton Hotels & Resorts | 145.69 | 63.54 | Q2 2021 | 2021 | Q2 | |
Hilton Hotels & Resorts | 162.94 | 84.34 | Q3 2021 | 2021 | Q3 | |
Hilton Hotels & Resorts | 161.82 | 86.22 | Q4 2021 | 2021 | Q4 | |
Hilton Hotels & Resorts | 169.18 | 83.85 | Q1 2022 | 2022 | Q1 | |
Hilton Hotels & Resorts | 186.11 | 120.67 | Q2 2022 | 2022 | Q2 | |
Home2 Suites by Hilton | 114.78 | 86.41 | Q1 2019 | 2019 | Q1 | |
Home2 Suites by Hilton | 120.75 | 101.04 | Q2 2019 | 2019 | Q2 | |
Home2 Suites by Hilton | 118.99 | 97.53 | Q3 2019 | 2019 | Q3 | |
Home2 Suites by Hilton | 113.13 | 83.10 | Q4 2019 | 2019 | Q4 | |
Home2 Suites by Hilton | 110.84 | 69.87 | Q1 2020 | 2020 | Q1 | |
Home2 Suites by Hilton | 93.46 | 37.43 | Q2 2020 | 2020 | Q2 | |
Home2 Suites by Hilton | 99.37 | 63.02 | Q3 2020 | 2020 | Q3 | |
Home2 Suites by Hilton | 94.51 | 54.75 | Q4 2020 | 2020 | Q4 | |
Home2 Suites by Hilton | 96.63 | 62.38 | Q1 2021 | 2021 | Q1 | |
Home2 Suites by Hilton | 112.99 | 88.67 | Q2 2021 | 2021 | Q2 | |
Home2 Suites by Hilton | 124.14 | 100.64 | Q3 2021 | 2021 | Q3 | |
Home2 Suites by Hilton | 119.32 | 88.67 | Q4 2021 | 2021 | Q4 | |
Home2 Suites by Hilton | 123.65 | 91.16 | Q1 2022 | 2022 | Q1 | |
Home2 Suites by Hilton | 138.64 | 112.93 | Q2 2022 | 2022 | Q2 | |
Homewood Suites by Hilton | 138.46 | 106.78 | Q1 2019 | 2019 | Q1 | |
Homewood Suites by Hilton | 144.79 | 122.06 | Q2 2019 | 2019 | Q2 | |
Homewood Suites by Hilton | 143.00 | 120.04 | Q3 2019 | 2019 | Q3 | |
Homewood Suites by Hilton | 135.32 | 103.32 | Q4 2019 | 2019 | Q4 | |
Homewood Suites by Hilton | 131.70 | 86.49 | Q1 2020 | 2020 | Q1 | |
Homewood Suites by Hilton | 103.65 | 42.06 | Q2 2020 | 2020 | Q2 | |
Homewood Suites by Hilton | 110.02 | 68.41 | Q3 2020 | 2020 | Q3 | |
Homewood Suites by Hilton | 104.51 | 60.37 | Q4 2020 | 2020 | Q4 | |
Homewood Suites by Hilton | 105.82 | 67.94 | Q1 2021 | 2021 | Q1 | |
Homewood Suites by Hilton | 122.02 | 93.26 | Q2 2021 | 2021 | Q2 | |
Homewood Suites by Hilton | 136.69 | 109.43 | Q3 2021 | 2021 | Q3 | |
Homewood Suites by Hilton | 133.66 | 99.33 | Q4 2021 | 2021 | Q4 | |
Homewood Suites by Hilton | 135.97 | 100.09 | Q1 2022 | 2022 | Q1 | |
Homewood Suites by Hilton | 153.96 | 125.89 | Q2 2022 | 2022 | Q2 | |
Tapestry Collection by Hilton | 127.11 | 67.08 | Q1 2020 | 2020 | Q1 | |
Tapestry Collection by Hilton | 98.85 | 28.59 | Q2 2020 | 2020 | Q2 | |
Tapestry Collection by Hilton | 116.63 | 50.45 | Q3 2020 | 2020 | Q3 | |
Tapestry Collection by Hilton | 111.77 | 44.06 | Q4 2020 | 2020 | Q4 | |
Tapestry Collection by Hilton | 112.46 | 42.13 | Q1 2021 | 2021 | Q1 | |
Tapestry Collection by Hilton | 136.53 | 71.17 | Q2 2021 | 2021 | Q2 | |
Tapestry Collection by Hilton | 154.38 | 99.86 | Q3 2021 | 2021 | Q3 | |
Tapestry Collection by Hilton | 151.38 | 90.32 | Q4 2021 | 2021 | Q4 | |
Tapestry Collection by Hilton | 145.89 | 78.48 | Q1 2022 | 2022 | Q1 | |
Tapestry Collection by Hilton | 173.40 | 117.86 | Q2 2022 | 2022 | Q2 | |
Tru by Hilton | 99.63 | 62.84 | Q1 2019 | 2019 | Q1 | |
Tru by Hilton | 109.04 | 80.05 | Q2 2019 | 2019 | Q2 | |
Tru by Hilton | 115.33 | 89.70 | Q3 2019 | 2019 | Q3 | |
Tru by Hilton | 99.19 | 68.59 | Q4 2019 | 2019 | Q4 | |
Tru by Hilton | 95.16 | 50.63 | Q1 2020 | 2020 | Q1 | |
Tru by Hilton | 81.62 | 24.31 | Q2 2020 | 2020 | Q2 | |
Tru by Hilton | 90.00 | 50.08 | Q3 2020 | 2020 | Q3 | |
Tru by Hilton | 85.89 | 42.88 | Q4 2020 | 2020 | Q4 | |
Tru by Hilton | 83.84 | 44.83 | Q1 2021 | 2021 | Q1 | |
Tru by Hilton | 105.41 | 73.25 | Q2 2021 | 2021 | Q2 | |
Tru by Hilton | 123.47 | 91.40 | Q3 2021 | 2021 | Q3 | |
Tru by Hilton | 111.64 | 72.92 | Q4 2021 | 2021 | Q4 | |
Tru by Hilton | 112.29 | 70.86 | Q1 2022 | 2022 | Q1 | |
Tru by Hilton | 128.33 | 95.81 | Q2 2022 | 2022 | Q2 | |
Waldorf Astoria Hotels & Resorts | 384.45 | 275.51 | Q1 2019 | 2019 | Q1 | |
Waldorf Astoria Hotels & Resorts | 367.61 | 269.84 | Q2 2019 | 2019 | Q2 | |
Waldorf Astoria Hotels & Resorts | 353.40 | 239.67 | Q3 2019 | 2019 | Q3 | |
Waldorf Astoria Hotels & Resorts | 366.03 | 265.81 | Q4 2019 | 2019 | Q4 | |
Waldorf Astoria Hotels & Resorts | 423.71 | 224.76 | Q1 2020 | 2020 | Q1 | |
Waldorf Astoria Hotels & Resorts | 280.27 | 18.41 | Q2 2020 | 2020 | Q2 | |
Waldorf Astoria Hotels & Resorts | 247.26 | 79.30 | Q3 2020 | 2020 | Q3 | |
Waldorf Astoria Hotels & Resorts | 352.37 | 101.81 | Q4 2020 | 2020 | Q4 | |
Waldorf Astoria Hotels & Resorts | 573.77 | 183.51 | Q1 2021 | 2021 | Q1 | |
Waldorf Astoria Hotels & Resorts | 499.78 | 234.79 | Q2 2021 | 2021 | Q2 | |
Waldorf Astoria Hotels & Resorts | 500.93 | 233.15 | Q3 2021 | 2021 | Q3 | |
Waldorf Astoria Hotels & Resorts | 596.43 | 328.51 | Q4 2021 | 2021 | Q4 | |
Waldorf Astoria Hotels & Resorts | 599.50 | 286.03 | Q1 2022 | 2022 | Q1 | |
Waldorf Astoria Hotels & Resorts | 464.07 | 266.46 | Q2 2022 | 2022 | Q2 |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment