Skip to content

Instantly share code, notes, and snippets.

@doryokujin

doryokujin/dc_timestamp.sql

Last active August 26, 2016 06:59
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/d88a4695dc22831394ca2e4d0d38b729 to your computer and use it in GitHub Desktop.
Save doryokujin/d88a4695dc22831394ca2e4d0d38b729 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
dc_timestamp.sql
+---------------------------+------------------------------+-------------------------+-------------------+----------------+----------------+
| date_hour:timestamp | page_path:string | dimension1:string | dimension2:string | pageviews:long | view_id:string |
+---------------------------+------------------------------+-------------------------+-------------------+----------------+----------------+
| "2016-08-22 02:00:00 UTC" | "/" | "1646047626.1464089680" | "1471831722" | 1 | "128049838" |
| "2016-08-22 02:00:00 UTC" | "/entry/20101102/1288651712" | "1192170867.1468485620" | "1471833441" | 1 | "128049838" |
| "2016-08-22 02:00:00 UTC" | "/entry/20101116/1289860948" | "781104774.14690125300" | "1471833732" | 1 | "128049838" |
| "2016-08-22 02:00:00 UTC" | "/entry/2014/02/04/145027" | "318470974.14633835430" | "1471833680" | 1 | "128049838" |
| "2016-08-22 02:00:00 UTC" | "/entry/2014/02/06/000000" | "1806353841.1468204750" | "1471834643" | 1 | "128049838" |
| "2016-08-22 03:00:00 UTC" | "/entry/20110519/1305737343" | "1172146118.1465981400" | "1471837839" | 1 | "128049838" |
| "2016-08-22 03:00:00 UTC" | "/entry/2012/07/13/041634" | "1493588479.1465341800" | "1471836723" | 1 | "128049838" |
| "2016-08-22 03:00:00 UTC" | "/entry/2016/01/09/211747" | "1174883870.1465729760" | "1471837531" | 1 | "128049838" |
| "2016-08-22 04:00:00 UTC" | "/entry/20110614/1308010072" | "2017183738.1421123730" | "1471839860" | 1 | "128049838" |
| "2016-08-22 04:00:00 UTC" | "/entry/2014/01/14/175541" | "225366604.14606897630" | "1471841160" | 1 | "128049838" |
+---------------------------+------------------------------+-------------------------+-------------------+----------------+----------------+
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment