PREVIEW / etf_1hour / 2012-09-17

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-09-17.parquet
  size:    189 KB
  rows:    5,927

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-17 04:00:00	SPY	ETF	147.07	147.07	146.93	147.01	12100.0
2012-09-17 05:00:00	SPY	ETF	147.01	147.02	146.85	146.97	24775.0
2012-09-17 06:00:00	SPY	ETF	146.94	147.0	146.94	146.95	11600.0
2012-09-17 07:00:00	SPY	ETF	146.99	147.01	146.76	146.76	242118.0
2012-09-17 08:00:00	SPY	ETF	146.78	147.07	146.73	147.0	820972.0
2012-09-17 09:00:00	SPY	ETF	147.0	147.19	146.79	146.9	13346681.0
2012-09-17 10:00:00	SPY	ETF	146.9	147.14	146.81	146.9701	16670044.0
2012-09-17 11:00:00	SPY	ETF	146.97	147.08	146.88	146.93	13674881.0
2012-09-17 12:00:00	SPY	ETF	146.92	146.99	146.88	146.885	6520133.0
2012-09-17 13:00:00	SPY	ETF	146.89	146.96	146.72	146.7818	8388346.0
2012-09-17 14:00:00	SPY	ETF	146.7804	146.95	146.51	146.61	14488247.0
2012-09-17 15:00:00	SPY	ETF	146.61	146.78	146.37	146.77	20696197.0
2012-09-17 16:00:00	SPY	ETF	146.78	146.8	146.64	146.69	13360805.0
2012-09-17 17:00:00	SPY	ETF	146.69	146.75	146.69	146.72	88281.0
2012-09-17 18:00:00	SPY	ETF	146.73	146.76	146.69	146.74	21678.0
2012-09-17 19:00:00	SPY	ETF	146.74	146.77	146.71	146.73	19296.0
2012-09-17 04:00:00	QQQ	ETF	70.12	70.12	70.12	70.12	1000.0
2012-09-17 05:00:00	QQQ	ETF	70.06	70.06	70.06	70.06	1000.0
2012-09-17 07:00:00	QQQ	ETF	70.12	70.13	70.06	70.07	49274.0
2012-09-17 08:00:00	QQQ	ETF	70.09	70.23	70.07	70.19	102761.0
2012-09-17 09:00:00	QQQ	ETF	70.2	70.25	69.97	69.99	4522696.0
2012-09-17 10:00:00	QQQ	ETF	70.0	70.2	69.99	70.11	4316147.0
2012-09-17 11:00:00	QQQ	ETF	70.12	70.16	70.03	70.11	2600729.0
2012-09-17 12:00:00	QQQ	ETF	70.1	70.16	70.08	70.1	1144188.0
2012-09-17 13:00:00	QQQ	ETF	70.1	70.12	70.05	70.08	1488765.0
2012-09-17 14:00:00	QQQ	ETF	70.07	70.125	69.97	70.065	2722838.0
2012-09-17 15:00:00	QQQ	ETF	70.06	70.21	69.96	70.2	4819725.0
2012-09-17 16:00:00	QQQ	ETF	70.21	70.22	69.9901	70.14	445561.0
2012-09-17 17:00:00	QQQ	ETF	70.15	70.2	70.14	70.14	1006811.0
2012-09-17 18:00:00	QQQ	ETF	70.13	70.16	70.11	70.16	4900.0
2012-09-17 19:00:00	QQQ	ETF	70.16	70.17	70.14	70.16	26750.0
2012-09-17 04:00:00	IWM	ETF	86.2	86.2	86.2	86.2	2600.0
2012-09-17 05:00:00	IWM	ETF	86.14	86.14	86.1	86.1	3300.0
2012-09-17 06:00:00	IWM	ETF	86.14	86.15	86.12	86.14	7825.0
2012-09-17 07:00:00	IWM	ETF	86.19	86.2	85.98	85.98	27900.0
2012-09-17 08:00:00	IWM	ETF	86.03	86.06	85.77	85.96	307956.0
2012-09-17 09:00:00	IWM	ETF	85.98	86.22	85.895	85.96	4085421.0
2012-09-17 10:00:00	IWM	ETF	85.96	86.18	85.83	85.92	4010431.0
2012-09-17 11:00:00	IWM	ETF	85.91	86.02	85.82	85.86	2203172.0
2012-09-17 12:00:00	IWM	ETF	85.85	85.97	85.83	85.89	1109636.0
2012-09-17 13:00:00	IWM	ETF	85.9	85.92	85.69	85.78	1796490.0
2012-09-17 14:00:00	IWM	ETF	85.77	85.81	85.62	85.6717	2546170.0
2012-09-17 15:00:00	IWM	ETF	85.67	85.97	85.57	85.97	6514426.0
2012-09-17 16:00:00	IWM	ETF	85.98	86.04	85.9	85.95	878791.0
2012-09-17 17:00:00	IWM	ETF	86.02	86.02	86.01	86.02	28998.0
2012-09-17 19:00:00	IWM	ETF	85.97	85.97	85.97	85.97	2000.0
2012-09-17 08:00:00	DIA	ETF	135.56	135.75	135.56	135.75	600.0
2012-09-17 09:00:00	DIA	ETF	135.71	135.88	135.55	135.7	403579.0
2012-09-17 10:00:00	DIA	ETF	135.71	135.82	135.6	135.69	365549.0
2012-09-17 11:00:00	DIA	ETF	135.7	135.8	135.53	135.57	275869.0

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

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