PREVIEW / etf_1hour / 2012-06-15

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-06-15.parquet
  size:    186 KB
  rows:    5,745

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-06-15 04:00:00	SPY	ETF	133.89	133.89	133.55	133.67	1500.0
2012-06-15 05:00:00	SPY	ETF	133.74	133.76	133.62	133.73	6465.0
2012-06-15 06:00:00	SPY	ETF	133.61	133.62	133.38	133.6	70044.0
2012-06-15 07:00:00	SPY	ETF	133.59	133.7	133.41	133.44	303529.0
2012-06-15 08:00:00	SPY	ETF	133.43	133.91	133.2	133.22	1554767.0
2012-06-15 09:00:00	SPY	ETF	133.23	133.51	133.1	133.47	25520336.0
2012-06-15 10:00:00	SPY	ETF	133.48	133.66	133.28	133.551	22570548.0
2012-06-15 11:00:00	SPY	ETF	133.55	133.73	133.45	133.55	15804469.0
2012-06-15 12:00:00	SPY	ETF	133.55	133.6	133.32	133.47	11481427.0
2012-06-15 13:00:00	SPY	ETF	133.46	133.76	133.46	133.6414	13141337.0
2012-06-15 14:00:00	SPY	ETF	133.64	133.96	133.63	133.7423	14677052.0
2012-06-15 15:00:00	SPY	ETF	133.74	134.26	133.72	134.1	39493529.0
2012-06-15 16:00:00	SPY	ETF	134.09	134.47	133.55	134.39	20848670.0
2012-06-15 17:00:00	SPY	ETF	134.1738	134.48	134.1738	134.44	1282337.0
2012-06-15 18:00:00	SPY	ETF	134.45	134.75	134.45	134.72	228929.0
2012-06-15 19:00:00	SPY	ETF	134.69	134.7	134.58	134.67	110980.0
2012-06-15 04:00:00	QQQ	ETF	62.51	62.53	62.49	62.49	1194.0
2012-06-15 06:00:00	QQQ	ETF	62.5	62.5	62.5	62.5	200.0
2012-06-15 07:00:00	QQQ	ETF	62.51	62.6	62.45	62.45	10400.0
2012-06-15 08:00:00	QQQ	ETF	62.46	62.47	62.33	62.33	154390.0
2012-06-15 09:00:00	QQQ	ETF	62.35	62.61	62.25	62.61	6744254.0
2012-06-15 10:00:00	QQQ	ETF	62.62	62.76	62.59	62.72	6295664.0
2012-06-15 11:00:00	QQQ	ETF	62.72	62.84	62.68	62.74	3556421.0
2012-06-15 12:00:00	QQQ	ETF	62.74	62.8	62.65	62.73	2615912.0
2012-06-15 13:00:00	QQQ	ETF	62.73	62.83	62.71	62.78	2782540.0
2012-06-15 14:00:00	QQQ	ETF	62.78	62.93	62.76	62.8154	2748250.0
2012-06-15 15:00:00	QQQ	ETF	62.8101	63.08	62.8	63.02	10866120.0
2012-06-15 16:00:00	QQQ	ETF	63.01	63.065	62.6186	63.03	4706135.0
2012-06-15 17:00:00	QQQ	ETF	63.03	63.07	63.01	63.04	102073.0
2012-06-15 18:00:00	QQQ	ETF	63.04	63.15	63.04	63.09	13324.0
2012-06-15 19:00:00	QQQ	ETF	63.09	63.2	63.02	63.2	11863.0
2012-06-15 04:00:00	IWM	ETF	76.71	76.71	76.64	76.64	1200.0
2012-06-15 05:00:00	IWM	ETF	76.67	76.67	76.67	76.67	200.0
2012-06-15 06:00:00	IWM	ETF	76.49	76.6	76.39	76.6	20200.0
2012-06-15 07:00:00	IWM	ETF	76.7	76.7	76.5	76.51	36075.0
2012-06-15 08:00:00	IWM	ETF	76.51	76.54	76.32	76.32	145649.0
2012-06-15 09:00:00	IWM	ETF	76.35	76.47	76.1	76.44	4854748.0
2012-06-15 10:00:00	IWM	ETF	76.45	76.64	76.24	76.58	7232809.0
2012-06-15 11:00:00	IWM	ETF	76.57	76.82	76.5201	76.7	5074497.0
2012-06-15 12:00:00	IWM	ETF	76.705	76.74	76.56	76.67	1940827.0
2012-06-15 13:00:00	IWM	ETF	76.68	76.93	76.68	76.87	3671515.0
2012-06-15 14:00:00	IWM	ETF	76.88	77.24	76.85	77.07	6037300.0
2012-06-15 15:00:00	IWM	ETF	77.07	77.32	77.01	77.21	13536440.0
2012-06-15 16:00:00	IWM	ETF	77.18	77.31	77.045	77.3	4609503.0
2012-06-15 17:00:00	IWM	ETF	77.28	77.3	77.22	77.27	2322040.0
2012-06-15 18:00:00	IWM	ETF	77.3	77.55	77.3	77.51	30560.0
2012-06-15 19:00:00	IWM	ETF	77.44	77.49	77.36	77.39	3500.0
2012-06-15 05:00:00	DIA	ETF	126.99	126.99	126.99	126.99	100.0
2012-06-15 07:00:00	DIA	ETF	126.99	127.06	126.93	126.95	2200.0
2012-06-15 08:00:00	DIA	ETF	126.77	126.8	126.63	126.67	24500.0

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

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