PREVIEW / etf_1hour / 2012-10-05

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-10-05.parquet
  size:    189 KB
  rows:    5,825

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-10-05 04:00:00	SPY	ETF	146.25	146.25	146.03	146.03	1750.0
2012-10-05 05:00:00	SPY	ETF	146.29	146.29	146.18	146.18	20401.0
2012-10-05 06:00:00	SPY	ETF	146.25	146.33	146.25	146.3	39000.0
2012-10-05 07:00:00	SPY	ETF	146.32	146.49	146.25	146.45	99992.0
2012-10-05 08:00:00	SPY	ETF	146.44	146.91	145.87	146.77	3987472.0
2012-10-05 09:00:00	SPY	ETF	146.78	147.01	146.27	146.91	16803225.0
2012-10-05 10:00:00	SPY	ETF	146.91	147.16	146.74	146.871	15209262.0
2012-10-05 11:00:00	SPY	ETF	146.871	146.895	146.57	146.68	11000686.0
2012-10-05 12:00:00	SPY	ETF	146.69	146.81	146.52	146.73	10503256.0
2012-10-05 13:00:00	SPY	ETF	146.72	146.76	146.37	146.45	10169381.0
2012-10-05 14:00:00	SPY	ETF	146.4597	146.52	145.93	145.9601	12220954.0
2012-10-05 15:00:00	SPY	ETF	145.965	146.15	145.7	146.15	28393038.0
2012-10-05 16:00:00	SPY	ETF	146.15	146.797	146.0	146.08	8029748.0
2012-10-05 17:00:00	SPY	ETF	146.08	146.15	146.02	146.03	295380.0
2012-10-05 18:00:00	SPY	ETF	146.07	146.07	145.88	145.88	132920.0
2012-10-05 19:00:00	SPY	ETF	145.86	145.98	145.82	145.83	47517.0
2012-10-05 05:00:00	QQQ	ETF	69.46	69.46	69.45	69.45	600.0
2012-10-05 06:00:00	QQQ	ETF	69.49	69.49	69.49	69.49	1200.0
2012-10-05 07:00:00	QQQ	ETF	69.47	69.55	69.47	69.54	44040.0
2012-10-05 08:00:00	QQQ	ETF	69.54	69.76	69.47	69.68	339914.0
2012-10-05 09:00:00	QQQ	ETF	69.68	69.77	69.54	69.68	3802895.0
2012-10-05 10:00:00	QQQ	ETF	69.68	69.8	69.47	69.49	3770679.0
2012-10-05 11:00:00	QQQ	ETF	69.5	69.53	69.29	69.33	2842365.0
2012-10-05 12:00:00	QQQ	ETF	69.33	69.38	69.16	69.36	2456036.0
2012-10-05 13:00:00	QQQ	ETF	69.36	69.42	69.2	69.26	1605771.0
2012-10-05 14:00:00	QQQ	ETF	69.26	69.305	68.95	68.96	3122071.0
2012-10-05 15:00:00	QQQ	ETF	68.97	69.05	68.8	68.96	5897491.0
2012-10-05 16:00:00	QQQ	ETF	68.97	69.3206	68.87	68.91	1020204.0
2012-10-05 17:00:00	QQQ	ETF	68.91	68.91	68.89	68.89	9463.0
2012-10-05 18:00:00	QQQ	ETF	68.89	68.89	68.89	68.89	7113.0
2012-10-05 19:00:00	QQQ	ETF	68.89	68.89	68.79	68.85	31917.0
2012-10-05 07:00:00	IWM	ETF	84.2	84.36	84.19	84.35	30980.0
2012-10-05 08:00:00	IWM	ETF	84.33	84.6	84.17	84.49	1173442.0
2012-10-05 09:00:00	IWM	ETF	84.5	84.87	84.42	84.74	4481594.0
2012-10-05 10:00:00	IWM	ETF	84.74	85.25	84.645	85.0	8490654.0
2012-10-05 11:00:00	IWM	ETF	85.0	85.03	84.72	84.728	3475069.0
2012-10-05 12:00:00	IWM	ETF	84.74	84.8	84.52	84.64	2589188.0
2012-10-05 13:00:00	IWM	ETF	84.64	84.67	84.34	84.45	2628273.0
2012-10-05 14:00:00	IWM	ETF	84.445	84.49	84.07	84.08	3550794.0
2012-10-05 15:00:00	IWM	ETF	84.0899	84.13	83.84	84.04	7237289.0
2012-10-05 16:00:00	IWM	ETF	84.06	84.5	83.92	84.02	912354.0
2012-10-05 17:00:00	IWM	ETF	84.01	84.02	84.0	84.0	37800.0
2012-10-05 18:00:00	IWM	ETF	83.96	83.96	83.95	83.95	300.0
2012-10-05 19:00:00	IWM	ETF	83.96	83.96	83.9	83.9	2290.0
2012-10-05 05:00:00	DIA	ETF	135.52	135.52	135.52	135.52	193.0
2012-10-05 07:00:00	DIA	ETF	135.58	135.58	135.58	135.58	100.0
2012-10-05 08:00:00	DIA	ETF	135.78	136.0	135.56	135.95	30238.0
2012-10-05 09:00:00	DIA	ETF	135.96	136.27	135.95	136.17	1246399.0
2012-10-05 10:00:00	DIA	ETF	136.18	136.44	136.06	136.23	823484.0
2012-10-05 11:00:00	DIA	ETF	136.23	136.24	135.975	136.12	408758.0

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

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