PREVIEW / etf_1hour / 2012-08-08

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-08-08.parquet
  size:    182 KB
  rows:    5,619

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-08-08 04:00:00	SPY	ETF	140.0	140.1	139.94	139.98	2128.0
2012-08-08 05:00:00	SPY	ETF	139.96	139.97	139.83	139.83	2200.0
2012-08-08 06:00:00	SPY	ETF	139.87	140.1	139.84	139.9	12800.0
2012-08-08 07:00:00	SPY	ETF	139.92	140.02	139.87	139.87	164301.0
2012-08-08 08:00:00	SPY	ETF	139.89	139.92	139.67	139.71	1772326.0
2012-08-08 09:00:00	SPY	ETF	139.71	140.18	139.7	140.065	12894089.0
2012-08-08 10:00:00	SPY	ETF	140.06	140.24	139.98	140.15	15342759.0
2012-08-08 11:00:00	SPY	ETF	140.15	140.65	140.14	140.48	14171659.0
2012-08-08 12:00:00	SPY	ETF	140.47	140.58	140.24	140.42	6554474.0
2012-08-08 13:00:00	SPY	ETF	140.43	140.57	140.36	140.39	5835905.0
2012-08-08 14:00:00	SPY	ETF	140.4	140.42	140.17	140.275	9779920.0
2012-08-08 15:00:00	SPY	ETF	140.28	140.56	140.26	140.47	14193162.0
2012-08-08 16:00:00	SPY	ETF	140.48	140.565	140.1	140.4	6666940.0
2012-08-08 17:00:00	SPY	ETF	140.4	140.4	140.32	140.34	50460.0
2012-08-08 18:00:00	SPY	ETF	140.36	140.42	140.35	140.36	14101.0
2012-08-08 19:00:00	SPY	ETF	140.35	140.37	140.31	140.35	90880.0
2012-08-08 20:00:00	SPY	ETF	140.35	140.35	140.35	140.35	1000.0
2012-08-08 07:00:00	QQQ	ETF	66.55	66.55	66.5	66.51	14825.0
2012-08-08 08:00:00	QQQ	ETF	66.51	66.51	66.41	66.41	636487.0
2012-08-08 09:00:00	QQQ	ETF	66.42	66.66	66.41	66.48	4350342.0
2012-08-08 10:00:00	QQQ	ETF	66.48	66.61	66.37	66.49	2927186.0
2012-08-08 11:00:00	QQQ	ETF	66.49	66.76	66.45	66.71	4260269.0
2012-08-08 12:00:00	QQQ	ETF	66.7	66.762	66.53	66.64	1600494.0
2012-08-08 13:00:00	QQQ	ETF	66.64	66.69	66.57	66.63	1293031.0
2012-08-08 14:00:00	QQQ	ETF	66.64	66.65	66.53	66.56	1437756.0
2012-08-08 15:00:00	QQQ	ETF	66.56	66.66	66.52	66.6	2798290.0
2012-08-08 16:00:00	QQQ	ETF	66.6	66.67	66.5099	66.54	504005.0
2012-08-08 17:00:00	QQQ	ETF	66.54	66.55	66.51	66.55	18090.0
2012-08-08 18:00:00	QQQ	ETF	66.53	66.55	66.52	66.54	10125.0
2012-08-08 19:00:00	QQQ	ETF	66.54	66.54	66.51	66.53	7400.0
2012-08-08 07:00:00	IWM	ETF	79.72	79.74	79.72	79.73	700.0
2012-08-08 08:00:00	IWM	ETF	79.7	79.7	79.25	79.53	643955.0
2012-08-08 09:00:00	IWM	ETF	79.53	79.9	79.51	79.8	5142576.0
2012-08-08 10:00:00	IWM	ETF	79.81	80.11	79.76	79.84	4776028.0
2012-08-08 11:00:00	IWM	ETF	79.83	80.19	79.8	80.02	2783821.0
2012-08-08 12:00:00	IWM	ETF	80.02	80.11	79.75	79.8401	2170601.0
2012-08-08 13:00:00	IWM	ETF	79.85	80.04	79.82	79.92	2089306.0
2012-08-08 14:00:00	IWM	ETF	79.92	79.93	79.66	79.702	2735236.0
2012-08-08 15:00:00	IWM	ETF	79.7	79.96	79.7	79.82	4520432.0
2012-08-08 16:00:00	IWM	ETF	79.82	79.89	79.7557	79.84	813029.0
2012-08-08 17:00:00	IWM	ETF	79.85	79.85	79.84	79.84	200.0
2012-08-08 18:00:00	IWM	ETF	79.82	79.82	79.82	79.82	200.0
2012-08-08 19:00:00	IWM	ETF	79.82	79.82	79.77	79.77	1000.0
2012-08-08 08:00:00	DIA	ETF	131.06	131.06	130.8	130.8	16175.0
2012-08-08 09:00:00	DIA	ETF	130.8	131.4	130.78	131.35	452131.0
2012-08-08 10:00:00	DIA	ETF	131.354	131.5	131.22	131.37	379518.0
2012-08-08 11:00:00	DIA	ETF	131.38	131.8378	131.37	131.67	512984.0
2012-08-08 12:00:00	DIA	ETF	131.65	131.75	131.43	131.6	219119.0
2012-08-08 13:00:00	DIA	ETF	131.6051	131.72	131.53	131.55	155523.0
2012-08-08 14:00:00	DIA	ETF	131.56	131.57	131.34	131.49	443650.0

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

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