PREVIEW / etf_1hour / 2014-07-31

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-07-31.parquet
  size:    236 KB
  rows:    7,481

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-07-31 04:00:00	SPY	ETF	196.61	196.61	195.35	195.5	52502.0
2014-07-31 05:00:00	SPY	ETF	195.5	195.8	195.5	195.71	43903.0
2014-07-31 06:00:00	SPY	ETF	195.68	195.98	195.62	195.92	228270.0
2014-07-31 07:00:00	SPY	ETF	195.96	196.04	195.61	195.94	580797.0
2014-07-31 08:00:00	SPY	ETF	195.76	196.966	195.36	195.54	2497351.0
2014-07-31 09:00:00	SPY	ETF	195.55	195.92	195.22	195.31	19589872.0
2014-07-31 10:00:00	SPY	ETF	195.31	195.51	194.195	194.24	24932033.0
2014-07-31 11:00:00	SPY	ETF	194.23	194.6	193.91	193.98	21377053.0
2014-07-31 12:00:00	SPY	ETF	193.98	194.28	193.68	194.1999	17002304.0
2014-07-31 13:00:00	SPY	ETF	194.19	194.4	193.81	194.23	13540295.0
2014-07-31 14:00:00	SPY	ETF	194.23	194.43	193.49	193.505	14078094.0
2014-07-31 15:00:00	SPY	ETF	193.5	194.7	193.04	193.05	43693947.0
2014-07-31 16:00:00	SPY	ETF	193.05	196.9727	192.9	192.96	20550741.0
2014-07-31 17:00:00	SPY	ETF	193.01	193.16	192.93	193.16	1000219.0
2014-07-31 18:00:00	SPY	ETF	193.16	193.34	193.16	193.28	226940.0
2014-07-31 19:00:00	SPY	ETF	193.28	193.41	193.23	193.37	163396.0
2014-07-31 04:00:00	QQQ	ETF	96.7	96.7	96.11	96.19	57010.0
2014-07-31 05:00:00	QQQ	ETF	96.24	96.34	96.16	96.34	2300.0
2014-07-31 06:00:00	QQQ	ETF	96.3	96.41	96.29	96.41	7850.0
2014-07-31 07:00:00	QQQ	ETF	96.45	96.45	96.2	96.37	88860.0
2014-07-31 08:00:00	QQQ	ETF	96.38	96.49	96.12	96.18	473261.0
2014-07-31 09:00:00	QQQ	ETF	96.16	96.34	95.94	95.95	6592871.0
2014-07-31 10:00:00	QQQ	ETF	95.95	96.09	95.39	95.41	7938502.0
2014-07-31 11:00:00	QQQ	ETF	95.4	95.5786	95.13	95.19	6049526.0
2014-07-31 12:00:00	QQQ	ETF	95.2	95.42	95.04	95.415	4530768.0
2014-07-31 13:00:00	QQQ	ETF	95.41	95.56	95.2328	95.51	3517109.0
2014-07-31 14:00:00	QQQ	ETF	95.52	95.551	95.08	95.09	3764207.0
2014-07-31 15:00:00	QQQ	ETF	95.08	95.273	94.88	95.0299	10816726.0
2014-07-31 16:00:00	QQQ	ETF	95.01	95.758	94.95	95.03	1832658.0
2014-07-31 17:00:00	QQQ	ETF	95.02	95.14	95.01	95.14	84269.0
2014-07-31 18:00:00	QQQ	ETF	95.14	95.2	95.14	95.17	18742.0
2014-07-31 19:00:00	QQQ	ETF	95.18	95.24	95.17	95.24	27143.0
2014-07-31 04:00:00	IWM	ETF	113.06	113.06	112.49	112.49	500.0
2014-07-31 05:00:00	IWM	ETF	112.57	112.7	112.55	112.58	800.0
2014-07-31 06:00:00	IWM	ETF	112.55	113.01	112.5	113.01	13300.0
2014-07-31 07:00:00	IWM	ETF	112.98	113.0	112.6	112.96	74374.0
2014-07-31 08:00:00	IWM	ETF	112.93	113.12	112.58	112.66	510613.0
2014-07-31 09:00:00	IWM	ETF	112.64	112.99	112.31	112.57	5021218.0
2014-07-31 10:00:00	IWM	ETF	112.56	112.72	111.54	111.58	9280406.0
2014-07-31 11:00:00	IWM	ETF	111.58	111.83	111.28	111.31	6486626.0
2014-07-31 12:00:00	IWM	ETF	111.32	111.73	111.16	111.69	4463953.0
2014-07-31 13:00:00	IWM	ETF	111.69	111.94	111.51	111.87	3680963.0
2014-07-31 14:00:00	IWM	ETF	111.88	111.94	111.46	111.48	3785918.0
2014-07-31 15:00:00	IWM	ETF	111.49	111.65	111.11	111.11	12649496.0
2014-07-31 16:00:00	IWM	ETF	111.11	111.4	111.0	111.1	2070524.0
2014-07-31 17:00:00	IWM	ETF	111.06	111.25	110.97	111.24	208391.0
2014-07-31 18:00:00	IWM	ETF	111.22	111.29	111.19	111.25	850.0
2014-07-31 19:00:00	IWM	ETF	111.2	111.55	111.11	111.55	3003.0
2014-07-31 04:00:00	DIA	ETF	167.73	167.75	167.33	167.33	1100.0
2014-07-31 06:00:00	DIA	ETF	167.61	167.66	167.61	167.66	200.0

> showing 50 of 7,481 rows — these rows as CSV

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