PREVIEW / etf_1hour / 2012-12-17

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-12-17.parquet
  size:    194 KB
  rows:    6,045

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-12-17 04:00:00	SPY	ETF	142.37	142.51	142.36	142.36	1343.0
2012-12-17 05:00:00	SPY	ETF	142.33	142.4	142.22	142.36	27300.0
2012-12-17 06:00:00	SPY	ETF	142.35	142.55	142.26	142.48	65245.0
2012-12-17 07:00:00	SPY	ETF	142.48	142.55	142.31	142.5	182832.0
2012-12-17 08:00:00	SPY	ETF	142.51	142.9	142.41	142.58	1550995.0
2012-12-17 09:00:00	SPY	ETF	142.57	143.05	142.43	142.93	15859796.0
2012-12-17 10:00:00	SPY	ETF	142.93	143.1	142.68	142.82	13043897.0
2012-12-17 11:00:00	SPY	ETF	142.81	143.42	142.8	143.28	14688030.0
2012-12-17 12:00:00	SPY	ETF	143.28	143.54	143.24	143.375	7684866.0
2012-12-17 13:00:00	SPY	ETF	143.38	143.43	143.02	143.055	13891121.0
2012-12-17 14:00:00	SPY	ETF	143.05	143.31	142.91	143.17	16397925.0
2012-12-17 15:00:00	SPY	ETF	143.17	143.85	143.12	143.77	30602135.0
2012-12-17 16:00:00	SPY	ETF	143.77	144.09	142.0566	144.07	8926200.0
2012-12-17 17:00:00	SPY	ETF	144.08	144.13	143.91	144.09	8347881.0
2012-12-17 18:00:00	SPY	ETF	144.08	144.1	143.79	144.04	443469.0
2012-12-17 19:00:00	SPY	ETF	144.03	144.22	144.01	144.22	120851.0
2012-12-17 05:00:00	QQQ	ETF	64.59	64.59	64.39	64.49	26034.0
2012-12-17 06:00:00	QQQ	ETF	64.48	64.48	64.48	64.48	2166.0
2012-12-17 07:00:00	QQQ	ETF	64.54	64.65	64.54	64.65	96534.0
2012-12-17 08:00:00	QQQ	ETF	64.65	64.94	64.57	64.79	466212.0
2012-12-17 09:00:00	QQQ	ETF	64.8	65.12	64.66	64.942	8820463.0
2012-12-17 10:00:00	QQQ	ETF	64.94	64.99	64.692	64.91	5115991.0
2012-12-17 11:00:00	QQQ	ETF	64.9	65.35	64.88	65.31	5772261.0
2012-12-17 12:00:00	QQQ	ETF	65.3199	65.4681	65.26	65.34	3501132.0
2012-12-17 13:00:00	QQQ	ETF	65.34	65.39	65.09	65.1001	2755235.0
2012-12-17 14:00:00	QQQ	ETF	65.1	65.24	64.99	65.19	3582789.0
2012-12-17 15:00:00	QQQ	ETF	65.19	65.57	65.14	65.55	6632079.0
2012-12-17 16:00:00	QQQ	ETF	65.541	65.705	65.1968	65.66	1613473.0
2012-12-17 17:00:00	QQQ	ETF	65.67	65.73	65.63	65.69	21799.0
2012-12-17 18:00:00	QQQ	ETF	65.7	65.7	65.64	65.64	9726.0
2012-12-17 19:00:00	QQQ	ETF	65.63	65.69	65.63	65.69	16278.0
2012-12-17 06:00:00	IWM	ETF	82.71	82.71	82.71	82.71	500.0
2012-12-17 07:00:00	IWM	ETF	82.72	82.75	82.59	82.59	50215.0
2012-12-17 08:00:00	IWM	ETF	82.66	82.94	82.63	82.77	681376.0
2012-12-17 09:00:00	IWM	ETF	82.78	82.95	82.52	82.8297	4718344.0
2012-12-17 10:00:00	IWM	ETF	82.83	83.01	82.61	82.71	3178484.0
2012-12-17 11:00:00	IWM	ETF	82.71	83.28	82.7	83.17	4303919.0
2012-12-17 12:00:00	IWM	ETF	83.18	83.39	83.15	83.26	2357882.0
2012-12-17 13:00:00	IWM	ETF	83.25	83.29	83.09	83.11	1467895.0
2012-12-17 14:00:00	IWM	ETF	83.11	83.24	83.05	83.2	2531969.0
2012-12-17 15:00:00	IWM	ETF	83.19	83.48	83.14	83.46	8930966.0
2012-12-17 16:00:00	IWM	ETF	83.47	83.64	83.3764	83.63	1301425.0
2012-12-17 17:00:00	IWM	ETF	83.67	83.69	83.6	83.69	10009.0
2012-12-17 18:00:00	IWM	ETF	83.64	83.68	83.57	83.6	15240.0
2012-12-17 19:00:00	IWM	ETF	83.67	83.68	83.67	83.68	362.0
2012-12-17 05:00:00	DIA	ETF	131.61	131.61	131.61	131.61	200.0
2012-12-17 07:00:00	DIA	ETF	131.74	131.74	131.74	131.74	100.0
2012-12-17 08:00:00	DIA	ETF	131.84	131.99	131.7	131.7	11943.0
2012-12-17 09:00:00	DIA	ETF	131.75	132.16	131.63	132.07	566827.0
2012-12-17 10:00:00	DIA	ETF	132.05	132.237	131.91	131.93	609133.0

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

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