PREVIEW / etf_1hour / 2011-06-24

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-06-24.parquet
  size:    176 KB
  rows:    5,369

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-06-24 04:00:00	SPY	ETF	128.55	129.01	128.55	128.95	5270.0
2011-06-24 05:00:00	SPY	ETF	128.95	129.01	128.77	128.77	4590.0
2011-06-24 06:00:00	SPY	ETF	128.72	128.72	127.95	128.16	208370.0
2011-06-24 07:00:00	SPY	ETF	128.19	128.44	128.09	128.11	677845.0
2011-06-24 08:00:00	SPY	ETF	128.1	128.64	127.89	128.5	3403656.0
2011-06-24 09:00:00	SPY	ETF	128.5	128.6	127.69	127.88	22179210.0
2011-06-24 10:00:00	SPY	ETF	127.87	127.97	126.94	127.17	38140629.0
2011-06-24 11:00:00	SPY	ETF	127.17	127.48	126.92	127.3	27684303.0
2011-06-24 12:00:00	SPY	ETF	127.295	127.44	126.83	126.99	16277924.0
2011-06-24 13:00:00	SPY	ETF	126.99	128.2717	126.76	127.21	20604564.0
2011-06-24 14:00:00	SPY	ETF	127.21	128.2716	126.89	126.96	20426379.0
2011-06-24 15:00:00	SPY	ETF	126.97	127.03	126.62	126.8	51973300.0
2011-06-24 16:00:00	SPY	ETF	126.81	128.2716	126.62	126.67	21255712.0
2011-06-24 17:00:00	SPY	ETF	126.67	128.2716	126.65	126.77	721665.0
2011-06-24 18:00:00	SPY	ETF	126.74	126.81	126.7	126.72	294993.0
2011-06-24 19:00:00	SPY	ETF	126.77	126.78	126.7	126.71	23520.0
2011-06-24 04:00:00	QQQ	ETF	55.25	55.47	55.25	55.39	12600.0
2011-06-24 05:00:00	QQQ	ETF	55.44	55.44	55.44	55.44	400.0
2011-06-24 06:00:00	QQQ	ETF	55.17	55.27	55.13	55.14	1900.0
2011-06-24 07:00:00	QQQ	ETF	55.2	55.2	55.09	55.1	224858.0
2011-06-24 08:00:00	QQQ	ETF	55.07	55.26	55.04	55.22	1407046.0
2011-06-24 09:00:00	QQQ	ETF	55.22	55.25	54.83	54.96	6131722.0
2011-06-24 10:00:00	QQQ	ETF	54.96	55.01	54.58	54.69	11204348.0
2011-06-24 11:00:00	QQQ	ETF	54.69	54.8	54.57	54.68	6053457.0
2011-06-24 12:00:00	QQQ	ETF	54.68	54.75	54.44	54.5	4638991.0
2011-06-24 13:00:00	QQQ	ETF	54.5	54.64	54.4	54.5808	4438654.0
2011-06-24 14:00:00	QQQ	ETF	54.585	54.59	54.43	54.45	3527163.0
2011-06-24 15:00:00	QQQ	ETF	54.46	54.47	54.27	54.38	9318416.0
2011-06-24 16:00:00	QQQ	ETF	54.37	54.39	54.22	54.22	2641623.0
2011-06-24 17:00:00	QQQ	ETF	54.22	54.419	54.21	54.419	35122.0
2011-06-24 18:00:00	QQQ	ETF	54.38	54.38	54.25	54.29	50753.0
2011-06-24 19:00:00	QQQ	ETF	54.26	54.35	54.25	54.27	11899.0
2011-06-24 04:00:00	IWM	ETF	80.43	80.87	80.43	80.83	1400.0
2011-06-24 05:00:00	IWM	ETF	80.85	80.85	80.8	80.8	400.0
2011-06-24 06:00:00	IWM	ETF	80.34	80.5	80.21	80.21	6200.0
2011-06-24 07:00:00	IWM	ETF	80.3	80.82	80.3	80.34	572851.0
2011-06-24 08:00:00	IWM	ETF	80.39	80.81	80.15	80.77	2203975.0
2011-06-24 09:00:00	IWM	ETF	80.78	80.86	80.08	80.38	9541507.0
2011-06-24 10:00:00	IWM	ETF	80.38	80.46	79.69	79.94	9042484.0
2011-06-24 11:00:00	IWM	ETF	79.93	80.26	79.73	80.0	7801540.0
2011-06-24 12:00:00	IWM	ETF	80.0	80.12	79.72	79.86	5096459.0
2011-06-24 13:00:00	IWM	ETF	79.86	80.02	79.69	79.87	4692371.0
2011-06-24 14:00:00	IWM	ETF	79.87	79.91	79.47	79.63	6166846.0
2011-06-24 15:00:00	IWM	ETF	79.64	79.94	79.49	79.92	15337843.0
2011-06-24 16:00:00	IWM	ETF	79.92	80.0	79.6	79.8	7463092.0
2011-06-24 17:00:00	IWM	ETF	79.8	79.94	79.8	79.85	20720.0
2011-06-24 18:00:00	IWM	ETF	79.83	79.83	79.77	79.77	800.0
2011-06-24 19:00:00	IWM	ETF	79.75	79.78	79.75	79.78	1600.0
2011-06-24 04:00:00	DIA	ETF	120.55	120.82	120.55	120.82	400.0
2011-06-24 05:00:00	DIA	ETF	120.9	120.95	120.73	120.75	5400.0

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

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