Skip to content

Instantly share code, notes, and snippets.

View all4miller's full-sized avatar

Angus Miller all4miller

View GitHub Profile
drop table if exists datatz;
create table if not exists datatz (
timestmp timestamp,
user_id integer,
stat double precision
);
insert into datatz
select timestmp,
drop table if exists datadz;
create table if not exists datadz (
datestmp date,
user_id integer,
stat double precision
);
insert into datadz
select date(datestmp),