PREVIEW / etf_1hour / 2012-08-29

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-08-29.parquet
  size:    177 KB
  rows:    5,497

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-29 04:00:00	SPY	ETF	141.31	141.35	141.3	141.35	400.0
2012-08-29 05:00:00	SPY	ETF	141.3	141.3	141.27	141.27	2500.0
2012-08-29 06:00:00	SPY	ETF	141.28	141.41	141.28	141.35	9750.0
2012-08-29 07:00:00	SPY	ETF	141.37	141.45	141.29	141.34	87198.0
2012-08-29 08:00:00	SPY	ETF	141.33	141.72	141.33	141.63	546670.0
2012-08-29 09:00:00	SPY	ETF	141.63	141.68	141.32	141.405	8715332.0
2012-08-29 10:00:00	SPY	ETF	141.41	141.62	141.12	141.21	14395478.0
2012-08-29 11:00:00	SPY	ETF	141.2	141.58	141.18	141.501	9161538.0
2012-08-29 12:00:00	SPY	ETF	141.51	141.65	141.45	141.59	4013423.0
2012-08-29 13:00:00	SPY	ETF	141.59	141.89	141.58	141.81	8331102.0
2012-08-29 14:00:00	SPY	ETF	141.81	141.82	141.62	141.63	6238109.0
2012-08-29 15:00:00	SPY	ETF	141.64	141.73	141.48	141.52	10612373.0
2012-08-29 16:00:00	SPY	ETF	141.5	141.5736	141.2	141.33	2521791.0
2012-08-29 17:00:00	SPY	ETF	141.33	141.4	141.33	141.4	55654.0
2012-08-29 18:00:00	SPY	ETF	141.37	141.39	141.33	141.34	21814.0
2012-08-29 19:00:00	SPY	ETF	141.34	141.36	141.3	141.34	14600.0
2012-08-29 04:00:00	QQQ	ETF	68.3	68.3	68.3	68.3	400.0
2012-08-29 06:00:00	QQQ	ETF	68.33	68.33	68.33	68.33	2000.0
2012-08-29 07:00:00	QQQ	ETF	68.34	68.35	68.28	68.28	5700.0
2012-08-29 08:00:00	QQQ	ETF	68.33	68.52	68.33	68.47	118028.0
2012-08-29 09:00:00	QQQ	ETF	68.46	68.56	68.38	68.39	2238793.0
2012-08-29 10:00:00	QQQ	ETF	68.39	68.51	68.11	68.15	3963919.0
2012-08-29 11:00:00	QQQ	ETF	68.15	68.38	68.15	68.32	2437384.0
2012-08-29 12:00:00	QQQ	ETF	68.33	68.43	68.3	68.39	980299.0
2012-08-29 13:00:00	QQQ	ETF	68.385	68.57	68.38	68.55	2945011.0
2012-08-29 14:00:00	QQQ	ETF	68.55	68.56	68.44	68.46	1511364.0
2012-08-29 15:00:00	QQQ	ETF	68.46	68.4983	68.38	68.4	2371080.0
2012-08-29 16:00:00	QQQ	ETF	68.39	68.4675	68.33	68.35	4654342.0
2012-08-29 17:00:00	QQQ	ETF	68.36	68.37	68.34	68.35	5439.0
2012-08-29 18:00:00	QQQ	ETF	68.34	68.38	68.34	68.37	5043.0
2012-08-29 19:00:00	QQQ	ETF	68.37	68.37	68.35	68.35	1600.0
2012-08-29 04:00:00	IWM	ETF	81.36	81.36	81.36	81.36	200.0
2012-08-29 07:00:00	IWM	ETF	81.42	81.42	81.34	81.42	21405.0
2012-08-29 08:00:00	IWM	ETF	81.42	81.64	81.42	81.56	136809.0
2012-08-29 09:00:00	IWM	ETF	81.55	81.65	81.27	81.3	2930441.0
2012-08-29 10:00:00	IWM	ETF	81.29	81.56	81.145	81.1875	4187159.0
2012-08-29 11:00:00	IWM	ETF	81.2	81.71	81.18	81.61	3886249.0
2012-08-29 12:00:00	IWM	ETF	81.62	81.705	81.58	81.62	1913582.0
2012-08-29 13:00:00	IWM	ETF	81.61	81.96	81.61	81.88	4456764.0
2012-08-29 14:00:00	IWM	ETF	81.88	81.9	81.72	81.74	2196608.0
2012-08-29 15:00:00	IWM	ETF	81.73	81.83	81.58	81.58	3795666.0
2012-08-29 16:00:00	IWM	ETF	81.59	81.6764	81.225	81.46	2263697.0
2012-08-29 17:00:00	IWM	ETF	81.44	81.45	81.44	81.45	3779.0
2012-08-29 18:00:00	IWM	ETF	81.45	81.45	81.43	81.43	5372.0
2012-08-29 19:00:00	IWM	ETF	81.49	81.49	81.48	81.48	900.0
2012-08-29 08:00:00	DIA	ETF	130.76	130.97	130.75	130.94	20850.0
2012-08-29 09:00:00	DIA	ETF	130.96	131.04	130.73	130.79	310488.0
2012-08-29 10:00:00	DIA	ETF	130.74	130.96	130.63	130.7	420162.0
2012-08-29 11:00:00	DIA	ETF	130.71	130.95	130.668	130.86	579217.0
2012-08-29 12:00:00	DIA	ETF	130.86	131.03	130.8544	130.954	125964.0

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

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