PREVIEW / etf_1hour / 2016-01-07

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-01-07.parquet
  size:    270 KB
  rows:    8,655

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-01-07 04:00:00	SPY	ETF	194.27	195.45	193.75	194.51	427570.0
2016-01-07 05:00:00	SPY	ETF	194.49	194.87	193.83	194.35	155451.0
2016-01-07 06:00:00	SPY	ETF	194.35	195.08	194.35	194.75	116444.0
2016-01-07 07:00:00	SPY	ETF	194.73	195.22	194.5	194.91	794592.0
2016-01-07 08:00:00	SPY	ETF	194.91	196.95	193.68	195.27	2219586.0
2016-01-07 09:00:00	SPY	ETF	195.26	196.58	195.03	196.18	23737847.0
2016-01-07 10:00:00	SPY	ETF	196.18	197.44	195.66	197.2	24395845.0
2016-01-07 11:00:00	SPY	ETF	197.19	197.37	196.18	196.21	18306295.0
2016-01-07 12:00:00	SPY	ETF	196.21	196.49	195.651	195.73	14730481.0
2016-01-07 13:00:00	SPY	ETF	195.72	195.77	193.93	194.48	31810545.0
2016-01-07 14:00:00	SPY	ETF	194.48	195.17	193.8	194.345	30498074.0
2016-01-07 15:00:00	SPY	ETF	194.34	194.99	193.59	194.01	52882079.0
2016-01-07 16:00:00	SPY	ETF	194.02	196.27	193.42	193.96	10899228.0
2016-01-07 17:00:00	SPY	ETF	193.99	194.32	193.83	194.09	554749.0
2016-01-07 18:00:00	SPY	ETF	194.1	194.24	193.45	194.13	444448.0
2016-01-07 19:00:00	SPY	ETF	194.04	194.41	193.89	193.93	322891.0
2016-01-07 04:00:00	QQQ	ETF	105.51	106.1	105.03	105.52	63085.0
2016-01-07 05:00:00	QQQ	ETF	105.63	105.66	104.95	105.13	78941.0
2016-01-07 06:00:00	QQQ	ETF	105.12	105.54	105.12	105.35	34463.0
2016-01-07 07:00:00	QQQ	ETF	105.36	105.65	105.21	105.57	294614.0
2016-01-07 08:00:00	QQQ	ETF	105.55	106.68	105.22	105.8	541336.0
2016-01-07 09:00:00	QQQ	ETF	105.85	106.5878	105.68	106.32	8188286.0
2016-01-07 10:00:00	QQQ	ETF	106.31	107.27	105.94	107.17	7872755.0
2016-01-07 11:00:00	QQQ	ETF	107.165	108.26	106.5	106.54	3984536.0
2016-01-07 12:00:00	QQQ	ETF	106.52	106.72	106.15	106.18	3362224.0
2016-01-07 13:00:00	QQQ	ETF	106.19	106.22	104.94	105.21	8107220.0
2016-01-07 14:00:00	QQQ	ETF	105.2	105.78	104.81	105.32	6655622.0
2016-01-07 15:00:00	QQQ	ETF	105.32	105.6	104.87	104.88	10729218.0
2016-01-07 16:00:00	QQQ	ETF	104.89	104.98	104.57	104.79	1550838.0
2016-01-07 17:00:00	QQQ	ETF	104.72	105.09	104.71	104.8	444925.0
2016-01-07 18:00:00	QQQ	ETF	104.81	104.93	104.53	104.91	69397.0
2016-01-07 19:00:00	QQQ	ETF	104.84	105.08	104.79	104.84	81830.0
2016-01-07 04:00:00	IWM	ETF	106.62	106.62	106.01	106.01	9855.0
2016-01-07 05:00:00	IWM	ETF	105.95	105.95	105.82	105.82	12000.0
2016-01-07 06:00:00	IWM	ETF	106.08	106.25	106.08	106.25	1625.0
2016-01-07 07:00:00	IWM	ETF	106.33	106.5	106.25	106.49	162228.0
2016-01-07 08:00:00	IWM	ETF	106.47	106.58	106.11	106.58	299308.0
2016-01-07 09:00:00	IWM	ETF	106.57	107.22	106.39	106.89	6151515.0
2016-01-07 10:00:00	IWM	ETF	106.88	107.48	106.5301	107.41	6687627.0
2016-01-07 11:00:00	IWM	ETF	107.4	107.5	106.8	106.83	4269364.0
2016-01-07 12:00:00	IWM	ETF	106.83	106.92	106.36	106.39	3025320.0
2016-01-07 13:00:00	IWM	ETF	106.4	106.42	105.49	105.79	6296932.0
2016-01-07 14:00:00	IWM	ETF	105.79	106.32	105.69	106.07	5650936.0
2016-01-07 15:00:00	IWM	ETF	106.06	106.19	105.58	105.68	9876033.0
2016-01-07 16:00:00	IWM	ETF	105.67	106.49	105.33	105.42	1515007.0
2016-01-07 17:00:00	IWM	ETF	105.35	105.5	105.35	105.5	209289.0
2016-01-07 18:00:00	IWM	ETF	105.18	105.57	105.18	105.57	10800.0
2016-01-07 19:00:00	IWM	ETF	105.54	105.6	105.54	105.6	1100.0
2016-01-07 04:00:00	DIA	ETF	165.2	165.3	164.84	164.92	1947.0
2016-01-07 05:00:00	DIA	ETF	164.79	164.95	164.77	164.95	4000.0

> showing 50 of 8,655 rows — these rows as CSV

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