PREVIEW / etf_1hour / 2014-02-26

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-02-26.parquet
  size:    214 KB
  rows:    6,726

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
2014-02-26 04:00:00	SPY	ETF	185.57	185.57	185.38	185.39	29195.0
2014-02-26 05:00:00	SPY	ETF	185.47	185.56	185.47	185.48	8959.0
2014-02-26 06:00:00	SPY	ETF	185.47	185.56	185.42	185.45	4984.0
2014-02-26 07:00:00	SPY	ETF	185.47	185.51	185.28	185.41	286560.0
2014-02-26 08:00:00	SPY	ETF	185.48	185.64	185.27	185.32	576703.0
2014-02-26 09:00:00	SPY	ETF	185.32	185.36	184.54	184.64	10562591.0
2014-02-26 10:00:00	SPY	ETF	184.64	185.6	184.63	185.25	17408397.0
2014-02-26 11:00:00	SPY	ETF	185.25	185.58	185.11	185.26	8377264.0
2014-02-26 12:00:00	SPY	ETF	185.25	185.53	185.24	185.37	5454881.0
2014-02-26 13:00:00	SPY	ETF	185.38	185.495	185.09	185.16	7464933.0
2014-02-26 14:00:00	SPY	ETF	185.16	185.26	184.33	184.73	16015589.0
2014-02-26 15:00:00	SPY	ETF	184.73	184.92	184.35	184.83	20118301.0
2014-02-26 16:00:00	SPY	ETF	184.82	184.86	184.65	184.81	8159655.0
2014-02-26 17:00:00	SPY	ETF	184.81	185.01	184.81	184.98	2670132.0
2014-02-26 18:00:00	SPY	ETF	184.96	184.96	184.79	184.88	74598.0
2014-02-26 19:00:00	SPY	ETF	184.89	184.9	184.75	184.86	303966.0
2014-02-26 04:00:00	QQQ	ETF	90.62	90.62	90.61	90.61	2700.0
2014-02-26 06:00:00	QQQ	ETF	90.63	90.69	90.62	90.63	9000.0
2014-02-26 07:00:00	QQQ	ETF	90.64	90.65	90.55	90.63	34315.0
2014-02-26 08:00:00	QQQ	ETF	90.63	90.67	90.58	90.6	89908.0
2014-02-26 09:00:00	QQQ	ETF	90.61	90.6999	90.245	90.3299	3600843.0
2014-02-26 10:00:00	QQQ	ETF	90.33	90.81	90.31	90.6299	6490143.0
2014-02-26 11:00:00	QQQ	ETF	90.63	90.84	90.611	90.675	2935508.0
2014-02-26 12:00:00	QQQ	ETF	90.675	90.77	90.63	90.68	1730455.0
2014-02-26 13:00:00	QQQ	ETF	90.6899	90.6899	90.45	90.48	2576308.0
2014-02-26 14:00:00	QQQ	ETF	90.47	90.51	89.87	90.1476	5032687.0
2014-02-26 15:00:00	QQQ	ETF	90.14	90.24	89.95	90.21	9039403.0
2014-02-26 16:00:00	QQQ	ETF	90.22	90.81	90.085	90.26	4642414.0
2014-02-26 17:00:00	QQQ	ETF	90.26	90.34	90.26	90.3	12820.0
2014-02-26 18:00:00	QQQ	ETF	90.29	90.33	90.28	90.28	6538.0
2014-02-26 19:00:00	QQQ	ETF	90.32	90.33	90.25	90.3	8060.0
2014-02-26 06:00:00	IWM	ETF	117.04	117.04	117.04	117.04	100.0
2014-02-26 07:00:00	IWM	ETF	116.83	116.9	116.78	116.87	12500.0
2014-02-26 08:00:00	IWM	ETF	116.86	116.91	116.79	116.79	136568.0
2014-02-26 09:00:00	IWM	ETF	116.82	117.09	116.43	116.66	3492067.0
2014-02-26 10:00:00	IWM	ETF	116.66	117.64	116.6	117.45	6926816.0
2014-02-26 11:00:00	IWM	ETF	117.45	117.76	117.44	117.68	4355668.0
2014-02-26 12:00:00	IWM	ETF	117.68	118.11	117.67	117.91	3139089.0
2014-02-26 13:00:00	IWM	ETF	117.91	118.11	117.7	117.76	2780031.0
2014-02-26 14:00:00	IWM	ETF	117.752	117.845	116.94	117.25	5513929.0
2014-02-26 15:00:00	IWM	ETF	117.26	117.47	116.985	117.31	9507708.0
2014-02-26 16:00:00	IWM	ETF	117.31	117.45	117.22	117.37	1112690.0
2014-02-26 17:00:00	IWM	ETF	117.37	117.48	117.35	117.42	991022.0
2014-02-26 18:00:00	IWM	ETF	117.44	117.47	117.39	117.39	3540.0
2014-02-26 19:00:00	IWM	ETF	117.47	117.47	117.37	117.38	6632.0
2014-02-26 07:00:00	DIA	ETF	162.0	162.0	161.84	161.99	350.0
2014-02-26 08:00:00	DIA	ETF	161.88	162.03	161.88	161.88	12000.0
2014-02-26 09:00:00	DIA	ETF	161.9	161.99	161.3	161.4	652331.0
2014-02-26 10:00:00	DIA	ETF	161.4	162.258	161.38	161.91	1041369.0
2014-02-26 11:00:00	DIA	ETF	161.9	162.19	161.78	161.91	420054.0

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

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