PREVIEW / etf_1hour / 2014-06-09

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-06-09.parquet
  size:    214 KB
  rows:    6,825

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-06-09 04:00:00	SPY	ETF	195.41	195.41	195.25	195.35	29201.0
2014-06-09 05:00:00	SPY	ETF	195.36	195.38	195.23	195.35	7872.0
2014-06-09 06:00:00	SPY	ETF	195.35	195.36	195.33	195.35	34673.0
2014-06-09 07:00:00	SPY	ETF	195.35	195.38	195.29	195.37	187972.0
2014-06-09 08:00:00	SPY	ETF	195.38	195.53	195.24	195.3	393830.0
2014-06-09 09:00:00	SPY	ETF	195.3	195.72	195.23	195.57	12952446.0
2014-06-09 10:00:00	SPY	ETF	195.57	195.77	195.49	195.715	6558870.0
2014-06-09 11:00:00	SPY	ETF	195.715	196.05	195.65	195.95	5822628.0
2014-06-09 12:00:00	SPY	ETF	195.96	195.97	195.72	195.75	5272752.0
2014-06-09 13:00:00	SPY	ETF	195.75	195.79	195.54	195.585	6096110.0
2014-06-09 14:00:00	SPY	ETF	195.5801	195.6	195.17	195.47	9520457.0
2014-06-09 15:00:00	SPY	ETF	195.47	195.68	195.42	195.58	13407097.0
2014-06-09 16:00:00	SPY	ETF	195.58	195.69	195.4233	195.53	3830211.0
2014-06-09 17:00:00	SPY	ETF	195.52	195.59	195.5	195.5	34347.0
2014-06-09 18:00:00	SPY	ETF	195.5	195.54	195.46	195.47	65060.0
2014-06-09 19:00:00	SPY	ETF	195.48	195.54	195.47	195.54	23185.0
2014-06-09 04:00:00	QQQ	ETF	92.81	92.81	92.76	92.76	4899.0
2014-06-09 05:00:00	QQQ	ETF	92.76	92.85	92.76	92.84	750.0
2014-06-09 06:00:00	QQQ	ETF	92.82	92.84	92.82	92.84	200.0
2014-06-09 07:00:00	QQQ	ETF	92.82	92.82	92.8	92.81	1000.0
2014-06-09 08:00:00	QQQ	ETF	92.81	92.81	92.74	92.77	54376.0
2014-06-09 09:00:00	QQQ	ETF	92.79	92.87	92.59	92.71	3320562.0
2014-06-09 10:00:00	QQQ	ETF	92.71	92.83	92.61	92.79	3042865.0
2014-06-09 11:00:00	QQQ	ETF	92.8	92.98	92.73	92.929	2039069.0
2014-06-09 12:00:00	QQQ	ETF	92.929	92.98	92.91	92.94	1109186.0
2014-06-09 13:00:00	QQQ	ETF	92.94	92.95	92.7	92.73	2069910.0
2014-06-09 14:00:00	QQQ	ETF	92.73	92.74	92.495	92.6865	3177229.0
2014-06-09 15:00:00	QQQ	ETF	92.69	92.82	92.64	92.74	3928315.0
2014-06-09 16:00:00	QQQ	ETF	92.74	92.8205	92.7	92.7	2508346.0
2014-06-09 17:00:00	QQQ	ETF	92.6786	92.78	92.6786	92.75	43200.0
2014-06-09 18:00:00	QQQ	ETF	92.75	92.75	92.7	92.71	8525.0
2014-06-09 19:00:00	QQQ	ETF	92.71	92.73	92.71	92.73	2900.0
2014-06-09 04:00:00	IWM	ETF	115.9	115.9	115.88	115.88	2400.0
2014-06-09 07:00:00	IWM	ETF	116.01	116.01	115.98	115.98	2100.0
2014-06-09 08:00:00	IWM	ETF	115.99	115.99	115.85	115.87	78303.0
2014-06-09 09:00:00	IWM	ETF	115.88	116.64	115.66	116.46	3598140.0
2014-06-09 10:00:00	IWM	ETF	116.46	116.84	116.43	116.76	4800707.0
2014-06-09 11:00:00	IWM	ETF	116.77	117.48	116.6299	117.38	7538698.0
2014-06-09 12:00:00	IWM	ETF	117.38	117.42	116.96	117.07	4340504.0
2014-06-09 13:00:00	IWM	ETF	117.07	117.23	116.78	116.78	4052227.0
2014-06-09 14:00:00	IWM	ETF	116.78	116.86	116.36	116.78	4466369.0
2014-06-09 15:00:00	IWM	ETF	116.79	117.02	116.7	116.88	5605249.0
2014-06-09 16:00:00	IWM	ETF	116.89	117.1754	116.0017	116.83	1489918.0
2014-06-09 17:00:00	IWM	ETF	116.83	116.95	116.83	116.95	44150.0
2014-06-09 18:00:00	IWM	ETF	116.86	116.86	116.86	116.86	1200.0
2014-06-09 19:00:00	IWM	ETF	116.86	116.86	116.86	116.86	5200.0
2014-06-09 08:00:00	DIA	ETF	169.11	169.11	169.07	169.1	1600.0
2014-06-09 09:00:00	DIA	ETF	169.1	169.39	169.05	169.18	486601.0
2014-06-09 10:00:00	DIA	ETF	169.2	169.38	169.15	169.34	519851.0
2014-06-09 11:00:00	DIA	ETF	169.35	169.58	169.31	169.52	202206.0

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

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