PREVIEW / etf_1hour / 2012-07-06

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-07-06.parquet
  size:    180 KB
  rows:    5,548

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
2012-07-06 04:00:00	SPY	ETF	136.69	136.7	136.59	136.7	12892.0
2012-07-06 05:00:00	SPY	ETF	136.54	136.54	136.41	136.45	14821.0
2012-07-06 06:00:00	SPY	ETF	136.46	136.55	136.46	136.55	12574.0
2012-07-06 07:00:00	SPY	ETF	136.54	136.63	136.37	136.48	154021.0
2012-07-06 08:00:00	SPY	ETF	136.48	136.57	135.57	135.67	7316992.0
2012-07-06 09:00:00	SPY	ETF	135.66	135.86	135.37	135.59	18286413.0
2012-07-06 10:00:00	SPY	ETF	135.59	135.65	135.22	135.2688	24085591.0
2012-07-06 11:00:00	SPY	ETF	135.27	135.41	135.02	135.06	16513144.0
2012-07-06 12:00:00	SPY	ETF	135.07	135.33	134.93	135.32	13239147.0
2012-07-06 13:00:00	SPY	ETF	135.32	135.39	134.98	135.051	10572061.0
2012-07-06 14:00:00	SPY	ETF	135.0531	135.18	134.85	135.12	10530279.0
2012-07-06 15:00:00	SPY	ETF	135.11	135.7	135.06	135.52	31562951.0
2012-07-06 16:00:00	SPY	ETF	135.52	136.8185	135.04	135.91	17047380.0
2012-07-06 17:00:00	SPY	ETF	135.91	135.94	135.8	135.87	196235.0
2012-07-06 18:00:00	SPY	ETF	135.87	135.9	135.84	135.87	33500.0
2012-07-06 19:00:00	SPY	ETF	135.86	135.93	135.82	135.93	38026.0
2012-07-06 07:00:00	QQQ	ETF	64.84	64.88	64.81	64.87	64000.0
2012-07-06 08:00:00	QQQ	ETF	64.86	64.87	64.52	64.55	3610399.0
2012-07-06 09:00:00	QQQ	ETF	64.57	64.73	64.16	64.301	8314352.0
2012-07-06 10:00:00	QQQ	ETF	64.3	64.3199	63.915	63.98	5416609.0
2012-07-06 11:00:00	QQQ	ETF	63.98	64.01	63.8	63.83	2978472.0
2012-07-06 12:00:00	QQQ	ETF	63.83	63.88	63.72	63.88	3631972.0
2012-07-06 13:00:00	QQQ	ETF	63.8795	63.95	63.73	63.7682	2016415.0
2012-07-06 14:00:00	QQQ	ETF	63.76	63.849	63.65	63.83	2263910.0
2012-07-06 15:00:00	QQQ	ETF	63.82	64.1	63.77	64.09	9588916.0
2012-07-06 16:00:00	QQQ	ETF	64.09	64.16	64.0012	64.15	605731.0
2012-07-06 17:00:00	QQQ	ETF	64.15	64.15	64.1	64.12	34263.0
2012-07-06 18:00:00	QQQ	ETF	64.13	64.14	64.12	64.12	1228.0
2012-07-06 19:00:00	QQQ	ETF	64.15	64.2	64.12	64.13	10836.0
2012-07-06 07:00:00	IWM	ETF	81.37	81.43	81.3	81.4	22650.0
2012-07-06 08:00:00	IWM	ETF	81.34	81.37	80.69	80.72	601827.0
2012-07-06 09:00:00	IWM	ETF	80.72	80.84	80.45	80.63	6663952.0
2012-07-06 10:00:00	IWM	ETF	80.63	80.78	80.38	80.53	6001566.0
2012-07-06 11:00:00	IWM	ETF	80.53	80.64	80.38	80.43	3988662.0
2012-07-06 12:00:00	IWM	ETF	80.42	80.56	80.295	80.51	2995507.0
2012-07-06 13:00:00	IWM	ETF	80.5	80.52	80.24	80.31	2372513.0
2012-07-06 14:00:00	IWM	ETF	80.3	80.32	80.15	80.22	2715384.0
2012-07-06 15:00:00	IWM	ETF	80.22	80.6	80.16	80.52	8332333.0
2012-07-06 16:00:00	IWM	ETF	80.52	80.62	80.2664	80.48	1267563.0
2012-07-06 17:00:00	IWM	ETF	80.6	80.6	80.56	80.56	2014.0
2012-07-06 19:00:00	IWM	ETF	80.57	80.58	80.57	80.58	1050.0
2012-07-06 07:00:00	DIA	ETF	128.71	128.71	128.71	128.71	100.0
2012-07-06 08:00:00	DIA	ETF	128.71	128.71	127.88	127.88	16383.0
2012-07-06 09:00:00	DIA	ETF	128.02	128.09	127.45	127.61	517228.0
2012-07-06 10:00:00	DIA	ETF	127.62	127.68	127.18	127.23	606688.0
2012-07-06 11:00:00	DIA	ETF	127.23	127.35	126.98	127.06	509935.0
2012-07-06 12:00:00	DIA	ETF	127.03	127.27	126.87	127.23	575961.0
2012-07-06 13:00:00	DIA	ETF	127.248	127.33	127.0599	127.11	287737.0
2012-07-06 14:00:00	DIA	ETF	127.11	127.24	126.96	127.1761	373717.0
2012-07-06 15:00:00	DIA	ETF	127.17	127.71	127.15	127.56	1391639.0

> showing 50 of 5,548 rows — these rows as CSV

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