PREVIEW / etf_1hour / 2014-03-24

all etf 1-hour files

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

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-24 04:00:00	SPY	ETF	186.47	186.92	186.47	186.69	50350.0
2014-03-24 05:00:00	SPY	ETF	186.66	186.66	186.42	186.58	24039.0
2014-03-24 06:00:00	SPY	ETF	186.57	186.72	186.42	186.54	72407.0
2014-03-24 07:00:00	SPY	ETF	186.53	186.66	186.5	186.59	304962.0
2014-03-24 08:00:00	SPY	ETF	186.53	186.74	186.32	186.67	535148.0
2014-03-24 09:00:00	SPY	ETF	186.67	187.07	186.19	186.3	14271185.0
2014-03-24 10:00:00	SPY	ETF	186.305	186.31	185.16	185.2499	21768074.0
2014-03-24 11:00:00	SPY	ETF	185.2411	185.2411	184.73	184.99	17892838.0
2014-03-24 12:00:00	SPY	ETF	184.99	185.18	184.62	184.84	12751984.0
2014-03-24 13:00:00	SPY	ETF	184.84	185.45	184.83	185.41	10377643.0
2014-03-24 14:00:00	SPY	ETF	185.41	185.73	185.2	185.4629	13497495.0
2014-03-24 15:00:00	SPY	ETF	185.47	185.95	185.16	185.41	21114625.0
2014-03-24 16:00:00	SPY	ETF	185.42	186.3398	185.34	185.43	7477569.0
2014-03-24 17:00:00	SPY	ETF	185.495	185.53	185.41	185.44	162025.0
2014-03-24 18:00:00	SPY	ETF	185.47	185.6	185.43	185.59	523583.0
2014-03-24 19:00:00	SPY	ETF	185.56	185.69	185.55	185.59	132990.0
2014-03-24 04:00:00	QQQ	ETF	89.22	89.34	89.2	89.22	38000.0
2014-03-24 05:00:00	QQQ	ETF	89.15	89.15	89.15	89.15	1000.0
2014-03-24 06:00:00	QQQ	ETF	89.23	89.24	89.13	89.14	57520.0
2014-03-24 07:00:00	QQQ	ETF	89.16	89.26	89.16	89.26	59530.0
2014-03-24 08:00:00	QQQ	ETF	89.25	89.27	89.13	89.25	169177.0
2014-03-24 09:00:00	QQQ	ETF	89.26	89.39	88.5	88.73	8317814.0
2014-03-24 10:00:00	QQQ	ETF	88.73	88.7353	87.7	87.81	15257484.0
2014-03-24 11:00:00	QQQ	ETF	87.81	87.93	87.41	87.72	14236074.0
2014-03-24 12:00:00	QQQ	ETF	87.72	87.89	87.52	87.61	8094393.0
2014-03-24 13:00:00	QQQ	ETF	87.61	88.09	87.605	88.06	5791516.0
2014-03-24 14:00:00	QQQ	ETF	88.06	88.44	88.0	88.27	5228150.0
2014-03-24 15:00:00	QQQ	ETF	88.27	88.52	88.01	88.23	8139646.0
2014-03-24 16:00:00	QQQ	ETF	88.23	89.0712	87.59	88.32	3428749.0
2014-03-24 17:00:00	QQQ	ETF	88.32	88.35	88.22	88.3	2177379.0
2014-03-24 18:00:00	QQQ	ETF	88.31	88.34	88.26	88.28	7633.0
2014-03-24 19:00:00	QQQ	ETF	88.32	88.37	88.32	88.33	9552.0
2014-03-24 06:00:00	IWM	ETF	118.69	118.69	118.69	118.69	200.0
2014-03-24 07:00:00	IWM	ETF	118.82	118.82	118.76	118.76	15500.0
2014-03-24 08:00:00	IWM	ETF	118.8	118.97	118.68	118.91	49808.0
2014-03-24 09:00:00	IWM	ETF	118.9	119.23	118.2	118.33	5562688.0
2014-03-24 10:00:00	IWM	ETF	118.32	118.33	116.69	116.92	14208283.0
2014-03-24 11:00:00	IWM	ETF	116.91	116.92	116.19	116.57	10870072.0
2014-03-24 12:00:00	IWM	ETF	116.57	116.79	116.38	116.55	4915598.0
2014-03-24 13:00:00	IWM	ETF	116.55	117.19	116.52	117.15	4765696.0
2014-03-24 14:00:00	IWM	ETF	117.16	117.32	116.88	117.095	5896091.0
2014-03-24 15:00:00	IWM	ETF	117.1	117.52	116.85	117.25	8362712.0
2014-03-24 16:00:00	IWM	ETF	117.24	118.7122	117.12	117.19	3973369.0
2014-03-24 17:00:00	IWM	ETF	117.27	117.47	117.25	117.26	164408.0
2014-03-24 18:00:00	IWM	ETF	117.2	117.26	117.19	117.19	1339.0
2014-03-24 19:00:00	IWM	ETF	117.34	117.34	117.34	117.34	600.0
2014-03-24 04:00:00	DIA	ETF	163.02	163.02	163.0	163.0	900.0
2014-03-24 08:00:00	DIA	ETF	163.1	163.1	162.8	163.0	4550.0
2014-03-24 09:00:00	DIA	ETF	163.03	163.46	162.95	163.03	705186.0
2014-03-24 10:00:00	DIA	ETF	163.03	163.03	162.23	162.38	1162751.0

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

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