PREVIEW / etf_1hour / 2012-07-19

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-07-19.parquet
  size:    183 KB
  rows:    5,700

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-07-19 04:00:00	SPY	ETF	137.85	137.85	137.46	137.48	7735.0
2012-07-19 05:00:00	SPY	ETF	137.51	137.72	137.51	137.68	53700.0
2012-07-19 06:00:00	SPY	ETF	137.7	138.1	137.7	137.85	87803.0
2012-07-19 07:00:00	SPY	ETF	137.87	137.98	137.7	137.91	309599.0
2012-07-19 08:00:00	SPY	ETF	137.91	138.15	137.75	137.82	2819212.0
2012-07-19 09:00:00	SPY	ETF	137.82	137.96	137.54	137.92	18663814.0
2012-07-19 10:00:00	SPY	ETF	137.92	137.92	137.21	137.635	24965096.0
2012-07-19 11:00:00	SPY	ETF	137.65	137.88	137.615	137.77	11667865.0
2012-07-19 12:00:00	SPY	ETF	137.77	138.18	137.67	137.7099	13056843.0
2012-07-19 13:00:00	SPY	ETF	137.7	137.95	137.32	137.48	14613217.0
2012-07-19 14:00:00	SPY	ETF	137.47	137.83	137.45	137.73	11653656.0
2012-07-19 15:00:00	SPY	ETF	137.73	137.925	137.55	137.71	23381822.0
2012-07-19 16:00:00	SPY	ETF	137.71	137.84	137.392	137.75	8419763.0
2012-07-19 17:00:00	SPY	ETF	137.74	137.78	137.68	137.72	99474.0
2012-07-19 18:00:00	SPY	ETF	137.73	137.78	137.71	137.72	23654.0
2012-07-19 19:00:00	SPY	ETF	137.71	137.75	137.67	137.68	77115.0
2012-07-19 06:00:00	QQQ	ETF	64.7	64.8	64.7	64.8	4800.0
2012-07-19 07:00:00	QQQ	ETF	64.73	64.79	64.67	64.77	45500.0
2012-07-19 08:00:00	QQQ	ETF	64.78	64.87	64.75	64.8	416330.0
2012-07-19 09:00:00	QQQ	ETF	64.8	65.06	64.77	64.99	8605406.0
2012-07-19 10:00:00	QQQ	ETF	64.99	65.03	64.72	64.96	6703473.0
2012-07-19 11:00:00	QQQ	ETF	64.97	65.14	64.97	65.08	3655206.0
2012-07-19 12:00:00	QQQ	ETF	65.09	65.31	65.08	65.14	5666742.0
2012-07-19 13:00:00	QQQ	ETF	65.13	65.26	64.88	64.98	4492207.0
2012-07-19 14:00:00	QQQ	ETF	64.99	65.19	64.99	65.13	3094089.0
2012-07-19 15:00:00	QQQ	ETF	65.13	65.27	65.08	65.1	7905158.0
2012-07-19 16:00:00	QQQ	ETF	65.1	65.29	64.3962	65.23	4452682.0
2012-07-19 17:00:00	QQQ	ETF	65.23	65.24	65.22	65.22	18700.0
2012-07-19 18:00:00	QQQ	ETF	65.22	65.26	65.21	65.23	17812.0
2012-07-19 19:00:00	QQQ	ETF	65.21	65.21	65.18	65.19	16150.0
2012-07-19 07:00:00	IWM	ETF	80.64	80.7	80.48	80.67	39225.0
2012-07-19 08:00:00	IWM	ETF	80.65	80.78	80.47	80.55	204755.0
2012-07-19 09:00:00	IWM	ETF	80.56	80.74	80.46	80.55	5682608.0
2012-07-19 10:00:00	IWM	ETF	80.54	80.55	79.93	80.22	7385141.0
2012-07-19 11:00:00	IWM	ETF	80.23	80.35	80.09	80.23	2744294.0
2012-07-19 12:00:00	IWM	ETF	80.24	80.56	80.23	80.258	4903394.0
2012-07-19 13:00:00	IWM	ETF	80.25	80.37	79.81	79.96	4492325.0
2012-07-19 14:00:00	IWM	ETF	79.96	80.21	79.93	80.11	4375248.0
2012-07-19 15:00:00	IWM	ETF	80.11	80.18	79.94	79.96	7431379.0
2012-07-19 16:00:00	IWM	ETF	79.95	80.2815	79.78	79.95	6785522.0
2012-07-19 17:00:00	IWM	ETF	79.94	79.94	79.85	79.9	33285.0
2012-07-19 19:00:00	IWM	ETF	79.95	79.95	79.95	79.95	100.0
2012-07-19 06:00:00	DIA	ETF	129.74	129.75	129.74	129.75	200.0
2012-07-19 07:00:00	DIA	ETF	129.8	129.8	129.61	129.61	1000.0
2012-07-19 08:00:00	DIA	ETF	129.44	130.08	129.21	129.6	3115.0
2012-07-19 09:00:00	DIA	ETF	129.5	129.5	129.1	129.44	509666.0
2012-07-19 10:00:00	DIA	ETF	129.32	129.33	128.81	129.1	773408.0
2012-07-19 11:00:00	DIA	ETF	129.11	129.37	129.1	129.18	248614.0
2012-07-19 12:00:00	DIA	ETF	129.21	129.71	129.16	129.19	400824.0
2012-07-19 13:00:00	DIA	ETF	129.19	129.47	128.88	129.01	516607.0

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

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