Google Trends Financial Terms—Daily And Weekly
Google Trends (daily and weekly) data over large (2004—2020).
@kaggle.cristianperezjensen_google_trends_financial_terms_dail_6e204f01
Google Trends (daily and weekly) data over large (2004—2020).
@kaggle.cristianperezjensen_google_trends_financial_terms_dail_6e204f01
For a project of mine, I wanted to use Google Trends data to predict the stock market. However, over large timespans, only monthly data is provided, so I had to use this data—together with the daily and weekly data from smaller timespans—to create daily and weekly data over the large timespan. I have created a script for this purpose, and thought I would share the data from 98 financial keywords.
In each file there are only two columns; "date" and "adjusted". "date" is obviously the date. "adjusted" is the adjusted data, derived from the monthly and weekly data — in the case of the daily data.
CREATE TABLE investment (
"date" TIMESTAMP,
"adjusted" DOUBLE
);CREATE TABLE kitchen (
"date" TIMESTAMP,
"adjusted" DOUBLE
);CREATE TABLE labor (
"date" TIMESTAMP,
"adjusted" DOUBLE
);CREATE TABLE leverage (
"date" TIMESTAMP,
"adjusted" DOUBLE
);CREATE TABLE lifestyle (
"date" TIMESTAMP,
"adjusted" DOUBLE
);CREATE TABLE loss (
"date" TIMESTAMP,
"adjusted" DOUBLE
);CREATE TABLE markets (
"date" TIMESTAMP,
"adjusted" DOUBLE
);CREATE TABLE marriage (
"date" TIMESTAMP,
"adjusted" DOUBLE
);CREATE TABLE metals (
"date" TIMESTAMP,
"adjusted" DOUBLE
);CREATE TABLE money (
"date" TIMESTAMP,
"adjusted" DOUBLE
);CREATE TABLE movie (
"date" TIMESTAMP,
"adjusted" DOUBLE
);CREATE TABLE nasdaq (
"date" TIMESTAMP,
"adjusted" DOUBLE
);CREATE TABLE nyse (
"date" TIMESTAMP,
"adjusted" DOUBLE
);CREATE TABLE office (
"date" TIMESTAMP,
"adjusted" DOUBLE
);CREATE TABLE oil (
"date" TIMESTAMP,
"adjusted" DOUBLE
);CREATE TABLE opportunity (
"date" TIMESTAMP,
"adjusted" DOUBLE
);CREATE TABLE ore (
"date" TIMESTAMP,
"adjusted" DOUBLE
);CREATE TABLE politics (
"date" TIMESTAMP,
"adjusted" DOUBLE
);CREATE TABLE portfolio (
"date" TIMESTAMP,
"adjusted" DOUBLE
);CREATE TABLE present (
"date" TIMESTAMP,
"adjusted" DOUBLE
);CREATE TABLE profit (
"date" TIMESTAMP,
"adjusted" DOUBLE
);CREATE TABLE religion (
"date" TIMESTAMP,
"adjusted" DOUBLE
);CREATE TABLE restaurant (
"date" TIMESTAMP,
"adjusted" DOUBLE
);CREATE TABLE return (
"date" TIMESTAMP,
"adjusted" DOUBLE
);CREATE TABLE returns (
"date" TIMESTAMP,
"adjusted" DOUBLE
);CREATE TABLE revenue (
"date" TIMESTAMP,
"adjusted" DOUBLE
);CREATE TABLE rich (
"date" TIMESTAMP,
"adjusted" DOUBLE
);CREATE TABLE ring (
"date" TIMESTAMP,
"adjusted" DOUBLE
);CREATE TABLE risk (
"date" TIMESTAMP,
"adjusted" DOUBLE
);CREATE TABLE sell (
"date" TIMESTAMP,
"adjusted" DOUBLE
);CREATE TABLE society (
"date" TIMESTAMP,
"adjusted" DOUBLE
);CREATE TABLE stock_market (
"date" TIMESTAMP,
"adjusted" DOUBLE
);CREATE TABLE stocks (
"date" TIMESTAMP,
"adjusted" DOUBLE
);CREATE TABLE success (
"date" TIMESTAMP,
"adjusted" DOUBLE
);CREATE TABLE tourism (
"date" TIMESTAMP,
"adjusted" DOUBLE
);CREATE TABLE trader (
"date" TIMESTAMP,
"adjusted" DOUBLE
);CREATE TABLE train (
"date" TIMESTAMP,
"adjusted" DOUBLE
);CREATE TABLE transaction (
"date" TIMESTAMP,
"adjusted" DOUBLE
);CREATE TABLE travel (
"date" TIMESTAMP,
"adjusted" DOUBLE
);CREATE TABLE unemployment (
"date" TIMESTAMP,
"adjusted" DOUBLE
);CREATE TABLE war (
"date" TIMESTAMP,
"adjusted" DOUBLE
);CREATE TABLE water (
"date" TIMESTAMP,
"adjusted" DOUBLE
);CREATE TABLE world (
"date" TIMESTAMP,
"adjusted" DOUBLE
);Anyone who has the link will be able to view this.