sum(interactions_count) OVER (PARTITION BY period_start_at) ranK() OVER (PARTITION BY period_start_at ORDER BY market_share DESC) WHERE rank <= 5
period_start_at | rank | market_share | show_id | name | interactions_count | day_interactions_count
---------------------+------+--------------+--------------------------------------+---------------------------+--------------------+------------------------
2011-10-17 00:00:00 | 1 | 67.7 | 71692ae2-daec-11e0-9b8e-40402761cfca | Occupation double | 19652 | 29039
2011-10-17 00:00:00 | 2 | 10.6 | 71691cfa-daec-11e0-9b8e-40402761cfca | TVA NOUVELLES | 3078 | 29039
2011-10-17 00:00:00 | 3 | 7.8 | 71689eba-daec-11e0-9b8e-40402761cfca | Tout le monde en parle | 2264 | 29039
2011-10-17 00:00:00 | 4 | 3.1 | 71681dd2-daec-11e0-9b8e-40402761cfca | Un souper presque parfait | 911 | 29039
2011-10-17 00:00:00 | 5 | 2.1 | 7169cc22-daec-11e0-9b8e-40402761cfca | La Galère | 611 | 29039
2011-10-18 00:00:00 | 1 | 44.8 | 71692ae2-daec-11e0-9b8e-40402761cfca | Occupation double | 6140 | 13713
2011-10-18 00:00:00 | 2 | 15.1 | 71691cfa-daec-11e0-9b8e-40402761cfca | TVA NOUVELLES | 2075 | 13713
2011-10-18 00:00:00 | 3 | 8.6 | 7169cc22-daec-11e0-9b8e-40402761cfca | La Galère | 1181 | 13713
2011-10-18 00:00:00 | 4 | 5.1 | 71681dd2-daec-11e0-9b8e-40402761cfca | Un souper presque parfait | 699 | 13713
2011-10-18 00:00:00 | 5 | 3.9 | d427f470-dd5c-012e-ebb7-40400fe46aa7 | Star Académie | 531 | 13713
2011-10-19 00:00:00 | 1 | 45.6 | 71692ae2-daec-11e0-9b8e-40402761cfca | Occupation double | 7017 | 15375
2011-10-19 00:00:00 | 2 | 24.7 | 71691cfa-daec-11e0-9b8e-40402761cfca | TVA NOUVELLES | 3795 | 15375
2011-10-19 00:00:00 | 3 | 10.5 | 71681dd2-daec-11e0-9b8e-40402761cfca | Un souper presque parfait | 1617 | 15375
2011-10-19 00:00:00 | 4 | 3.2 | 7168f630-daec-11e0-9b8e-40402761cfca | Salut, Bonjour! | 491 | 15375
2011-10-19 00:00:00 | 5 | 1.9 | 7169d442-daec-11e0-9b8e-40402761cfca | Mirador | 296 | 15375
2011-10-20 00:00:00 | 1 | 27.4 | 71691cfa-daec-11e0-9b8e-40402761cfca | TVA NOUVELLES | 2480 | 9045
2011-10-20 00:00:00 | 2 | 18.9 | d427f470-dd5c-012e-ebb7-40400fe46aa7 | Star Académie | 1707 | 9045
2011-10-20 00:00:00 | 3 | 14.9 | 71681dd2-daec-11e0-9b8e-40402761cfca | Un souper presque parfait | 1349 | 9045
2011-10-20 00:00:00 | 4 | 6.4 | 71692ae2-daec-11e0-9b8e-40402761cfca | Occupation double | 582 | 9045
2011-10-20 00:00:00 | 5 | 5.7 | 7168f630-daec-11e0-9b8e-40402761cfca | Salut, Bonjour! | 512 | 9045
2011-10-21 00:00:00 | 1 | 33.0 | d427f470-dd5c-012e-ebb7-40400fe46aa7 | Star Académie | 3620 | 10957
2011-10-21 00:00:00 | 2 | 25.0 | 71691cfa-daec-11e0-9b8e-40402761cfca | TVA NOUVELLES | 2740 | 10957
2011-10-21 00:00:00 | 3 | 10.6 | 71692ae2-daec-11e0-9b8e-40402761cfca | Occupation double | 1163 | 10957
2011-10-21 00:00:00 | 4 | 6.1 | 71681dd2-daec-11e0-9b8e-40402761cfca | Un souper presque parfait | 664 | 10957
2011-10-21 00:00:00 | 5 | 3.2 | 71684690-daec-11e0-9b8e-40402761cfca | Un gars le soir | 356 | 10957
2011-10-22 00:00:00 | 1 | 34.4 | 71691cfa-daec-11e0-9b8e-40402761cfca | TVA NOUVELLES | 1224 | 3561
2011-10-22 00:00:00 | 2 | 13.4 | 7168f630-daec-11e0-9b8e-40402761cfca | Salut, Bonjour! | 478 | 3561
2011-10-22 00:00:00 | 3 | 12.6 | 7168b846-daec-11e0-9b8e-40402761cfca | C’est juste de la tv | 448 | 3561
2011-10-22 00:00:00 | 4 | 6.8 | 71692ae2-daec-11e0-9b8e-40402761cfca | Occupation double | 241 | 3561
2011-10-22 00:00:00 | 5 | 4.5 | 71681dd2-daec-11e0-9b8e-40402761cfca | Un souper presque parfait | 159 | 3561