PREVIEW / etf_1hour / 2017-09-15

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-09-15.parquet
  size:    274 KB
  rows:    9,017

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-15 04:00:00	SPY	ETF	248.72	248.74	248.56	248.74	24433.0
2017-09-15 05:00:00	SPY	ETF	248.75	248.83	248.6	248.63	900.0
2017-09-15 06:00:00	SPY	ETF	248.57	248.65	248.52	248.56	62939.0
2017-09-15 07:00:00	SPY	ETF	248.59	248.81	248.55	248.76	229069.0
2017-09-15 08:00:00	SPY	ETF	248.78	248.82	248.58	248.61	382227.0
2017-09-15 09:00:00	SPY	ETF	248.6	248.88	248.45	248.65	9363892.0
2017-09-15 10:00:00	SPY	ETF	248.645	249.18	248.57	249.05	23580683.0
2017-09-15 11:00:00	SPY	ETF	249.05	249.09	248.94	249.0766	6659972.0
2017-09-15 12:00:00	SPY	ETF	249.0701	249.11	248.95	248.96	3947887.0
2017-09-15 13:00:00	SPY	ETF	248.96	249.055	248.88	248.955	4470502.0
2017-09-15 14:00:00	SPY	ETF	248.95	249.08	248.91	249.05	4662199.0
2017-09-15 15:00:00	SPY	ETF	249.055	249.29	249.02	249.25	15371545.0
2017-09-15 16:00:00	SPY	ETF	249.25	249.47	248.78	249.47	23190724.0
2017-09-15 17:00:00	SPY	ETF	249.42	249.43	249.19	249.2	1192326.0
2017-09-15 18:00:00	SPY	ETF	249.22	249.23	249.1	249.16	115250.0
2017-09-15 19:00:00	SPY	ETF	249.16	249.45	249.15	249.34	58614.0
2017-09-15 04:00:00	QQQ	ETF	145.43	145.55	145.43	145.55	2200.0
2017-09-15 05:00:00	QQQ	ETF	145.38	145.38	145.37	145.37	300.0
2017-09-15 06:00:00	QQQ	ETF	145.34	145.36	145.28	145.33	3900.0
2017-09-15 07:00:00	QQQ	ETF	145.38	145.48	145.33	145.44	30133.0
2017-09-15 08:00:00	QQQ	ETF	145.44	145.5	145.32	145.32	64166.0
2017-09-15 09:00:00	QQQ	ETF	145.34	145.68	145.28	145.48	3978391.0
2017-09-15 10:00:00	QQQ	ETF	145.48	146.59	145.44	146.435	5563194.0
2017-09-15 11:00:00	QQQ	ETF	146.43	146.46	146.12	146.245	2509295.0
2017-09-15 12:00:00	QQQ	ETF	146.2485	146.31	146.005	146.015	1116317.0
2017-09-15 13:00:00	QQQ	ETF	146.0172	146.1	145.89	145.965	1146391.0
2017-09-15 14:00:00	QQQ	ETF	145.97	146.05	145.904	146.03	1734976.0
2017-09-15 15:00:00	QQQ	ETF	146.04	146.15	145.94	146.02	9085360.0
2017-09-15 16:00:00	QQQ	ETF	146.01	146.19	145.9394	146.15	5768242.0
2017-09-15 17:00:00	QQQ	ETF	146.17	146.19	146.03	146.03	1942562.0
2017-09-15 18:00:00	QQQ	ETF	146.1	146.1	146.06	146.09	10060.0
2017-09-15 19:00:00	QQQ	ETF	146.09	146.17	146.06	146.16	12366.0
2017-09-15 05:00:00	IWM	ETF	141.94	141.94	141.8	141.83	11500.0
2017-09-15 06:00:00	IWM	ETF	141.73	141.77	141.73	141.73	1300.0
2017-09-15 07:00:00	IWM	ETF	141.75	141.87	141.7	141.85	29622.0
2017-09-15 08:00:00	IWM	ETF	141.84	141.88	141.64	141.64	33783.0
2017-09-15 09:00:00	IWM	ETF	141.64	142.0399	141.53	141.62	1898401.0
2017-09-15 10:00:00	IWM	ETF	141.61	141.96	141.57	141.86	1757741.0
2017-09-15 11:00:00	IWM	ETF	141.85	142.13	141.78	142.07	1912194.0
2017-09-15 12:00:00	IWM	ETF	142.075	142.155	142.04	142.11	1471599.0
2017-09-15 13:00:00	IWM	ETF	142.11	142.15	142.045	142.09	1114264.0
2017-09-15 14:00:00	IWM	ETF	142.09	142.35	142.09	142.1975	1894437.0
2017-09-15 15:00:00	IWM	ETF	142.2	142.46	142.19	142.38	4330651.0
2017-09-15 16:00:00	IWM	ETF	142.38	142.73	142.36	142.73	2024971.0
2017-09-15 17:00:00	IWM	ETF	142.69	142.71	142.41	142.58	1794970.0
2017-09-15 18:00:00	IWM	ETF	142.57	142.57	142.51	142.55	7918.0
2017-09-15 19:00:00	IWM	ETF	142.55	142.64	142.52	142.64	4300.0
2017-09-15 06:00:00	DIA	ETF	222.0	222.0	221.98	221.98	4000.0
2017-09-15 07:00:00	DIA	ETF	222.0	222.01	221.88	222.0	4150.0
2017-09-15 08:00:00	DIA	ETF	221.9	221.9	221.86	221.9	3850.0

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

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