A Magical Oven that allows the wizards to make a magical query on Google Trends and transform that query into a beautiful graphic
SELECT refresh_date AS Day, term AS Top_Term, -- These search terms are in the top 25 in the US each day. rank, FROM
bigquery-public-data.google_trends.top_terms WHERE rank = 1 -- Choose only the top term each day. AND refresh_date >= DATE_SUB(CURRENT_DATE(), INTERVAL 2 WEEK) -- Filter to the last 2 weeks. GROUP BY Day, Top_Term, rank ORDER BY Day DESC
-
Notifications
You must be signed in to change notification settings - Fork 0
A Magical Oven that allows the wizards to make a magical query on Google Trends and transform that query into a beautiful graphic
License
Valwolfor/MagicQoven
Folders and files
Name | Name | Last commit message | Last commit date | |
---|---|---|---|---|
Repository files navigation
About
A Magical Oven that allows the wizards to make a magical query on Google Trends and transform that query into a beautiful graphic
Resources
License
Stars
Watchers
Forks
Releases
No releases published
Packages 0
No packages published