PREVIEW / etf_1hour / 2014-03-27

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-03-27.parquet
  size:    215 KB
  rows:    6,801

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-27 04:00:00	SPY	ETF	185.14	185.14	184.91	184.97	13751.0
2014-03-27 05:00:00	SPY	ETF	185.0	185.3	185.0	185.26	72784.0
2014-03-27 06:00:00	SPY	ETF	185.26	185.29	185.04	185.2	102847.0
2014-03-27 07:00:00	SPY	ETF	185.21	185.27	184.94	184.96	265770.0
2014-03-27 08:00:00	SPY	ETF	184.99	185.14	184.43	184.67	1291956.0
2014-03-27 09:00:00	SPY	ETF	184.65	184.94	183.9	184.48	23309895.0
2014-03-27 10:00:00	SPY	ETF	184.47	185.34	184.32	185.03	25484030.0
2014-03-27 11:00:00	SPY	ETF	185.07	185.1666	184.04	184.37	25360844.0
2014-03-27 12:00:00	SPY	ETF	184.37	184.8799	184.03	184.58	12024313.0
2014-03-27 13:00:00	SPY	ETF	184.58	184.94	184.36	184.51	11794363.0
2014-03-27 14:00:00	SPY	ETF	184.52	184.73	184.24	184.47	11181137.0
2014-03-27 15:00:00	SPY	ETF	184.47	184.89	184.27	184.62	19540417.0
2014-03-27 16:00:00	SPY	ETF	184.64	185.0035	184.46	184.74	6629184.0
2014-03-27 17:00:00	SPY	ETF	184.75	184.85	184.58	184.78	742497.0
2014-03-27 18:00:00	SPY	ETF	184.79	184.9	184.79	184.85	118916.0
2014-03-27 19:00:00	SPY	ETF	184.88	184.89	184.76	184.8	92595.0
2014-03-27 04:00:00	QQQ	ETF	87.44	87.48	87.42	87.44	1100.0
2014-03-27 05:00:00	QQQ	ETF	87.48	87.6	87.48	87.6	1700.0
2014-03-27 06:00:00	QQQ	ETF	87.6	87.6	87.48	87.56	25700.0
2014-03-27 07:00:00	QQQ	ETF	87.55	87.57	87.4	87.4	40335.0
2014-03-27 08:00:00	QQQ	ETF	87.42	87.47	87.13	87.27	246452.0
2014-03-27 09:00:00	QQQ	ETF	87.25	87.36	86.4	87.0	12992245.0
2014-03-27 10:00:00	QQQ	ETF	87.01	87.64	86.8701	87.319	14613993.0
2014-03-27 11:00:00	QQQ	ETF	87.31	87.36	86.56	86.83	6790337.0
2014-03-27 12:00:00	QQQ	ETF	86.83	87.089	86.53	86.97	6226817.0
2014-03-27 13:00:00	QQQ	ETF	86.96	87.24	86.82	86.91	3964126.0
2014-03-27 14:00:00	QQQ	ETF	86.92	87.11	86.69	86.82	5573937.0
2014-03-27 15:00:00	QQQ	ETF	86.83	87.06	86.651	86.87	9522972.0
2014-03-27 16:00:00	QQQ	ETF	86.87	86.97	86.75	86.94	1079700.0
2014-03-27 17:00:00	QQQ	ETF	86.97	87.05	86.88	87.02	1060252.0
2014-03-27 18:00:00	QQQ	ETF	87.01	87.06	86.89	87.05	21488.0
2014-03-27 19:00:00	QQQ	ETF	87.04	87.05	86.97	86.97	25727.0
2014-03-27 05:00:00	IWM	ETF	114.97	114.97	114.97	114.97	100.0
2014-03-27 06:00:00	IWM	ETF	114.9	114.95	114.9	114.95	5100.0
2014-03-27 07:00:00	IWM	ETF	115.01	115.01	114.85	114.85	49503.0
2014-03-27 08:00:00	IWM	ETF	114.85	114.92	114.41	114.61	307679.0
2014-03-27 09:00:00	IWM	ETF	114.62	114.79	113.79	114.52	10266346.0
2014-03-27 10:00:00	IWM	ETF	114.54	115.38	114.3	114.6	11534104.0
2014-03-27 11:00:00	IWM	ETF	114.59	114.63	113.69	114.06	8293576.0
2014-03-27 12:00:00	IWM	ETF	114.05	114.48	113.72	114.26	4997016.0
2014-03-27 13:00:00	IWM	ETF	114.26	114.66	114.08	114.2199	3563814.0
2014-03-27 14:00:00	IWM	ETF	114.23	114.41	113.86	113.97	5513508.0
2014-03-27 15:00:00	IWM	ETF	113.97	114.36	113.75	114.35	9077672.0
2014-03-27 16:00:00	IWM	ETF	114.33	114.6766	114.15	114.42	5240081.0
2014-03-27 17:00:00	IWM	ETF	114.39	114.44	114.39	114.4	81640.0
2014-03-27 18:00:00	IWM	ETF	114.46	114.63	114.46	114.6	3925.0
2014-03-27 19:00:00	IWM	ETF	114.57	114.77	114.4	114.61	103000.0
2014-03-27 08:00:00	DIA	ETF	162.33	162.49	162.21	162.21	11727.0
2014-03-27 09:00:00	DIA	ETF	162.18	162.44	161.54	161.93	2370410.0
2014-03-27 10:00:00	DIA	ETF	161.93	162.68	161.82	162.52	1469394.0

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

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