PREVIEW / etf_1hour / 2016-05-19

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-05-19.parquet
  size:    251 KB
  rows:    8,107

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-05-19 04:00:00	SPY	ETF	204.31	204.51	203.85	203.92	23083.0
2016-05-19 05:00:00	SPY	ETF	204.0	204.01	203.87	203.99	4428.0
2016-05-19 06:00:00	SPY	ETF	203.95	204.27	203.95	204.04	68471.0
2016-05-19 07:00:00	SPY	ETF	204.03	204.64	204.02	204.42	326491.0
2016-05-19 08:00:00	SPY	ETF	204.21	204.49	203.86	204.18	847996.0
2016-05-19 09:00:00	SPY	ETF	204.18	204.54	203.11	203.1261	14497651.0
2016-05-19 10:00:00	SPY	ETF	203.12	203.72	202.94	203.0507	25069687.0
2016-05-19 11:00:00	SPY	ETF	203.06	203.38	202.78	203.26	19653384.0
2016-05-19 12:00:00	SPY	ETF	203.26	203.63	203.02	203.045	9847718.0
2016-05-19 13:00:00	SPY	ETF	203.05	203.97	203.03	203.64	9418376.0
2016-05-19 14:00:00	SPY	ETF	203.65	204.1801	203.545	203.6	10470067.0
2016-05-19 15:00:00	SPY	ETF	203.6	204.41	203.59	204.22	18142890.0
2016-05-19 16:00:00	SPY	ETF	204.23	204.9834	204.16	204.43	3936169.0
2016-05-19 17:00:00	SPY	ETF	204.43	204.49	204.37	204.46	120940.0
2016-05-19 18:00:00	SPY	ETF	204.46	204.49	204.37	204.45	116595.0
2016-05-19 19:00:00	SPY	ETF	204.45	204.53	204.32	204.37	102230.0
2016-05-19 04:00:00	QQQ	ETF	105.73	105.73	105.4	105.4	700.0
2016-05-19 05:00:00	QQQ	ETF	105.42	105.42	105.36	105.36	1048.0
2016-05-19 06:00:00	QQQ	ETF	105.56	105.56	105.37	105.37	300.0
2016-05-19 07:00:00	QQQ	ETF	105.56	105.7	105.56	105.64	14082.0
2016-05-19 08:00:00	QQQ	ETF	105.61	105.65	105.42	105.44	49587.0
2016-05-19 09:00:00	QQQ	ETF	105.44	105.705	104.93	104.94	3374133.0
2016-05-19 10:00:00	QQQ	ETF	104.935	105.09	104.75	104.8	4360309.0
2016-05-19 11:00:00	QQQ	ETF	104.805	104.925	104.54	104.77	2981456.0
2016-05-19 12:00:00	QQQ	ETF	104.77	104.99	104.61	104.66	1845032.0
2016-05-19 13:00:00	QQQ	ETF	104.66	105.18	104.65	104.93	1729047.0
2016-05-19 14:00:00	QQQ	ETF	104.93	105.18	104.81	104.83	1750174.0
2016-05-19 15:00:00	QQQ	ETF	104.84	105.45	104.84	105.31	3613466.0
2016-05-19 16:00:00	QQQ	ETF	105.31	105.43	105.27	105.43	468203.0
2016-05-19 17:00:00	QQQ	ETF	105.41	105.43	105.41	105.43	5301.0
2016-05-19 18:00:00	QQQ	ETF	105.43	105.45	105.37	105.37	16986.0
2016-05-19 19:00:00	QQQ	ETF	105.4	105.46	105.36	105.36	102790.0
2016-05-19 04:00:00	IWM	ETF	109.54	109.54	109.08	109.08	800.0
2016-05-19 05:00:00	IWM	ETF	109.2	109.24	109.08	109.08	500.0
2016-05-19 06:00:00	IWM	ETF	109.26	109.26	109.23	109.23	2600.0
2016-05-19 07:00:00	IWM	ETF	109.24	109.6	109.21	109.46	41004.0
2016-05-19 08:00:00	IWM	ETF	109.52	109.52	109.15	109.16	32831.0
2016-05-19 09:00:00	IWM	ETF	109.17	109.77	108.79	108.805	4158832.0
2016-05-19 10:00:00	IWM	ETF	108.81	109.11	108.35	108.43	7145543.0
2016-05-19 11:00:00	IWM	ETF	108.46	108.5301	107.99	108.3	6115414.0
2016-05-19 12:00:00	IWM	ETF	108.3	108.69	108.235	108.46	3710143.0
2016-05-19 13:00:00	IWM	ETF	108.46	109.1	108.4	108.87	3299534.0
2016-05-19 14:00:00	IWM	ETF	108.88	109.18	108.73	108.75	2607116.0
2016-05-19 15:00:00	IWM	ETF	108.75	109.25	108.73	108.955	4764936.0
2016-05-19 16:00:00	IWM	ETF	108.94	109.06	108.92	109.01	887780.0
2016-05-19 17:00:00	IWM	ETF	109.02	109.02	108.97	109.02	30863.0
2016-05-19 18:00:00	IWM	ETF	109.0	109.0	108.96	108.96	3300.0
2016-05-19 19:00:00	IWM	ETF	109.04	109.04	108.98	108.98	1900.0
2016-05-19 04:00:00	DIA	ETF	175.1	175.1	174.93	174.93	300.0
2016-05-19 07:00:00	DIA	ETF	174.97	175.34	174.97	175.34	400.0

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

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