PREVIEW / etf_1hour / 2014-11-12

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-11-12.parquet
  size:    226 KB
  rows:    7,195

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-11-12 04:00:00	SPY	ETF	203.9	203.9	203.61	203.64	36101.0
2014-11-12 05:00:00	SPY	ETF	203.7	203.94	203.62	203.86	23812.0
2014-11-12 06:00:00	SPY	ETF	203.71	203.74	203.38	203.42	100305.0
2014-11-12 07:00:00	SPY	ETF	203.44	203.53	203.33	203.44	330615.0
2014-11-12 08:00:00	SPY	ETF	203.44	203.52	203.24	203.39	2210176.0
2014-11-12 09:00:00	SPY	ETF	203.39	203.7	203.3	203.6699	7689752.0
2014-11-12 10:00:00	SPY	ETF	203.67	203.95	203.48	203.49	12233564.0
2014-11-12 11:00:00	SPY	ETF	203.49	204.12	203.39	204.05	10942773.0
2014-11-12 12:00:00	SPY	ETF	204.06	204.19	203.91	204.03	9451581.0
2014-11-12 13:00:00	SPY	ETF	204.04	204.19	203.93	203.98	8456599.0
2014-11-12 14:00:00	SPY	ETF	203.97	204.17	203.72	203.81	8758863.0
2014-11-12 15:00:00	SPY	ETF	203.81	204.24	203.71	203.98	16076378.0
2014-11-12 16:00:00	SPY	ETF	203.99	204.18	203.8592	204.02	8967657.0
2014-11-12 17:00:00	SPY	ETF	204.02	204.03	203.97	204.01	320986.0
2014-11-12 18:00:00	SPY	ETF	204.0	204.0	203.9	203.95	87404.0
2014-11-12 19:00:00	SPY	ETF	203.95	204.01	203.93	204.01	57075.0
2014-11-12 04:00:00	QQQ	ETF	102.05	102.05	102.05	102.05	200.0
2014-11-12 05:00:00	QQQ	ETF	102.0	102.12	102.0	102.11	1600.0
2014-11-12 06:00:00	QQQ	ETF	102.05	102.05	101.87	101.9	44001.0
2014-11-12 07:00:00	QQQ	ETF	101.91	101.97	101.87	101.96	63377.0
2014-11-12 08:00:00	QQQ	ETF	101.93	101.95	101.82	101.88	176861.0
2014-11-12 09:00:00	QQQ	ETF	101.89	102.11	101.86	102.04	2534680.0
2014-11-12 10:00:00	QQQ	ETF	102.04	102.25	101.98	102.0	2586914.0
2014-11-12 11:00:00	QQQ	ETF	101.99	102.38	101.923	102.3301	2328974.0
2014-11-12 12:00:00	QQQ	ETF	102.34	102.44	102.31	102.42	2165203.0
2014-11-12 13:00:00	QQQ	ETF	102.42	102.49	102.37	102.38	1610417.0
2014-11-12 14:00:00	QQQ	ETF	102.375	102.49	102.24	102.29	1929200.0
2014-11-12 15:00:00	QQQ	ETF	102.299	102.57	102.241	102.45	4164736.0
2014-11-12 16:00:00	QQQ	ETF	102.46	102.59	102.1961	102.49	2593940.0
2014-11-12 17:00:00	QQQ	ETF	102.49	102.53	102.45	102.46	9094.0
2014-11-12 18:00:00	QQQ	ETF	102.46	102.46	102.42	102.44	15960.0
2014-11-12 19:00:00	QQQ	ETF	102.44	102.49	102.44	102.47	3400.0
2014-11-12 04:00:00	IWM	ETF	116.87	116.87	116.8	116.8	700.0
2014-11-12 06:00:00	IWM	ETF	116.79	116.79	116.55	116.55	300.0
2014-11-12 07:00:00	IWM	ETF	116.54	116.73	116.54	116.67	58687.0
2014-11-12 08:00:00	IWM	ETF	116.65	117.9324	116.46	116.65	2390130.0
2014-11-12 09:00:00	IWM	ETF	116.67	117.24	116.62	117.09	3688708.0
2014-11-12 10:00:00	IWM	ETF	117.09	117.32	117.0	117.03	2765823.0
2014-11-12 11:00:00	IWM	ETF	117.04	117.51	116.97	117.392	2673733.0
2014-11-12 12:00:00	IWM	ETF	117.39	117.59	117.28	117.52	1223433.0
2014-11-12 13:00:00	IWM	ETF	117.52	117.76	117.48	117.71	1628749.0
2014-11-12 14:00:00	IWM	ETF	117.7	118.04	117.57	117.69	3265299.0
2014-11-12 15:00:00	IWM	ETF	117.68	118.08	117.62	117.92	5238919.0
2014-11-12 16:00:00	IWM	ETF	117.91	118.07	117.87	117.93	3884637.0
2014-11-12 17:00:00	IWM	ETF	117.85	117.87	117.84	117.87	700.0
2014-11-12 18:00:00	IWM	ETF	117.9	117.9	117.87	117.87	300.0
2014-11-12 19:00:00	IWM	ETF	117.86	117.86	117.81	117.81	1500.0
2014-11-12 04:00:00	DIA	ETF	175.8	175.8	175.8	175.8	200.0
2014-11-12 07:00:00	DIA	ETF	175.45	175.45	175.45	175.45	600.0
2014-11-12 08:00:00	DIA	ETF	175.4	175.4	175.2	175.2	31415.0

> showing 50 of 7,195 rows — these rows as CSV

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