PREVIEW / etf_1hour / 2011-05-25

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-05-25.parquet
  size:    176 KB
  rows:    5,390

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
2011-05-25 04:00:00	SPY	ETF	131.42	131.58	131.32	131.5	1800.0
2011-05-25 05:00:00	SPY	ETF	131.6	131.76	131.59	131.72	4516.0
2011-05-25 06:00:00	SPY	ETF	131.74	131.81	131.24	131.55	84638.0
2011-05-25 07:00:00	SPY	ETF	131.62	131.81	131.56	131.81	423405.0
2011-05-25 08:00:00	SPY	ETF	131.78	131.88	131.28	131.51	2457766.0
2011-05-25 09:00:00	SPY	ETF	131.51	132.02	131.19	131.805	22540319.0
2011-05-25 10:00:00	SPY	ETF	131.8	132.27	131.56	132.08	25052951.0
2011-05-25 11:00:00	SPY	ETF	132.08	132.61	132.06	132.4	19154551.0
2011-05-25 12:00:00	SPY	ETF	132.4	132.47	132.24	132.42	8084747.0
2011-05-25 13:00:00	SPY	ETF	132.42	132.46	132.16	132.25	10307882.0
2011-05-25 14:00:00	SPY	ETF	132.24	132.52	132.2	132.45	10583896.0
2011-05-25 15:00:00	SPY	ETF	132.46	132.94	132.36	132.38	36588361.0
2011-05-25 16:00:00	SPY	ETF	132.37	132.78	132.09	132.14	13909596.0
2011-05-25 17:00:00	SPY	ETF	132.13	132.18	132.12	132.15	383923.0
2011-05-25 18:00:00	SPY	ETF	132.17	132.37	132.17	132.25	141997.0
2011-05-25 19:00:00	SPY	ETF	132.27	132.28	132.09	132.09	63981.0
2011-05-25 05:00:00	QQQ	ETF	56.6	56.61	56.6	56.61	25000.0
2011-05-25 06:00:00	QQQ	ETF	56.43	56.55	56.43	56.53	40000.0
2011-05-25 07:00:00	QQQ	ETF	56.52	56.59	56.49	56.59	265795.0
2011-05-25 08:00:00	QQQ	ETF	56.57	56.59	56.41	56.49	592838.0
2011-05-25 09:00:00	QQQ	ETF	56.49	56.74	56.37	56.66	6195700.0
2011-05-25 10:00:00	QQQ	ETF	56.665	56.84	56.59	56.679	7734884.0
2011-05-25 11:00:00	QQQ	ETF	56.679	56.905	56.679	56.8329	3330081.0
2011-05-25 12:00:00	QQQ	ETF	56.84	56.88	56.8	56.85	1844959.0
2011-05-25 13:00:00	QQQ	ETF	56.84	56.85	56.73	56.77	2680266.0
2011-05-25 14:00:00	QQQ	ETF	56.77	56.9	56.75	56.87	2373431.0
2011-05-25 15:00:00	QQQ	ETF	56.87	57.06	56.78	56.79	7391661.0
2011-05-25 16:00:00	QQQ	ETF	56.79	56.83	56.73	56.76	4178629.0
2011-05-25 17:00:00	QQQ	ETF	56.77	56.82	56.75	56.79	13907.0
2011-05-25 18:00:00	QQQ	ETF	56.79	56.81	56.78	56.81	29863.0
2011-05-25 19:00:00	QQQ	ETF	56.79	56.79	56.73	56.73	12650.0
2011-05-25 04:00:00	IWM	ETF	80.71	80.71	80.71	80.71	300.0
2011-05-25 05:00:00	IWM	ETF	80.77	80.77	80.77	80.77	200.0
2011-05-25 06:00:00	IWM	ETF	80.75	80.8	80.75	80.8	200.0
2011-05-25 07:00:00	IWM	ETF	80.8	80.96	80.77	80.94	10333.0
2011-05-25 08:00:00	IWM	ETF	80.94	80.98	80.67	80.81	508052.0
2011-05-25 09:00:00	IWM	ETF	80.81	81.4	80.6	81.19	8298536.0
2011-05-25 10:00:00	IWM	ETF	81.17	81.67	80.865	81.48	11814939.0
2011-05-25 11:00:00	IWM	ETF	81.48	82.08	81.43	81.95	7553770.0
2011-05-25 12:00:00	IWM	ETF	81.95	82.04	81.79	82.01	4076752.0
2011-05-25 13:00:00	IWM	ETF	82.01	82.01	81.7	81.78	3226595.0
2011-05-25 14:00:00	IWM	ETF	81.79	82.13	81.74	82.08	4245855.0
2011-05-25 15:00:00	IWM	ETF	82.07	82.29	81.99	82.02	10548010.0
2011-05-25 16:00:00	IWM	ETF	82.02	82.09	81.0084	81.78	3057654.0
2011-05-25 17:00:00	IWM	ETF	81.85	81.85	81.85	81.85	100.0
2011-05-25 18:00:00	IWM	ETF	81.86	81.9	81.86	81.9	5439.0
2011-05-25 19:00:00	IWM	ETF	81.93	81.94	81.88	81.89	4300.0
2011-05-25 06:00:00	DIA	ETF	122.99	122.99	122.99	122.99	100.0
2011-05-25 07:00:00	DIA	ETF	123.06	123.06	123.01	123.01	650.0
2011-05-25 08:00:00	DIA	ETF	123.13	123.13	122.87	123.0	27000.0

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

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