PREVIEW / etf_1hour / 2012-12-21

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-12-21.parquet
  size:    200 KB
  rows:    6,263

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-21 04:00:00	SPY	ETF	142.95	142.99	142.18	142.18	56705.0
2012-12-21 05:00:00	SPY	ETF	142.12	142.28	141.9	142.17	871951.0
2012-12-21 06:00:00	SPY	ETF	142.19	142.51	142.17	142.46	1210810.0
2012-12-21 07:00:00	SPY	ETF	142.46	142.65	142.38	142.4	1158944.0
2012-12-21 08:00:00	SPY	ETF	142.41	142.55	141.9481	142.15	5257782.0
2012-12-21 09:00:00	SPY	ETF	142.16	143.0814	141.89	142.6	40525746.0
2012-12-21 10:00:00	SPY	ETF	142.59	143.1	142.42	142.62	30885528.0
2012-12-21 11:00:00	SPY	ETF	142.62	142.73	141.94	142.28	24614517.0
2012-12-21 12:00:00	SPY	ETF	142.28	144.0881	141.98	142.322	13843373.0
2012-12-21 13:00:00	SPY	ETF	142.32	142.68	142.12	142.61	18834773.0
2012-12-21 14:00:00	SPY	ETF	142.608	142.79	142.46	142.59	16580436.0
2012-12-21 15:00:00	SPY	ETF	142.585	143.02	142.45	142.8	37635819.0
2012-12-21 16:00:00	SPY	ETF	142.81	144.0882	142.525	143.02	20515372.0
2012-12-21 17:00:00	SPY	ETF	143.01	143.1	142.94	143.01	15011125.0
2012-12-21 18:00:00	SPY	ETF	142.95	143.2	142.94	143.0	99578.0
2012-12-21 19:00:00	SPY	ETF	143.02	143.1	143.0	143.1	76221.0
2012-12-21 04:00:00	QQQ	ETF	65.45	65.45	64.92	64.92	23948.0
2012-12-21 05:00:00	QQQ	ETF	64.92	64.95	64.88	64.95	5300.0
2012-12-21 06:00:00	QQQ	ETF	65.0	65.05	65.0	65.04	12500.0
2012-12-21 07:00:00	QQQ	ETF	65.05	65.12	64.96	65.04	118964.0
2012-12-21 08:00:00	QQQ	ETF	65.06	65.09	64.78	64.9	1732732.0
2012-12-21 09:00:00	QQQ	ETF	64.91	65.01	64.6	64.979	13567708.0
2012-12-21 10:00:00	QQQ	ETF	64.98	65.28	64.88	65.08	8237973.0
2012-12-21 11:00:00	QQQ	ETF	65.08	65.16	64.78	64.95	4948544.0
2012-12-21 12:00:00	QQQ	ETF	64.95	65.0	64.78	64.95	4406613.0
2012-12-21 13:00:00	QQQ	ETF	64.96	65.1085	64.84	65.027	4114385.0
2012-12-21 14:00:00	QQQ	ETF	65.025	65.1	64.95	65.03	2314578.0
2012-12-21 15:00:00	QQQ	ETF	65.0399	65.24	64.97	65.19	6815261.0
2012-12-21 16:00:00	QQQ	ETF	65.19	65.91	65.0954	65.35	2823550.0
2012-12-21 17:00:00	QQQ	ETF	65.34	65.42	65.0998	65.38	210775.0
2012-12-21 18:00:00	QQQ	ETF	65.4	65.45	65.36	65.36	13494.0
2012-12-21 19:00:00	QQQ	ETF	65.36	65.36	65.33	65.35	6262.0
2012-12-21 04:00:00	IWM	ETF	83.45	83.45	83.45	83.45	1000.0
2012-12-21 07:00:00	IWM	ETF	83.61	83.61	83.51	83.51	43496.0
2012-12-21 08:00:00	IWM	ETF	83.5	83.6	83.3	83.35	565082.0
2012-12-21 09:00:00	IWM	ETF	83.36	83.84	82.96	83.67	9320416.0
2012-12-21 10:00:00	IWM	ETF	83.6799	84.09	83.51	83.88	6961536.0
2012-12-21 11:00:00	IWM	ETF	83.88	83.94	83.46	83.57	5356505.0
2012-12-21 12:00:00	IWM	ETF	83.57	83.74	83.5	83.71	2920635.0
2012-12-21 13:00:00	IWM	ETF	83.72	83.82	83.585	83.771	3887756.0
2012-12-21 14:00:00	IWM	ETF	83.78	83.86	83.58	83.77	4327660.0
2012-12-21 15:00:00	IWM	ETF	83.77	84.16	83.73	84.16	8508044.0
2012-12-21 16:00:00	IWM	ETF	84.16	84.5273	83.4	84.26	3985665.0
2012-12-21 17:00:00	IWM	ETF	84.25	84.34	84.21	84.21	12197.0
2012-12-21 18:00:00	IWM	ETF	84.21	84.25	84.21	84.25	852.0
2012-12-21 19:00:00	IWM	ETF	84.21	84.25	84.21	84.25	625.0
2012-12-21 05:00:00	DIA	ETF	131.0	131.0	131.0	131.0	900.0
2012-12-21 06:00:00	DIA	ETF	131.29	131.29	131.29	131.29	100.0
2012-12-21 07:00:00	DIA	ETF	131.21	131.38	131.21	131.32	3165.0
2012-12-21 08:00:00	DIA	ETF	131.31	131.78	131.02	131.02	44806.0

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

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