Big Stock Data

datetime Datetime	open Open	high High	low Low	close Close	volume Volume
2021-03-04 09:30:00-05:00
2021-03-05 09:30:00-05:00	1.4386999607086182	1.4479999542236328	1.4199999570846558	1.4386999607086182	339213
2021-03-05 09:31:00-05:00	1.4294999837875366	1.4299999475479126	1.4199999570846558	1.4199999570846558	12342
2021-03-05 09:32:00-05:00	1.4249999523162842	1.429900050163269	1.4199999570846558	1.429900050163269	18549
2021-03-05 09:33:00-05:00	1.4297000169754028	1.4297000169754028	1.4199999570846558	1.4289000034332275	19243
2021-03-05 09:34:00-05:00	1.4249999523162842	1.4299999475479126	1.4199999570846558	1.4249999523162842	20702
2021-03-05 09:35:00-05:00	1.429800033569336	1.429800033569336	1.4199999570846558	1.4200999736785889	15642
2021-03-05 09:36:00-05:00	1.4199999570846558	1.4199999570846558	1.409999966621399	1.4189000129699707	3294
2021-03-05 09:37:00-05:00	1.410099983215332	1.4183000326156616	1.409999966621399	1.4183000326156616	5198
2021-03-05 09:38:00-05:00	1.4190000295639038	1.4199999570846558	1.410099983215332	1.414199948310852	12745


CREATE TABLE avgr (
  "datetime" VARCHAR,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" DOUBLE
);