PREVIEW / etf_1hour / 2012-08-28

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-08-28.parquet
  size:    174 KB
  rows:    5,528

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-28 05:00:00	SPY	ETF	141.72	141.72	141.59	141.59	200.0
2012-08-28 06:00:00	SPY	ETF	141.6	141.65	141.55	141.55	65987.0
2012-08-28 07:00:00	SPY	ETF	141.54	141.54	141.38	141.44	137023.0
2012-08-28 08:00:00	SPY	ETF	141.4	141.49	141.07	141.12	859550.0
2012-08-28 09:00:00	SPY	ETF	141.12	141.56	141.06	141.12	12645081.0
2012-08-28 10:00:00	SPY	ETF	141.14	141.84	140.97	141.449	18123333.0
2012-08-28 11:00:00	SPY	ETF	141.45	141.61	141.28	141.61	7864339.0
2012-08-28 12:00:00	SPY	ETF	141.6	141.75	141.56	141.709	6321960.0
2012-08-28 13:00:00	SPY	ETF	141.71	141.72	141.41	141.449	5348647.0
2012-08-28 14:00:00	SPY	ETF	141.45	141.72	141.44	141.56	4785721.0
2012-08-28 15:00:00	SPY	ETF	141.57	141.8001	141.33	141.4	12939393.0
2012-08-28 16:00:00	SPY	ETF	141.415	141.489	141.34	141.38	5267164.0
2012-08-28 17:00:00	SPY	ETF	141.37	141.53	141.37	141.47	86537.0
2012-08-28 18:00:00	SPY	ETF	141.46	141.57	141.45	141.56	56660.0
2012-08-28 19:00:00	SPY	ETF	141.53	141.55	141.51	141.53	10802.0
2012-08-28 06:00:00	QQQ	ETF	68.52	68.52	68.52	68.52	1000.0
2012-08-28 07:00:00	QQQ	ETF	68.44	68.46	68.38	68.38	23295.0
2012-08-28 08:00:00	QQQ	ETF	68.42	68.42	68.26	68.27	111786.0
2012-08-28 09:00:00	QQQ	ETF	68.31	68.47	68.19	68.22	3842026.0
2012-08-28 10:00:00	QQQ	ETF	68.21	68.5199	68.11	68.3	5859178.0
2012-08-28 11:00:00	QQQ	ETF	68.31	68.491	68.22	68.48	2647874.0
2012-08-28 12:00:00	QQQ	ETF	68.49	68.585	68.46	68.5	2850773.0
2012-08-28 13:00:00	QQQ	ETF	68.51	68.52	68.36	68.4	1693272.0
2012-08-28 14:00:00	QQQ	ETF	68.4092	68.49	68.365	68.41	2376214.0
2012-08-28 15:00:00	QQQ	ETF	68.42	68.52	68.35	68.37	3834233.0
2012-08-28 16:00:00	QQQ	ETF	68.39	68.43	68.3365	68.36	1075421.0
2012-08-28 17:00:00	QQQ	ETF	68.35	68.4	68.35	68.4	3895.0
2012-08-28 18:00:00	QQQ	ETF	68.42	68.45	68.42	68.45	1900.0
2012-08-28 19:00:00	QQQ	ETF	68.41	68.45	68.41	68.45	20400.0
2012-08-28 04:00:00	IWM	ETF	81.14	81.14	81.14	81.14	290.0
2012-08-28 05:00:00	IWM	ETF	81.25	81.25	81.25	81.25	200.0
2012-08-28 06:00:00	IWM	ETF	81.29	81.29	81.26	81.26	7100.0
2012-08-28 07:00:00	IWM	ETF	81.16	81.17	81.14	81.14	2200.0
2012-08-28 08:00:00	IWM	ETF	81.14	81.14	80.85	80.87	186802.0
2012-08-28 09:00:00	IWM	ETF	80.9	81.32	80.84	80.98	3921013.0
2012-08-28 10:00:00	IWM	ETF	81.0	81.51	80.75	81.1	6653992.0
2012-08-28 11:00:00	IWM	ETF	81.11	81.29	80.95	81.27	2482893.0
2012-08-28 12:00:00	IWM	ETF	81.27	81.39	81.24	81.37	1623382.0
2012-08-28 13:00:00	IWM	ETF	81.38	81.39	81.1575	81.24	1318726.0
2012-08-28 14:00:00	IWM	ETF	81.25	81.37	81.1975	81.29	1200690.0
2012-08-28 15:00:00	IWM	ETF	81.3	81.44	81.22	81.34	6069253.0
2012-08-28 16:00:00	IWM	ETF	81.34	81.39	81.26	81.35	3280281.0
2012-08-28 17:00:00	IWM	ETF	81.34	81.44	81.34	81.43	6711.0
2012-08-28 18:00:00	IWM	ETF	81.33	81.33	81.33	81.33	115.0
2012-08-28 19:00:00	IWM	ETF	81.41	81.5	81.41	81.5	7215.0
2012-08-28 08:00:00	DIA	ETF	130.91	130.91	130.69	130.77	15375.0
2012-08-28 09:00:00	DIA	ETF	130.91	131.11	130.67	130.67	340795.0
2012-08-28 10:00:00	DIA	ETF	130.75	131.3	130.6	131.06	773557.0
2012-08-28 11:00:00	DIA	ETF	131.07	131.14	130.9	131.13	243171.0
2012-08-28 12:00:00	DIA	ETF	131.15	131.2499	131.08	131.17	346869.0

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

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