PREVIEW / etf_1hour / 2013-11-29

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-11-29.parquet
  size:    133 KB
  rows:    4,031

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
2013-11-29 04:00:00	SPY	ETF	181.25	181.33	180.92	181.33	1940.0
2013-11-29 05:00:00	SPY	ETF	181.28	181.3	181.28	181.28	1100.0
2013-11-29 06:00:00	SPY	ETF	181.28	181.35	181.22	181.35	3349.0
2013-11-29 07:00:00	SPY	ETF	181.33	181.42	181.3	181.38	115441.0
2013-11-29 08:00:00	SPY	ETF	181.37	181.38	181.1217	181.3	698885.0
2013-11-29 09:00:00	SPY	ETF	181.29	181.59	181.21	181.56	7081804.0
2013-11-29 10:00:00	SPY	ETF	181.56	181.75	181.5	181.63	7531543.0
2013-11-29 11:00:00	SPY	ETF	181.63	181.71	181.51	181.6	7294536.0
2013-11-29 12:00:00	SPY	ETF	181.595	181.66	180.8	180.91	20211777.0
2013-11-29 13:00:00	SPY	ETF	180.91	181.4292	180.83	180.95	9827892.0
2013-11-29 14:00:00	SPY	ETF	180.95	180.97	180.92	180.92	97431.0
2013-11-29 15:00:00	SPY	ETF	180.9499	180.95	180.93	180.95	34894.0
2013-11-29 16:00:00	SPY	ETF	180.95	181.0	180.94	181.0	9614.0
2013-11-29 05:00:00	QQQ	ETF	85.5	85.5	85.48	85.5	12200.0
2013-11-29 06:00:00	QQQ	ETF	85.53	85.53	85.52	85.52	1300.0
2013-11-29 07:00:00	QQQ	ETF	85.56	85.59	85.55	85.55	35398.0
2013-11-29 08:00:00	QQQ	ETF	85.53	85.56	85.47	85.47	51585.0
2013-11-29 09:00:00	QQQ	ETF	85.47	85.6403	85.45	85.61	4390738.0
2013-11-29 10:00:00	QQQ	ETF	85.61	85.7456	85.55	85.7	2835033.0
2013-11-29 11:00:00	QQQ	ETF	85.7099	85.84	85.66	85.76	2415794.0
2013-11-29 12:00:00	QQQ	ETF	85.76	85.82	85.56	85.66	4634616.0
2013-11-29 13:00:00	QQQ	ETF	85.66	85.76	85.2131	85.68	1158995.0
2013-11-29 14:00:00	QQQ	ETF	85.68	85.68	85.62	85.63	8859.0
2013-11-29 15:00:00	QQQ	ETF	85.72	85.72	85.66	85.66	1535.0
2013-11-29 16:00:00	QQQ	ETF	85.72	85.72	85.72	85.72	200.0
2013-11-29 06:00:00	IWM	ETF	113.42	113.93	113.42	113.9	7300.0
2013-11-29 07:00:00	IWM	ETF	113.9	114.0	113.84	114.0	35784.0
2013-11-29 08:00:00	IWM	ETF	114.0	114.02	113.87	113.87	60130.0
2013-11-29 09:00:00	IWM	ETF	113.87	113.98	113.71	113.86	2164093.0
2013-11-29 10:00:00	IWM	ETF	113.87	114.16	113.785	113.96	2752486.0
2013-11-29 11:00:00	IWM	ETF	113.95	114.14	113.8	114.07	2685995.0
2013-11-29 12:00:00	IWM	ETF	114.078	114.15	113.46	113.52	4914835.0
2013-11-29 13:00:00	IWM	ETF	113.51	113.55	113.35	113.4	1430958.0
2013-11-29 14:00:00	IWM	ETF	113.4	113.6	113.3	113.54	2300.0
2013-11-29 15:00:00	IWM	ETF	113.61	113.61	113.61	113.61	200.0
2013-11-29 08:00:00	DIA	ETF	161.11	161.11	161.11	161.11	1000.0
2013-11-29 09:00:00	DIA	ETF	161.11	161.43	161.0	161.35	506464.0
2013-11-29 10:00:00	DIA	ETF	161.36	161.58	161.308	161.38	646237.0
2013-11-29 11:00:00	DIA	ETF	161.39	161.4299	161.25	161.31	451337.0
2013-11-29 12:00:00	DIA	ETF	161.29	161.37	160.58	160.67	1123424.0
2013-11-29 13:00:00	DIA	ETF	160.66	161.0	160.65	161.0	125251.0
2013-11-29 14:00:00	DIA	ETF	160.97	160.97	160.97	160.97	865.0
2013-11-29 15:00:00	DIA	ETF	161.3499	161.3499	161.3499	161.3499	500.0
2013-11-29 04:00:00	GLD	ETF	120.0	120.35	120.0	120.35	424.0
2013-11-29 06:00:00	GLD	ETF	120.35	120.45	120.35	120.45	1700.0
2013-11-29 07:00:00	GLD	ETF	120.45	120.85	120.45	120.85	3900.0
2013-11-29 08:00:00	GLD	ETF	120.67	121.0	120.61	120.67	73400.0
2013-11-29 09:00:00	GLD	ETF	120.7	120.85	120.66	120.81	517992.0
2013-11-29 10:00:00	GLD	ETF	120.83	121.05	120.82	121.01	536842.0
2013-11-29 11:00:00	GLD	ETF	121.02	121.03	120.75	120.7701	338864.0

> showing 50 of 4,031 rows — these rows as CSV

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