PREVIEW / etf_1hour / 2013-05-07

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-05-07.parquet
  size:    204 KB
  rows:    6,398

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
2013-05-07 04:00:00	SPY	ETF	161.78	161.78	161.78	161.78	200.0
2013-05-07 05:00:00	SPY	ETF	161.79	161.96	161.79	161.96	18300.0
2013-05-07 06:00:00	SPY	ETF	161.91	162.06	161.91	162.03	39844.0
2013-05-07 07:00:00	SPY	ETF	162.03	162.12	162.0	162.1	184853.0
2013-05-07 08:00:00	SPY	ETF	162.0	162.16	161.343	162.01	902147.0
2013-05-07 09:00:00	SPY	ETF	162.01	162.39	161.99	162.37	12941268.0
2013-05-07 10:00:00	SPY	ETF	162.37	162.43	161.67	162.04	20507175.0
2013-05-07 11:00:00	SPY	ETF	162.04	162.25	162.0	162.101	9188208.0
2013-05-07 12:00:00	SPY	ETF	162.1016	162.47	162.09	162.45	8949660.0
2013-05-07 13:00:00	SPY	ETF	162.44	162.625	162.37	162.56	7219699.0
2013-05-07 14:00:00	SPY	ETF	162.56	162.63	162.42	162.61	7908224.0
2013-05-07 15:00:00	SPY	ETF	162.619	162.65	162.5	162.59	14698579.0
2013-05-07 16:00:00	SPY	ETF	162.59	162.66	161.7775	162.56	6492763.0
2013-05-07 17:00:00	SPY	ETF	162.56	162.59	162.53	162.55	208551.0
2013-05-07 18:00:00	SPY	ETF	162.55	162.55	162.31	162.34	323155.0
2013-05-07 19:00:00	SPY	ETF	162.35	162.48	162.34	162.48	87820.0
2013-05-07 04:00:00	QQQ	ETF	72.41	72.41	72.41	72.41	9600.0
2013-05-07 06:00:00	QQQ	ETF	72.51	72.51	72.51	72.51	1600.0
2013-05-07 07:00:00	QQQ	ETF	72.49	72.52	72.48	72.52	19600.0
2013-05-07 08:00:00	QQQ	ETF	72.51	72.53	72.45	72.47	240966.0
2013-05-07 09:00:00	QQQ	ETF	72.47	72.57	72.43	72.55	3597278.0
2013-05-07 10:00:00	QQQ	ETF	72.55	72.57	72.09	72.22	7307950.0
2013-05-07 11:00:00	QQQ	ETF	72.23	72.39	72.22	72.27	2033882.0
2013-05-07 12:00:00	QQQ	ETF	72.2799	72.43	72.27	72.41	2274099.0
2013-05-07 13:00:00	QQQ	ETF	72.41	72.46	72.32	72.43	1548786.0
2013-05-07 14:00:00	QQQ	ETF	72.425	72.47	72.33	72.425	2265703.0
2013-05-07 15:00:00	QQQ	ETF	72.42	72.44	72.24	72.34	3820519.0
2013-05-07 16:00:00	QQQ	ETF	72.34	72.4066	72.3087	72.34	2513811.0
2013-05-07 17:00:00	QQQ	ETF	72.35	72.39	72.35	72.36	7980.0
2013-05-07 18:00:00	QQQ	ETF	72.33	72.35	72.27	72.27	61024.0
2013-05-07 19:00:00	QQQ	ETF	72.28	72.3	72.28	72.3	3862.0
2013-05-07 06:00:00	IWM	ETF	95.54	95.54	95.54	95.54	200.0
2013-05-07 07:00:00	IWM	ETF	95.52	95.64	95.52	95.6	23695.0
2013-05-07 08:00:00	IWM	ETF	95.58	95.59	95.42	95.44	51311.0
2013-05-07 09:00:00	IWM	ETF	95.47	96.01	95.47	95.955	4127844.0
2013-05-07 10:00:00	IWM	ETF	95.95	96.005	95.13	95.53	7421691.0
2013-05-07 11:00:00	IWM	ETF	95.54	95.71	95.42	95.53	3118809.0
2013-05-07 12:00:00	IWM	ETF	95.52	95.94	95.51	95.88	3104568.0
2013-05-07 13:00:00	IWM	ETF	95.875	95.98	95.78	95.91	2398116.0
2013-05-07 14:00:00	IWM	ETF	95.911	96.08	95.89	96.01	2228798.0
2013-05-07 15:00:00	IWM	ETF	96.0	96.17	95.95	96.14	3640225.0
2013-05-07 16:00:00	IWM	ETF	96.14	96.16	95.3664	96.02	1213543.0
2013-05-07 17:00:00	IWM	ETF	96.05	96.12	96.05	96.12	20550.0
2013-05-07 18:00:00	IWM	ETF	96.01	96.01	96.01	96.01	1003.0
2013-05-07 19:00:00	IWM	ETF	96.03	96.03	95.99	95.99	1386.0
2013-05-07 07:00:00	DIA	ETF	149.76	149.76	149.76	149.76	100.0
2013-05-07 08:00:00	DIA	ETF	149.75	149.75	149.67	149.67	351700.0
2013-05-07 09:00:00	DIA	ETF	149.73	149.89	149.61	149.89	465376.0
2013-05-07 10:00:00	DIA	ETF	149.9	149.98	149.44	149.78	1382362.0
2013-05-07 11:00:00	DIA	ETF	149.78	149.94	149.68	149.78	408137.0

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

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