PREVIEW / etf_1hour / 2012-02-29

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-02-29.parquet
  size:    195 KB
  rows:    6,042

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
2012-02-29 04:00:00	SPY	ETF	137.51	137.82	137.51	137.82	9760.0
2012-02-29 05:00:00	SPY	ETF	137.84	138.11	137.59	137.7	128960.0
2012-02-29 06:00:00	SPY	ETF	137.8	137.8	137.59	137.77	69168.0
2012-02-29 07:00:00	SPY	ETF	137.78	137.93	137.72	137.75	519026.0
2012-02-29 08:00:00	SPY	ETF	137.73	138.06	137.64	137.7	1245602.0
2012-02-29 09:00:00	SPY	ETF	137.7	138.12	137.65	138.09	15731885.0
2012-02-29 10:00:00	SPY	ETF	138.09	138.19	136.88	137.25	40393082.0
2012-02-29 11:00:00	SPY	ETF	137.24	137.36	136.79	137.28	27612248.0
2012-02-29 12:00:00	SPY	ETF	137.28	137.5706	137.16	137.385	17498212.0
2012-02-29 13:00:00	SPY	ETF	137.39	137.61	137.24	137.545	12174289.0
2012-02-29 14:00:00	SPY	ETF	137.54	137.685	137.27	137.2815	13517784.0
2012-02-29 15:00:00	SPY	ETF	137.29	137.5706	136.72	136.88	36611634.0
2012-02-29 16:00:00	SPY	ETF	136.88	137.3922	136.17	136.51	16804363.0
2012-02-29 17:00:00	SPY	ETF	136.53	136.97	136.38	136.49	1754786.0
2012-02-29 18:00:00	SPY	ETF	136.49	136.69	136.49	136.68	174256.0
2012-02-29 19:00:00	SPY	ETF	136.68	136.85	136.4	136.85	161420.0
2012-02-29 05:00:00	QQQ	ETF	64.76	64.76	64.76	64.76	500.0
2012-02-29 06:00:00	QQQ	ETF	64.68	64.7	64.68	64.7	2265.0
2012-02-29 07:00:00	QQQ	ETF	64.76	64.78	64.7	64.71	76150.0
2012-02-29 08:00:00	QQQ	ETF	64.7	64.82	64.66	64.7	368822.0
2012-02-29 09:00:00	QQQ	ETF	64.69	64.95	64.69	64.93	7109604.0
2012-02-29 10:00:00	QQQ	ETF	64.93	64.96	64.44	64.62	12630282.0
2012-02-29 11:00:00	QQQ	ETF	64.62	64.69	64.4	64.62	8229457.0
2012-02-29 12:00:00	QQQ	ETF	64.62	64.72	64.53	64.625	5637884.0
2012-02-29 13:00:00	QQQ	ETF	64.63	64.69	64.52	64.67	4012486.0
2012-02-29 14:00:00	QQQ	ETF	64.67	64.75	64.5	64.54	3417580.0
2012-02-29 15:00:00	QQQ	ETF	64.53	64.58	64.2	64.4	13151528.0
2012-02-29 16:00:00	QQQ	ETF	64.41	64.46	64.3	64.35	1641088.0
2012-02-29 17:00:00	QQQ	ETF	64.35	64.38	64.26	64.27	171401.0
2012-02-29 18:00:00	QQQ	ETF	64.31	64.42	64.31	64.41	44521.0
2012-02-29 19:00:00	QQQ	ETF	64.39	64.46	64.39	64.46	68065.0
2012-02-29 04:00:00	IWM	ETF	82.6	82.65	82.6	82.65	1032.0
2012-02-29 05:00:00	IWM	ETF	82.65	82.75	82.65	82.75	476.0
2012-02-29 06:00:00	IWM	ETF	82.4	82.5	82.4	82.5	51000.0
2012-02-29 07:00:00	IWM	ETF	82.5	82.56	82.45	82.56	90400.0
2012-02-29 08:00:00	IWM	ETF	82.46	82.96	82.1	82.48	113003.0
2012-02-29 09:00:00	IWM	ETF	82.44	82.96	82.42	82.83	5103855.0
2012-02-29 10:00:00	IWM	ETF	82.82	82.92	81.26	81.71	13865878.0
2012-02-29 11:00:00	IWM	ETF	81.72	82.08	81.29	81.92	8913211.0
2012-02-29 12:00:00	IWM	ETF	81.92	82.11	81.6197	81.9	5223678.0
2012-02-29 13:00:00	IWM	ETF	81.905	82.058	81.73	81.95	2725565.0
2012-02-29 14:00:00	IWM	ETF	81.94	82.08	81.47	81.61	4897724.0
2012-02-29 15:00:00	IWM	ETF	81.6	81.6	80.99	81.01	14013320.0
2012-02-29 16:00:00	IWM	ETF	81.02	81.296	80.59	80.71	4681352.0
2012-02-29 17:00:00	IWM	ETF	80.72	80.99	80.61	80.71	1064390.0
2012-02-29 18:00:00	IWM	ETF	80.69	80.76	80.69	80.73	7400.0
2012-02-29 19:00:00	IWM	ETF	80.84	80.86	80.83	80.86	1805.0
2012-02-29 05:00:00	DIA	ETF	130.11	130.17	130.11	130.17	500.0
2012-02-29 06:00:00	DIA	ETF	130.06	130.06	130.06	130.06	100.0
2012-02-29 07:00:00	DIA	ETF	130.11	130.13	129.99	129.99	6700.0

> showing 50 of 6,042 rows — these rows as CSV

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