PREVIEW / etf_1hour / 2014-10-16

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-10-16.parquet
  size:    243 KB
  rows:    7,727

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-10-16 04:00:00	SPY	ETF	185.61	185.87	185.01	185.15	59682.0
2014-10-16 05:00:00	SPY	ETF	185.18	185.18	182.49	183.28	219003.0
2014-10-16 06:00:00	SPY	ETF	183.18	183.94	182.26	182.87	948659.0
2014-10-16 07:00:00	SPY	ETF	182.92	183.49	182.17	183.43	1751092.0
2014-10-16 08:00:00	SPY	ETF	183.43	183.91	182.39	182.91	7089024.0
2014-10-16 09:00:00	SPY	ETF	182.92	185.23	182.85	185.1	34594427.0
2014-10-16 10:00:00	SPY	ETF	185.09	186.25	183.37	185.52	52552774.0
2014-10-16 11:00:00	SPY	ETF	185.52	186.78	184.579	185.48	33720772.0
2014-10-16 12:00:00	SPY	ETF	185.481	186.48	185.07	186.33	20204595.0
2014-10-16 13:00:00	SPY	ETF	186.33	187.58	184.58	186.58	30397060.0
2014-10-16 14:00:00	SPY	ETF	186.57	187.1	185.79	186.02	27533293.0
2014-10-16 15:00:00	SPY	ETF	186.03	186.89	185.55	186.24	41308225.0
2014-10-16 16:00:00	SPY	ETF	186.24	187.0	185.44	185.72	17884954.0
2014-10-16 17:00:00	SPY	ETF	185.67	185.91	185.64	185.91	275808.0
2014-10-16 18:00:00	SPY	ETF	185.9	186.3	185.85	186.3	131303.0
2014-10-16 19:00:00	SPY	ETF	186.3	186.3	186.0	186.23	103697.0
2014-10-16 04:00:00	QQQ	ETF	91.57	91.77	91.52	91.77	513.0
2014-10-16 05:00:00	QQQ	ETF	91.46	91.46	90.42	90.77	30068.0
2014-10-16 06:00:00	QQQ	ETF	90.8	90.98	90.19	90.41	166348.0
2014-10-16 07:00:00	QQQ	ETF	90.47	90.73	90.1	90.71	296917.0
2014-10-16 08:00:00	QQQ	ETF	90.72	91.04	90.22	90.58	772673.0
2014-10-16 09:00:00	QQQ	ETF	90.6	91.45	90.39	91.41	14927351.0
2014-10-16 10:00:00	QQQ	ETF	91.43	91.8679	90.47	91.55	21039097.0
2014-10-16 11:00:00	QQQ	ETF	91.55	92.14	91.3	91.47	12330240.0
2014-10-16 12:00:00	QQQ	ETF	91.47	91.94	91.23	91.87	6949519.0
2014-10-16 13:00:00	QQQ	ETF	91.865	92.58	91.865	92.07	9877469.0
2014-10-16 14:00:00	QQQ	ETF	92.06	92.27	91.68	91.73	8373838.0
2014-10-16 15:00:00	QQQ	ETF	91.74	92.17	91.51	91.84	8418337.0
2014-10-16 16:00:00	QQQ	ETF	91.83	92.3581	91.23	91.54	4300957.0
2014-10-16 17:00:00	QQQ	ETF	91.5	91.65	91.48	91.62	29468.0
2014-10-16 18:00:00	QQQ	ETF	91.62	91.81	91.62	91.81	53910.0
2014-10-16 19:00:00	QQQ	ETF	91.8	91.8	91.65	91.77	16780.0
2014-10-16 04:00:00	IWM	ETF	106.48	106.48	106.48	106.48	490.0
2014-10-16 05:00:00	IWM	ETF	106.1	106.19	104.52	104.84	29700.0
2014-10-16 06:00:00	IWM	ETF	104.86	105.45	104.55	104.86	149950.0
2014-10-16 07:00:00	IWM	ETF	104.9	105.28	104.5	105.06	526757.0
2014-10-16 08:00:00	IWM	ETF	105.07	105.43	104.53	104.88	1501078.0
2014-10-16 09:00:00	IWM	ETF	104.92	106.91	104.84	106.69	14902686.0
2014-10-16 10:00:00	IWM	ETF	106.68	107.87	105.79	107.3	21175528.0
2014-10-16 11:00:00	IWM	ETF	107.29	107.76	106.48	106.82	10647691.0
2014-10-16 12:00:00	IWM	ETF	106.82	107.855	106.515	107.7799	5537323.0
2014-10-16 13:00:00	IWM	ETF	107.78	108.57	107.78	107.952	8454343.0
2014-10-16 14:00:00	IWM	ETF	107.94	108.14	107.53	107.7	6156114.0
2014-10-16 15:00:00	IWM	ETF	107.7	108.27	107.38	107.83	11190356.0
2014-10-16 16:00:00	IWM	ETF	107.83	108.12	107.59	107.83	3009529.0
2014-10-16 17:00:00	IWM	ETF	107.94	107.94	107.85	107.93	67065.0
2014-10-16 18:00:00	IWM	ETF	107.96	108.1	107.96	108.1	3459.0
2014-10-16 19:00:00	IWM	ETF	108.1	108.1	107.96	108.0	1600.0
2014-10-16 04:00:00	DIA	ETF	160.64	160.64	160.64	160.64	100.0
2014-10-16 05:00:00	DIA	ETF	160.5	160.5	159.13	159.13	600.0

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

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