PREVIEW / etf_1hour / 2012-07-17

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-07-17.parquet
  size:    182 KB
  rows:    5,556

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-07-17 04:00:00	SPY	ETF	135.93	136.04	135.93	135.95	3130.0
2012-07-17 05:00:00	SPY	ETF	135.89	136.01	135.84	135.84	8700.0
2012-07-17 06:00:00	SPY	ETF	135.8	135.89	135.78	135.81	3325.0
2012-07-17 07:00:00	SPY	ETF	135.74	136.05	135.74	136.0	518276.0
2012-07-17 08:00:00	SPY	ETF	136.0	136.16	135.75	135.89	2206891.0
2012-07-17 09:00:00	SPY	ETF	135.88	136.24	135.61	135.76	17186223.0
2012-07-17 10:00:00	SPY	ETF	135.76	135.79	134.55	134.84	33060073.0
2012-07-17 11:00:00	SPY	ETF	134.84	135.78	134.79	135.7613	17424056.0
2012-07-17 12:00:00	SPY	ETF	135.77	136.18	135.77	135.925	11804166.0
2012-07-17 13:00:00	SPY	ETF	135.925	136.53	135.9	136.33	10109776.0
2012-07-17 14:00:00	SPY	ETF	136.33	136.64	136.32	136.501	9382992.0
2012-07-17 15:00:00	SPY	ETF	136.5	136.53	136.13	136.39	22488456.0
2012-07-17 16:00:00	SPY	ETF	136.39	136.5	135.2915	136.36	9968189.0
2012-07-17 17:00:00	SPY	ETF	136.39	136.41	135.4457	136.38	795778.0
2012-07-17 18:00:00	SPY	ETF	136.38	136.39	136.33	136.34	37337.0
2012-07-17 19:00:00	SPY	ETF	136.36	136.42	136.34	136.42	248580.0
2012-07-17 04:00:00	QQQ	ETF	63.5	63.5	63.5	63.5	153.0
2012-07-17 05:00:00	QQQ	ETF	63.45	63.45	63.45	63.45	100.0
2012-07-17 06:00:00	QQQ	ETF	63.44	63.47	63.44	63.46	2900.0
2012-07-17 07:00:00	QQQ	ETF	63.47	63.56	63.45	63.53	114974.0
2012-07-17 08:00:00	QQQ	ETF	63.53	63.57	63.45	63.53	1940304.0
2012-07-17 09:00:00	QQQ	ETF	63.53	63.72	63.28	63.41	4809899.0
2012-07-17 10:00:00	QQQ	ETF	63.42	63.43	62.63	62.799	9549973.0
2012-07-17 11:00:00	QQQ	ETF	62.8	63.31	62.77	63.31	3203796.0
2012-07-17 12:00:00	QQQ	ETF	63.32	63.59	63.32	63.37	3346787.0
2012-07-17 13:00:00	QQQ	ETF	63.37	63.66	63.35	63.53	2521742.0
2012-07-17 14:00:00	QQQ	ETF	63.52	63.74	63.51	63.67	4122117.0
2012-07-17 15:00:00	QQQ	ETF	63.67	63.69	63.36	63.54	8043495.0
2012-07-17 16:00:00	QQQ	ETF	63.53	63.72	63.38	63.6	2570805.0
2012-07-17 17:00:00	QQQ	ETF	63.59	63.61	63.58	63.61	66467.0
2012-07-17 18:00:00	QQQ	ETF	63.59	63.59	63.54	63.57	9052.0
2012-07-17 19:00:00	QQQ	ETF	63.59	63.6	63.57	63.57	9166.0
2012-07-17 07:00:00	IWM	ETF	79.81	80.0	79.81	80.0	43900.0
2012-07-17 08:00:00	IWM	ETF	79.95	79.98	79.81	79.92	153833.0
2012-07-17 09:00:00	IWM	ETF	79.91	80.15	79.46	79.6	4315857.0
2012-07-17 10:00:00	IWM	ETF	79.61	79.66	78.65	78.9	10909435.0
2012-07-17 11:00:00	IWM	ETF	78.9	79.65	78.84	79.65	5288210.0
2012-07-17 12:00:00	IWM	ETF	79.65	79.83	79.63	79.65	4392562.0
2012-07-17 13:00:00	IWM	ETF	79.65	79.98	79.63	79.8251	4143700.0
2012-07-17 14:00:00	IWM	ETF	79.83	79.97	79.8	79.89	3243624.0
2012-07-17 15:00:00	IWM	ETF	79.89	79.92	79.64	79.74	6204537.0
2012-07-17 16:00:00	IWM	ETF	79.73	79.89	79.059	79.75	932750.0
2012-07-17 17:00:00	IWM	ETF	79.79	79.8	79.79	79.8	26100.0
2012-07-17 07:00:00	DIA	ETF	127.5	127.52	127.5	127.52	650.0
2012-07-17 08:00:00	DIA	ETF	127.44	127.49	127.35	127.49	1400.0
2012-07-17 09:00:00	DIA	ETF	127.48	127.85	127.41	127.54	409497.0
2012-07-17 10:00:00	DIA	ETF	127.55	127.55	126.29	126.4582	976478.0
2012-07-17 11:00:00	DIA	ETF	126.44	127.5	126.41	127.49	285755.0
2012-07-17 12:00:00	DIA	ETF	127.52	127.84	127.51	127.6	396579.0
2012-07-17 13:00:00	DIA	ETF	127.6	128.1	127.59	127.92	347578.0

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

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