PREVIEW / etf_1hour / 2012-10-23

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-10-23.parquet
  size:    195 KB
  rows:    6,041

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-10-23 04:00:00	SPY	ETF	142.71	142.71	142.54	142.63	34249.0
2012-10-23 05:00:00	SPY	ETF	142.51	142.75	142.47	142.7	85658.0
2012-10-23 06:00:00	SPY	ETF	142.68	142.71	141.35	141.94	457762.0
2012-10-23 07:00:00	SPY	ETF	141.95	142.26	141.94	142.09	923131.0
2012-10-23 08:00:00	SPY	ETF	142.1	143.41	141.71	141.93	2578722.0
2012-10-23 09:00:00	SPY	ETF	141.93	142.03	141.37	141.57	23243163.0
2012-10-23 10:00:00	SPY	ETF	141.57	141.82	140.83	141.18	35424255.0
2012-10-23 11:00:00	SPY	ETF	141.18	141.36	140.98	141.25	18404769.0
2012-10-23 12:00:00	SPY	ETF	141.25	141.68	141.145	141.61	15518344.0
2012-10-23 13:00:00	SPY	ETF	141.6	141.87	141.43	141.68	17614513.0
2012-10-23 14:00:00	SPY	ETF	141.68	141.98	141.27	141.89	22690340.0
2012-10-23 15:00:00	SPY	ETF	141.8899	142.06	141.3	141.4	35562946.0
2012-10-23 16:00:00	SPY	ETF	141.39	143.483	141.2	141.46	18119218.0
2012-10-23 17:00:00	SPY	ETF	141.45	141.48	141.39	141.47	168108.0
2012-10-23 18:00:00	SPY	ETF	141.49	141.49	141.45	141.45	54216.0
2012-10-23 19:00:00	SPY	ETF	141.47	141.54	141.41	141.53	92589.0
2012-10-23 04:00:00	QQQ	ETF	65.66	65.66	65.62	65.63	1000.0
2012-10-23 05:00:00	QQQ	ETF	65.6	65.67	65.55	65.64	3000.0
2012-10-23 06:00:00	QQQ	ETF	65.61	65.61	65.36	65.39	23629.0
2012-10-23 07:00:00	QQQ	ETF	65.39	65.54	65.38	65.46	87800.0
2012-10-23 08:00:00	QQQ	ETF	65.46	65.53	65.31	65.39	386906.0
2012-10-23 09:00:00	QQQ	ETF	65.4	65.57	65.3	65.45	5393045.0
2012-10-23 10:00:00	QQQ	ETF	65.44	65.68	65.19	65.43	7219298.0
2012-10-23 11:00:00	QQQ	ETF	65.43	65.54	65.342	65.52	5326572.0
2012-10-23 12:00:00	QQQ	ETF	65.52	65.85	65.445	65.77	4197474.0
2012-10-23 13:00:00	QQQ	ETF	65.77	65.95	65.6	65.74	4259357.0
2012-10-23 14:00:00	QQQ	ETF	65.73	65.83	65.36	65.7	5751705.0
2012-10-23 15:00:00	QQQ	ETF	65.69	65.82	65.33	65.37	8825009.0
2012-10-23 16:00:00	QQQ	ETF	65.37	66.0773	65.33	65.47	7934514.0
2012-10-23 17:00:00	QQQ	ETF	65.48	65.53	65.47	65.53	16819.0
2012-10-23 18:00:00	QQQ	ETF	65.53	65.58	65.48	65.53	2697.0
2012-10-23 19:00:00	QQQ	ETF	65.55	65.55	65.49	65.55	6906.0
2012-10-23 04:00:00	IWM	ETF	81.45	81.45	81.45	81.45	176.0
2012-10-23 06:00:00	IWM	ETF	81.4	81.4	81.03	81.03	300.0
2012-10-23 07:00:00	IWM	ETF	81.08	81.12	80.91	80.96	128397.0
2012-10-23 08:00:00	IWM	ETF	80.99	81.01	80.85	80.99	249327.0
2012-10-23 09:00:00	IWM	ETF	81.01	81.17	80.68	80.78	6175092.0
2012-10-23 10:00:00	IWM	ETF	80.77	80.935	80.43	80.6	6979243.0
2012-10-23 11:00:00	IWM	ETF	80.606	80.715	80.5	80.7	4896584.0
2012-10-23 12:00:00	IWM	ETF	80.71	81.13	80.64	81.13	3137748.0
2012-10-23 13:00:00	IWM	ETF	81.1248	81.33	81.07	81.18	3188816.0
2012-10-23 14:00:00	IWM	ETF	81.18	81.5	81.1	81.42	4042635.0
2012-10-23 15:00:00	IWM	ETF	81.43	81.53	81.19	81.41	7226991.0
2012-10-23 16:00:00	IWM	ETF	81.41	81.49	80.88	81.48	1001136.0
2012-10-23 17:00:00	IWM	ETF	81.48	81.54	81.4	81.54	7758.0
2012-10-23 18:00:00	IWM	ETF	81.48	81.48	81.48	81.48	1150.0
2012-10-23 19:00:00	IWM	ETF	81.52	81.57	81.52	81.52	300.0
2012-10-23 06:00:00	DIA	ETF	132.05	132.05	132.05	132.05	100.0
2012-10-23 07:00:00	DIA	ETF	132.1	132.1	131.95	131.95	1100.0
2012-10-23 08:00:00	DIA	ETF	132.03	132.03	131.61	131.78	30727.0

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

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