PREVIEW / etf_1hour / 2016-06-06

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-06-06.parquet
  size:    252 KB
  rows:    8,082

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
2016-06-06 04:00:00	SPY	ETF	210.49	210.6	210.43	210.58	4812.0
2016-06-06 05:00:00	SPY	ETF	210.61	210.61	210.38	210.57	3616.0
2016-06-06 06:00:00	SPY	ETF	210.45	210.5	210.35	210.49	13780.0
2016-06-06 07:00:00	SPY	ETF	210.45	210.76	210.45	210.66	68033.0
2016-06-06 08:00:00	SPY	ETF	210.65	210.98	210.031	210.84	533340.0
2016-06-06 09:00:00	SPY	ETF	210.85	211.38	210.5607	211.18	7386108.0
2016-06-06 10:00:00	SPY	ETF	211.19	211.4	211.085	211.34	7762035.0
2016-06-06 11:00:00	SPY	ETF	211.34	211.45	211.21	211.24	5010784.0
2016-06-06 12:00:00	SPY	ETF	211.24	211.32	210.51	210.86	10111452.0
2016-06-06 13:00:00	SPY	ETF	210.86	211.48	210.81	211.39	6289951.0
2016-06-06 14:00:00	SPY	ETF	211.3901	211.77	211.35	211.55	7093115.0
2016-06-06 15:00:00	SPY	ETF	211.56	211.64	211.3	211.35	13151672.0
2016-06-06 16:00:00	SPY	ETF	211.37	211.47	210.3091	211.42	6240338.0
2016-06-06 17:00:00	SPY	ETF	211.41	211.45	211.32	211.36	202013.0
2016-06-06 18:00:00	SPY	ETF	211.36	211.42	211.33	211.36	51359.0
2016-06-06 19:00:00	SPY	ETF	211.34	211.38	211.22	211.29	65312.0
2016-06-06 05:00:00	QQQ	ETF	110.17	110.2	110.17	110.2	4876.0
2016-06-06 06:00:00	QQQ	ETF	110.19	110.19	110.19	110.19	599.0
2016-06-06 07:00:00	QQQ	ETF	110.2	110.3	110.2	110.29	22080.0
2016-06-06 08:00:00	QQQ	ETF	110.26	110.39	110.2	110.34	26195.0
2016-06-06 09:00:00	QQQ	ETF	110.36	110.54	110.13	110.393	1730308.0
2016-06-06 10:00:00	QQQ	ETF	110.4	110.495	110.3	110.46	1604441.0
2016-06-06 11:00:00	QQQ	ETF	110.47	110.59	110.39	110.4	1014794.0
2016-06-06 12:00:00	QQQ	ETF	110.4	110.46	110.07	110.24	1801640.0
2016-06-06 13:00:00	QQQ	ETF	110.25	110.59	110.23	110.555	1403765.0
2016-06-06 14:00:00	QQQ	ETF	110.5699	110.75	110.53	110.56	1307889.0
2016-06-06 15:00:00	QQQ	ETF	110.55	110.63	110.43	110.44	2654208.0
2016-06-06 16:00:00	QQQ	ETF	110.46	110.51	110.44	110.48	455967.0
2016-06-06 17:00:00	QQQ	ETF	110.47	110.48	110.43	110.44	1922.0
2016-06-06 18:00:00	QQQ	ETF	110.44	110.47	110.38	110.43	5012.0
2016-06-06 19:00:00	QQQ	ETF	110.38	110.39	110.35	110.39	2280.0
2016-06-06 07:00:00	IWM	ETF	116.11	116.11	116.09	116.11	5199.0
2016-06-06 08:00:00	IWM	ETF	116.11	116.23	116.11	116.16	12519.0
2016-06-06 09:00:00	IWM	ETF	116.17	116.68	116.01	116.57	3933749.0
2016-06-06 10:00:00	IWM	ETF	116.58	116.89	116.54	116.79	3104459.0
2016-06-06 11:00:00	IWM	ETF	116.78	116.98	116.58	116.811	2594732.0
2016-06-06 12:00:00	IWM	ETF	116.82	116.94	116.55	116.775	2197707.0
2016-06-06 13:00:00	IWM	ETF	116.7701	117.26	116.75	117.17	2347527.0
2016-06-06 14:00:00	IWM	ETF	117.1601	117.58	117.15	117.445	3480480.0
2016-06-06 15:00:00	IWM	ETF	117.4441	117.5	117.15	117.23	4597904.0
2016-06-06 16:00:00	IWM	ETF	117.23	117.29	117.17	117.27	1423371.0
2016-06-06 17:00:00	IWM	ETF	117.25	117.28	115.7101	115.7101	17107.0
2016-06-06 18:00:00	IWM	ETF	117.25	117.25	117.25	117.25	1949.0
2016-06-06 19:00:00	IWM	ETF	117.22	117.24	117.11	117.11	3487.0
2016-06-06 08:00:00	DIA	ETF	178.29	178.73	178.26	178.64	4700.0
2016-06-06 09:00:00	DIA	ETF	178.55	179.11	178.41	178.9599	424347.0
2016-06-06 10:00:00	DIA	ETF	178.97	179.18	178.86	179.14	335256.0
2016-06-06 11:00:00	DIA	ETF	179.14	179.25	179.075	179.13	321109.0
2016-06-06 12:00:00	DIA	ETF	179.14	179.17	178.51	178.77	586974.0
2016-06-06 13:00:00	DIA	ETF	178.74	179.29	178.71	179.222	307629.0

> showing 50 of 8,082 rows — these rows as CSV

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