Skip to content

Instantly share code, notes, and snippets.

@doryokujin

doryokujin/30dayUsers.sql

Last active August 26, 2016 04:37
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save doryokujin/f9210e795dbf64439a0125cd983fcbb7 to your computer and use it in GitHub Desktop.
Save doryokujin/f9210e795dbf64439a0125cd983fcbb7 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
30dayUsers.sql
+---------------------------+-----------------+----------------+----------------+
| date:timestamp | 1day_users:long | pageviews:long | view_id:string |
+---------------------------+-----------------+----------------+----------------+
| "2016-08-18 07:00:00 UTC" | 5279 | 27240 | "104634715" |
| "2016-08-19 07:00:00 UTC" | 4313 | 17425 | "104634715" |
| "2016-08-20 07:00:00 UTC" | 3196 | 8372 | "104634715" |
| "2016-08-21 07:00:00 UTC" | 4224 | 17468 | "104634715" |
| "2016-08-22 07:00:00 UTC" | 5604 | 30809 | "104634715" |
| "2016-08-23 07:00:00 UTC" | 5512 | 29494 | "104634715" |
| "2016-08-24 07:00:00 UTC" | 5241 | 28102 | "104634715" |
+---------------------------+-----------------+----------------+----------------+
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment