PREVIEW / etf_1hour / 2017-05-16

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-05-16.parquet
  size:    278 KB
  rows:    9,104

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-05-16 04:00:00	SPY	ETF	240.15	240.15	239.98	239.98	14384.0
2017-05-16 05:00:00	SPY	ETF	239.98	240.07	239.96	240.0	12300.0
2017-05-16 06:00:00	SPY	ETF	240.04	240.23	240.04	240.23	46920.0
2017-05-16 07:00:00	SPY	ETF	240.19	240.44	240.16	240.36	300619.0
2017-05-16 08:00:00	SPY	ETF	240.32	240.61	240.19	240.49	505143.0
2017-05-16 09:00:00	SPY	ETF	240.49	240.67	240.3	240.45	5214058.0
2017-05-16 10:00:00	SPY	ETF	240.45	240.47	239.63	239.83	9972512.0
2017-05-16 11:00:00	SPY	ETF	239.83	240.29	239.71	240.17	7316000.0
2017-05-16 12:00:00	SPY	ETF	240.18	240.33	240.07	240.13	3661388.0
2017-05-16 13:00:00	SPY	ETF	240.135	240.18	239.95	239.98	2823400.0
2017-05-16 14:00:00	SPY	ETF	239.985	240.05	239.83	239.8899	5645802.0
2017-05-16 15:00:00	SPY	ETF	239.89	240.18	239.885	240.1	9703094.0
2017-05-16 16:00:00	SPY	ETF	240.09	240.1263	239.93	239.96	3434727.0
2017-05-16 17:00:00	SPY	ETF	239.96	240.08	239.87	239.87	143285.0
2017-05-16 18:00:00	SPY	ETF	239.87	239.87	239.15	239.2	436840.0
2017-05-16 19:00:00	SPY	ETF	239.19	239.31	238.8	238.85	258683.0
2017-05-16 04:00:00	QQQ	ETF	139.05	139.05	139.0	139.0	300.0
2017-05-16 05:00:00	QQQ	ETF	139.0	139.1	139.0	139.1	25800.0
2017-05-16 06:00:00	QQQ	ETF	139.13	139.13	139.08	139.09	800.0
2017-05-16 07:00:00	QQQ	ETF	139.12	139.25	139.11	139.21	90008.0
2017-05-16 08:00:00	QQQ	ETF	139.11	139.31	139.11	139.25	173941.0
2017-05-16 09:00:00	QQQ	ETF	139.26	139.43	139.17	139.37	2992705.0
2017-05-16 10:00:00	QQQ	ETF	139.3701	139.44	138.99	139.19	2946867.0
2017-05-16 11:00:00	QQQ	ETF	139.19	139.48	139.12	139.39	1914647.0
2017-05-16 12:00:00	QQQ	ETF	139.39	139.51	139.3301	139.47	1762889.0
2017-05-16 13:00:00	QQQ	ETF	139.47	139.53	139.38	139.395	1222493.0
2017-05-16 14:00:00	QQQ	ETF	139.39	139.45	139.34	139.4	1128023.0
2017-05-16 15:00:00	QQQ	ETF	139.4	139.64	139.3861	139.63	3631931.0
2017-05-16 16:00:00	QQQ	ETF	139.63	139.63	139.5129	139.59	1098621.0
2017-05-16 17:00:00	QQQ	ETF	139.55	139.59	139.53	139.55	3937.0
2017-05-16 18:00:00	QQQ	ETF	139.54	139.54	139.24	139.24	59605.0
2017-05-16 19:00:00	QQQ	ETF	139.25	139.27	138.99	139.02	96134.0
2017-05-16 04:00:00	IWM	ETF	138.45	138.45	138.45	138.45	300.0
2017-05-16 05:00:00	IWM	ETF	138.46	138.46	138.41	138.42	400.0
2017-05-16 07:00:00	IWM	ETF	138.6	138.85	138.6	138.85	30729.0
2017-05-16 08:00:00	IWM	ETF	138.83	138.94	138.73	138.76	52546.0
2017-05-16 09:00:00	IWM	ETF	138.79	139.04	138.39	138.51	1979219.0
2017-05-16 10:00:00	IWM	ETF	138.52	138.64	137.62	137.81	3786398.0
2017-05-16 11:00:00	IWM	ETF	137.81	138.46	137.69	138.35	2462001.0
2017-05-16 12:00:00	IWM	ETF	138.36	138.51	138.231	138.38	1488241.0
2017-05-16 13:00:00	IWM	ETF	138.38	138.41	138.16	138.23	1644682.0
2017-05-16 14:00:00	IWM	ETF	138.24	138.47	138.19	138.4	1468231.0
2017-05-16 15:00:00	IWM	ETF	138.41	138.73	138.33	138.66	2715116.0
2017-05-16 16:00:00	IWM	ETF	138.63	138.72	138.62	138.7	606614.0
2017-05-16 17:00:00	IWM	ETF	138.7	138.74	138.65	138.66	49117.0
2017-05-16 18:00:00	IWM	ETF	138.66	138.66	138.31	138.32	86598.0
2017-05-16 19:00:00	IWM	ETF	138.31	138.34	137.9	137.9	24357.0
2017-05-16 04:00:00	DIA	ETF	209.83	209.83	209.83	209.83	100.0
2017-05-16 05:00:00	DIA	ETF	209.88	209.88	209.88	209.88	100.0
2017-05-16 06:00:00	DIA	ETF	209.93	210.08	209.93	210.08	700.0

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

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