PREVIEW / etf_1hour / 2012-08-27

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-08-27.parquet
  size:    180 KB
  rows:    5,573

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-27 04:00:00	SPY	ETF	141.75	141.84	141.75	141.84	400.0
2012-08-27 05:00:00	SPY	ETF	141.7	141.72	141.7	141.7	500.0
2012-08-27 06:00:00	SPY	ETF	141.95	142.06	141.95	141.97	35165.0
2012-08-27 07:00:00	SPY	ETF	141.96	142.07	141.88	141.96	158100.0
2012-08-27 08:00:00	SPY	ETF	141.96	142.22	141.9	141.94	927282.0
2012-08-27 09:00:00	SPY	ETF	141.93	141.99	141.43	141.43	11099302.0
2012-08-27 10:00:00	SPY	ETF	141.43	141.6	141.37	141.53	10248597.0
2012-08-27 11:00:00	SPY	ETF	141.53	142.08	141.5	141.91	9245764.0
2012-08-27 12:00:00	SPY	ETF	141.9	142.01	141.8	141.865	4371971.0
2012-08-27 13:00:00	SPY	ETF	141.865	141.97	141.71	141.761	5636045.0
2012-08-27 14:00:00	SPY	ETF	141.77	141.88	141.64	141.79	4992483.0
2012-08-27 15:00:00	SPY	ETF	141.794	141.82	141.34	141.52	14655174.0
2012-08-27 16:00:00	SPY	ETF	141.53	141.54	141.4	141.43	3103675.0
2012-08-27 17:00:00	SPY	ETF	141.44	141.52	141.44	141.52	36271.0
2012-08-27 18:00:00	SPY	ETF	141.5	141.51	141.47	141.5	4317.0
2012-08-27 19:00:00	SPY	ETF	141.5	141.56	141.48	141.54	65193.0
2012-08-27 06:00:00	QQQ	ETF	68.58	68.58	68.54	68.56	800.0
2012-08-27 07:00:00	QQQ	ETF	68.58	68.6	68.52	68.6	113410.0
2012-08-27 08:00:00	QQQ	ETF	68.6	68.7	68.57	68.58	191963.0
2012-08-27 09:00:00	QQQ	ETF	68.58	68.63	68.28	68.3	4270750.0
2012-08-27 10:00:00	QQQ	ETF	68.3	68.47	68.28	68.39	3233470.0
2012-08-27 11:00:00	QQQ	ETF	68.39	68.67	68.38	68.52	3090848.0
2012-08-27 12:00:00	QQQ	ETF	68.52	68.59	68.42	68.4801	1570490.0
2012-08-27 13:00:00	QQQ	ETF	68.48	68.56	68.41	68.4501	1308267.0
2012-08-27 14:00:00	QQQ	ETF	68.45	68.558	68.38	68.51	1316132.0
2012-08-27 15:00:00	QQQ	ETF	68.5	68.51	68.25	68.39	3255666.0
2012-08-27 16:00:00	QQQ	ETF	68.39	68.45	68.36	68.4	473671.0
2012-08-27 17:00:00	QQQ	ETF	68.41	68.46	68.41	68.43	17650.0
2012-08-27 18:00:00	QQQ	ETF	68.42	68.42	68.4	68.41	21673.0
2012-08-27 19:00:00	QQQ	ETF	68.41	68.45	68.41	68.45	17050.0
2012-08-27 05:00:00	IWM	ETF	81.21	81.21	81.21	81.21	100.0
2012-08-27 06:00:00	IWM	ETF	81.39	81.39	81.39	81.39	900.0
2012-08-27 07:00:00	IWM	ETF	81.34	81.4	81.31	81.38	119000.0
2012-08-27 08:00:00	IWM	ETF	81.33	81.47	81.24	81.25	173120.0
2012-08-27 09:00:00	IWM	ETF	81.25	81.29	80.63	80.65	4072906.0
2012-08-27 10:00:00	IWM	ETF	80.64	80.93	80.58	80.83	2969315.0
2012-08-27 11:00:00	IWM	ETF	80.83	81.41	80.81	81.169	4257255.0
2012-08-27 12:00:00	IWM	ETF	81.16	81.26	80.98	81.11	1444334.0
2012-08-27 13:00:00	IWM	ETF	81.1	81.16	80.86	80.88	1986431.0
2012-08-27 14:00:00	IWM	ETF	80.88	81.03	80.81	80.96	1641727.0
2012-08-27 15:00:00	IWM	ETF	80.96	80.98	80.75	80.95	4548527.0
2012-08-27 16:00:00	IWM	ETF	80.96	80.98	80.8519	80.95	1185268.0
2012-08-27 17:00:00	IWM	ETF	80.95	80.95	80.95	80.95	3000.0
2012-08-27 18:00:00	IWM	ETF	80.94	80.94	80.94	80.94	700.0
2012-08-27 19:00:00	IWM	ETF	80.92	80.95	80.92	80.95	4305.0
2012-08-27 08:00:00	DIA	ETF	131.6	131.73	131.58	131.58	13550.0
2012-08-27 09:00:00	DIA	ETF	131.54	131.55	131.04	131.05	242018.0
2012-08-27 10:00:00	DIA	ETF	131.05	131.18	130.994	131.12	261768.0
2012-08-27 11:00:00	DIA	ETF	131.1	131.57	131.1	131.42	307563.0
2012-08-27 12:00:00	DIA	ETF	131.41	131.52	131.35	131.39	104927.0

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

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