PREVIEW / etf_1hour / 2014-03-14

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-03-14.parquet
  size:    216 KB
  rows:    6,810

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-14 04:00:00	SPY	ETF	184.91	185.5	184.91	185.31	26925.0
2014-03-14 05:00:00	SPY	ETF	185.32	185.52	185.32	185.5	126017.0
2014-03-14 06:00:00	SPY	ETF	185.56	185.58	185.35	185.5	227825.0
2014-03-14 07:00:00	SPY	ETF	185.48	185.49	185.08	185.1	381939.0
2014-03-14 08:00:00	SPY	ETF	185.27	185.38	184.45	185.0	2609006.0
2014-03-14 09:00:00	SPY	ETF	185.0	185.71	184.67	185.06	20680272.0
2014-03-14 10:00:00	SPY	ETF	185.07	185.8	184.96	185.02	18937380.0
2014-03-14 11:00:00	SPY	ETF	185.02	185.72	184.53	185.55	27871001.0
2014-03-14 12:00:00	SPY	ETF	185.56	185.62	184.92	185.4	19989571.0
2014-03-14 13:00:00	SPY	ETF	185.4	185.48	184.88	185.115	10183072.0
2014-03-14 14:00:00	SPY	ETF	185.11	185.18	184.56	184.59	10298396.0
2014-03-14 15:00:00	SPY	ETF	184.59	184.98	184.44	184.61	28718713.0
2014-03-14 16:00:00	SPY	ETF	184.62	185.39	184.44	184.5	9321962.0
2014-03-14 17:00:00	SPY	ETF	184.49	184.74	184.46	184.69	3678682.0
2014-03-14 18:00:00	SPY	ETF	184.67	184.82	184.67	184.72	136360.0
2014-03-14 19:00:00	SPY	ETF	184.73	184.76	184.67	184.67	39631.0
2014-03-14 04:00:00	QQQ	ETF	89.29	89.29	89.29	89.29	2500.0
2014-03-14 06:00:00	QQQ	ETF	89.43	89.45	89.33	89.37	15400.0
2014-03-14 07:00:00	QQQ	ETF	89.38	89.46	89.23	89.25	123248.0
2014-03-14 08:00:00	QQQ	ETF	89.3	89.33	88.94	89.25	259372.0
2014-03-14 09:00:00	QQQ	ETF	89.26	89.38	88.9	88.92	6811363.0
2014-03-14 10:00:00	QQQ	ETF	88.91	89.3525	88.82	88.87	5689710.0
2014-03-14 11:00:00	QQQ	ETF	88.87	89.3466	88.64	89.28	7281726.0
2014-03-14 12:00:00	QQQ	ETF	89.28	89.3	88.95	89.16	4064048.0
2014-03-14 13:00:00	QQQ	ETF	89.17	89.21	88.85	88.955	2445703.0
2014-03-14 14:00:00	QQQ	ETF	88.95	88.97	88.67	88.68	3542832.0
2014-03-14 15:00:00	QQQ	ETF	88.68	88.9	88.63	88.65	4896974.0
2014-03-14 16:00:00	QQQ	ETF	88.65	89.2381	88.62	88.63	1295959.0
2014-03-14 17:00:00	QQQ	ETF	88.64	88.68	88.64	88.68	720172.0
2014-03-14 18:00:00	QQQ	ETF	88.71	88.74	88.71	88.73	2035.0
2014-03-14 19:00:00	QQQ	ETF	88.68	88.7	88.66	88.68	3950.0
2014-03-14 07:00:00	IWM	ETF	116.86	116.94	116.76	116.78	25525.0
2014-03-14 08:00:00	IWM	ETF	116.76	116.83	116.34	116.72	668566.0
2014-03-14 09:00:00	IWM	ETF	116.76	117.54	116.48	117.03	5653546.0
2014-03-14 10:00:00	IWM	ETF	117.04	117.87	117.04	117.29	7248165.0
2014-03-14 11:00:00	IWM	ETF	117.29	117.72	116.91	117.67	8418214.0
2014-03-14 12:00:00	IWM	ETF	117.67	117.72	117.24	117.58	4186954.0
2014-03-14 13:00:00	IWM	ETF	117.59	117.67	117.38	117.61	2906043.0
2014-03-14 14:00:00	IWM	ETF	117.6	117.765	117.25	117.28	3996833.0
2014-03-14 15:00:00	IWM	ETF	117.28	117.56	117.22	117.52	9053458.0
2014-03-14 16:00:00	IWM	ETF	117.52	117.5589	117.285	117.33	2214889.0
2014-03-14 17:00:00	IWM	ETF	117.34	117.54	117.31	117.43	201224.0
2014-03-14 18:00:00	IWM	ETF	117.51	117.54	117.47	117.47	2850.0
2014-03-14 19:00:00	IWM	ETF	117.47	117.47	117.38	117.4	2464.0
2014-03-14 04:00:00	DIA	ETF	161.05	161.05	161.05	161.05	150.0
2014-03-14 07:00:00	DIA	ETF	161.16	161.16	161.0	161.0	200.0
2014-03-14 08:00:00	DIA	ETF	161.0	161.0	160.76	160.81	1330.0
2014-03-14 09:00:00	DIA	ETF	160.87	161.49	160.64	161.1	1302857.0
2014-03-14 10:00:00	DIA	ETF	161.11	161.6	160.84	160.9	1136415.0
2014-03-14 11:00:00	DIA	ETF	160.9	161.52	160.53	161.36	1790427.0

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

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