PREVIEW / etf_1hour / 2011-06-23

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-06-23.parquet
  size:    184 KB
  rows:    5,596

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-23 04:00:00	SPY	ETF	128.0	128.17	128.0	128.06	5400.0
2011-06-23 05:00:00	SPY	ETF	128.0	128.02	127.8	127.82	12800.0
2011-06-23 06:00:00	SPY	ETF	127.84	128.05	127.7	127.7	51530.0
2011-06-23 07:00:00	SPY	ETF	127.75	127.89	127.6	127.63	526536.0
2011-06-23 08:00:00	SPY	ETF	127.65	127.67	126.79	126.98	8189705.0
2011-06-23 09:00:00	SPY	ETF	126.98	127.31	126.34	126.68	37585786.0
2011-06-23 10:00:00	SPY	ETF	126.69	127.03	126.19	126.56	53136122.0
2011-06-23 11:00:00	SPY	ETF	126.57	128.6361	126.39	126.87	35026402.0
2011-06-23 12:00:00	SPY	ETF	126.87	127.13	126.62	127.1099	20902814.0
2011-06-23 13:00:00	SPY	ETF	127.11	127.55	127.06	127.29	27376072.0
2011-06-23 14:00:00	SPY	ETF	127.29	127.83	126.63	127.82	36133585.0
2011-06-23 15:00:00	SPY	ETF	127.82	128.37	127.29	128.31	82036603.0
2011-06-23 16:00:00	SPY	ETF	128.31	128.6361	126.5823	128.6361	29876929.0
2011-06-23 17:00:00	SPY	ETF	128.38	128.46	128.29	128.4	278353.0
2011-06-23 18:00:00	SPY	ETF	128.38	128.84	128.27	128.6	570329.0
2011-06-23 19:00:00	SPY	ETF	128.6	128.65	128.51	128.59	66100.0
2011-06-23 05:00:00	QQQ	ETF	54.65	54.65	54.65	54.65	10000.0
2011-06-23 06:00:00	QQQ	ETF	54.6	54.6	54.51	54.56	8677.0
2011-06-23 07:00:00	QQQ	ETF	54.55	54.59	54.47	54.47	95412.0
2011-06-23 08:00:00	QQQ	ETF	54.47	54.48	54.2	54.26	1220432.0
2011-06-23 09:00:00	QQQ	ETF	54.26	54.35	54.06	54.18	8753568.0
2011-06-23 10:00:00	QQQ	ETF	54.18	54.43	54.065	54.22	12576062.0
2011-06-23 11:00:00	QQQ	ETF	54.22	54.52	54.15	54.5	5774390.0
2011-06-23 12:00:00	QQQ	ETF	54.5	54.72	54.47	54.72	7605079.0
2011-06-23 13:00:00	QQQ	ETF	54.72	54.955	54.7	54.78	9126213.0
2011-06-23 14:00:00	QQQ	ETF	54.79	55.01	54.49	55.0	8807238.0
2011-06-23 15:00:00	QQQ	ETF	55.0	55.37	54.82	55.34	18536042.0
2011-06-23 16:00:00	QQQ	ETF	55.35	55.36	54.97	55.09	3885377.0
2011-06-23 17:00:00	QQQ	ETF	55.09	55.21	55.06	55.15	483879.0
2011-06-23 18:00:00	QQQ	ETF	55.15	55.31	55.14	55.24	87568.0
2011-06-23 19:00:00	QQQ	ETF	55.25	55.25	55.19	55.19	28864.0
2011-06-23 04:00:00	IWM	ETF	79.81	79.81	79.81	79.81	200.0
2011-06-23 05:00:00	IWM	ETF	79.64	79.64	79.44	79.54	1100.0
2011-06-23 06:00:00	IWM	ETF	79.46	79.55	79.45	79.45	800.0
2011-06-23 07:00:00	IWM	ETF	79.35	79.54	79.1	79.35	34660.0
2011-06-23 08:00:00	IWM	ETF	79.36	79.66	78.81	78.98	1662408.0
2011-06-23 09:00:00	IWM	ETF	78.97	79.17	78.3	78.65	14922623.0
2011-06-23 10:00:00	IWM	ETF	78.65	79.3	78.55	78.84	15281712.0
2011-06-23 11:00:00	IWM	ETF	78.85	79.14	78.67	79.08	5431472.0
2011-06-23 12:00:00	IWM	ETF	79.08	79.55	78.85	79.55	6758439.0
2011-06-23 13:00:00	IWM	ETF	79.55	79.96	79.51	79.795	9181973.0
2011-06-23 14:00:00	IWM	ETF	79.8	80.17	79.19	80.16	9097054.0
2011-06-23 15:00:00	IWM	ETF	80.16	80.51	79.74	80.32	21321553.0
2011-06-23 16:00:00	IWM	ETF	80.32	80.36	80.09	80.36	1735040.0
2011-06-23 17:00:00	IWM	ETF	80.38	80.4	80.3	80.35	51033.0
2011-06-23 18:00:00	IWM	ETF	80.41	80.55	80.41	80.46	19181.0
2011-06-23 19:00:00	IWM	ETF	80.46	80.46	80.46	80.46	3300.0
2011-06-23 05:00:00	DIA	ETF	120.37	120.37	120.2	120.2	5000.0
2011-06-23 06:00:00	DIA	ETF	120.2	120.31	120.2	120.31	600.0
2011-06-23 07:00:00	DIA	ETF	120.15	120.19	120.09	120.09	5800.0

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

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