PREVIEW / etf_1hour / 2013-10-31

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-10-31.parquet
  size:    211 KB
  rows:    6,657

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-10-31 04:00:00	SPY	ETF	175.88	176.11	175.88	175.98	17700.0
2013-10-31 05:00:00	SPY	ETF	175.96	176.13	175.9	176.13	7600.0
2013-10-31 06:00:00	SPY	ETF	176.08	176.16	176.06	176.12	4850.0
2013-10-31 07:00:00	SPY	ETF	176.07	176.36	176.01	176.24	212719.0
2013-10-31 08:00:00	SPY	ETF	176.26	176.45	176.21	176.24	898290.0
2013-10-31 09:00:00	SPY	ETF	176.25	176.68	175.835	175.94	16357590.0
2013-10-31 10:00:00	SPY	ETF	175.94	176.07	175.53	175.95	20467728.0
2013-10-31 11:00:00	SPY	ETF	175.94	176.47	175.88	176.22	14463124.0
2013-10-31 12:00:00	SPY	ETF	176.22	176.58	176.14	176.35	11543843.0
2013-10-31 13:00:00	SPY	ETF	176.35	176.55	176.32	176.46	4451303.0
2013-10-31 14:00:00	SPY	ETF	176.47	176.89	176.37	176.485	14496876.0
2013-10-31 15:00:00	SPY	ETF	176.485	176.49	175.69	175.72	33396647.0
2013-10-31 16:00:00	SPY	ETF	175.72	176.3282	175.6536	176.05	14164232.0
2013-10-31 17:00:00	SPY	ETF	176.045	176.06	175.959	176.02	160237.0
2013-10-31 18:00:00	SPY	ETF	176.02	176.02	175.79	175.96	383183.0
2013-10-31 19:00:00	SPY	ETF	175.96	175.96	175.81	175.91	45140.0
2013-10-31 04:00:00	QQQ	ETF	82.8	82.92	82.8	82.85	45800.0
2013-10-31 05:00:00	QQQ	ETF	82.84	82.91	82.81	82.89	12300.0
2013-10-31 06:00:00	QQQ	ETF	82.88	82.93	82.86	82.89	12000.0
2013-10-31 07:00:00	QQQ	ETF	82.88	82.98	82.83	82.94	60245.0
2013-10-31 08:00:00	QQQ	ETF	82.94	83.02	82.85	82.85	243551.0
2013-10-31 09:00:00	QQQ	ETF	82.85	83.09	82.56	82.59	5331063.0
2013-10-31 10:00:00	QQQ	ETF	82.59	82.96	82.48	82.91	6381744.0
2013-10-31 11:00:00	QQQ	ETF	82.92	83.2	82.915	83.1	2706120.0
2013-10-31 12:00:00	QQQ	ETF	83.095	83.27	83.02	83.11	1784269.0
2013-10-31 13:00:00	QQQ	ETF	83.11	83.21	83.08	83.13	1596962.0
2013-10-31 14:00:00	QQQ	ETF	83.1314	83.3	83.07	83.07	2208762.0
2013-10-31 15:00:00	QQQ	ETF	83.06	83.07	82.77	82.78	7358824.0
2013-10-31 16:00:00	QQQ	ETF	82.78	83.0133	82.554	82.89	2567214.0
2013-10-31 17:00:00	QQQ	ETF	82.91	82.91	82.86	82.88	11510.0
2013-10-31 18:00:00	QQQ	ETF	82.88	82.89	82.83	82.85	37305.0
2013-10-31 19:00:00	QQQ	ETF	82.84	82.85	82.83	82.83	2897.0
2013-10-31 07:00:00	IWM	ETF	109.83	109.92	109.76	109.85	26188.0
2013-10-31 08:00:00	IWM	ETF	109.83	110.04	109.82	109.91	124671.0
2013-10-31 09:00:00	IWM	ETF	109.92	110.14	109.26	109.31	7047159.0
2013-10-31 10:00:00	IWM	ETF	109.315	109.43	108.89	109.26	9487523.0
2013-10-31 11:00:00	IWM	ETF	109.27	109.76	109.2	109.585	4972354.0
2013-10-31 12:00:00	IWM	ETF	109.59	109.76	109.555	109.6	3320072.0
2013-10-31 13:00:00	IWM	ETF	109.61	109.96	109.61	109.88	1888978.0
2013-10-31 14:00:00	IWM	ETF	109.89	110.18	109.82	109.89	3620015.0
2013-10-31 15:00:00	IWM	ETF	109.89	109.89	109.16	109.26	11089533.0
2013-10-31 16:00:00	IWM	ETF	109.26	109.605	109.185	109.38	2766227.0
2013-10-31 17:00:00	IWM	ETF	109.43	109.43	109.31	109.35	8923.0
2013-10-31 18:00:00	IWM	ETF	109.33	109.33	109.33	109.33	1000.0
2013-10-31 19:00:00	IWM	ETF	109.34	109.35	109.26	109.33	18061.0
2013-10-31 07:00:00	DIA	ETF	155.63	155.63	155.63	155.63	100.0
2013-10-31 08:00:00	DIA	ETF	155.63	155.81	155.63	155.74	6120.0
2013-10-31 09:00:00	DIA	ETF	155.69	155.98	155.4	155.48	1110598.0
2013-10-31 10:00:00	DIA	ETF	155.43	155.48	155.1	155.36	1183879.0
2013-10-31 11:00:00	DIA	ETF	155.37	155.77	155.27	155.59	473563.0

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

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