PREVIEW / etf_1hour / 2014-03-31

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-03-31.parquet
  size:    220 KB
  rows:    6,988

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-03-31 04:00:00	SPY	ETF	186.14	186.28	186.14	186.22	43116.0
2014-03-31 05:00:00	SPY	ETF	186.21	186.26	186.11	186.21	15061.0
2014-03-31 06:00:00	SPY	ETF	186.24	186.24	186.02	186.12	189247.0
2014-03-31 07:00:00	SPY	ETF	186.13	186.34	186.08	186.34	343872.0
2014-03-31 08:00:00	SPY	ETF	186.31	186.69	186.13	186.6	809924.0
2014-03-31 09:00:00	SPY	ETF	186.61	187.09	186.53	187.01	17074917.0
2014-03-31 10:00:00	SPY	ETF	187.02	187.18	186.77	186.93	13741468.0
2014-03-31 11:00:00	SPY	ETF	186.93	186.94	186.47	186.79	8580322.0
2014-03-31 12:00:00	SPY	ETF	186.8	187.3	186.79	187.169	9624719.0
2014-03-31 13:00:00	SPY	ETF	187.17	187.23	186.69	186.78	8407893.0
2014-03-31 14:00:00	SPY	ETF	186.7737	187.15	186.76	187.08	6650655.0
2014-03-31 15:00:00	SPY	ETF	187.08	187.24	186.89	187.02	21679391.0
2014-03-31 16:00:00	SPY	ETF	187.0	187.04	185.5216	186.9	10810052.0
2014-03-31 17:00:00	SPY	ETF	186.89	187.01	186.88	186.96	244160.0
2014-03-31 18:00:00	SPY	ETF	186.96	187.01	186.92	186.93	81237.0
2014-03-31 19:00:00	SPY	ETF	186.95	186.95	186.86	186.92	30750.0
2014-03-31 04:00:00	QQQ	ETF	87.52	87.52	87.52	87.52	500.0
2014-03-31 05:00:00	QQQ	ETF	87.47	87.47	87.41	87.41	2400.0
2014-03-31 06:00:00	QQQ	ETF	87.46	87.46	87.37	87.41	17870.0
2014-03-31 07:00:00	QQQ	ETF	87.42	87.54	87.41	87.54	133969.0
2014-03-31 08:00:00	QQQ	ETF	87.44	87.78	87.44	87.76	320595.0
2014-03-31 09:00:00	QQQ	ETF	87.75	88.09	87.63	88.08	7021357.0
2014-03-31 10:00:00	QQQ	ETF	88.07	88.26	87.92	88.01	6046483.0
2014-03-31 11:00:00	QQQ	ETF	88.005	88.02	87.73	87.96	3144402.0
2014-03-31 12:00:00	QQQ	ETF	87.95	88.115	87.9299	88.02	2466759.0
2014-03-31 13:00:00	QQQ	ETF	88.02	88.05	87.66	87.7	1854781.0
2014-03-31 14:00:00	QQQ	ETF	87.69	87.96	87.67	87.88	1921674.0
2014-03-31 15:00:00	QQQ	ETF	87.87	87.939	87.62	87.68	5651750.0
2014-03-31 16:00:00	QQQ	ETF	87.67	87.9525	87.0988	87.59	2611377.0
2014-03-31 17:00:00	QQQ	ETF	87.6	87.67	87.57	87.6	405454.0
2014-03-31 18:00:00	QQQ	ETF	87.64	87.64	87.6	87.6	15366.0
2014-03-31 19:00:00	QQQ	ETF	87.6	87.61	87.56	87.56	33096.0
2014-03-31 05:00:00	IWM	ETF	115.0	115.0	115.0	115.0	300.0
2014-03-31 06:00:00	IWM	ETF	114.6	114.75	114.6	114.75	5400.0
2014-03-31 07:00:00	IWM	ETF	114.84	114.95	114.77	114.95	57050.0
2014-03-31 08:00:00	IWM	ETF	114.95	115.32	114.92	115.2	203774.0
2014-03-31 09:00:00	IWM	ETF	115.19	115.43	114.6299	115.3099	5286618.0
2014-03-31 10:00:00	IWM	ETF	115.3	115.98	115.25	115.878	6505653.0
2014-03-31 11:00:00	IWM	ETF	115.87	116.0	115.4	115.91	4276081.0
2014-03-31 12:00:00	IWM	ETF	115.92	116.63	115.915	116.56	5316909.0
2014-03-31 13:00:00	IWM	ETF	116.56	116.61	116.2	116.33	3180749.0
2014-03-31 14:00:00	IWM	ETF	116.31	116.53	116.23	116.44	3479344.0
2014-03-31 15:00:00	IWM	ETF	116.44	116.68	116.3	116.34	9030841.0
2014-03-31 16:00:00	IWM	ETF	116.34	116.4251	114.3186	116.25	2904463.0
2014-03-31 17:00:00	IWM	ETF	116.23	116.34	116.19	116.24	57899.0
2014-03-31 18:00:00	IWM	ETF	116.22	116.35	116.22	116.35	3800.0
2014-03-31 19:00:00	IWM	ETF	116.24	116.3	116.2	116.25	9825.0
2014-03-31 04:00:00	DIA	ETF	163.0	163.0	163.0	163.0	100.0
2014-03-31 08:00:00	DIA	ETF	163.5	163.76	163.5	163.69	4319.0
2014-03-31 09:00:00	DIA	ETF	163.7	164.41	163.63	164.34	1564331.0

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

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