PREVIEW / etf_1hour / 2012-07-11

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-07-11.parquet
  size:    177 KB
  rows:    5,482

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-11 04:00:00	SPY	ETF	134.16	134.58	134.16	134.58	24865.0
2012-07-11 05:00:00	SPY	ETF	134.58	134.6	134.46	134.46	6422.0
2012-07-11 06:00:00	SPY	ETF	134.48	134.76	134.35	134.7	88030.0
2012-07-11 07:00:00	SPY	ETF	134.71	134.84	134.44	134.47	186166.0
2012-07-11 08:00:00	SPY	ETF	134.51	134.64	134.27	134.3	1899049.0
2012-07-11 09:00:00	SPY	ETF	134.31	134.52	133.99	134.3301	14820113.0
2012-07-11 10:00:00	SPY	ETF	134.34	134.6	133.93	133.93	18634823.0
2012-07-11 11:00:00	SPY	ETF	133.94	134.32	133.9	134.26	13013675.0
2012-07-11 12:00:00	SPY	ETF	134.26	134.48	134.21	134.43	10607010.0
2012-07-11 13:00:00	SPY	ETF	134.42	134.43	134.09	134.34	8478002.0
2012-07-11 14:00:00	SPY	ETF	134.34	134.48	133.38	133.631	31983184.0
2012-07-11 15:00:00	SPY	ETF	133.63	134.54	133.63	134.18	32398636.0
2012-07-11 16:00:00	SPY	ETF	134.16	134.42	134.0411	134.38	7176028.0
2012-07-11 17:00:00	SPY	ETF	134.38	134.53	134.36	134.45	359916.0
2012-07-11 18:00:00	SPY	ETF	134.47	134.5	134.35	134.39	151765.0
2012-07-11 19:00:00	SPY	ETF	134.41	134.47	134.38	134.42	133276.0
2012-07-11 06:00:00	QQQ	ETF	63.57	63.58	63.56	63.58	400.0
2012-07-11 07:00:00	QQQ	ETF	63.56	63.61	63.46	63.46	49660.0
2012-07-11 08:00:00	QQQ	ETF	63.46	63.46	63.31	63.34	1042641.0
2012-07-11 09:00:00	QQQ	ETF	63.32	63.39	63.06	63.22	7120720.0
2012-07-11 10:00:00	QQQ	ETF	63.21	63.46	63.0	63.01	4274485.0
2012-07-11 11:00:00	QQQ	ETF	63.01	63.16	62.95	63.1	4406085.0
2012-07-11 12:00:00	QQQ	ETF	63.1	63.18	62.99	63.09	2403733.0
2012-07-11 13:00:00	QQQ	ETF	63.09	63.09	62.84	63.0	3297132.0
2012-07-11 14:00:00	QQQ	ETF	63.01	63.07	62.5	62.67	8419311.0
2012-07-11 15:00:00	QQQ	ETF	62.67	63.21	62.67	63.03	8873934.0
2012-07-11 16:00:00	QQQ	ETF	63.03	63.08	62.773	63.07	351796.0
2012-07-11 17:00:00	QQQ	ETF	63.07	63.18	63.07	63.17	158780.0
2012-07-11 18:00:00	QQQ	ETF	63.16	63.16	63.0	63.08	48980.0
2012-07-11 19:00:00	QQQ	ETF	63.05	63.14	63.02	63.12	53498.0
2012-07-11 06:00:00	IWM	ETF	79.58	79.58	79.58	79.58	600.0
2012-07-11 07:00:00	IWM	ETF	79.58	79.84	79.58	79.68	3100.0
2012-07-11 08:00:00	IWM	ETF	79.6	79.63	79.28	79.51	161017.0
2012-07-11 09:00:00	IWM	ETF	79.48	79.59	79.12	79.43	4900409.0
2012-07-11 10:00:00	IWM	ETF	79.425	79.65	79.0	79.03	5614384.0
2012-07-11 11:00:00	IWM	ETF	79.025	79.27	78.96	79.1	5337876.0
2012-07-11 12:00:00	IWM	ETF	79.11	79.24	79.01	79.11	2484805.0
2012-07-11 13:00:00	IWM	ETF	79.11	79.11	78.81	79.0	3058550.0
2012-07-11 14:00:00	IWM	ETF	79.01	79.14	78.55	78.695	7527489.0
2012-07-11 15:00:00	IWM	ETF	78.69	79.19	78.66	79.06	9444094.0
2012-07-11 16:00:00	IWM	ETF	79.06	79.11	78.96	79.03	754792.0
2012-07-11 17:00:00	IWM	ETF	79.03	79.1	79.03	79.06	7471.0
2012-07-11 18:00:00	IWM	ETF	79.06	79.07	79.05	79.05	1700.0
2012-07-11 19:00:00	IWM	ETF	79.05	79.22	79.05	79.22	5328.0
2012-07-11 08:00:00	DIA	ETF	125.71	126.7	125.71	126.57	17674.0
2012-07-11 09:00:00	DIA	ETF	126.6	126.61	125.95	126.19	611498.0
2012-07-11 10:00:00	DIA	ETF	126.19	126.36	125.79	125.82	729935.0
2012-07-11 11:00:00	DIA	ETF	125.83	126.1724	125.8	126.07	712637.0
2012-07-11 12:00:00	DIA	ETF	126.09	126.27	125.98	126.1145	467972.0
2012-07-11 13:00:00	DIA	ETF	126.1101	126.12	125.85	126.0	1085315.0

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

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