PREVIEW / etf_1hour / 2013-03-18

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-03-18.parquet
  size:    199 KB
  rows:    6,329

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
2013-03-18 04:00:00	SPY	ETF	154.15	154.3	154.02	154.29	64082.0
2013-03-18 05:00:00	SPY	ETF	154.31	154.54	154.21	154.46	78904.0
2013-03-18 06:00:00	SPY	ETF	154.55	154.57	154.13	154.25	232625.0
2013-03-18 07:00:00	SPY	ETF	154.27	154.53	154.27	154.5	950866.0
2013-03-18 08:00:00	SPY	ETF	154.5	154.73	153.8	154.5	2558764.0
2013-03-18 09:00:00	SPY	ETF	154.52	154.88	154.2	154.82	20955695.0
2013-03-18 10:00:00	SPY	ETF	154.81	155.16	154.7	154.95	18039129.0
2013-03-18 11:00:00	SPY	ETF	154.965	155.29	154.91	155.28	11572628.0
2013-03-18 12:00:00	SPY	ETF	155.28	155.605	155.28	155.4	13779510.0
2013-03-18 13:00:00	SPY	ETF	155.4	155.47	155.16	155.179	9301401.0
2013-03-18 14:00:00	SPY	ETF	155.179	155.64	155.16	155.28	8948441.0
2013-03-18 15:00:00	SPY	ETF	155.28	155.46	154.75	154.95	29672859.0
2013-03-18 16:00:00	SPY	ETF	154.95	155.8309	154.85	155.165	8432010.0
2013-03-18 17:00:00	SPY	ETF	155.17	155.19	154.97	155.17	118832.0
2013-03-18 18:00:00	SPY	ETF	155.17	155.17	155.07	155.13	55735.0
2013-03-18 19:00:00	SPY	ETF	155.15	155.2	155.08	155.18	55684.0
2013-03-18 04:00:00	QQQ	ETF	67.91	67.91	67.67	67.67	1077.0
2013-03-18 05:00:00	QQQ	ETF	67.73	67.78	67.73	67.78	900.0
2013-03-18 06:00:00	QQQ	ETF	67.78	67.78	67.77	67.77	396.0
2013-03-18 07:00:00	QQQ	ETF	67.79	67.92	67.78	67.92	23733.0
2013-03-18 08:00:00	QQQ	ETF	67.92	68.03	67.77	67.94	419388.0
2013-03-18 09:00:00	QQQ	ETF	67.935	68.14	67.73	68.11	4191081.0
2013-03-18 10:00:00	QQQ	ETF	68.1	68.36	68.08	68.24	4048999.0
2013-03-18 11:00:00	QQQ	ETF	68.24	68.42	68.22	68.41	2027598.0
2013-03-18 12:00:00	QQQ	ETF	68.42	68.6001	68.42	68.46	5644209.0
2013-03-18 13:00:00	QQQ	ETF	68.459	68.552	68.4	68.4	1136030.0
2013-03-18 14:00:00	QQQ	ETF	68.4	68.6367	68.38	68.47	1933758.0
2013-03-18 15:00:00	QQQ	ETF	68.4745	68.565	68.24	68.35	4637887.0
2013-03-18 16:00:00	QQQ	ETF	68.35	68.49	68.07	68.43	1272579.0
2013-03-18 17:00:00	QQQ	ETF	68.42	68.42	68.4	68.42	2800.0
2013-03-18 18:00:00	QQQ	ETF	68.41	68.41	68.38	68.4	4270.0
2013-03-18 19:00:00	QQQ	ETF	68.4	68.4	68.4	68.4	325.0
2013-03-18 05:00:00	IWM	ETF	93.6	93.6	93.5	93.6	9996.0
2013-03-18 06:00:00	IWM	ETF	93.89	94.07	93.51	93.65	41639.0
2013-03-18 07:00:00	IWM	ETF	93.8	93.84	93.4	93.8	167452.0
2013-03-18 08:00:00	IWM	ETF	93.79	93.96	93.69	93.83	333112.0
2013-03-18 09:00:00	IWM	ETF	93.83	94.26	93.65	94.21	5484616.0
2013-03-18 10:00:00	IWM	ETF	94.21	94.27	93.89	94.09	6004289.0
2013-03-18 11:00:00	IWM	ETF	94.1	94.45	94.08	94.45	3593175.0
2013-03-18 12:00:00	IWM	ETF	94.4572	94.56	94.34	94.4	2577675.0
2013-03-18 13:00:00	IWM	ETF	94.4099	94.47	94.3	94.34	1747259.0
2013-03-18 14:00:00	IWM	ETF	94.35	94.61	94.32	94.34	3407842.0
2013-03-18 15:00:00	IWM	ETF	94.34	94.4	93.98	94.23	7673368.0
2013-03-18 16:00:00	IWM	ETF	94.23	94.53	94.04	94.37	1785433.0
2013-03-18 17:00:00	IWM	ETF	94.36	94.38	94.23	94.33	21670.0
2013-03-18 18:00:00	IWM	ETF	94.36	94.37	94.32	94.33	9340.0
2013-03-18 19:00:00	IWM	ETF	94.33	94.34	94.33	94.34	500.0
2013-03-18 05:00:00	DIA	ETF	143.98	143.98	143.95	143.95	800.0
2013-03-18 06:00:00	DIA	ETF	143.88	143.88	143.88	143.88	100.0
2013-03-18 07:00:00	DIA	ETF	143.81	144.01	143.79	144.0	18650.0

> showing 50 of 6,329 rows — these rows as CSV

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