PREVIEW / etf_1hour / 2017-08-31

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-08-31.parquet
  size:    282 KB
  rows:    9,167

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-31 04:00:00	SPY	ETF	246.09	246.65	246.09	246.63	37510.0
2017-08-31 05:00:00	SPY	ETF	246.6	246.77	246.56	246.76	8098.0
2017-08-31 06:00:00	SPY	ETF	246.8	246.85	246.39	246.55	56329.0
2017-08-31 07:00:00	SPY	ETF	246.55	246.68	246.32	246.37	338745.0
2017-08-31 08:00:00	SPY	ETF	246.65	246.66	246.32	246.57	497664.0
2017-08-31 09:00:00	SPY	ETF	246.57	247.03	246.57	246.98	6488204.0
2017-08-31 10:00:00	SPY	ETF	246.99	247.31	246.79	246.9656	9954230.0
2017-08-31 11:00:00	SPY	ETF	246.97	247.12	246.68	247.04	7777048.0
2017-08-31 12:00:00	SPY	ETF	247.04	247.29	247.04	247.21	8160013.0
2017-08-31 13:00:00	SPY	ETF	247.2099	247.27	247.07	247.22	4613334.0
2017-08-31 14:00:00	SPY	ETF	247.21	247.565	247.06	247.54	9410795.0
2017-08-31 15:00:00	SPY	ETF	247.53	247.77	247.22	247.42	25651072.0
2017-08-31 16:00:00	SPY	ETF	247.43	247.6074	246.0473	247.38	27087849.0
2017-08-31 17:00:00	SPY	ETF	247.39	247.49	247.33	247.38	753145.0
2017-08-31 18:00:00	SPY	ETF	247.38	247.53	247.38	247.47	125174.0
2017-08-31 19:00:00	SPY	ETF	247.47	247.6	247.44	247.59	68902.0
2017-08-31 04:00:00	QQQ	ETF	144.97	145.12	144.97	145.08	2850.0
2017-08-31 05:00:00	QQQ	ETF	145.06	145.19	145.05	145.19	12873.0
2017-08-31 06:00:00	QQQ	ETF	145.19	145.19	144.89	145.01	116094.0
2017-08-31 07:00:00	QQQ	ETF	145.02	145.06	144.85	144.89	36474.0
2017-08-31 08:00:00	QQQ	ETF	145.0	145.03	144.86	145.01	422579.0
2017-08-31 09:00:00	QQQ	ETF	145.03	145.5225	144.98	145.4949	4121911.0
2017-08-31 10:00:00	QQQ	ETF	145.49	145.68	145.3501	145.48	4978094.0
2017-08-31 11:00:00	QQQ	ETF	145.48	145.72	145.3699	145.68	3395348.0
2017-08-31 12:00:00	QQQ	ETF	145.68	145.97	145.67	145.89	3501111.0
2017-08-31 13:00:00	QQQ	ETF	145.885	145.94	145.76	145.88	2082944.0
2017-08-31 14:00:00	QQQ	ETF	145.87	146.02	145.73	145.97	2998482.0
2017-08-31 15:00:00	QQQ	ETF	145.975	146.21	145.85	146.05	8299685.0
2017-08-31 16:00:00	QQQ	ETF	146.05	146.2	145.2472	146.17	2412251.0
2017-08-31 17:00:00	QQQ	ETF	146.14	146.2	146.11	146.2	419869.0
2017-08-31 18:00:00	QQQ	ETF	146.13	146.25	146.13	146.17	14070.0
2017-08-31 19:00:00	QQQ	ETF	146.19	146.28	146.19	146.28	15401.0
2017-08-31 04:00:00	IWM	ETF	138.49	138.76	138.49	138.76	903.0
2017-08-31 05:00:00	IWM	ETF	138.89	139.01	138.89	139.01	9843.0
2017-08-31 06:00:00	IWM	ETF	138.85	138.88	138.75	138.88	15965.0
2017-08-31 07:00:00	IWM	ETF	138.88	138.92	138.73	138.73	9475.0
2017-08-31 08:00:00	IWM	ETF	138.76	138.8	138.68	138.74	50141.0
2017-08-31 09:00:00	IWM	ETF	138.72	139.31	138.67	139.24	3779410.0
2017-08-31 10:00:00	IWM	ETF	139.24	139.4	139.0501	139.37	3075633.0
2017-08-31 11:00:00	IWM	ETF	139.37	139.94	139.22	139.68	3339324.0
2017-08-31 12:00:00	IWM	ETF	139.6856	139.91	139.66	139.73	1462076.0
2017-08-31 13:00:00	IWM	ETF	139.7301	139.8	139.53	139.55	1079779.0
2017-08-31 14:00:00	IWM	ETF	139.55	139.725	139.46	139.68	1802425.0
2017-08-31 15:00:00	IWM	ETF	139.68	139.86	139.52	139.75	5226382.0
2017-08-31 16:00:00	IWM	ETF	139.76	139.79	139.56	139.7	1518913.0
2017-08-31 17:00:00	IWM	ETF	139.73	139.82	139.62	139.73	1464327.0
2017-08-31 18:00:00	IWM	ETF	139.73	139.73	139.73	139.73	500.0
2017-08-31 19:00:00	IWM	ETF	139.74	139.82	139.73	139.82	7393.0
2017-08-31 07:00:00	DIA	ETF	219.3	219.3	219.3	219.3	345.0
2017-08-31 08:00:00	DIA	ETF	219.32	219.36	219.32	219.36	2850.0

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

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