Stock Market Predictions
Contains daily news for stock market predictions
@kaggle.tanishqdublish_stock_market_predictions
Combined News Djia
@kaggle.tanishqdublish_stock_market_predictions.combined_news_djia
- 3.96 MB
- 1989 rows
- 27 columns
dateDate | labelLabel | top1Top1 | top2Top2 | top3Top3 | top4Top4 | top5Top5 | top6Top6 | top7Top7 | top8Top8 | top9Top9 | top10Top10 | top11Top11 | top12Top12 | top13Top13 | top14Top14 | top15Top15 | top16Top16 | top17Top17 | top18Top18 | top19Top19 | top20Top20 | top21Top21 | top22Top22 | top23Top23 | top24Top24 | top25Top25 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Fri Aug 08 2008 00:00:00 GMT+0000 (Coordinated Universal Time) | b"Georgia 'downs two Russian warplanes' as countries move to brink of war" | b'BREAKING: Musharraf to be impeached.' | b'Russia Today: Columns of troops roll into South Ossetia; footage from fighting (YouTube)' | b'Russian tanks are moving towards the capital of South Ossetia, which has reportedly been completely destroyed by Georgian artillery fire' | b"Afghan children raped with 'impunity,' U.N. official says - this is sick, a three year old was raped and they do nothing" | b'150 Russian tanks have entered South Ossetia whilst Georgia shoots down two Russian jets.' | b"Breaking: Georgia invades South Ossetia, Russia warned it would intervene on SO's side" | b"The 'enemy combatent' trials are nothing but a sham: Salim Haman has been sentenced to 5 1/2 years, but will be kept longer anyway just because they feel like it." | b'Georgian troops retreat from S. Osettain capital, presumably leaving several hundred people killed. [VIDEO]' | b'Did the U.S. Prep Georgia for War with Russia?' | b'Rice Gives Green Light for Israel to Attack Iran: Says U.S. has no veto over Israeli military ops' | b'Announcing:Class Action Lawsuit on Behalf of American Public Against the FBI' | b"So---Russia and Georgia are at war and the NYT's top story is opening ceremonies of the Olympics? What a fucking disgrace and yet further proof of the decline of journalism." | b"China tells Bush to stay out of other countries' affairs" | b'Did World War III start today?' | b'Georgia Invades South Ossetia - if Russia gets involved, will NATO absorb Georgia and unleash a full scale war?' | b'Al-Qaeda Faces Islamist Backlash' | b'Condoleezza Rice: "The US would not act to prevent an Israeli strike on Iran." Israeli Defense Minister Ehud Barak: "Israel is prepared for uncompromising victory in the case of military hostilities."' | b'This is a busy day: The European Union has approved new sanctions against Iran in protest at its nuclear programme.' | b"Georgia will withdraw 1,000 soldiers from Iraq to help fight off Russian forces in Georgia's breakaway region of South Ossetia" | b'Why the Pentagon Thinks Attacking Iran is a Bad Idea - US News & World Report' | b'Caucasus in crisis: Georgia invades South Ossetia' | b'Indian shoe manufactory - And again in a series of "you do not like your work?"' | b'Visitors Suffering from Mental Illnesses Banned from Olympics' | b"No Help for Mexico's Kidnapping Surge" | |
| Mon Aug 11 2008 00:00:00 GMT+0000 (Coordinated Universal Time) | 1 | b'Why wont America and Nato help us? If they wont help us now, why did we help them in Iraq?' | b'Bush puts foot down on Georgian conflict' | b"Jewish Georgian minister: Thanks to Israeli training, we're fending off Russia " | b'Georgian army flees in disarray as Russians advance - Gori abandoned to Russia without a shot fired' | b"Olympic opening ceremony fireworks 'faked'" | b'What were the Mossad with fraudulent New Zealand Passports doing in Iraq?' | b'Russia angered by Israeli military sale to Georgia' | b'An American citizen living in S.Ossetia blames U.S. and Georgian leaders for the genocide of innocent people' | b'Welcome To World War IV! Now In High Definition!' | b"Georgia's move, a mistake of monumental proportions " | b'Russia presses deeper into Georgia; U.S. says regime change is goal' | b'Abhinav Bindra wins first ever Individual Olympic Gold Medal for India' | b' U.S. ship heads for Arctic to define territory' | b'Drivers in a Jerusalem taxi station threaten to quit rather than work for their new boss - an Arab' | b'The French Team is Stunned by Phelps and the 4x100m Relay Team' | b'Israel and the US behind the Georgian aggression?' | b'"Do not believe TV, neither Russian nor Georgian. There are much more victims"' | b'Riots are still going on in Montreal (Canada) because police murdered a boy on Saturday.' | b'China to overtake US as largest manufacturer' | b'War in South Ossetia [PICS]' | b'Israeli Physicians Group Condemns State Torture' | b' Russia has just beaten the United States over the head with Peak Oil' | b'Perhaps *the* question about the Georgia - Russia conflict ' | b'Russia is so much better at war' | b"So this is what it's come to: trading sex for food." |
| Tue Aug 12 2008 00:00:00 GMT+0000 (Coordinated Universal Time) | b'Remember that adorable 9-year-old who sang at the opening ceremonies? That was fake, too.' | b"Russia 'ends Georgia operation'" | b'"If we had no sexual harassment we would have no children..."' | b"Al-Qa'eda is losing support in Iraq because of a brutal crackdown on activities it regards as un-Islamic - including women buying cucumbers" | b'Ceasefire in Georgia: Putin Outmaneuvers the West' | b'Why Microsoft and Intel tried to kill the XO $100 laptop' | b'Stratfor: The Russo-Georgian War and the Balance of Power ' | b"I'm Trying to Get a Sense of This Whole Georgia-Russia War: Vote Up If You Think Georgia Started It, Or Down If you Think Russia Did" | b"The US military was surprised by the timing and swiftness of the Russian military's move into South Ossetia and is still trying to sort out what happened, a US defense official said Monday" | b'U.S. Beats War Drum as Iran Dumps the Dollar' | b'Gorbachev: "Georgian military attacked the South Ossetian capital of Tskhinvali with multiple rocket launchers designed to devastate large areas"' | b'CNN use footage of Tskhinvali ruins to cover Georgian report [VIDEO]' | b'Beginning a war as the Olympics were opening violates the ancient tradition of a truce to conflict during the Games. The IOC could respond by taking the 2014 games away from Russia.' | b'55 pyramids as large as the Luxor stacked into a mega-city pyramid in Tokyo Bay' | b'The 11 Top Party Cities in the World' | b'U.S. troops still in Georgia (did you know they were in Georgia in the first place?)' | b'Why Russias response to Georgia was right' | b'Gorbachev accuses U.S. of making a "serious blunder" in pursuing its interest in the Caucasus region' | b'Russia, Georgia, and NATO: Cold War Two' | b'Remember that adorable 62-year-old who led your country into war based on evidence? That was fake, too.' | b'War in Georgia: The Israeli connection' | b'All signs point to the US encouraging Georgia to invade South Ossetia. Goddamnit Bush.' | b'Christopher King argues that the US and NATO are behind the Georgian invasion of South Ossetia but have misjudged Russian resolve. ' | b'America: The New Mexico?' | b"BBC NEWS | Asia-Pacific | Extinction 'by man not climate'" | |
| Wed Aug 13 2008 00:00:00 GMT+0000 (Coordinated Universal Time) | b' U.S. refuses Israel weapons to attack Iran: report' | b"When the president ordered to attack Tskhinvali [the capital of South Ossetia], we knew then we were doomed. How come he didn't realize that?" | b' Israel clears troops who killed Reuters cameraman' | b'Britain\'s policy of being tough on drugs is "pointless", says a former civil servant who once ran the Cabinet\'s anti-drugs unit.' | b'Body of 14 year old found in trunk; Latest (ransom paid) kidnapping victim in Mexico. Head cop quits, Prez dissolves suspect elite task force' | b'China has moved 10 *million* quake survivors into prefab homes' | b"Bush announces Operation Get All Up In Russia's Grill. Yeah, this will end well." | b'Russian forces sink Georgian ships ' | b"The commander of a Navy air reconnaissance squadron that provides the President and the defense secretary the airborne ability to command the nation's nuclear weapons has been relieved of duty" | b"92% of CNN readers: Russia's actions in Georgia - justified!" | b'USA to send fleet into Black Sea to help Georgia, send troops in "humanitarian aid exercise"' | b"US warns against Israeli plan to strike against Iran's nuclear facilities" | b"In an intriguing cyberalliance, two Estonian computer experts are heading to Georgia to keep the country's networks running amid an intense military confrontation with Russia" | b'The CNN Effect: Georgia Schools Russia in Information Warfare' | b'Why Russias response to Georgia was right' | b'Elephants extinct by 2020?' | b'US humanitarian missions soon in Georgia - if Russia hits the US - WWIII?' | b"Georgia's DDOS came from US sources" | b'Russian convoy heads into Georgia, violating truce' | b'Israeli defence minister: US against strike on Iran' | b'Gorbachev: We Had No Choice' | b'Witness: Russian forces head towards Tbilisi in breach of ceasefire agreement' | b' Quarter of Russians blame U.S. for conflict: poll' | b'Georgian president says US military will take control of seaports and airports - Pentagon denies' | b'2006: Nobel laureate Aleksander Solzhenitsyn accuses U.S., NATO of encircling Russia' | |
| Thu Aug 14 2008 00:00:00 GMT+0000 (Coordinated Universal Time) | 1 | b'All the experts admit that we should legalise drugs ' | b'War in South Osetia - 89 pictures made by a Russian soldier.' | b'Swedish wrestler Ara Abrahamian throws away medal in Olympic hissy fit ' | b'Russia exaggerated the death toll in South Ossetia. Now only 44 were originally killed compared to 2,000.' | b'Missile That Killed 9 Inside Pakistan May Have Been Launched by the CIA' | b"Rushdie Condemns Random House's Refusal to Publish Novel for Fear of Muslim Retaliation" | b'Poland and US agree to missle defense deal. Interesting timing!' | b'Will the Russians conquer Tblisi? Bet on it, no seriously you can BET on it' | b'Russia exaggerating South Ossetian death toll, says human rights group' | b' Musharraf expected to resign rather than face impeachment' | b'Moscow Made Plans Months Ago to Invade Georgia' | b'Why Russias response to Georgia was right' | b'Nigeria has handed over the potentially oil-rich Bakassi peninsula to Cameroon.' | b'The US and Poland have agreed a preliminary deal on plans for the controversial US defence shield' | b'Russia apparently is sabotaging infrastructure to cripple the already battered Georgian military.' | b'Bank analyst forecast Georgian crisis 2 days early' | b"Georgia confict could set back Russia's US relations 'for years' | World news | guardian.co.uk" | b'War in the Caucasus is as much the product of an American imperial drive as local conflicts.' | b'"Non-media" photos of South Ossetia/Georgia conflict.' | b'Georgian TV reporter shot by Russian sniper during live broadcast [video]' | b'Saudi Arabia: Mother moves to block child marriage' | b'Taliban wages war on humanitarian aid workers' | b'Russia: World "can forget about" Georgia\'s territorial integrity' | b'Darfur rebels accuse Sudan of mounting major attack' | b'Philippines : Peace Advocate say Muslims need assurance Christians not out to convert them' |
| Fri Aug 15 2008 00:00:00 GMT+0000 (Coordinated Universal Time) | 1 | b"Mom of missing gay man: Too bad he's not a 21-year-old cheerleader, then they'd still be looking for him" | b"Russia: U.S. Poland Missile Deal Won't Go 'Unpunished'" | b"The government has been accused of creating laws that have a chilling effect on freedom of expression in the UK in a critical report from the UN's committee on human rights" | b'The Italian government has lashed out at an influential Catholic magazine which suggested fascism might be resurfacing within the government.' | b'Gorbachev: Georgia started conflict in S. Ossetia' | b"China fakes more than your girlfriend; 'Ethnic minority' children at Olympics ceremony were fake too!" | b"The UN's criticism of freedom of expression in the UK are valid" | b'Russian general threatens nuclear strike on Poland as Bush demands Moscow withdraws from Georgia' | b'Russia can inspect Polish missile defence site' | b'Russia-Georgia Conflict Fueled by Rush to Control Caspian Energy Resources' | b"Business Week: Victory in Georgia gives Russia the edge in the struggle over access to the Caspian's 35 billion barrels of oil and trillions of cubic feet of gas" | b"Under Soviet rule we didn't believe a word of our own propaganda... But we have learnt... that the West has its own propaganda and... is more powerful because people believe it." | b'Ministers have been accused of building a national DNA database "by stealth" by retaining profiles of nearly 40,000 children never convicted of a crime.' | b"Russia: Georgia can 'forget' regaining provinces" | b"Russians 'Seize US Weapons Depot' in Georgia" | b'Why are redditors generally supportive of Russias invasion of Georgia, but critical of Americas in Iraq?' | b'Johann Hari: We need to stop being such cowards about Islam' | b'US officials have said that their military presence in Georgia will now become permanent' | b'Israel clears troops who killed Reuters cameraman' | b'Unenforceable laws encourage cops to escalate their tactics -- until tragedy occurs' | b'What Chinese pollution really looks like' | b'Hacker Kidnaps and Tortures Informant, Posts Picture as a Warning to Others' | b'Bush Tells Putin: This Aggression Will Not Stand' | b'Georgia is all about the oil pipelines' | b'Rivals say they plan to remove Georgian president' |
| Mon Aug 18 2008 00:00:00 GMT+0000 (Coordinated Universal Time) | b'In an Afghan prison, the majority of female prisoners are serving 20-year sentences for being victims of rape ' | b"Little girl, you're not ugly; they are" | b"Pakistan's Musharraf to Resign, Leave the Country" | b'Tornado throws a bus in Poland, captured by one of the passengers' | b"Britain's terror laws have left me and my family shattered" | b"Iran 'fires satellite into space'" | b'Rights of Non-Muslims restricted by new Maldives constitution' | b'Tour of Tskhinvali undercuts Russian version of fighting' | b'The Great Resource War is already underway, mainly in the Middle East, but also in smaller skirmishes scattered areas around the world, disguised to many as the Global War on Terror. ' | b'Over 190,000 US contractors working in Iraq' | b'Russia moves SS-21 missiles into Georgia: US defense official' | b'a President says he is resigning "to avoid an impeachment battle that would harm the nation\'s interests"' | b'"Democratic" Georgia shuts down an opposition TV channel owned by Russians' | b'New Cold War is an option -- Russian parliamentarian ' | b'Georgian Situation Continues the Quest for The Prize of Oil, Money and Power' | b'MI5 seeks gay spies' | b' New porn channel lets Canadians strut their stuff' | b'The Dangerous Neighbor: Vladimir Putin Takes on a Powerless West' | b'Israel opinion page: Russians are saner.' | b"NATO's Hour" | b'Georgian President Saakashvili Eats His Tie on Live TV' | b'No Chicken Left Behind: Animal RFID Surveillance Arrives in Force' | b'Putin has given us an order that everyone must leave or be shot' | b'National DNA database grows on the genes of the innocent' | b'Mayor Asks Ugly Women To Visit His Town' | |
| Tue Aug 19 2008 00:00:00 GMT+0000 (Coordinated Universal Time) | b"Man arrested and locked up for five hours after taking photo of police van ignoring 'no entry' sign" | b'The US missile defence system is the magic pudding that will never run out' | b'Schrder lambasted for blaming Russian conflict on Georgia' | b'Officials: 10 French soldiers killed near Kabul ' | b'These ten laws make China a totalitarian wasteland' | b'Russia seizes US vehicles' | b"Muslims are only 4% of Denmark's 5.4 million people but make up a majority of the country's convicted rapists. Practically all the female victims are non-Muslim." | b'Taliban Forces Kill 10 French Soldiers and Raid U.S. Base' | b'Assaults, kidnappings and killings of humanitarian aid workers have more than doubled in the past five years' | b"South Ossetia Isn't Kosovo" | b'Finally, an Olympic image to take your mind off Michael Phelps ... [pic]' | b'New York laser graffiti artist detained indefinitely in Beijing for Tibet Protest art' | b'US left isolated over Nato plans to maintain relations with Russia' | b"Driven: Shai Agassi's Audacious Plan to Put Electric Cars on the Road" | b' NATO freezes Russian ties over Georgia' | b'Brazil Will Play Military War Game to Defend Recently Discovered Offshore Oil' | b'16,000 fine for British woman caught sharing game online' | b'102-year-old grandma is oldest person on Facebook' | b'Today 5 years ago - August 19th 2003. Bombing of the UN headquarters in Iraq' | b'US national Ken Haywood, whose computer was found to send threat emails after serial bomb blasts in India, flees the country.' | b' Taliban kill 10 French troops near Afghan capital' | b'Not Everybody Loves Offshore Wind Power in Spain' | b'Taliban Forces Kill 10 French Soldiers and Raid U.S. Base ' | b'Pakistan is more democratic than America. ' | b'Blaze engulfs Egyptian parliament' | |
| Wed Aug 20 2008 00:00:00 GMT+0000 (Coordinated Universal Time) | 1 | b'Two elderly Chinese women have been sentenced to a year of re-education through labor after they sought a permit to demonstrate in an official Olympic protest area.' | b'The Power of Islam: The Human Rights Council at the United Nations has now banned any criticism regarding Sharia Law and human rights in the Islamic World' | b"We had 55 times more military soldiers in the first Gulf War than contractors. In the current Iraq war, the ratio's 1:1." | b'"I live here on less than a dollar a month" -- Obama\'s brother, Kenya shanty town ' | b'Russia sends aircraft carrier to Syria.' | b'The American people should be eternally grateful to Old Europe for having spiked the Bush-McCain plan to bring Georgia into NATO.' | b'Abkhazia officially appeals to Russia for independence' | b'Russia warns of response "beyond diplomacy" against US missile shield' | b'India Sets Aside 40% of Regional Wasteland for Jatropha Biodiesel Production' | b'Elderly Chinese Women Sentenced to Labor Re-education After Applying for Permission to Protest at the Olympics' | b'Plane skids off runway in Madrid' | b'Taliban mount ferocious assaults on allied targets' | b'150 Feared Dead In Spanair Plane Crash In Madrid ' | b'Was Western Intelligence involved in terrorist attacks in India? A westerners computer Internet connection was used to send terror e-mail minutes before Ahmedabad blasts. ' | b'Spanish Freedom of Speech Dies an Ignoble Death so that Spanish Parasites Will Not be Offended. ' | b'Grote Markt [PIC]' | b'Russia has informed Norway that it plans to cut all military ties with NATO' | b"'What Are the Aims of this War?': French Opposition Demands Rethink of Afghanistan Mission" | b'Bush Covered up Musharraf Ties with Al Qaeda' | b'Mikhail Gorbachev: Russia Never Wanted a War' | b'Germans urge tougher laws after new privacy scandal ' | b'The Time of the Wimps: Dialogue with Russia Is the Only Choice' | b'1998 Missile Strikes on Bin Laden May Have Backfired' | b"For a moment let's forget everything else and pay homage to these unsung heroes" | b'The First Solar Radio Station in Argentina' |
| Thu Aug 21 2008 00:00:00 GMT+0000 (Coordinated Universal Time) | 1 | b"British resident held in Guantanamo Bay wins legal battle to force Foreign Office to reveal 'torture' evidence" | b'Chinese may have killed 140 Tibetans this week: Dalai Lama' | b'U.S. Navy Ships Head to Georgia' | b'Hacker uncovers Chinese olympic fraud' | b"If you've ever wondered what Kim Jong Il was like in grade school, here you go. Yes, he was quite ronery. Also, ordered his former teacher's whole family killed." | b"Russia's Nuclear Threat Is More Than Words" | b'Czech President: "I must protest aloud against the incorrect interpretation of the situation in the Caucasus."' | b'50% Of All Food Produced Is Wasted Before It Gets Used' | b"China sentences Alive in Baghdad blogger, GRL's James Powderly & 4 other citizen journalists to 10 days in jail for covering Tibet protests during the Olympics" | b'"Go ahead and let Georgia declare war between NATO and Russia. Now, any half-wit small-country leader gets to audition for the role of Archduke Ferdinand"' | b'Cafferty: Georgia Started War with Russia [vid]' | b'Kazakhstan is considering diverting its oil exports away from the BTC pipeline that runs through Georgia, and using Russia instead. The reason?' | b"Russia threatens sale of offensive weapons to Israel's enemies" | b'Belfast Police Confiscate Boardgame In Terrorist Crackdown' | b"World's Oldest Man Dies At The Age Of 138" | b'Russia condemns US missile deal' | b'NATOs decision to freeze relations with Moscow and Washingtons inept handling of Pakistan are strategic foreign policy mistakes.' | b'Sweet Sixteen or Fraudulent Fourteen, Hackers unearth more underage gymnast allegations ' | b'If Russias feeling churlish, they can pretty much bring to a grinding halt any kind of coercive actions' | b'Chinese Gymnasts 14, Official Document Shows' | b'Suicide attack kills at least 50 at Pakistan arms factory' | b'The Abkhazian Parliament has approved an official appeal to Russia to recognise its independence' | b'Georgia, Bulgaria and the Second Balkan War | afoe | A Fistful of Euros | European Opinion' | b"Terrorist reveals Pak's sinister designs on India" | b"International Olympic Committee launches probe into He Kexin's age" |
CREATE TABLE combined_news_djia (
"date" TIMESTAMP,
"label" BIGINT,
"top1" VARCHAR,
"top2" VARCHAR,
"top3" VARCHAR,
"top4" VARCHAR,
"top5" VARCHAR,
"top6" VARCHAR,
"top7" VARCHAR,
"top8" VARCHAR,
"top9" VARCHAR,
"top10" VARCHAR,
"top11" VARCHAR,
"top12" VARCHAR,
"top13" VARCHAR,
"top14" VARCHAR,
"top15" VARCHAR,
"top16" VARCHAR,
"top17" VARCHAR,
"top18" VARCHAR,
"top19" VARCHAR,
"top20" VARCHAR,
"top21" VARCHAR,
"top22" VARCHAR,
"top23" VARCHAR,
"top24" VARCHAR,
"top25" VARCHAR
);