PREVIEW / etf_1hour / 2014-03-18

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-03-18.parquet
  size:    218 KB
  rows:    6,782

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-03-18 04:00:00	SPY	ETF	186.24	186.26	185.87	186.05	61250.0
2014-03-18 05:00:00	SPY	ETF	185.99	186.05	185.91	185.95	25849.0
2014-03-18 06:00:00	SPY	ETF	185.93	186.29	185.89	185.9	63336.0
2014-03-18 07:00:00	SPY	ETF	185.93	187.13	185.78	186.96	1465078.0
2014-03-18 08:00:00	SPY	ETF	187.06	187.07	185.9	186.82	1204229.0
2014-03-18 09:00:00	SPY	ETF	186.82	187.27	186.51	187.17	14674265.0
2014-03-18 10:00:00	SPY	ETF	187.18	187.74	187.03	187.23	19368950.0
2014-03-18 11:00:00	SPY	ETF	187.22	187.66	187.19	187.565	11744022.0
2014-03-18 12:00:00	SPY	ETF	187.57	187.68	187.28	187.46	10684317.0
2014-03-18 13:00:00	SPY	ETF	187.46	187.89	187.39	187.74	9836699.0
2014-03-18 14:00:00	SPY	ETF	187.747	187.91	187.65	187.819	8151334.0
2014-03-18 15:00:00	SPY	ETF	187.81	187.84	187.55	187.69	16098196.0
2014-03-18 16:00:00	SPY	ETF	187.69	187.8318	186.395	187.63	6990436.0
2014-03-18 17:00:00	SPY	ETF	187.61	187.66	186.395	187.63	516198.0
2014-03-18 18:00:00	SPY	ETF	187.63	187.63	187.45	187.53	139214.0
2014-03-18 19:00:00	SPY	ETF	187.53	187.69	187.52	187.69	38401.0
2014-03-18 04:00:00	QQQ	ETF	89.35	89.35	89.19	89.19	18100.0
2014-03-18 05:00:00	QQQ	ETF	89.24	89.25	89.19	89.22	19000.0
2014-03-18 06:00:00	QQQ	ETF	89.17	89.39	89.17	89.25	14150.0
2014-03-18 07:00:00	QQQ	ETF	89.19	89.76	89.15	89.7	49700.0
2014-03-18 08:00:00	QQQ	ETF	89.7	89.77	89.19	89.64	70104.0
2014-03-18 09:00:00	QQQ	ETF	89.64	90.0699	89.45	90.02	5073668.0
2014-03-18 10:00:00	QQQ	ETF	90.03	90.33	89.93	90.19	6055691.0
2014-03-18 11:00:00	QQQ	ETF	90.2	90.4	90.18	90.385	3137279.0
2014-03-18 12:00:00	QQQ	ETF	90.38	90.47	90.27	90.35	2293722.0
2014-03-18 13:00:00	QQQ	ETF	90.351	90.6	90.28	90.55	2066178.0
2014-03-18 14:00:00	QQQ	ETF	90.543	90.64	90.47	90.57	2149210.0
2014-03-18 15:00:00	QQQ	ETF	90.58	90.63	90.47	90.545	5218428.0
2014-03-18 16:00:00	QQQ	ETF	90.53	90.5664	89.5101	90.51	1561363.0
2014-03-18 17:00:00	QQQ	ETF	90.5	90.56	90.49	90.56	684689.0
2014-03-18 18:00:00	QQQ	ETF	90.49	90.49	90.42	90.45	15713.0
2014-03-18 19:00:00	QQQ	ETF	90.45	90.52	90.45	90.52	6754.0
2014-03-18 05:00:00	IWM	ETF	117.88	117.88	117.88	117.88	128.0
2014-03-18 06:00:00	IWM	ETF	117.88	117.88	117.88	117.88	200.0
2014-03-18 07:00:00	IWM	ETF	117.64	118.51	117.64	118.39	212150.0
2014-03-18 08:00:00	IWM	ETF	118.41	118.47	118.29	118.29	121416.0
2014-03-18 09:00:00	IWM	ETF	118.28	118.69	118.1	118.6	4644315.0
2014-03-18 10:00:00	IWM	ETF	118.6	119.22	118.5	118.97	6151773.0
2014-03-18 11:00:00	IWM	ETF	118.98	119.47	118.96	119.44	4142567.0
2014-03-18 12:00:00	IWM	ETF	119.44	119.61	119.22	119.28	3888284.0
2014-03-18 13:00:00	IWM	ETF	119.3	119.85	119.18	119.7901	4122011.0
2014-03-18 14:00:00	IWM	ETF	119.79	119.88	119.66	119.8	2439987.0
2014-03-18 15:00:00	IWM	ETF	119.81	119.84	119.525	119.78	5429039.0
2014-03-18 16:00:00	IWM	ETF	119.79	119.8	118.3856	119.69	2420390.0
2014-03-18 17:00:00	IWM	ETF	119.69	119.81	119.65	119.65	339713.0
2014-03-18 18:00:00	IWM	ETF	119.67	119.67	119.66	119.66	2037.0
2014-03-18 19:00:00	IWM	ETF	119.63	119.65	119.63	119.64	3000.0
2014-03-18 07:00:00	DIA	ETF	162.89	163.04	162.86	162.86	1500.0
2014-03-18 08:00:00	DIA	ETF	162.9	162.9	162.8	162.819	9706.0
2014-03-18 09:00:00	DIA	ETF	162.71	163.13	162.55	163.08	757962.0

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

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