PREVIEW / etf_1hour / 2017-08-09

all etf 1-hour files

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

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-08-09 04:00:00	SPY	ETF	246.63	246.64	246.25	246.64	29817.0
2017-08-09 05:00:00	SPY	ETF	246.63	246.65	246.07	246.18	105850.0
2017-08-09 06:00:00	SPY	ETF	246.15	246.62	246.15	246.58	130869.0
2017-08-09 07:00:00	SPY	ETF	246.57	246.67	246.24	246.32	280989.0
2017-08-09 08:00:00	SPY	ETF	246.32	246.63	246.11	246.58	931531.0
2017-08-09 09:00:00	SPY	ETF	246.57	246.88	246.06	246.76	12770421.0
2017-08-09 10:00:00	SPY	ETF	246.76	247.015	246.315	246.89	9006967.0
2017-08-09 11:00:00	SPY	ETF	246.88	247.12	246.4499	247.095	7143325.0
2017-08-09 12:00:00	SPY	ETF	247.1	247.16	246.8	246.8105	3315649.0
2017-08-09 13:00:00	SPY	ETF	246.8105	247.0	246.72	246.795	3029934.0
2017-08-09 14:00:00	SPY	ETF	246.79	246.8375	246.36	246.64	5152749.0
2017-08-09 15:00:00	SPY	ETF	246.64	247.31	246.49	247.23	14520548.0
2017-08-09 16:00:00	SPY	ETF	247.22	247.52	246.7283	247.49	4699658.0
2017-08-09 17:00:00	SPY	ETF	247.49	247.5	247.44	247.48	81463.0
2017-08-09 18:00:00	SPY	ETF	247.48	247.48	247.29	247.32	199578.0
2017-08-09 19:00:00	SPY	ETF	247.33	247.35	247.24	247.32	99400.0
2017-08-09 04:00:00	QQQ	ETF	143.75	143.75	143.25	143.52	10854.0
2017-08-09 05:00:00	QQQ	ETF	143.46	143.46	143.14	143.2	43918.0
2017-08-09 06:00:00	QQQ	ETF	143.28	143.49	143.28	143.42	30193.0
2017-08-09 07:00:00	QQQ	ETF	143.48	143.5	143.2	143.24	129415.0
2017-08-09 08:00:00	QQQ	ETF	143.25	143.486	143.0	143.26	439128.0
2017-08-09 09:00:00	QQQ	ETF	143.26	143.55	142.795	143.45	9285944.0
2017-08-09 10:00:00	QQQ	ETF	143.46	143.8	143.17	143.66	5978788.0
2017-08-09 11:00:00	QQQ	ETF	143.66	144.0566	143.44	144.05	3370353.0
2017-08-09 12:00:00	QQQ	ETF	144.06	144.14	143.78	143.79	2318366.0
2017-08-09 13:00:00	QQQ	ETF	143.785	143.95	143.74	143.9143	1258422.0
2017-08-09 14:00:00	QQQ	ETF	143.9101	143.94	143.39	143.66	1973524.0
2017-08-09 15:00:00	QQQ	ETF	143.66	144.19	143.51	144.13	4247845.0
2017-08-09 16:00:00	QQQ	ETF	144.12	144.31	144.0661	144.3	1299746.0
2017-08-09 17:00:00	QQQ	ETF	144.26	144.34	144.25	144.34	8610.0
2017-08-09 18:00:00	QQQ	ETF	144.26	144.26	144.17	144.18	35431.0
2017-08-09 19:00:00	QQQ	ETF	144.19	144.22	144.15	144.21	10642.0
2017-08-09 04:00:00	IWM	ETF	139.5	139.5	139.0	139.24	3489.0
2017-08-09 05:00:00	IWM	ETF	139.14	139.14	138.86	138.86	6324.0
2017-08-09 06:00:00	IWM	ETF	139.03	139.18	139.0	139.14	21091.0
2017-08-09 07:00:00	IWM	ETF	139.24	139.29	139.07	139.19	43048.0
2017-08-09 08:00:00	IWM	ETF	139.13	139.13	138.58	138.97	297428.0
2017-08-09 09:00:00	IWM	ETF	138.97	139.2999	138.67	139.18	4134535.0
2017-08-09 10:00:00	IWM	ETF	139.19	139.39	138.95	138.9658	2863650.0
2017-08-09 11:00:00	IWM	ETF	138.96	139.29	138.75	139.22	2460606.0
2017-08-09 12:00:00	IWM	ETF	139.23	139.35	138.9	138.91	1408167.0
2017-08-09 13:00:00	IWM	ETF	138.91	139.035	138.81	138.92	985213.0
2017-08-09 14:00:00	IWM	ETF	138.92	138.9301	138.36	138.46	2694121.0
2017-08-09 15:00:00	IWM	ETF	138.45	138.85	138.28	138.81	5697670.0
2017-08-09 16:00:00	IWM	ETF	138.81	140.0672	138.7546	139.03	1530686.0
2017-08-09 17:00:00	IWM	ETF	139.03	139.03	138.95	138.95	1507.0
2017-08-09 18:00:00	IWM	ETF	138.95	138.95	138.79	138.9	675.0
2017-08-09 19:00:00	IWM	ETF	138.88	138.98	138.7569	138.7569	305724.0
2017-08-09 04:00:00	DIA	ETF	220.25	220.3	220.25	220.3	2200.0
2017-08-09 05:00:00	DIA	ETF	220.3	220.3	220.17	220.17	3400.0

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

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