PREVIEW / etf_1hour / 2016-10-28

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-10-28.parquet
  size:    256 KB
  rows:    8,273

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
2016-10-28 04:00:00	SPY	ETF	212.51	212.58	212.06	212.58	110857.0
2016-10-28 05:00:00	SPY	ETF	212.61	212.89	212.59	212.83	16059.0
2016-10-28 06:00:00	SPY	ETF	212.86	213.14	212.82	213.1	49383.0
2016-10-28 07:00:00	SPY	ETF	213.14	213.24	213.07	213.2	199537.0
2016-10-28 08:00:00	SPY	ETF	213.17	213.38	212.78	213.17	1047181.0
2016-10-28 09:00:00	SPY	ETF	213.17	213.515	212.61	213.24	10475396.0
2016-10-28 10:00:00	SPY	ETF	213.24	213.88	212.79	213.7	15006509.0
2016-10-28 11:00:00	SPY	ETF	213.705	213.8144	213.55	213.57	5392182.0
2016-10-28 12:00:00	SPY	ETF	213.57	213.93	213.51	213.805	6342069.0
2016-10-28 13:00:00	SPY	ETF	213.8	213.9	211.81	211.855	42777914.0
2016-10-28 14:00:00	SPY	ETF	211.87	213.04	211.71	212.935	25108170.0
2016-10-28 15:00:00	SPY	ETF	212.93	213.17	212.32	212.52	24854840.0
2016-10-28 16:00:00	SPY	ETF	212.52	212.92	212.475	212.78	7530320.0
2016-10-28 17:00:00	SPY	ETF	212.76	212.94	212.7	212.83	390576.0
2016-10-28 18:00:00	SPY	ETF	212.86	212.99	212.77	212.94	73610.0
2016-10-28 19:00:00	SPY	ETF	212.93	212.94	212.84	212.94	37981.0
2016-10-28 04:00:00	QQQ	ETF	117.11	117.11	116.86	116.86	46544.0
2016-10-28 05:00:00	QQQ	ETF	117.21	117.21	117.21	117.21	200.0
2016-10-28 06:00:00	QQQ	ETF	117.18	117.36	117.18	117.34	13900.0
2016-10-28 07:00:00	QQQ	ETF	117.38	117.48	117.37	117.45	17814.0
2016-10-28 08:00:00	QQQ	ETF	117.45	117.61	117.28	117.5	161286.0
2016-10-28 09:00:00	QQQ	ETF	117.54	117.85	117.06	117.7	3161122.0
2016-10-28 10:00:00	QQQ	ETF	117.7	118.11	117.38	117.96	3798418.0
2016-10-28 11:00:00	QQQ	ETF	117.97	117.98	117.798	117.8	1254042.0
2016-10-28 12:00:00	QQQ	ETF	117.81	118.09	117.7	117.91	1325228.0
2016-10-28 13:00:00	QQQ	ETF	117.91	117.96	116.87	116.9	7765775.0
2016-10-28 14:00:00	QQQ	ETF	116.91	117.4099	116.74	117.31	4452346.0
2016-10-28 15:00:00	QQQ	ETF	117.29	117.46	116.97	117.07	5672982.0
2016-10-28 16:00:00	QQQ	ETF	117.08	117.6013	117.08	117.18	2399333.0
2016-10-28 17:00:00	QQQ	ETF	117.18	117.23	117.07	117.1	101086.0
2016-10-28 18:00:00	QQQ	ETF	117.15	117.17	117.14	117.17	2597.0
2016-10-28 19:00:00	QQQ	ETF	117.16	117.17	117.11	117.14	5676.0
2016-10-28 04:00:00	IWM	ETF	117.76	117.76	117.42	117.42	4858.0
2016-10-28 05:00:00	IWM	ETF	117.85	117.89	117.81	117.87	1910.0
2016-10-28 06:00:00	IWM	ETF	117.85	118.07	117.85	118.04	4787.0
2016-10-28 07:00:00	IWM	ETF	118.08	118.12	118.01	118.06	5362.0
2016-10-28 08:00:00	IWM	ETF	118.11	118.41	117.96	118.21	128136.0
2016-10-28 09:00:00	IWM	ETF	118.26	118.74	118.05	118.51	2912683.0
2016-10-28 10:00:00	IWM	ETF	118.515	118.97	118.33	118.78	4101783.0
2016-10-28 11:00:00	IWM	ETF	118.78	118.84	118.58	118.6111	1512959.0
2016-10-28 12:00:00	IWM	ETF	118.611	119.03	118.56	118.78	2036707.0
2016-10-28 13:00:00	IWM	ETF	118.78	118.86	117.84	117.85	8206971.0
2016-10-28 14:00:00	IWM	ETF	117.85	118.22	117.75	118.2	4783606.0
2016-10-28 15:00:00	IWM	ETF	118.19	118.38	117.9	118.03	6471431.0
2016-10-28 16:00:00	IWM	ETF	118.03	118.26	118.02	118.13	2159044.0
2016-10-28 17:00:00	IWM	ETF	118.11	118.2	118.11	118.2	1500.0
2016-10-28 18:00:00	IWM	ETF	118.11	118.11	118.1	118.1	500.0
2016-10-28 19:00:00	IWM	ETF	118.14	118.18	118.14	118.14	1418.0
2016-10-28 06:00:00	DIA	ETF	181.4	181.4	181.4	181.4	2500.0
2016-10-28 07:00:00	DIA	ETF	181.61	181.61	181.61	181.61	600.0

> showing 50 of 8,273 rows — these rows as CSV

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