PREVIEW / etf_1hour / 2017-09-28

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-09-28.parquet
  size:    278 KB
  rows:    9,086

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
2017-09-28 04:00:00	SPY	ETF	249.91	250.03	249.84	249.99	82274.0
2017-09-28 05:00:00	SPY	ETF	249.96	250.04	249.87	250.0	3811.0
2017-09-28 06:00:00	SPY	ETF	249.95	249.96	249.87	249.87	3126.0
2017-09-28 07:00:00	SPY	ETF	249.89	249.91	249.58	249.65	203389.0
2017-09-28 08:00:00	SPY	ETF	250.05	250.05	249.52	249.69	290938.0
2017-09-28 09:00:00	SPY	ETF	249.68	250.0022	249.61	249.83	3811117.0
2017-09-28 10:00:00	SPY	ETF	249.83	250.19	249.63	249.99	4766691.0
2017-09-28 11:00:00	SPY	ETF	250.0	250.21	249.89	250.06	4110203.0
2017-09-28 12:00:00	SPY	ETF	250.07	250.32	250.0	250.26	5726190.0
2017-09-28 13:00:00	SPY	ETF	250.25	250.425	250.175	250.41	5286820.0
2017-09-28 14:00:00	SPY	ETF	250.4	250.44	250.16	250.25	2542229.0
2017-09-28 15:00:00	SPY	ETF	250.25	250.37	250.08	250.34	8369896.0
2017-09-28 16:00:00	SPY	ETF	250.33	250.44	250.06	250.39	7271740.0
2017-09-28 17:00:00	SPY	ETF	250.38	250.38	250.138	250.37	87585.0
2017-09-28 18:00:00	SPY	ETF	250.36	250.36	250.24	250.26	56751.0
2017-09-28 19:00:00	SPY	ETF	250.25	250.3612	250.22	250.22	545777.0
2017-09-28 04:00:00	QQQ	ETF	144.39	144.48	144.38	144.48	10482.0
2017-09-28 05:00:00	QQQ	ETF	144.38	144.46	144.38	144.46	28200.0
2017-09-28 06:00:00	QQQ	ETF	144.41	144.41	144.41	144.41	200.0
2017-09-28 07:00:00	QQQ	ETF	144.32	144.37	144.07	144.08	36446.0
2017-09-28 08:00:00	QQQ	ETF	144.08	144.38	143.92	144.09	247827.0
2017-09-28 09:00:00	QQQ	ETF	144.08	144.3	143.78	144.21	4470641.0
2017-09-28 10:00:00	QQQ	ETF	144.2	144.5566	143.98	144.25	3144156.0
2017-09-28 11:00:00	QQQ	ETF	144.25	144.33	144.05	144.13	2300770.0
2017-09-28 12:00:00	QQQ	ETF	144.13	144.34	144.05	144.24	1359683.0
2017-09-28 13:00:00	QQQ	ETF	144.25	144.49	144.12	144.42	955717.0
2017-09-28 14:00:00	QQQ	ETF	144.42	144.455	144.16	144.25	1406650.0
2017-09-28 15:00:00	QQQ	ETF	144.25	144.43	144.07	144.41	5325593.0
2017-09-28 16:00:00	QQQ	ETF	144.41	144.52	144.2501	144.5	612264.0
2017-09-28 17:00:00	QQQ	ETF	144.5	144.52	144.45	144.46	18930.0
2017-09-28 18:00:00	QQQ	ETF	144.46	144.46	144.37	144.37	32461.0
2017-09-28 19:00:00	QQQ	ETF	144.39	144.39	144.36	144.37	6498.0
2017-09-28 04:00:00	IWM	ETF	147.52	147.59	147.45	147.55	22157.0
2017-09-28 05:00:00	IWM	ETF	147.56	147.69	147.54	147.54	25215.0
2017-09-28 06:00:00	IWM	ETF	147.63	147.7	147.63	147.66	33464.0
2017-09-28 07:00:00	IWM	ETF	147.66	147.69	147.5	147.56	82434.0
2017-09-28 08:00:00	IWM	ETF	147.56	147.56	147.26	147.45	192300.0
2017-09-28 09:00:00	IWM	ETF	147.41	147.41	146.95	147.065	4522286.0
2017-09-28 10:00:00	IWM	ETF	147.06	147.31	146.78	147.13	3268296.0
2017-09-28 11:00:00	IWM	ETF	147.125	147.42	146.98	147.4	2798690.0
2017-09-28 12:00:00	IWM	ETF	147.4	147.845	147.33	147.78	2372004.0
2017-09-28 13:00:00	IWM	ETF	147.78	147.93	147.64	147.9	1973204.0
2017-09-28 14:00:00	IWM	ETF	147.89	147.95	147.635	147.67	1966966.0
2017-09-28 15:00:00	IWM	ETF	147.68	148.06	147.61	147.86	4196708.0
2017-09-28 16:00:00	IWM	ETF	147.86	148.15	147.006	148.08	931238.0
2017-09-28 17:00:00	IWM	ETF	148.05	148.05	147.6606	147.99	402101.0
2017-09-28 18:00:00	IWM	ETF	147.99	148.03	147.93	147.94	43920.0
2017-09-28 19:00:00	IWM	ETF	147.93	147.95	147.92	147.94	17004.0
2017-09-28 07:00:00	DIA	ETF	223.1	223.1	222.96	222.96	1000.0
2017-09-28 08:00:00	DIA	ETF	222.9	222.9	222.79	222.8	2000.0

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

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