PREVIEW / etf_1hour / 2013-08-13

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-08-13.parquet
  size:    204 KB
  rows:    6,365

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
2013-08-13 04:00:00	SPY	ETF	169.54	169.79	169.54	169.78	9300.0
2013-08-13 05:00:00	SPY	ETF	169.8	169.85	169.7	169.71	20906.0
2013-08-13 06:00:00	SPY	ETF	169.74	169.77	169.62	169.62	12200.0
2013-08-13 07:00:00	SPY	ETF	169.66	169.66	169.52	169.58	134308.0
2013-08-13 08:00:00	SPY	ETF	169.55	169.63	169.31	169.45	629275.0
2013-08-13 09:00:00	SPY	ETF	169.45	169.55	168.99	169.09	10277138.0
2013-08-13 10:00:00	SPY	ETF	169.09	169.1	168.41	168.64	17980570.0
2013-08-13 11:00:00	SPY	ETF	168.64	169.09	168.6	168.94	7329563.0
2013-08-13 12:00:00	SPY	ETF	168.94	169.64	168.86	169.53	9169636.0
2013-08-13 13:00:00	SPY	ETF	169.535	169.9	169.49	169.65	8062568.0
2013-08-13 14:00:00	SPY	ETF	169.65	169.8	169.52	169.67	8210888.0
2013-08-13 15:00:00	SPY	ETF	169.665	169.83	169.55	169.61	14248067.0
2013-08-13 16:00:00	SPY	ETF	169.61	169.72	169.2634	169.55	3106950.0
2013-08-13 17:00:00	SPY	ETF	169.55	169.58	169.2233	169.58	58426.0
2013-08-13 18:00:00	SPY	ETF	169.6	169.7	169.55	169.69	43954.0
2013-08-13 19:00:00	SPY	ETF	169.69	169.71	169.57	169.57	73260.0
2013-08-13 04:00:00	QQQ	ETF	76.81	76.94	76.81	76.94	12900.0
2013-08-13 05:00:00	QQQ	ETF	76.96	76.98	76.94	76.94	8299.0
2013-08-13 06:00:00	QQQ	ETF	76.96	76.96	76.88	76.88	10325.0
2013-08-13 07:00:00	QQQ	ETF	76.87	76.88	76.84	76.87	40862.0
2013-08-13 08:00:00	QQQ	ETF	76.85	76.87	76.75	76.78	93566.0
2013-08-13 09:00:00	QQQ	ETF	76.78	76.88	76.55	76.64	2714592.0
2013-08-13 10:00:00	QQQ	ETF	76.64	76.64	76.22	76.439	4005994.0
2013-08-13 11:00:00	QQQ	ETF	76.43	76.7	76.41	76.6095	1919549.0
2013-08-13 12:00:00	QQQ	ETF	76.6	76.94	76.53	76.86	1761303.0
2013-08-13 13:00:00	QQQ	ETF	76.8514	77.08	76.84	76.93	1865926.0
2013-08-13 14:00:00	QQQ	ETF	76.94	77.17	76.92	77.12	2705605.0
2013-08-13 15:00:00	QQQ	ETF	77.13	77.27	77.05	77.08	5130068.0
2013-08-13 16:00:00	QQQ	ETF	77.08	77.1293	76.666	77.04	1257541.0
2013-08-13 17:00:00	QQQ	ETF	77.04	77.08	77.04	77.07	14874.0
2013-08-13 18:00:00	QQQ	ETF	77.08	77.11	77.07	77.11	3300.0
2013-08-13 19:00:00	QQQ	ETF	77.11	77.13	77.06	77.06	9571.0
2013-08-13 04:00:00	IWM	ETF	104.82	105.0	104.82	105.0	411.0
2013-08-13 06:00:00	IWM	ETF	104.89	104.9	104.89	104.9	800.0
2013-08-13 07:00:00	IWM	ETF	104.89	104.9	104.82	104.86	45700.0
2013-08-13 08:00:00	IWM	ETF	104.87	104.89	104.65	104.69	155140.0
2013-08-13 09:00:00	IWM	ETF	104.7	104.79	104.17	104.25	3075251.0
2013-08-13 10:00:00	IWM	ETF	104.25	104.25	103.78	103.94	4022566.0
2013-08-13 11:00:00	IWM	ETF	103.93	104.35	103.9	104.2	2606058.0
2013-08-13 12:00:00	IWM	ETF	104.2	104.58	104.13	104.44	3496022.0
2013-08-13 13:00:00	IWM	ETF	104.43	104.61	104.3716	104.46	1820215.0
2013-08-13 14:00:00	IWM	ETF	104.47	104.55	104.35	104.42	2039450.0
2013-08-13 15:00:00	IWM	ETF	104.42	104.5	104.38	104.45	3349412.0
2013-08-13 16:00:00	IWM	ETF	104.45	104.51	104.39	104.39	1597489.0
2013-08-13 17:00:00	IWM	ETF	104.39	104.42	104.39	104.4	28600.0
2013-08-13 19:00:00	IWM	ETF	104.49	104.49	104.49	104.49	232.0
2013-08-13 06:00:00	DIA	ETF	154.63	154.63	154.63	154.63	100.0
2013-08-13 07:00:00	DIA	ETF	154.53	154.55	154.48	154.53	5500.0
2013-08-13 08:00:00	DIA	ETF	154.6	154.6	154.33	154.37	3404.0
2013-08-13 09:00:00	DIA	ETF	154.45	154.49	153.8299	153.89	1189312.0

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

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