PREVIEW / etf_1hour / 2011-02-07

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-02-07.parquet
  size:    177 KB
  rows:    5,419

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-07 04:00:00	SPY	ETF	131.64	131.76	131.6	131.76	1175.0
2011-02-07 05:00:00	SPY	ETF	131.71	131.71	131.71	131.71	4000.0
2011-02-07 06:00:00	SPY	ETF	131.61	131.61	131.51	131.55	11399.0
2011-02-07 07:00:00	SPY	ETF	131.53	131.57	131.42	131.46	1818484.0
2011-02-07 08:00:00	SPY	ETF	131.47	131.79	131.43	131.48	2900386.0
2011-02-07 09:00:00	SPY	ETF	131.48	131.86	131.19	131.725	15184767.0
2011-02-07 10:00:00	SPY	ETF	131.73	132.31	131.72	132.235	18388575.0
2011-02-07 11:00:00	SPY	ETF	132.23	132.4	132.15	132.23	13971909.0
2011-02-07 12:00:00	SPY	ETF	132.235	132.28	132.1	132.16	9050435.0
2011-02-07 13:00:00	SPY	ETF	132.15	132.28	132.14	132.24	6566312.0
2011-02-07 14:00:00	SPY	ETF	132.24	132.26	131.86	131.97	10440992.0
2011-02-07 15:00:00	SPY	ETF	131.97	132.11	131.75	131.98	23261463.0
2011-02-07 16:00:00	SPY	ETF	131.98	132.33	131.1857	131.86	10585704.0
2011-02-07 17:00:00	SPY	ETF	131.86	131.96	131.84	131.91	100029.0
2011-02-07 18:00:00	SPY	ETF	131.91	132.0	131.9	131.98	44652.0
2011-02-07 19:00:00	SPY	ETF	131.99	132.0	131.88	131.95	68565.0
2011-02-07 04:00:00	QQQ	ETF	57.51	57.62	57.51	57.62	800.0
2011-02-07 05:00:00	QQQ	ETF	57.6	57.6	57.6	57.6	600.0
2011-02-07 07:00:00	QQQ	ETF	57.56	57.56	57.48	57.48	27470.0
2011-02-07 08:00:00	QQQ	ETF	57.51	57.55	57.44	57.48	3266925.0
2011-02-07 09:00:00	QQQ	ETF	57.48	57.62	57.4	57.54	7501345.0
2011-02-07 10:00:00	QQQ	ETF	57.55	57.79	57.55	57.77	5662015.0
2011-02-07 11:00:00	QQQ	ETF	57.77	57.94	57.7699	57.85	4852769.0
2011-02-07 12:00:00	QQQ	ETF	57.85	57.97	57.8211	57.88	2547563.0
2011-02-07 13:00:00	QQQ	ETF	57.89	57.95	57.82	57.86	2145065.0
2011-02-07 14:00:00	QQQ	ETF	57.87	57.88	57.57	57.64	6774032.0
2011-02-07 15:00:00	QQQ	ETF	57.64	57.74	57.55	57.65	5900737.0
2011-02-07 16:00:00	QQQ	ETF	57.65	57.71	57.52	57.55	2695102.0
2011-02-07 17:00:00	QQQ	ETF	57.54	57.76	57.54	57.67	13080.0
2011-02-07 18:00:00	QQQ	ETF	57.64	57.67	57.56	57.6	13109.0
2011-02-07 19:00:00	QQQ	ETF	57.61	57.61	57.57	57.57	16813.0
2011-02-07 04:00:00	IWM	ETF	80.17	80.26	80.17	80.26	3449.0
2011-02-07 05:00:00	IWM	ETF	80.31	80.31	80.27	80.27	7500.0
2011-02-07 07:00:00	IWM	ETF	80.15	80.16	80.0	80.03	150141.0
2011-02-07 08:00:00	IWM	ETF	80.01	80.33	79.93	79.97	475141.0
2011-02-07 09:00:00	IWM	ETF	79.97	80.8199	79.89	80.66	6616203.0
2011-02-07 10:00:00	IWM	ETF	80.66	81.18	80.63	81.14	8024427.0
2011-02-07 11:00:00	IWM	ETF	81.13	81.25	80.9	81.02	3850722.0
2011-02-07 12:00:00	IWM	ETF	81.02	81.03	80.85	80.9	2530593.0
2011-02-07 13:00:00	IWM	ETF	80.91	81.02	80.73	80.82	2636657.0
2011-02-07 14:00:00	IWM	ETF	80.82	80.91	80.48	80.57	3369357.0
2011-02-07 15:00:00	IWM	ETF	80.57	80.9833	80.5075	80.66	7945109.0
2011-02-07 16:00:00	IWM	ETF	80.66	80.835	79.8919	79.8919	1762930.0
2011-02-07 17:00:00	IWM	ETF	80.57	80.57	80.54	80.57	3200.0
2011-02-07 18:00:00	IWM	ETF	80.57	80.57	80.57	80.57	500.0
2011-02-07 04:00:00	DIA	ETF	121.0	121.11	121.0	121.11	200.0
2011-02-07 05:00:00	DIA	ETF	121.05	121.05	121.05	121.05	100.0
2011-02-07 06:00:00	DIA	ETF	120.99	120.99	120.99	120.99	100.0
2011-02-07 07:00:00	DIA	ETF	120.97	120.97	120.92	120.92	200.0
2011-02-07 08:00:00	DIA	ETF	120.9	120.97	120.86	120.86	9584.0

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

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