PREVIEW / etf_1hour / 2017-11-08

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-11-08.parquet
  size:    285 KB
  rows:    9,343

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-11-08 04:00:00	SPY	ETF	258.52	258.71	258.52	258.63	15650.0
2017-11-08 05:00:00	SPY	ETF	258.63	258.63	258.52	258.57	11762.0
2017-11-08 06:00:00	SPY	ETF	258.55	258.58	258.32	258.38	18557.0
2017-11-08 07:00:00	SPY	ETF	258.4	258.48	258.25	258.34	95237.0
2017-11-08 08:00:00	SPY	ETF	258.42	258.57	258.29	258.5	233849.0
2017-11-08 09:00:00	SPY	ETF	258.5	258.58	258.15	258.25	4600525.0
2017-11-08 10:00:00	SPY	ETF	258.26	258.58	258.23	258.53	5819087.0
2017-11-08 11:00:00	SPY	ETF	258.53	258.68	258.405	258.58	3127773.0
2017-11-08 12:00:00	SPY	ETF	258.58	258.94	258.55	258.8999	4451678.0
2017-11-08 13:00:00	SPY	ETF	258.9	259.075	258.89	259.005	6396027.0
2017-11-08 14:00:00	SPY	ETF	259.0025	259.14	258.9	259.05	4126988.0
2017-11-08 15:00:00	SPY	ETF	259.05	259.22	258.88	259.13	10964234.0
2017-11-08 16:00:00	SPY	ETF	259.13	259.13	258.96	259.03	9466929.0
2017-11-08 17:00:00	SPY	ETF	259.06	259.1	259.02	259.09	148769.0
2017-11-08 18:00:00	SPY	ETF	259.04	259.15	259.04	259.08	37189.0
2017-11-08 19:00:00	SPY	ETF	259.08	259.37	259.05	259.26	119703.0
2017-11-08 04:00:00	QQQ	ETF	153.9	153.98	153.89	153.89	12000.0
2017-11-08 05:00:00	QQQ	ETF	153.89	153.9	153.82	153.9	5200.0
2017-11-08 06:00:00	QQQ	ETF	153.88	153.88	153.76	153.77	47199.0
2017-11-08 07:00:00	QQQ	ETF	153.84	153.85	153.75	153.76	8798.0
2017-11-08 08:00:00	QQQ	ETF	153.8	153.88	153.79	153.85	81198.0
2017-11-08 09:00:00	QQQ	ETF	153.85	153.98	153.62	153.71	2372712.0
2017-11-08 10:00:00	QQQ	ETF	153.72	154.06	153.72	154.02	3188819.0
2017-11-08 11:00:00	QQQ	ETF	154.02	154.2	153.99	154.0551	1775076.0
2017-11-08 12:00:00	QQQ	ETF	154.05	154.24	154.03	154.22	1294796.0
2017-11-08 13:00:00	QQQ	ETF	154.22	154.4	154.21	154.39	1322385.0
2017-11-08 14:00:00	QQQ	ETF	154.395	154.49	154.3	154.45	1722677.0
2017-11-08 15:00:00	QQQ	ETF	154.44	154.54	154.35	154.5	3183008.0
2017-11-08 16:00:00	QQQ	ETF	154.51	154.51	154.4	154.43	1080193.0
2017-11-08 17:00:00	QQQ	ETF	154.42	154.45	154.39	154.45	5394.0
2017-11-08 18:00:00	QQQ	ETF	154.41	154.47	154.4	154.4	10139.0
2017-11-08 19:00:00	QQQ	ETF	154.42	154.6	154.42	154.55	34279.0
2017-11-08 04:00:00	IWM	ETF	146.75	146.83	146.75	146.8	8289.0
2017-11-08 05:00:00	IWM	ETF	146.81	146.81	146.74	146.74	3006.0
2017-11-08 06:00:00	IWM	ETF	146.8	146.83	146.68	146.73	3734.0
2017-11-08 07:00:00	IWM	ETF	146.76	146.76	146.58	146.64	18128.0
2017-11-08 08:00:00	IWM	ETF	146.66	146.85	146.66	146.75	38211.0
2017-11-08 09:00:00	IWM	ETF	146.77	146.79	146.18	146.44	3397699.0
2017-11-08 10:00:00	IWM	ETF	146.435	146.69	145.835	146.325	5262646.0
2017-11-08 11:00:00	IWM	ETF	146.33	146.57	145.87	146.27	3548379.0
2017-11-08 12:00:00	IWM	ETF	146.27	147.02	146.22	146.99	3907381.0
2017-11-08 13:00:00	IWM	ETF	146.99	147.2	146.69	146.95	2539049.0
2017-11-08 14:00:00	IWM	ETF	146.96	147.45	146.955	147.34	1805717.0
2017-11-08 15:00:00	IWM	ETF	147.34	147.44	147.16	147.22	3460703.0
2017-11-08 16:00:00	IWM	ETF	147.2	147.45	146.61	147.38	1793894.0
2017-11-08 17:00:00	IWM	ETF	147.42	147.42	147.31	147.35	3570.0
2017-11-08 18:00:00	IWM	ETF	147.38	147.4	147.37	147.38	4631.0
2017-11-08 19:00:00	IWM	ETF	147.38	147.53	147.31	147.4	17204.0
2017-11-08 08:00:00	DIA	ETF	235.38	235.38	235.35	235.35	235.0
2017-11-08 09:00:00	DIA	ETF	235.36	235.45	234.9701	235.02	179511.0

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

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