PREVIEW / etf_1hour / 2012-09-13

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-09-13.parquet
  size:    197 KB
  rows:    6,055

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-13 04:00:00	SPY	ETF	144.51	144.51	144.24	144.24	69600.0
2012-09-13 05:00:00	SPY	ETF	144.29	144.38	144.23	144.38	2700.0
2012-09-13 06:00:00	SPY	ETF	144.28	144.35	144.25	144.35	76568.0
2012-09-13 07:00:00	SPY	ETF	144.33	144.44	144.33	144.34	201416.0
2012-09-13 08:00:00	SPY	ETF	144.33	144.49	144.21	144.45	512409.0
2012-09-13 09:00:00	SPY	ETF	144.46	144.46	144.15	144.27	9870819.0
2012-09-13 10:00:00	SPY	ETF	144.26	144.43	144.21	144.3701	8892231.0
2012-09-13 11:00:00	SPY	ETF	144.38	144.62	144.37	144.43	8864816.0
2012-09-13 12:00:00	SPY	ETF	144.42	145.54	143.99	145.429	44059852.0
2012-09-13 13:00:00	SPY	ETF	145.44	146.215	144.86	146.04	33748170.0
2012-09-13 14:00:00	SPY	ETF	146.04	147.04	145.98	146.51	40094419.0
2012-09-13 15:00:00	SPY	ETF	146.525	146.84	146.22	146.65	31576963.0
2012-09-13 16:00:00	SPY	ETF	146.66	146.71	144.46	146.35	28274696.0
2012-09-13 17:00:00	SPY	ETF	146.35	146.46	144.2847	146.44	10640328.0
2012-09-13 18:00:00	SPY	ETF	146.46	146.54	146.42	146.54	89295.0
2012-09-13 19:00:00	SPY	ETF	146.54	146.63	146.54	146.55	137044.0
2012-09-13 04:00:00	QQQ	ETF	68.56	68.56	68.56	68.56	600.0
2012-09-13 07:00:00	QQQ	ETF	68.54	68.64	68.54	68.61	33897.0
2012-09-13 08:00:00	QQQ	ETF	68.55	68.88	68.52	68.67	137398.0
2012-09-13 09:00:00	QQQ	ETF	68.67	68.78	68.48	68.75	3266575.0
2012-09-13 10:00:00	QQQ	ETF	68.74	68.89	68.68	68.77	3643820.0
2012-09-13 11:00:00	QQQ	ETF	68.775	68.88	68.77	68.8	2996494.0
2012-09-13 12:00:00	QQQ	ETF	68.8	69.34	68.68	69.22	12419659.0
2012-09-13 13:00:00	QQQ	ETF	69.22	69.62	69.22	69.475	7371251.0
2012-09-13 14:00:00	QQQ	ETF	69.4746	69.86	69.43	69.68	6204400.0
2012-09-13 15:00:00	QQQ	ETF	69.68	69.77	69.51	69.57	7504422.0
2012-09-13 16:00:00	QQQ	ETF	69.58	69.774	69.46	69.59	1319618.0
2012-09-13 17:00:00	QQQ	ETF	69.52	69.58	69.5	69.58	25900.0
2012-09-13 18:00:00	QQQ	ETF	69.59	69.6	69.58	69.58	4470.0
2012-09-13 19:00:00	QQQ	ETF	69.64	69.65	69.62	69.64	13930.0
2012-09-13 06:00:00	IWM	ETF	84.55	84.55	84.55	84.55	200.0
2012-09-13 07:00:00	IWM	ETF	84.57	84.57	84.52	84.57	15400.0
2012-09-13 08:00:00	IWM	ETF	84.56	84.7	84.46	84.62	59611.0
2012-09-13 09:00:00	IWM	ETF	84.64	84.67	84.26	84.38	2839909.0
2012-09-13 10:00:00	IWM	ETF	84.38	84.58	84.19	84.36	3791585.0
2012-09-13 11:00:00	IWM	ETF	84.36	84.5	84.33	84.355	2224666.0
2012-09-13 12:00:00	IWM	ETF	84.37	85.23	84.22	85.21	14762432.0
2012-09-13 13:00:00	IWM	ETF	85.22	85.97	85.21	85.63	12997027.0
2012-09-13 14:00:00	IWM	ETF	85.64	86.15	85.61	85.71	8746061.0
2012-09-13 15:00:00	IWM	ETF	85.71	85.755	85.42	85.61	10464281.0
2012-09-13 16:00:00	IWM	ETF	85.61	85.66	85.51	85.61	1695588.0
2012-09-13 17:00:00	IWM	ETF	85.61	85.65	84.477	85.61	1523538.0
2012-09-13 18:00:00	IWM	ETF	85.74	85.74	85.54	85.62	590.0
2012-09-13 19:00:00	IWM	ETF	85.66	85.71	85.66	85.7	3594.0
2012-09-13 07:00:00	DIA	ETF	133.44	133.44	133.44	133.44	100.0
2012-09-13 08:00:00	DIA	ETF	133.11	133.38	133.11	133.37	400.0
2012-09-13 09:00:00	DIA	ETF	133.39	133.39	133.21	133.32	338932.0
2012-09-13 10:00:00	DIA	ETF	133.32	133.5155	133.32	133.47	297984.0
2012-09-13 11:00:00	DIA	ETF	133.5	133.665	133.47	133.51	261799.0
2012-09-13 12:00:00	DIA	ETF	133.5	134.43	133.33	134.27	1882990.0

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

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