PREVIEW / etf_1hour / 2012-09-05

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-09-05.parquet
  size:    180 KB
  rows:    5,710

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
2012-09-05 04:00:00	SPY	ETF	140.65	140.65	140.5	140.5	3060.0
2012-09-05 05:00:00	SPY	ETF	140.58	141.02	140.53	141.02	20865.0
2012-09-05 06:00:00	SPY	ETF	141.02	141.02	140.93	140.98	49803.0
2012-09-05 07:00:00	SPY	ETF	140.98	140.99	140.7	140.75	951736.0
2012-09-05 08:00:00	SPY	ETF	140.76	141.29	140.7	141.19	4980857.0
2012-09-05 09:00:00	SPY	ETF	141.2	141.28	140.63	140.92	14220744.0
2012-09-05 10:00:00	SPY	ETF	140.91	141.47	140.85	140.89	24698890.0
2012-09-05 11:00:00	SPY	ETF	140.89	141.3	140.8	141.145	9181498.0
2012-09-05 12:00:00	SPY	ETF	141.15	141.25	141.12	141.17	5863352.0
2012-09-05 13:00:00	SPY	ETF	141.18	141.2	140.65	140.839	10130636.0
2012-09-05 14:00:00	SPY	ETF	140.84	141.06	140.76	140.985	6964670.0
2012-09-05 15:00:00	SPY	ETF	140.97	141.05	140.8	140.91	14151723.0
2012-09-05 16:00:00	SPY	ETF	140.9	141.18	140.87	141.16	7179984.0
2012-09-05 17:00:00	SPY	ETF	141.15	141.15	141.07	141.14	96778.0
2012-09-05 18:00:00	SPY	ETF	141.13	141.15	141.07	141.07	116875.0
2012-09-05 19:00:00	SPY	ETF	141.07	141.12	141.02	141.09	61035.0
2012-09-05 05:00:00	QQQ	ETF	67.82	67.82	67.82	67.82	200.0
2012-09-05 07:00:00	QQQ	ETF	68.04	68.04	67.86	67.86	642472.0
2012-09-05 08:00:00	QQQ	ETF	67.86	68.13	67.86	68.09	984426.0
2012-09-05 09:00:00	QQQ	ETF	68.09	68.19	67.84	68.14	4498246.0
2012-09-05 10:00:00	QQQ	ETF	68.15	68.35	68.0	68.0	5317492.0
2012-09-05 11:00:00	QQQ	ETF	68.0	68.27	67.9	68.191	3392797.0
2012-09-05 12:00:00	QQQ	ETF	68.195	68.32	68.18	68.26	1399759.0
2012-09-05 13:00:00	QQQ	ETF	68.26	68.27	67.94	68.02	2345294.0
2012-09-05 14:00:00	QQQ	ETF	68.03	68.16	67.97	68.1	1449461.0
2012-09-05 15:00:00	QQQ	ETF	68.1	68.11	67.93	68.01	4408575.0
2012-09-05 16:00:00	QQQ	ETF	68.01	68.1143	67.99	68.09	553955.0
2012-09-05 17:00:00	QQQ	ETF	68.07	68.09	68.04	68.04	1700.0
2012-09-05 18:00:00	QQQ	ETF	68.07	68.07	68.05	68.05	10254.0
2012-09-05 19:00:00	QQQ	ETF	68.02	68.06	68.02	68.05	550.0
2012-09-05 08:00:00	IWM	ETF	81.96	82.33	81.96	82.32	204500.0
2012-09-05 09:00:00	IWM	ETF	82.31	82.34	81.86	82.0482	4708030.0
2012-09-05 10:00:00	IWM	ETF	82.0413	82.51	82.0	82.06	7928827.0
2012-09-05 11:00:00	IWM	ETF	82.06	82.32	81.98	82.21	4928447.0
2012-09-05 12:00:00	IWM	ETF	82.21	82.28	82.18	82.2	1059690.0
2012-09-05 13:00:00	IWM	ETF	82.2	82.21	81.85	82.05	3549252.0
2012-09-05 14:00:00	IWM	ETF	82.05	82.24	82.0	82.11	2781320.0
2012-09-05 15:00:00	IWM	ETF	82.1	82.2	81.98	82.12	4186045.0
2012-09-05 16:00:00	IWM	ETF	82.13	82.23	82.0269	82.22	1018116.0
2012-09-05 17:00:00	IWM	ETF	82.18	82.19	82.15	82.19	5882.0
2012-09-05 19:00:00	IWM	ETF	82.17	82.24	82.17	82.23	4680.0
2012-09-05 08:00:00	DIA	ETF	130.24	130.49	130.13	130.49	3950.0
2012-09-05 09:00:00	DIA	ETF	130.36	130.5	130.04	130.25	276849.0
2012-09-05 10:00:00	DIA	ETF	130.25	130.83	130.19	130.34	914030.0
2012-09-05 11:00:00	DIA	ETF	130.34	130.71	130.25	130.55	270965.0
2012-09-05 12:00:00	DIA	ETF	130.54	130.61	130.49	130.53	136733.0
2012-09-05 13:00:00	DIA	ETF	130.54	130.55	130.0999	130.208	441229.0
2012-09-05 14:00:00	DIA	ETF	130.23	130.43	130.17	130.38	188275.0
2012-09-05 15:00:00	DIA	ETF	130.4	130.47	130.22	130.36	424771.0
2012-09-05 16:00:00	DIA	ETF	130.37	130.47	130.35	130.47	44230.0

> showing 50 of 5,710 rows — these rows as CSV

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