Skip to content

Instantly share code, notes, and snippets.

@jpsim

jpsim/stars_over_time.sql

Last active November 21, 2015 19:06
Show Gist options
  • Save jpsim/b1880b6141f535293588 to your computer and use it in GitHub Desktop.
Save jpsim/b1880b6141f535293588 to your computer and use it in GitHub Desktop.
Download ZIP
GitHub Archive Stars Over Time
Raw
stars_over_time.sql
select created_at
from [githubarchive:month.201401],
[githubarchive:month.201402],
[githubarchive:month.201403],
[githubarchive:month.201404],
[githubarchive:month.201405],
[githubarchive:month.201406],
[githubarchive:month.201407],
[githubarchive:month.201408],
[githubarchive:month.201409],
[githubarchive:month.201410],
[githubarchive:month.201411],
[githubarchive:month.201412],
where type = 'WatchEvent' AND repository_url = 'https://github.com/username/repo'
order by created_at;
select FORMAT_UTC_USEC(INTEGER(created_at))
from [githubarchive:month.201501],
[githubarchive:month.201502],
[githubarchive:month.201503],
[githubarchive:month.201504],
[githubarchive:month.201505],
[githubarchive:month.201506],
[githubarchive:month.201507],
[githubarchive:month.201508],
[githubarchive:month.201509],
[githubarchive:month.201510],
[githubarchive:month.201511],
where type = 'WatchEvent' AND repo_url = 'https://api.github.com/repos/username/repo'
order by created_at;
@jpsim
Copy link
Author

jpsim commented Nov 21, 2015

My charts here: https://docs.google.com/spreadsheets/d/1fneLEqhQ3b3xx-cy4RHK47fAKrbsyxnbpxcvRi4lHSs

@jpsim
Copy link
Author

jpsim commented Nov 21, 2015

Queries performed on Google BigQuery: https://bigquery.cloud.google.com

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment