PREVIEW / etf_1hour / 2016-12-15

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-12-15.parquet
  size:    281 KB
  rows:    9,121

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
2016-12-15 04:00:00	SPY	ETF	226.25	226.48	226.18	226.18	12495.0
2016-12-15 05:00:00	SPY	ETF	226.29	226.74	226.27	226.65	16992.0
2016-12-15 06:00:00	SPY	ETF	226.68	226.75	226.2	226.2	135692.0
2016-12-15 07:00:00	SPY	ETF	226.26	226.29	226.03	226.08	281853.0
2016-12-15 08:00:00	SPY	ETF	226.24	226.42	225.78	226.22	819092.0
2016-12-15 09:00:00	SPY	ETF	226.24	227.24	226.01	227.15	11562316.0
2016-12-15 10:00:00	SPY	ETF	227.14	227.46	226.91	227.2166	20711044.0
2016-12-15 11:00:00	SPY	ETF	227.21	227.81	227.17	227.37	13838508.0
2016-12-15 12:00:00	SPY	ETF	227.37	227.45	226.99	227.2	12129577.0
2016-12-15 13:00:00	SPY	ETF	227.2	227.45	226.34	226.4892	9415640.0
2016-12-15 14:00:00	SPY	ETF	226.495	227.03	226.37	226.7901	9756473.0
2016-12-15 15:00:00	SPY	ETF	226.795	227.05	226.63	226.77	23092237.0
2016-12-15 16:00:00	SPY	ETF	226.78	227.04	226.74	226.96	12788364.0
2016-12-15 17:00:00	SPY	ETF	226.98	227.0	226.81	226.93	2489813.0
2016-12-15 18:00:00	SPY	ETF	226.93	227.14	226.81	227.03	424635.0
2016-12-15 19:00:00	SPY	ETF	227.02	227.03	226.83	226.86	79391.0
2016-12-15 04:00:00	QQQ	ETF	120.29	120.29	120.29	120.29	500.0
2016-12-15 05:00:00	QQQ	ETF	120.3	120.54	120.3	120.51	29142.0
2016-12-15 06:00:00	QQQ	ETF	120.55	120.6	120.55	120.6	25100.0
2016-12-15 07:00:00	QQQ	ETF	120.29	120.29	120.15	120.19	26247.0
2016-12-15 08:00:00	QQQ	ETF	120.21	120.35	120.04	120.35	95058.0
2016-12-15 09:00:00	QQQ	ETF	120.33	120.75	120.18	120.73	2643487.0
2016-12-15 10:00:00	QQQ	ETF	120.73	120.83	120.47	120.5865	2639697.0
2016-12-15 11:00:00	QQQ	ETF	120.58	121.11	120.58	120.7824	2558315.0
2016-12-15 12:00:00	QQQ	ETF	120.78	120.915	120.64	120.82	1473112.0
2016-12-15 13:00:00	QQQ	ETF	120.82	120.9899	120.09	120.2	3116805.0
2016-12-15 14:00:00	QQQ	ETF	120.2	120.57	120.08	120.41	1685768.0
2016-12-15 15:00:00	QQQ	ETF	120.42	120.6561	120.35	120.42	3608765.0
2016-12-15 16:00:00	QQQ	ETF	120.42	120.9017	120.3647	120.54	822013.0
2016-12-15 17:00:00	QQQ	ETF	120.48	120.7	120.4	120.57	447205.0
2016-12-15 18:00:00	QQQ	ETF	120.55	120.63	120.55	120.56	10513.0
2016-12-15 19:00:00	QQQ	ETF	120.56	120.56	120.44	120.45	8301.0
2016-12-15 04:00:00	IWM	ETF	135.38	135.38	135.29	135.29	1363.0
2016-12-15 05:00:00	IWM	ETF	135.61	135.61	135.61	135.61	427.0
2016-12-15 06:00:00	IWM	ETF	135.65	135.65	135.54	135.54	1800.0
2016-12-15 07:00:00	IWM	ETF	135.29	135.38	135.15	135.2	43409.0
2016-12-15 08:00:00	IWM	ETF	135.2	135.48	134.97	135.4	159333.0
2016-12-15 09:00:00	IWM	ETF	135.39	136.5	134.96	136.46	3952507.0
2016-12-15 10:00:00	IWM	ETF	136.46	136.99	136.2471	136.71	6575322.0
2016-12-15 11:00:00	IWM	ETF	136.71	137.14	136.35	136.47	4819047.0
2016-12-15 12:00:00	IWM	ETF	136.47	136.64	136.12	136.43	2983415.0
2016-12-15 13:00:00	IWM	ETF	136.425	136.77	136.03	136.05	3236728.0
2016-12-15 14:00:00	IWM	ETF	136.05	136.38	135.96	136.0456	2658465.0
2016-12-15 15:00:00	IWM	ETF	136.05	136.26	135.87	136.18	5758342.0
2016-12-15 16:00:00	IWM	ETF	136.16	136.57	136.085	136.57	1109995.0
2016-12-15 17:00:00	IWM	ETF	136.49	136.53	136.16	136.53	177843.0
2016-12-15 18:00:00	IWM	ETF	136.5	136.53	136.49	136.53	1950.0
2016-12-15 19:00:00	IWM	ETF	136.52	136.55	136.41	136.45	6190.0
2016-12-15 05:00:00	DIA	ETF	198.67	198.78	198.67	198.78	400.0
2016-12-15 06:00:00	DIA	ETF	198.69	198.69	198.69	198.69	200.0

> showing 50 of 9,121 rows — these rows as CSV

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