PREVIEW / etf_1hour / 2014-02-24

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-02-24.parquet
  size:    220 KB
  rows:    6,954

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-24 04:00:00	SPY	ETF	184.0	184.4	184.0	184.19	8776.0
2014-02-24 05:00:00	SPY	ETF	184.15	184.15	183.95	183.98	51053.0
2014-02-24 06:00:00	SPY	ETF	183.98	184.32	183.98	184.32	79698.0
2014-02-24 07:00:00	SPY	ETF	184.29	184.47	184.29	184.37	593570.0
2014-02-24 08:00:00	SPY	ETF	184.38	184.59	184.32	184.36	566975.0
2014-02-24 09:00:00	SPY	ETF	184.36	185.45	184.19	185.36	15980882.0
2014-02-24 10:00:00	SPY	ETF	185.37	185.6928	185.155	185.55	15548988.0
2014-02-24 11:00:00	SPY	ETF	185.56	186.11	185.46	186.04	12979401.0
2014-02-24 12:00:00	SPY	ETF	186.04	186.15	185.91	185.935	8901000.0
2014-02-24 13:00:00	SPY	ETF	185.93	186.0	185.73	185.75	7595671.0
2014-02-24 14:00:00	SPY	ETF	185.75	185.97	185.71	185.71	6458358.0
2014-02-24 15:00:00	SPY	ETF	185.72	185.72	184.98	184.99	27929058.0
2014-02-24 16:00:00	SPY	ETF	184.95	186.12	183.885	184.96	13911665.0
2014-02-24 17:00:00	SPY	ETF	184.99	184.99	184.88	184.92	174725.0
2014-02-24 18:00:00	SPY	ETF	184.92	184.99	184.83	184.99	70352.0
2014-02-24 19:00:00	SPY	ETF	185.0	185.09	184.99	185.07	106333.0
2014-02-24 04:00:00	QQQ	ETF	90.03	90.15	90.0	90.08	8710.0
2014-02-24 05:00:00	QQQ	ETF	90.03	90.03	89.94	89.99	7000.0
2014-02-24 06:00:00	QQQ	ETF	89.96	90.07	89.96	90.07	1751.0
2014-02-24 07:00:00	QQQ	ETF	90.16	90.16	90.11	90.13	23310.0
2014-02-24 08:00:00	QQQ	ETF	90.11	90.25	90.1	90.14	162793.0
2014-02-24 09:00:00	QQQ	ETF	90.13	90.58	90.04	90.545	4229921.0
2014-02-24 10:00:00	QQQ	ETF	90.55	90.71	90.46	90.6619	4990760.0
2014-02-24 11:00:00	QQQ	ETF	90.67	90.79	90.595	90.7401	2172976.0
2014-02-24 12:00:00	QQQ	ETF	90.74	90.8	90.65	90.66	1246541.0
2014-02-24 13:00:00	QQQ	ETF	90.66	90.81	90.63	90.65	952453.0
2014-02-24 14:00:00	QQQ	ETF	90.655	90.82	90.65	90.6801	2590040.0
2014-02-24 15:00:00	QQQ	ETF	90.68	90.69	90.45	90.4699	5217067.0
2014-02-24 16:00:00	QQQ	ETF	90.45	90.51	90.216	90.47	1165835.0
2014-02-24 17:00:00	QQQ	ETF	90.46	90.51	90.45	90.51	27995.0
2014-02-24 18:00:00	QQQ	ETF	90.43	90.43	90.36	90.43	6500.0
2014-02-24 19:00:00	QQQ	ETF	90.47	90.52	90.47	90.52	8200.0
2014-02-24 07:00:00	IWM	ETF	115.97	116.05	115.76	115.95	92700.0
2014-02-24 08:00:00	IWM	ETF	115.93	116.09	115.87	115.87	121711.0
2014-02-24 09:00:00	IWM	ETF	115.87	116.56	115.76	116.45	4599874.0
2014-02-24 10:00:00	IWM	ETF	116.46	116.9473	116.37	116.85	4492532.0
2014-02-24 11:00:00	IWM	ETF	116.85	117.27	116.7	117.2499	4071106.0
2014-02-24 12:00:00	IWM	ETF	117.25	117.305	117.155	117.27	3558589.0
2014-02-24 13:00:00	IWM	ETF	117.27	117.3	117.03	117.0937	2720521.0
2014-02-24 14:00:00	IWM	ETF	117.095	117.23	117.03	117.03	2546082.0
2014-02-24 15:00:00	IWM	ETF	117.035	117.05	116.6	116.61	7494528.0
2014-02-24 16:00:00	IWM	ETF	116.6	117.2125	115.6585	116.51	5285763.0
2014-02-24 17:00:00	IWM	ETF	116.49	116.53	116.47	116.5	11634.0
2014-02-24 18:00:00	IWM	ETF	116.5	116.52	116.47	116.52	5666.0
2014-02-24 19:00:00	IWM	ETF	116.52	116.61	116.51	116.61	1400.0
2014-02-24 04:00:00	DIA	ETF	160.7	160.7	160.7	160.7	100.0
2014-02-24 07:00:00	DIA	ETF	161.1	161.1	161.1	161.1	900.0
2014-02-24 08:00:00	DIA	ETF	161.2	161.3	161.04	161.04	8300.0
2014-02-24 09:00:00	DIA	ETF	161.07	162.17	160.96	162.06	1269586.0
2014-02-24 10:00:00	DIA	ETF	162.06	162.3	161.84	162.14	1289847.0

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

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