PREVIEW / etf_1hour / 2012-07-02

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-07-02.parquet
  size:    185 KB
  rows:    5,687

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-02 04:00:00	SPY	ETF	136.01	136.71	136.01	136.63	7980.0
2012-07-02 05:00:00	SPY	ETF	136.65	136.66	136.31	136.33	21423.0
2012-07-02 06:00:00	SPY	ETF	136.3	136.4	136.26	136.38	66486.0
2012-07-02 07:00:00	SPY	ETF	136.36	136.63	136.35	136.48	547128.0
2012-07-02 08:00:00	SPY	ETF	136.48	136.68	136.1	136.28	2809596.0
2012-07-02 09:00:00	SPY	ETF	136.29	136.65	136.27	136.36	15438214.0
2012-07-02 10:00:00	SPY	ETF	136.36	136.37	135.55	135.775	32983674.0
2012-07-02 11:00:00	SPY	ETF	135.78	135.92	135.52	135.75	14976459.0
2012-07-02 12:00:00	SPY	ETF	135.75	136.2	135.7	136.05	10581345.0
2012-07-02 13:00:00	SPY	ETF	136.05	136.17	135.97	136.0263	7051638.0
2012-07-02 14:00:00	SPY	ETF	136.025	136.4	135.89	136.17	9839639.0
2012-07-02 15:00:00	SPY	ETF	136.17	136.54	135.99	136.44	20969720.0
2012-07-02 16:00:00	SPY	ETF	136.45	136.54	136.0885	136.27	8521573.0
2012-07-02 17:00:00	SPY	ETF	136.26	136.45	136.24	136.42	140350.0
2012-07-02 18:00:00	SPY	ETF	136.43	136.59	136.42	136.42	308227.0
2012-07-02 19:00:00	SPY	ETF	136.42	136.45	136.29	136.31	166999.0
2012-07-02 05:00:00	QQQ	ETF	64.24	64.24	64.24	64.24	500.0
2012-07-02 06:00:00	QQQ	ETF	64.06	64.1	64.06	64.1	300.0
2012-07-02 07:00:00	QQQ	ETF	64.15	64.25	64.09	64.18	777479.0
2012-07-02 08:00:00	QQQ	ETF	64.18	64.18	64.04	64.11	1314030.0
2012-07-02 09:00:00	QQQ	ETF	64.14	64.38	64.04	64.229	4144859.0
2012-07-02 10:00:00	QQQ	ETF	64.22	64.3	63.87	64.09	8306677.0
2012-07-02 11:00:00	QQQ	ETF	64.08	64.15	63.94	64.04	3060503.0
2012-07-02 12:00:00	QQQ	ETF	64.04	64.26	63.98	64.19	2979844.0
2012-07-02 13:00:00	QQQ	ETF	64.19	64.22	64.12	64.1355	1728181.0
2012-07-02 14:00:00	QQQ	ETF	64.1399	64.26	64.08	64.2	2405645.0
2012-07-02 15:00:00	QQQ	ETF	64.21	64.38	64.1	64.35	4699596.0
2012-07-02 16:00:00	QQQ	ETF	64.35	64.38	64.1627	64.23	707828.0
2012-07-02 17:00:00	QQQ	ETF	64.24	64.3	64.22	64.3	10764.0
2012-07-02 18:00:00	QQQ	ETF	64.3	64.32	64.3	64.32	800.0
2012-07-02 19:00:00	QQQ	ETF	64.28	64.28	64.24	64.25	7105.0
2012-07-02 04:00:00	IWM	ETF	79.85	80.0	79.85	80.0	1384.0
2012-07-02 06:00:00	IWM	ETF	79.8	79.8	79.8	79.8	50100.0
2012-07-02 07:00:00	IWM	ETF	79.96	79.96	79.85	79.89	103900.0
2012-07-02 08:00:00	IWM	ETF	79.89	79.89	79.56	79.83	242849.0
2012-07-02 09:00:00	IWM	ETF	79.84	79.95	79.59	79.66	4140995.0
2012-07-02 10:00:00	IWM	ETF	79.66	79.66	79.28	79.53	7375502.0
2012-07-02 11:00:00	IWM	ETF	79.53	79.6082	79.335	79.35	3151672.0
2012-07-02 12:00:00	IWM	ETF	79.35	79.83	79.315	79.73	3691145.0
2012-07-02 13:00:00	IWM	ETF	79.73	79.75	79.5	79.53	1740515.0
2012-07-02 14:00:00	IWM	ETF	79.53	79.82	79.38	79.75	5084519.0
2012-07-02 15:00:00	IWM	ETF	79.752	80.51	79.68	80.43	9649255.0
2012-07-02 16:00:00	IWM	ETF	80.43	80.59	79.581	79.581	3454735.0
2012-07-02 17:00:00	IWM	ETF	80.44	80.47	80.42	80.47	3528.0
2012-07-02 18:00:00	IWM	ETF	80.52	80.54	80.51	80.51	5391.0
2012-07-02 19:00:00	IWM	ETF	80.51	80.51	80.47	80.47	587.0
2012-07-02 07:00:00	DIA	ETF	128.75	129.2	128.69	128.75	4813.0
2012-07-02 08:00:00	DIA	ETF	128.5	128.52	128.33	128.51	11542.0
2012-07-02 09:00:00	DIA	ETF	128.46	128.77	128.45	128.58	520639.0
2012-07-02 10:00:00	DIA	ETF	128.41	128.54	127.71	127.88	1173458.0

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

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