PREVIEW / etf_1hour / 2017-12-06

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-12-06.parquet
  size:    289 KB
  rows:    9,549

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-12-06 04:00:00	SPY	ETF	262.86	262.87	262.58	262.58	22010.0
2017-12-06 05:00:00	SPY	ETF	262.62	262.78	262.56	262.78	4785.0
2017-12-06 06:00:00	SPY	ETF	262.69	262.87	262.6	262.72	26819.0
2017-12-06 07:00:00	SPY	ETF	262.85	262.94	262.75	262.94	205103.0
2017-12-06 08:00:00	SPY	ETF	262.8	263.06	262.62	263.03	939100.0
2017-12-06 09:00:00	SPY	ETF	263.03	263.41	262.79	263.23	7653686.0
2017-12-06 10:00:00	SPY	ETF	263.23	263.58	262.71	263.565	8761487.0
2017-12-06 11:00:00	SPY	ETF	263.57	263.66	263.13	263.245	6790497.0
2017-12-06 12:00:00	SPY	ETF	263.24	263.28	262.88	263.18	6866320.0
2017-12-06 13:00:00	SPY	ETF	263.2	263.515	263.05	263.479	4053973.0
2017-12-06 14:00:00	SPY	ETF	263.47	263.73	263.37	263.515	8897400.0
2017-12-06 15:00:00	SPY	ETF	263.51	263.63	263.065	263.21	12706693.0
2017-12-06 16:00:00	SPY	ETF	263.21	263.47	262.93	263.42	10427865.0
2017-12-06 17:00:00	SPY	ETF	263.4	263.53	263.35	263.36	159628.0
2017-12-06 18:00:00	SPY	ETF	263.36	263.56	263.1523	263.48	282086.0
2017-12-06 19:00:00	SPY	ETF	263.48	263.88	263.48	263.82	59426.0
2017-12-06 04:00:00	QQQ	ETF	152.51	152.51	152.19	152.19	10150.0
2017-12-06 05:00:00	QQQ	ETF	152.27	152.32	152.02	152.15	28207.0
2017-12-06 06:00:00	QQQ	ETF	152.05	152.3	152.05	152.18	26100.0
2017-12-06 07:00:00	QQQ	ETF	152.26	152.49	152.13	152.47	87827.0
2017-12-06 08:00:00	QQQ	ETF	152.26	152.56	152.18	152.54	267726.0
2017-12-06 09:00:00	QQQ	ETF	152.54	153.19	152.06	153.0	5306126.0
2017-12-06 10:00:00	QQQ	ETF	153.0	153.38	152.63	153.29	5062166.0
2017-12-06 11:00:00	QQQ	ETF	153.28	153.52	153.0	153.2175	2721460.0
2017-12-06 12:00:00	QQQ	ETF	153.21	153.32	152.85	153.07	1602286.0
2017-12-06 13:00:00	QQQ	ETF	153.06	153.45	152.9	153.41	1632908.0
2017-12-06 14:00:00	QQQ	ETF	153.4	153.71	153.38	153.56	4181365.0
2017-12-06 15:00:00	QQQ	ETF	153.5545	153.735	153.28	153.47	5259922.0
2017-12-06 16:00:00	QQQ	ETF	153.48	153.61	153.34	153.61	1184894.0
2017-12-06 17:00:00	QQQ	ETF	153.64	153.66	153.55	153.59	7964.0
2017-12-06 18:00:00	QQQ	ETF	153.55	153.72	153.49	153.64	21623.0
2017-12-06 19:00:00	QQQ	ETF	153.64	154.02	153.64	154.01	52671.0
2017-12-06 04:00:00	IWM	ETF	150.72	150.73	150.55	150.55	2910.0
2017-12-06 05:00:00	IWM	ETF	150.52	150.67	150.47	150.67	3991.0
2017-12-06 06:00:00	IWM	ETF	150.7	150.86	150.7	150.84	17012.0
2017-12-06 07:00:00	IWM	ETF	150.93	151.01	150.85	150.99	41803.0
2017-12-06 08:00:00	IWM	ETF	150.93	151.01	150.74	150.9	209044.0
2017-12-06 09:00:00	IWM	ETF	150.91	151.19	150.55	150.73	3058315.0
2017-12-06 10:00:00	IWM	ETF	150.73	151.05	150.26	150.99	2318670.0
2017-12-06 11:00:00	IWM	ETF	150.99	151.02	150.29	150.41	1795796.0
2017-12-06 12:00:00	IWM	ETF	150.4	150.57	149.95	150.32	2133451.0
2017-12-06 13:00:00	IWM	ETF	150.325	150.69	150.1	150.42	1496314.0
2017-12-06 14:00:00	IWM	ETF	150.4	150.66	150.21	150.24	1864833.0
2017-12-06 15:00:00	IWM	ETF	150.24	150.5	150.125	150.23	3130262.0
2017-12-06 16:00:00	IWM	ETF	150.21	150.31	149.99	150.24	2887958.0
2017-12-06 17:00:00	IWM	ETF	150.24	150.33	150.24	150.3	16563.0
2017-12-06 18:00:00	IWM	ETF	150.19	150.39	150.18	150.36	55278.0
2017-12-06 19:00:00	IWM	ETF	150.36	150.6	150.35	150.58	7408.0
2017-12-06 04:00:00	DIA	ETF	241.7	241.7	241.57	241.57	600.0
2017-12-06 06:00:00	DIA	ETF	242.05	242.05	242.05	242.05	242.0

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

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