PREVIEW / etf_1hour / 2014-05-19

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-05-19.parquet
  size:    214 KB
  rows:    6,800

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
2014-05-19 04:00:00	SPY	ETF	187.99	187.99	187.23	187.33	11890.0
2014-05-19 05:00:00	SPY	ETF	187.35	187.44	187.19	187.31	43304.0
2014-05-19 06:00:00	SPY	ETF	187.31	187.58	187.3	187.45	126309.0
2014-05-19 07:00:00	SPY	ETF	187.46	187.86	187.45	187.83	458173.0
2014-05-19 08:00:00	SPY	ETF	187.83	188.0	187.45	187.58	860300.0
2014-05-19 09:00:00	SPY	ETF	187.58	188.39	187.52	188.22	10364296.0
2014-05-19 10:00:00	SPY	ETF	188.22	188.47	187.98	188.3	10362053.0
2014-05-19 11:00:00	SPY	ETF	188.31	188.77	188.29	188.65	7989612.0
2014-05-19 12:00:00	SPY	ETF	188.65	188.78	188.45	188.53	5106809.0
2014-05-19 13:00:00	SPY	ETF	188.53	188.73	188.47	188.665	3707874.0
2014-05-19 14:00:00	SPY	ETF	188.66	188.86	188.62	188.678	4618394.0
2014-05-19 15:00:00	SPY	ETF	188.678	188.89	188.51	188.74	10495937.0
2014-05-19 16:00:00	SPY	ETF	188.74	188.87	188.0674	188.77	6370352.0
2014-05-19 17:00:00	SPY	ETF	188.75	188.75	188.67	188.7	225162.0
2014-05-19 18:00:00	SPY	ETF	188.7	188.7	188.6	188.6	112347.0
2014-05-19 19:00:00	SPY	ETF	188.63	188.66	188.61	188.61	60455.0
2014-05-19 04:00:00	QQQ	ETF	87.51	87.51	87.2	87.2	2010.0
2014-05-19 05:00:00	QQQ	ETF	87.26	87.26	87.2	87.2	700.0
2014-05-19 06:00:00	QQQ	ETF	87.26	87.33	87.26	87.28	2300.0
2014-05-19 07:00:00	QQQ	ETF	87.35	87.49	87.35	87.48	12700.0
2014-05-19 08:00:00	QQQ	ETF	87.48	87.51	87.33	87.45	151930.0
2014-05-19 09:00:00	QQQ	ETF	87.45	87.9552	87.3	87.8	4878310.0
2014-05-19 10:00:00	QQQ	ETF	87.79	88.13	87.64	88.07	4259138.0
2014-05-19 11:00:00	QQQ	ETF	88.08	88.35	88.07	88.31	4033768.0
2014-05-19 12:00:00	QQQ	ETF	88.31	88.43	88.23	88.2627	2191337.0
2014-05-19 13:00:00	QQQ	ETF	88.27	88.37	88.2	88.34	1483151.0
2014-05-19 14:00:00	QQQ	ETF	88.3301	88.42	88.3	88.33	2011905.0
2014-05-19 15:00:00	QQQ	ETF	88.33	88.46	88.205	88.33	5278590.0
2014-05-19 16:00:00	QQQ	ETF	88.33	88.41	87.6752	88.3	1100668.0
2014-05-19 17:00:00	QQQ	ETF	88.29	88.33	88.29	88.31	2420488.0
2014-05-19 18:00:00	QQQ	ETF	88.31	88.31	88.22	88.24	61950.0
2014-05-19 19:00:00	QQQ	ETF	88.24	88.27	88.24	88.25	15805.0
2014-05-19 04:00:00	IWM	ETF	109.4	109.4	109.4	109.4	100.0
2014-05-19 07:00:00	IWM	ETF	109.2	109.41	109.2	109.4	16100.0
2014-05-19 08:00:00	IWM	ETF	109.4	109.48	109.24	109.27	264447.0
2014-05-19 09:00:00	IWM	ETF	109.28	110.21	108.95	110.1	5689809.0
2014-05-19 10:00:00	IWM	ETF	110.1	110.65	109.86	110.62	6180026.0
2014-05-19 11:00:00	IWM	ETF	110.62	111.04	110.585	110.62	4675972.0
2014-05-19 12:00:00	IWM	ETF	110.62	110.78	110.23	110.275	1936558.0
2014-05-19 13:00:00	IWM	ETF	110.29	110.47	110.22	110.43	1615414.0
2014-05-19 14:00:00	IWM	ETF	110.43	110.54	110.28	110.4401	1878418.0
2014-05-19 15:00:00	IWM	ETF	110.45	110.8	110.23	110.74	4811815.0
2014-05-19 16:00:00	IWM	ETF	110.75	110.87	110.72	110.85	2312422.0
2014-05-19 17:00:00	IWM	ETF	110.82	110.84	110.8	110.82	48650.0
2014-05-19 18:00:00	IWM	ETF	110.75	110.75	110.75	110.75	400.0
2014-05-19 19:00:00	IWM	ETF	110.75	110.79	110.75	110.75	1761.0
2014-05-19 06:00:00	DIA	ETF	164.07	164.07	164.07	164.07	100.0
2014-05-19 07:00:00	DIA	ETF	164.27	164.53	164.27	164.38	1100.0
2014-05-19 08:00:00	DIA	ETF	164.3	164.4	164.08	164.08	11124.0
2014-05-19 09:00:00	DIA	ETF	164.11	164.6	164.03	164.41	463713.0

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

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