PREVIEW / etf_1hour / 2017-09-07

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-09-07.parquet
  size:    278 KB
  rows:    9,119

schema

  timestamp    TIMESTAMP
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

timestamp	symbol	asset_type	open	high	low	close	volume
2017-09-07 04:00:00	SPY	ETF	246.54	246.66	246.53	246.53	9750.0
2017-09-07 05:00:00	SPY	ETF	246.55	246.79	246.55	246.74	7150.0
2017-09-07 06:00:00	SPY	ETF	246.78	247.15	246.78	247.14	79341.0
2017-09-07 07:00:00	SPY	ETF	247.09	247.14	246.93	247.09	95937.0
2017-09-07 08:00:00	SPY	ETF	247.09	247.21	246.88	247.15	568654.0
2017-09-07 09:00:00	SPY	ETF	247.14	247.28	246.84	246.9	5705551.0
2017-09-07 10:00:00	SPY	ETF	246.9	247.155	246.43	247.01	11830349.0
2017-09-07 11:00:00	SPY	ETF	247.005	247.14	246.56	246.7	9484435.0
2017-09-07 12:00:00	SPY	ETF	246.69	246.78	246.4	246.69	7348907.0
2017-09-07 13:00:00	SPY	ETF	246.69	246.85	246.6	246.765	2406154.0
2017-09-07 14:00:00	SPY	ETF	246.76	246.91	246.69	246.87	3602405.0
2017-09-07 15:00:00	SPY	ETF	246.88	246.94	246.55	246.89	9712175.0
2017-09-07 16:00:00	SPY	ETF	246.89	247.09	246.7654	247.02	5290065.0
2017-09-07 17:00:00	SPY	ETF	247.02	247.05	246.87	247.01	314045.0
2017-09-07 18:00:00	SPY	ETF	247.04	247.15	246.94	247.14	128685.0
2017-09-07 19:00:00	SPY	ETF	247.08	247.1	246.84	246.84	114401.0
2017-09-07 04:00:00	QQQ	ETF	145.03	145.03	144.98	144.98	12900.0
2017-09-07 05:00:00	QQQ	ETF	145.01	145.22	145.01	145.17	21700.0
2017-09-07 06:00:00	QQQ	ETF	145.26	145.42	145.24	145.39	4641.0
2017-09-07 07:00:00	QQQ	ETF	145.38	145.4	145.27	145.33	50109.0
2017-09-07 08:00:00	QQQ	ETF	145.34	145.44	145.21	145.4	87731.0
2017-09-07 09:00:00	QQQ	ETF	145.4	145.46	145.06	145.23	2666235.0
2017-09-07 10:00:00	QQQ	ETF	145.23	145.8	144.94	145.7	5294707.0
2017-09-07 11:00:00	QQQ	ETF	145.7	145.84	145.47	145.61	2534128.0
2017-09-07 12:00:00	QQQ	ETF	145.61	145.61	145.06	145.25	3759321.0
2017-09-07 13:00:00	QQQ	ETF	145.24	145.5469	145.22	145.48	1340241.0
2017-09-07 14:00:00	QQQ	ETF	145.4759	145.58	145.365	145.5	1298021.0
2017-09-07 15:00:00	QQQ	ETF	145.49	145.535	145.31	145.46	3667785.0
2017-09-07 16:00:00	QQQ	ETF	145.46	145.7764	145.44	145.59	642877.0
2017-09-07 17:00:00	QQQ	ETF	145.59	145.61	145.53	145.57	53842.0
2017-09-07 18:00:00	QQQ	ETF	145.56	145.59	145.47	145.59	13882.0
2017-09-07 19:00:00	QQQ	ETF	145.54	145.54	145.44	145.44	11700.0
2017-09-07 04:00:00	IWM	ETF	139.18	139.18	139.14	139.18	4503.0
2017-09-07 05:00:00	IWM	ETF	139.19	139.33	139.19	139.33	2012.0
2017-09-07 06:00:00	IWM	ETF	139.42	139.48	139.37	139.46	16351.0
2017-09-07 07:00:00	IWM	ETF	139.49	139.56	139.35	139.54	11205.0
2017-09-07 08:00:00	IWM	ETF	139.37	139.54	139.25	139.52	105407.0
2017-09-07 09:00:00	IWM	ETF	139.47	139.685	138.97	139.01	1554650.0
2017-09-07 10:00:00	IWM	ETF	139.0099	139.47	138.59	139.34	3066897.0
2017-09-07 11:00:00	IWM	ETF	139.34	139.41	138.71	138.9	2306901.0
2017-09-07 12:00:00	IWM	ETF	138.9	139.3	138.8	139.19	1940437.0
2017-09-07 13:00:00	IWM	ETF	139.18	139.27	138.84	138.94	1670253.0
2017-09-07 14:00:00	IWM	ETF	138.92	139.08	138.88	139.05	1033754.0
2017-09-07 15:00:00	IWM	ETF	139.06	139.16	138.93	139.1	3104844.0
2017-09-07 16:00:00	IWM	ETF	139.09	139.24	138.9	139.09	592932.0
2017-09-07 17:00:00	IWM	ETF	139.01	139.09	139.01	139.09	451.0
2017-09-07 18:00:00	IWM	ETF	139.16	139.16	139.03	139.08	4420.0
2017-09-07 19:00:00	IWM	ETF	139.07	139.07	139.01	139.01	3519.0
2017-09-07 08:00:00	DIA	ETF	218.21	218.21	218.21	218.21	400.0
2017-09-07 09:00:00	DIA	ETF	218.47	218.72	218.26	218.29	336138.0

> showing 50 of 9,119 rows — these rows as CSV

> unlock the full archive -- $79 one-time