PREVIEW / etf_1hour / 2012-07-13

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-07-13.parquet
  size:    177 KB
  rows:    5,475

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-13 04:00:00	SPY	ETF	133.8	133.85	133.7	133.85	4443.0
2012-07-13 05:00:00	SPY	ETF	133.95	134.06	133.93	134.05	10400.0
2012-07-13 06:00:00	SPY	ETF	134.02	134.28	134.02	134.1	292072.0
2012-07-13 07:00:00	SPY	ETF	134.1	134.11	133.82	133.86	715836.0
2012-07-13 08:00:00	SPY	ETF	133.88	134.04	133.76	133.84	1737050.0
2012-07-13 09:00:00	SPY	ETF	133.84	134.87	133.64	134.83	21918430.0
2012-07-13 10:00:00	SPY	ETF	134.83	135.36	134.76	135.17	22930131.0
2012-07-13 11:00:00	SPY	ETF	135.17	135.46	135.03	135.408	11715544.0
2012-07-13 12:00:00	SPY	ETF	135.4	135.54	135.33	135.44	6831388.0
2012-07-13 13:00:00	SPY	ETF	135.43	135.54	135.34	135.45	7238177.0
2012-07-13 14:00:00	SPY	ETF	135.45	135.53	135.38	135.53	7024543.0
2012-07-13 15:00:00	SPY	ETF	135.53	135.89	135.525	135.7	34358568.0
2012-07-13 16:00:00	SPY	ETF	135.69	135.85	134.0831	135.69	13590930.0
2012-07-13 17:00:00	SPY	ETF	135.71	135.74	134.14	135.64	140975.0
2012-07-13 18:00:00	SPY	ETF	135.65	135.69	135.62	135.64	12433.0
2012-07-13 19:00:00	SPY	ETF	135.65	135.68	135.64	135.67	18705.0
2012-07-13 05:00:00	QQQ	ETF	62.64	62.66	62.64	62.66	6600.0
2012-07-13 06:00:00	QQQ	ETF	62.72	62.72	62.72	62.72	400.0
2012-07-13 07:00:00	QQQ	ETF	62.67	62.69	62.53	62.53	67960.0
2012-07-13 08:00:00	QQQ	ETF	62.57	62.66	62.5	62.57	896016.0
2012-07-13 09:00:00	QQQ	ETF	62.54	62.91	62.5	62.86	5053272.0
2012-07-13 10:00:00	QQQ	ETF	62.86	63.15	62.82	63.056	6373311.0
2012-07-13 11:00:00	QQQ	ETF	63.06	63.2	62.97	63.191	3972952.0
2012-07-13 12:00:00	QQQ	ETF	63.19	63.3	63.19	63.23	3099694.0
2012-07-13 13:00:00	QQQ	ETF	63.22	63.35	63.2	63.29	1893232.0
2012-07-13 14:00:00	QQQ	ETF	63.29	63.35	63.26	63.3401	1656435.0
2012-07-13 15:00:00	QQQ	ETF	63.345	63.52	63.345	63.37	7936522.0
2012-07-13 16:00:00	QQQ	ETF	63.38	63.4229	63.1402	63.35	932740.0
2012-07-13 17:00:00	QQQ	ETF	63.35	63.39	63.35	63.37	4950.0
2012-07-13 18:00:00	QQQ	ETF	63.37	63.37	63.37	63.37	1044.0
2012-07-13 19:00:00	QQQ	ETF	63.37	63.37	63.35	63.35	1020.0
2012-07-13 05:00:00	IWM	ETF	79.09	79.09	79.09	79.09	200.0
2012-07-13 06:00:00	IWM	ETF	79.18	79.45	79.18	79.45	5200.0
2012-07-13 07:00:00	IWM	ETF	79.15	79.15	78.96	79.04	90100.0
2012-07-13 08:00:00	IWM	ETF	79.0	79.11	78.92	79.01	131665.0
2012-07-13 09:00:00	IWM	ETF	78.98	79.76	78.88	79.72	6267184.0
2012-07-13 10:00:00	IWM	ETF	79.72	79.97	79.68	79.72	5730790.0
2012-07-13 11:00:00	IWM	ETF	79.72	79.88	79.61	79.82	3631115.0
2012-07-13 12:00:00	IWM	ETF	79.82	79.93	79.8	79.88	2718516.0
2012-07-13 13:00:00	IWM	ETF	79.89	79.92	79.77	79.87	1806015.0
2012-07-13 14:00:00	IWM	ETF	79.87	79.96	79.8	79.89	3417633.0
2012-07-13 15:00:00	IWM	ETF	79.89	80.09	79.76	79.76	8841854.0
2012-07-13 16:00:00	IWM	ETF	79.76	79.93	78.7357	79.78	2071851.0
2012-07-13 19:00:00	IWM	ETF	79.88	79.88	79.88	79.88	100.0
2012-07-13 08:00:00	DIA	ETF	125.84	125.94	125.81	125.91	12104.0
2012-07-13 09:00:00	DIA	ETF	125.82	126.86	125.77	126.8	685779.0
2012-07-13 10:00:00	DIA	ETF	126.81	127.26	126.73	127.18	695856.0
2012-07-13 11:00:00	DIA	ETF	127.21	127.46	126.97	127.42	544120.0
2012-07-13 12:00:00	DIA	ETF	127.41	127.48	127.26	127.3062	255972.0
2012-07-13 13:00:00	DIA	ETF	127.3	127.4	127.21	127.3	164364.0

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

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