PREVIEW / etf_1hour / 2012-09-06

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-09-06.parquet
  size:    192 KB
  rows:    6,028

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-09-06 04:00:00	SPY	ETF	141.3	141.96	141.3	141.91	47440.0
2012-09-06 05:00:00	SPY	ETF	141.87	141.95	141.8	141.8	64242.0
2012-09-06 06:00:00	SPY	ETF	141.8	141.92	141.73	141.76	184754.0
2012-09-06 07:00:00	SPY	ETF	141.79	141.82	141.5	141.76	677560.0
2012-09-06 08:00:00	SPY	ETF	141.75	142.06	141.38	141.63	4277356.0
2012-09-06 09:00:00	SPY	ETF	141.63	142.57	141.62	142.5038	20864197.0
2012-09-06 10:00:00	SPY	ETF	142.51	143.52	142.51	143.49	31066669.0
2012-09-06 11:00:00	SPY	ETF	143.48	143.66	143.27	143.57	18724238.0
2012-09-06 12:00:00	SPY	ETF	143.56	143.71	143.5	143.62	8360292.0
2012-09-06 13:00:00	SPY	ETF	143.63	143.68	143.52	143.64	8402838.0
2012-09-06 14:00:00	SPY	ETF	143.63	143.71	143.47	143.59	11949830.0
2012-09-06 15:00:00	SPY	ETF	143.58	143.78	143.385	143.74	33776247.0
2012-09-06 16:00:00	SPY	ETF	143.73	143.88	140.9025	143.88	13620974.0
2012-09-06 17:00:00	SPY	ETF	143.89	143.93	143.77	143.8	395359.0
2012-09-06 18:00:00	SPY	ETF	143.81	143.83	143.75	143.75	235113.0
2012-09-06 19:00:00	SPY	ETF	143.75	143.82	143.74	143.81	65785.0
2012-09-06 04:00:00	QQQ	ETF	68.33	68.45	68.33	68.45	1673.0
2012-09-06 05:00:00	QQQ	ETF	68.41	68.41	68.41	68.41	100.0
2012-09-06 06:00:00	QQQ	ETF	68.4	68.44	68.4	68.44	1500.0
2012-09-06 07:00:00	QQQ	ETF	68.41	68.41	68.26	68.37	64682.0
2012-09-06 08:00:00	QQQ	ETF	68.36	68.48	68.2	68.34	702271.0
2012-09-06 09:00:00	QQQ	ETF	68.32	68.82	68.32	68.81	6514313.0
2012-09-06 10:00:00	QQQ	ETF	68.82	69.27	68.815	69.253	8610699.0
2012-09-06 11:00:00	QQQ	ETF	69.26	69.4	69.17	69.37	5876536.0
2012-09-06 12:00:00	QQQ	ETF	69.371	69.48	69.365	69.4099	2412069.0
2012-09-06 13:00:00	QQQ	ETF	69.4	69.51	69.37	69.4683	2656877.0
2012-09-06 14:00:00	QQQ	ETF	69.4635	69.55	69.38	69.4784	2445260.0
2012-09-06 15:00:00	QQQ	ETF	69.47	69.54	69.4	69.5	7352839.0
2012-09-06 16:00:00	QQQ	ETF	69.5	69.55	69.14	69.55	1285229.0
2012-09-06 17:00:00	QQQ	ETF	69.53	69.62	69.53	69.54	5466.0
2012-09-06 18:00:00	QQQ	ETF	69.52	69.53	69.47	69.48	22308.0
2012-09-06 19:00:00	QQQ	ETF	69.48	69.49	69.48	69.48	16342.0
2012-09-06 04:00:00	IWM	ETF	82.67	82.67	82.67	82.67	100.0
2012-09-06 07:00:00	IWM	ETF	82.65	82.69	82.53	82.69	56233.0
2012-09-06 08:00:00	IWM	ETF	82.69	83.56	82.38	82.51	716552.0
2012-09-06 09:00:00	IWM	ETF	82.5	82.93	82.5	82.8	5437626.0
2012-09-06 10:00:00	IWM	ETF	82.81	83.67	82.81	83.64	8270577.0
2012-09-06 11:00:00	IWM	ETF	83.63	83.86	83.52	83.8	7695313.0
2012-09-06 12:00:00	IWM	ETF	83.8	83.9401	83.79	83.83	3096550.0
2012-09-06 13:00:00	IWM	ETF	83.83	83.87	83.73	83.8	3411073.0
2012-09-06 14:00:00	IWM	ETF	83.8	83.82	83.631	83.6499	2214346.0
2012-09-06 15:00:00	IWM	ETF	83.64	83.74	83.5	83.58	7278613.0
2012-09-06 16:00:00	IWM	ETF	83.58	83.8701	83.53	83.66	2715620.0
2012-09-06 17:00:00	IWM	ETF	83.71	83.75	83.71	83.71	8060.0
2012-09-06 18:00:00	IWM	ETF	83.68	83.68	83.66	83.66	1900.0
2012-09-06 19:00:00	IWM	ETF	83.66	83.73	83.66	83.73	3480.0
2012-09-06 07:00:00	DIA	ETF	130.99	130.99	130.99	130.99	1000.0
2012-09-06 08:00:00	DIA	ETF	131.08	131.25	130.98	131.0	12920.0
2012-09-06 09:00:00	DIA	ETF	131.09	131.98	131.09	131.92	1197141.0
2012-09-06 10:00:00	DIA	ETF	131.93	132.78	131.93	132.75	1147978.0

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

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