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 arts (
"date" TIMESTAMP,
"adjusted" DOUBLE
);CREATE TABLE banking (
"date" TIMESTAMP,
"adjusted" DOUBLE
);CREATE TABLE bonds (
"date" TIMESTAMP,
"adjusted" DOUBLE
);CREATE TABLE bubble (
"date" TIMESTAMP,
"adjusted" DOUBLE
);CREATE TABLE buy (
"date" TIMESTAMP,
"adjusted" DOUBLE
);CREATE TABLE cancer (
"date" TIMESTAMP,
"adjusted" DOUBLE
);CREATE TABLE car (
"date" TIMESTAMP,
"adjusted" DOUBLE
);CREATE TABLE cash (
"date" TIMESTAMP,
"adjusted" DOUBLE
);CREATE TABLE chance (
"date" TIMESTAMP,
"adjusted" DOUBLE
);CREATE TABLE color (
"date" TIMESTAMP,
"adjusted" DOUBLE
);CREATE TABLE conflict (
"date" TIMESTAMP,
"adjusted" DOUBLE
);CREATE TABLE consume (
"date" TIMESTAMP,
"adjusted" DOUBLE
);CREATE TABLE consumption (
"date" TIMESTAMP,
"adjusted" DOUBLE
);CREATE TABLE credit (
"date" TIMESTAMP,
"adjusted" DOUBLE
);CREATE TABLE crisis (
"date" TIMESTAMP,
"adjusted" DOUBLE
);CREATE TABLE culture (
"date" TIMESTAMP,
"adjusted" DOUBLE
);CREATE TABLE debt (
"date" TIMESTAMP,
"adjusted" DOUBLE
);CREATE TABLE default (
"date" TIMESTAMP,
"adjusted" DOUBLE
);CREATE TABLE derivatives (
"date" TIMESTAMP,
"adjusted" DOUBLE
);CREATE TABLE dividend (
"date" TIMESTAMP,
"adjusted" DOUBLE
);CREATE TABLE dow_jones (
"date" TIMESTAMP,
"adjusted" DOUBLE
);CREATE TABLE earnings (
"date" TIMESTAMP,
"adjusted" DOUBLE
);CREATE TABLE economics (
"date" TIMESTAMP,
"adjusted" DOUBLE
);CREATE TABLE economy (
"date" TIMESTAMP,
"adjusted" DOUBLE
);CREATE TABLE energy (
"date" TIMESTAMP,
"adjusted" DOUBLE
);CREATE TABLE environment (
"date" TIMESTAMP,
"adjusted" DOUBLE
);CREATE TABLE fed (
"date" TIMESTAMP,
"adjusted" DOUBLE
);CREATE TABLE finance (
"date" TIMESTAMP,
"adjusted" DOUBLE
);CREATE TABLE fine (
"date" TIMESTAMP,
"adjusted" DOUBLE
);CREATE TABLE fond (
"date" TIMESTAMP,
"adjusted" DOUBLE
);CREATE TABLE food (
"date" TIMESTAMP,
"adjusted" DOUBLE
);CREATE TABLE forex (
"date" TIMESTAMP,
"adjusted" DOUBLE
);CREATE TABLE freedom (
"date" TIMESTAMP,
"adjusted" DOUBLE
);CREATE TABLE fun (
"date" TIMESTAMP,
"adjusted" DOUBLE
);CREATE TABLE gain (
"date" TIMESTAMP,
"adjusted" DOUBLE
);CREATE TABLE gains (
"date" TIMESTAMP,
"adjusted" DOUBLE
);CREATE TABLE garden (
"date" TIMESTAMP,
"adjusted" DOUBLE
);CREATE TABLE gold (
"date" TIMESTAMP,
"adjusted" DOUBLE
);CREATE TABLE greed (
"date" TIMESTAMP,
"adjusted" DOUBLE
);CREATE TABLE growth (
"date" TIMESTAMP,
"adjusted" DOUBLE
);CREATE TABLE happy (
"date" TIMESTAMP,
"adjusted" DOUBLE
);CREATE TABLE headlines (
"date" TIMESTAMP,
"adjusted" DOUBLE
);CREATE TABLE health (
"date" TIMESTAMP,
"adjusted" DOUBLE
);CREATE TABLE hedge (
"date" TIMESTAMP,
"adjusted" DOUBLE
);CREATE TABLE holiday (
"date" TIMESTAMP,
"adjusted" DOUBLE
);CREATE TABLE home (
"date" TIMESTAMP,
"adjusted" DOUBLE
);CREATE TABLE house (
"date" TIMESTAMP,
"adjusted" DOUBLE
);CREATE TABLE housing (
"date" TIMESTAMP,
"adjusted" DOUBLE
);CREATE TABLE inflation (
"date" TIMESTAMP,
"adjusted" DOUBLE
);CREATE TABLE invest (
"date" TIMESTAMP,
"adjusted" DOUBLE
);Anyone who has the link will be able to view this.