PREVIEW / etf_1hour / 2016-11-23

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-11-23.parquet
  size:    272 KB
  rows:    8,745

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-11-23 04:00:00	SPY	ETF	220.71	220.88	220.68	220.68	17000.0
2016-11-23 05:00:00	SPY	ETF	220.58	220.59	220.33	220.48	8566.0
2016-11-23 06:00:00	SPY	ETF	220.48	220.54	220.32	220.37	62706.0
2016-11-23 07:00:00	SPY	ETF	220.46	220.6	220.42	220.6	35281.0
2016-11-23 08:00:00	SPY	ETF	220.58	220.62	220.12	220.2	451901.0
2016-11-23 09:00:00	SPY	ETF	220.22	220.26	219.75	219.88	8973294.0
2016-11-23 10:00:00	SPY	ETF	219.88	220.45	219.88	220.3	9786175.0
2016-11-23 11:00:00	SPY	ETF	220.3	220.35	219.98	220.34	5800584.0
2016-11-23 12:00:00	SPY	ETF	220.34	220.61	220.28	220.46	5074197.0
2016-11-23 13:00:00	SPY	ETF	220.47	220.55	220.35	220.365	3647804.0
2016-11-23 14:00:00	SPY	ETF	220.36	220.6	220.36	220.47	5190364.0
2016-11-23 15:00:00	SPY	ETF	220.46	220.76	220.45	220.73	11682883.0
2016-11-23 16:00:00	SPY	ETF	220.71	220.7554	220.55	220.61	4394673.0
2016-11-23 17:00:00	SPY	ETF	220.7	220.7	220.55	220.67	525436.0
2016-11-23 18:00:00	SPY	ETF	220.66	220.68	220.57	220.61	37221.0
2016-11-23 19:00:00	SPY	ETF	220.59	220.6	220.54	220.56	29432.0
2016-11-23 04:00:00	QQQ	ETF	119.03	119.13	119.03	119.13	2471.0
2016-11-23 05:00:00	QQQ	ETF	118.93	118.93	118.9	118.93	2305.0
2016-11-23 06:00:00	QQQ	ETF	118.88	118.89	118.88	118.89	200.0
2016-11-23 07:00:00	QQQ	ETF	118.86	118.93	118.86	118.91	15110.0
2016-11-23 08:00:00	QQQ	ETF	118.92	118.96	118.63	118.63	112115.0
2016-11-23 09:00:00	QQQ	ETF	118.63	118.66	118.05	118.18	4042811.0
2016-11-23 10:00:00	QQQ	ETF	118.185	118.37	118.07	118.17	3459992.0
2016-11-23 11:00:00	QQQ	ETF	118.18	118.21	117.9	118.21	2377457.0
2016-11-23 12:00:00	QQQ	ETF	118.2	118.34	118.16	118.25	1170479.0
2016-11-23 13:00:00	QQQ	ETF	118.25	118.29	118.06	118.09	1193814.0
2016-11-23 14:00:00	QQQ	ETF	118.08	118.34	118.08	118.18	1465361.0
2016-11-23 15:00:00	QQQ	ETF	118.18	118.43	118.18	118.43	1925391.0
2016-11-23 16:00:00	QQQ	ETF	118.42	118.44	118.34	118.4	3573505.0
2016-11-23 17:00:00	QQQ	ETF	118.4	118.46	118.36	118.36	145168.0
2016-11-23 18:00:00	QQQ	ETF	118.4	118.44	118.4	118.42	7518.0
2016-11-23 19:00:00	QQQ	ETF	118.38	118.38	118.36	118.37	5771.0
2016-11-23 04:00:00	IWM	ETF	132.77	132.79	132.71	132.71	3234.0
2016-11-23 05:00:00	IWM	ETF	132.67	132.74	132.6	132.6	8584.0
2016-11-23 06:00:00	IWM	ETF	132.67	132.74	132.62	132.62	4800.0
2016-11-23 07:00:00	IWM	ETF	132.7	132.9	132.67	132.9	51048.0
2016-11-23 08:00:00	IWM	ETF	132.92	133.0	132.51	132.74	176904.0
2016-11-23 09:00:00	IWM	ETF	132.75	133.04	132.1	132.27	4362408.0
2016-11-23 10:00:00	IWM	ETF	132.29	133.33	132.25	133.21	5866273.0
2016-11-23 11:00:00	IWM	ETF	133.216	133.24	132.75	133.18	2883344.0
2016-11-23 12:00:00	IWM	ETF	133.17	133.48	133.09	133.42	2121913.0
2016-11-23 13:00:00	IWM	ETF	133.43	133.57	133.21	133.25	2287051.0
2016-11-23 14:00:00	IWM	ETF	133.25	133.39	133.09	133.11	1632976.0
2016-11-23 15:00:00	IWM	ETF	133.115	133.65	133.11	133.61	3765778.0
2016-11-23 16:00:00	IWM	ETF	133.63	133.68	133.5541	133.58	997700.0
2016-11-23 17:00:00	IWM	ETF	133.63	133.64	133.57	133.61	405550.0
2016-11-23 18:00:00	IWM	ETF	133.65	133.67	133.65	133.65	5561.0
2016-11-23 19:00:00	IWM	ETF	133.62	133.65	133.58	133.58	10355.0
2016-11-23 05:00:00	DIA	ETF	190.1	190.1	190.1	190.1	100.0
2016-11-23 07:00:00	DIA	ETF	190.25	190.25	190.25	190.25	100.0

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

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