PREVIEW / etf_1hour / 2011-02-09

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-02-09.parquet
  size:    178 KB
  rows:    5,492

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-02-09 04:00:00	SPY	ETF	132.29	132.29	132.18	132.18	2100.0
2011-02-09 05:00:00	SPY	ETF	132.23	132.24	132.1	132.1	27255.0
2011-02-09 06:00:00	SPY	ETF	132.1	132.16	132.06	132.06	36900.0
2011-02-09 07:00:00	SPY	ETF	132.14	132.25	132.08	132.14	389145.0
2011-02-09 08:00:00	SPY	ETF	132.2	132.23	131.97	132.17	1442121.0
2011-02-09 09:00:00	SPY	ETF	132.16	132.38	132.1	132.32	15329863.0
2011-02-09 10:00:00	SPY	ETF	132.32	132.63	132.28	132.45	17095559.0
2011-02-09 11:00:00	SPY	ETF	132.46	132.49	131.88	131.9	26450652.0
2011-02-09 12:00:00	SPY	ETF	131.9	132.17	131.85	132.03	16423758.0
2011-02-09 13:00:00	SPY	ETF	132.03	132.31	132.02	132.09	10371622.0
2011-02-09 14:00:00	SPY	ETF	132.1	132.1	131.61	131.749	18215829.0
2011-02-09 15:00:00	SPY	ETF	131.74	132.28	131.73	132.27	26616252.0
2011-02-09 16:00:00	SPY	ETF	132.28	132.6117	132.1071	132.27	12793926.0
2011-02-09 17:00:00	SPY	ETF	132.27	132.27	132.15	132.17	319720.0
2011-02-09 18:00:00	SPY	ETF	132.18	132.32	132.16	132.17	155888.0
2011-02-09 19:00:00	SPY	ETF	132.17	132.32	132.09	132.09	141074.0
2011-02-09 05:00:00	QQQ	ETF	57.89	57.89	57.85	57.85	3200.0
2011-02-09 06:00:00	QQQ	ETF	57.85	57.88	57.85	57.88	995.0
2011-02-09 07:00:00	QQQ	ETF	57.91	57.92	57.82	57.86	317218.0
2011-02-09 08:00:00	QQQ	ETF	57.87	57.91	57.82	57.89	539011.0
2011-02-09 09:00:00	QQQ	ETF	57.88	58.04	57.87	58.0	5413306.0
2011-02-09 10:00:00	QQQ	ETF	58.01	58.12	57.93	58.05	9721385.0
2011-02-09 11:00:00	QQQ	ETF	58.06	58.08	57.84	57.89	9805110.0
2011-02-09 12:00:00	QQQ	ETF	57.895	58.04	57.87	57.96	6089692.0
2011-02-09 13:00:00	QQQ	ETF	57.9525	58.07	57.95	58.0	3395978.0
2011-02-09 14:00:00	QQQ	ETF	58.0	58.0	57.75	57.82	8942075.0
2011-02-09 15:00:00	QQQ	ETF	57.82	57.97	57.81	57.94	5214450.0
2011-02-09 16:00:00	QQQ	ETF	57.94	58.08	57.83	57.88	3382995.0
2011-02-09 17:00:00	QQQ	ETF	57.86	57.87	57.72	57.77	850682.0
2011-02-09 18:00:00	QQQ	ETF	57.77	57.79	57.75	57.79	79127.0
2011-02-09 19:00:00	QQQ	ETF	57.78	57.8	57.76	57.76	39279.0
2011-02-09 05:00:00	IWM	ETF	80.91	80.91	80.9	80.9	5000.0
2011-02-09 07:00:00	IWM	ETF	80.98	81.01	80.88	80.96	190450.0
2011-02-09 08:00:00	IWM	ETF	80.94	81.0	80.78	80.96	584424.0
2011-02-09 09:00:00	IWM	ETF	80.95	81.05	80.6175	80.92	6155450.0
2011-02-09 10:00:00	IWM	ETF	80.92	81.3	80.86	81.19	4797045.0
2011-02-09 11:00:00	IWM	ETF	81.19	81.22	80.52	80.56	6018386.0
2011-02-09 12:00:00	IWM	ETF	80.57	80.8001	80.43	80.6899	3676061.0
2011-02-09 13:00:00	IWM	ETF	80.69	81.05	80.685	80.89	5561690.0
2011-02-09 14:00:00	IWM	ETF	80.88	80.88	80.42	80.54	5992995.0
2011-02-09 15:00:00	IWM	ETF	80.54	80.85	80.53	80.84	7441105.0
2011-02-09 16:00:00	IWM	ETF	80.84	81.03	80.7925	80.9	777470.0
2011-02-09 17:00:00	IWM	ETF	80.86	80.86	80.77	80.78	95495.0
2011-02-09 18:00:00	IWM	ETF	80.76	80.76	80.7	80.72	10100.0
2011-02-09 19:00:00	IWM	ETF	80.72	80.72	80.66	80.67	2100.0
2011-02-09 07:00:00	DIA	ETF	122.0	122.02	121.98	122.02	16500.0
2011-02-09 08:00:00	DIA	ETF	122.0	122.12	121.95	122.1	63800.0
2011-02-09 09:00:00	DIA	ETF	122.08	122.21	122.05	122.21	817431.0
2011-02-09 10:00:00	DIA	ETF	122.21	122.4	122.1	122.28	832098.0
2011-02-09 11:00:00	DIA	ETF	122.28	122.32	121.92	121.92	1274773.0

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

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