PREVIEW / etf_1hour / 2017-09-08

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-09-08.parquet
  size:    275 KB
  rows:    9,027

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-08 04:00:00	SPY	ETF	246.51	246.55	246.26	246.27	9464.0
2017-09-08 05:00:00	SPY	ETF	246.52	246.64	246.4	246.4	1751.0
2017-09-08 06:00:00	SPY	ETF	246.5	246.5	246.14	246.18	19296.0
2017-09-08 07:00:00	SPY	ETF	246.2	246.45	246.18	246.43	109236.0
2017-09-08 08:00:00	SPY	ETF	246.18	246.58	246.18	246.55	236459.0
2017-09-08 09:00:00	SPY	ETF	246.56	246.72	246.3	246.71	5539794.0
2017-09-08 10:00:00	SPY	ETF	246.71	246.87	246.55	246.83	7108731.0
2017-09-08 11:00:00	SPY	ETF	246.83	247.11	246.74	246.77	5125470.0
2017-09-08 12:00:00	SPY	ETF	246.77	246.91	246.58	246.85	3091417.0
2017-09-08 13:00:00	SPY	ETF	246.85	246.86	246.63	246.735	5187048.0
2017-09-08 14:00:00	SPY	ETF	246.75	246.94	246.63	246.76	6833482.0
2017-09-08 15:00:00	SPY	ETF	246.75	246.82	246.36	246.55	13833456.0
2017-09-08 16:00:00	SPY	ETF	246.56	246.8752	246.523	246.68	12734484.0
2017-09-08 17:00:00	SPY	ETF	246.66	246.68	246.61	246.62	68168.0
2017-09-08 18:00:00	SPY	ETF	246.65	246.72	246.63	246.67	38593.0
2017-09-08 19:00:00	SPY	ETF	246.68	246.71	246.66	246.7	14835.0
2017-09-08 04:00:00	QQQ	ETF	145.13	145.19	145.12	145.12	8350.0
2017-09-08 05:00:00	QQQ	ETF	145.1	145.4	145.1	145.29	2662.0
2017-09-08 06:00:00	QQQ	ETF	145.28	145.28	145.08	145.08	10236.0
2017-09-08 07:00:00	QQQ	ETF	145.09	145.23	145.08	145.23	57926.0
2017-09-08 08:00:00	QQQ	ETF	145.22	145.35	145.17	145.3	109343.0
2017-09-08 09:00:00	QQQ	ETF	145.34	145.35	144.925	145.1	3228598.0
2017-09-08 10:00:00	QQQ	ETF	145.1	145.14	144.74	144.89	4137873.0
2017-09-08 11:00:00	QQQ	ETF	144.9	145.095	144.62	144.71	2337080.0
2017-09-08 12:00:00	QQQ	ETF	144.7125	144.76	144.53	144.64	2236153.0
2017-09-08 13:00:00	QQQ	ETF	144.65	144.765	144.48	144.5	1760702.0
2017-09-08 14:00:00	QQQ	ETF	144.51	144.54	144.23	144.3	2446100.0
2017-09-08 15:00:00	QQQ	ETF	144.3	144.39	144.06	144.23	6134132.0
2017-09-08 16:00:00	QQQ	ETF	144.22	144.6	144.19	144.3	2158936.0
2017-09-08 17:00:00	QQQ	ETF	144.29	144.34	144.21	144.31	3155.0
2017-09-08 18:00:00	QQQ	ETF	144.29	144.3	144.29	144.3	599.0
2017-09-08 19:00:00	QQQ	ETF	144.29	144.32	144.25	144.31	7592.0
2017-09-08 04:00:00	IWM	ETF	138.72	138.81	138.66	138.69	3159.0
2017-09-08 05:00:00	IWM	ETF	138.75	138.92	138.75	138.92	3509.0
2017-09-08 06:00:00	IWM	ETF	138.85	138.89	138.73	138.73	18020.0
2017-09-08 07:00:00	IWM	ETF	138.75	138.92	138.73	138.92	8094.0
2017-09-08 08:00:00	IWM	ETF	138.91	139.04	138.84	139.04	41669.0
2017-09-08 09:00:00	IWM	ETF	138.95	138.96	138.615	138.785	1641294.0
2017-09-08 10:00:00	IWM	ETF	138.77	139.52	138.77	139.44	2253660.0
2017-09-08 11:00:00	IWM	ETF	139.44	139.77	139.34	139.49	2583468.0
2017-09-08 12:00:00	IWM	ETF	139.49	139.53	139.09	139.4	1562404.0
2017-09-08 13:00:00	IWM	ETF	139.39	139.45	139.09	139.26	1444536.0
2017-09-08 14:00:00	IWM	ETF	139.27	139.415	139.26	139.34	1098804.0
2017-09-08 15:00:00	IWM	ETF	139.35	139.462	138.97	139.2	3689097.0
2017-09-08 16:00:00	IWM	ETF	139.21	139.6	139.193	139.52	1885732.0
2017-09-08 17:00:00	IWM	ETF	139.52	139.52	139.0183	139.0183	11341.0
2017-09-08 18:00:00	IWM	ETF	139.41	139.5	139.41	139.49	4590.0
2017-09-08 19:00:00	IWM	ETF	139.5	139.55	139.43	139.43	772.0
2017-09-08 04:00:00	DIA	ETF	217.7	217.7	217.65	217.65	399.0
2017-09-08 07:00:00	DIA	ETF	217.4	217.44	217.4	217.44	1200.0

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

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