PREVIEW / etf_1hour / 2012-11-12

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-11-12.parquet
  size:    182 KB
  rows:    5,612

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-11-12 04:00:00	SPY	ETF	138.38	138.57	138.3	138.57	37176.0
2012-11-12 05:00:00	SPY	ETF	138.54	138.6	138.45	138.45	38800.0
2012-11-12 06:00:00	SPY	ETF	138.49	138.59	138.45	138.55	88267.0
2012-11-12 07:00:00	SPY	ETF	138.56	138.78	138.51	138.76	763162.0
2012-11-12 08:00:00	SPY	ETF	138.76	138.8	138.53	138.72	1325799.0
2012-11-12 09:00:00	SPY	ETF	138.71	138.77	138.42	138.6	11855494.0
2012-11-12 10:00:00	SPY	ETF	138.6	138.61	138.04	138.08	16046798.0
2012-11-12 11:00:00	SPY	ETF	138.08	138.21	137.96	138.04	9620902.0
2012-11-12 12:00:00	SPY	ETF	138.05	138.49	137.99	138.48	6925302.0
2012-11-12 13:00:00	SPY	ETF	138.4799	138.81	138.47	138.63	12423388.0
2012-11-12 14:00:00	SPY	ETF	138.63	138.73	138.3	138.43	12062545.0
2012-11-12 15:00:00	SPY	ETF	138.43	138.54	138.2	138.27	18413072.0
2012-11-12 16:00:00	SPY	ETF	138.28	138.5759	138.0732	138.53	6148281.0
2012-11-12 17:00:00	SPY	ETF	138.52	138.53	138.44	138.48	86347.0
2012-11-12 18:00:00	SPY	ETF	138.48	138.48	138.14	138.17	128769.0
2012-11-12 19:00:00	SPY	ETF	138.2	138.22	138.03	138.12	246687.0
2012-11-12 04:00:00	QQQ	ETF	63.6	63.61	63.6	63.61	400.0
2012-11-12 07:00:00	QQQ	ETF	63.66	63.79	63.66	63.78	47885.0
2012-11-12 08:00:00	QQQ	ETF	63.81	63.81	63.4641	63.79	112749.0
2012-11-12 09:00:00	QQQ	ETF	63.8	63.87	63.7	63.78	3649019.0
2012-11-12 10:00:00	QQQ	ETF	63.78	63.78	63.32	63.33	3796815.0
2012-11-12 11:00:00	QQQ	ETF	63.32	63.38	63.25	63.3101	3022662.0
2012-11-12 12:00:00	QQQ	ETF	63.32	63.68	63.3	63.68	2366823.0
2012-11-12 13:00:00	QQQ	ETF	63.675	63.81	63.5	63.592	2810287.0
2012-11-12 14:00:00	QQQ	ETF	63.59	63.65	63.39	63.48	2712980.0
2012-11-12 15:00:00	QQQ	ETF	63.47	63.56	63.35	63.42	4087583.0
2012-11-12 16:00:00	QQQ	ETF	63.43	63.714	63.4	63.5	4103260.0
2012-11-12 17:00:00	QQQ	ETF	63.5	63.51	63.49	63.49	20168.0
2012-11-12 18:00:00	QQQ	ETF	63.48	63.48	63.4	63.4	44727.0
2012-11-12 19:00:00	QQQ	ETF	63.39	63.39	63.33	63.35	27809.0
2012-11-12 07:00:00	IWM	ETF	79.55	79.65	79.55	79.65	6000.0
2012-11-12 08:00:00	IWM	ETF	79.68	79.68	79.55	79.67	67506.0
2012-11-12 09:00:00	IWM	ETF	79.67	79.7	79.46	79.55	3046039.0
2012-11-12 10:00:00	IWM	ETF	79.54	79.59	79.06	79.1	2306533.0
2012-11-12 11:00:00	IWM	ETF	79.1	79.21	79.03	79.07	2616461.0
2012-11-12 12:00:00	IWM	ETF	79.06	79.44	79.06	79.428	1560350.0
2012-11-12 13:00:00	IWM	ETF	79.425	79.621	79.36	79.45	1874374.0
2012-11-12 14:00:00	IWM	ETF	79.445	79.445	79.25	79.33	1446721.0
2012-11-12 15:00:00	IWM	ETF	79.3326	79.4	79.15	79.18	4084833.0
2012-11-12 16:00:00	IWM	ETF	79.17	79.28	79.15	79.24	1614102.0
2012-11-12 17:00:00	IWM	ETF	79.26	79.26	79.2	79.2	700.0
2012-11-12 18:00:00	IWM	ETF	79.23	79.23	79.2	79.2	16010.0
2012-11-12 19:00:00	IWM	ETF	79.19	79.19	79.12	79.17	10160.0
2012-11-12 04:00:00	DIA	ETF	128.1	128.1	128.1	128.1	200.0
2012-11-12 05:00:00	DIA	ETF	128.21	128.23	128.12	128.12	1495.0
2012-11-12 07:00:00	DIA	ETF	128.35	128.35	128.35	128.35	100.0
2012-11-12 08:00:00	DIA	ETF	128.32	128.32	128.21	128.31	5219.0
2012-11-12 09:00:00	DIA	ETF	128.33	128.33	128.01	128.21	517194.0
2012-11-12 10:00:00	DIA	ETF	128.19	128.2	127.77	127.8	620687.0
2012-11-12 11:00:00	DIA	ETF	127.81	127.9	127.7	127.79	657179.0

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

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