PREVIEW / etf_1hour / 2016-12-27

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-12-27.parquet
  size:    264 KB
  rows:    8,688

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-12-27 05:00:00	SPY	ETF	225.67	225.67	225.61	225.61	301.0
2016-12-27 06:00:00	SPY	ETF	225.67	225.89	225.67	225.89	1079.0
2016-12-27 07:00:00	SPY	ETF	225.87	225.93	225.86	225.88	15448.0
2016-12-27 08:00:00	SPY	ETF	225.89	226.03	225.81	226.01	123708.0
2016-12-27 09:00:00	SPY	ETF	225.99	226.72	225.99	226.61	5763677.0
2016-12-27 10:00:00	SPY	ETF	226.62	226.73	226.53	226.56	3884503.0
2016-12-27 11:00:00	SPY	ETF	226.56	226.62	226.29	226.36	4905835.0
2016-12-27 12:00:00	SPY	ETF	226.35	226.3698	226.25	226.355	4047691.0
2016-12-27 13:00:00	SPY	ETF	226.35	226.61	226.32	226.401	3353635.0
2016-12-27 14:00:00	SPY	ETF	226.41	226.53	226.32	226.3673	4196153.0
2016-12-27 15:00:00	SPY	ETF	226.368	226.47	226.14	226.24	7721377.0
2016-12-27 16:00:00	SPY	ETF	226.24	226.27	225.88	225.97	6342650.0
2016-12-27 17:00:00	SPY	ETF	226.0	226.05	226.0	226.04	60516.0
2016-12-27 18:00:00	SPY	ETF	226.05	226.27	226.03	226.06	17120.0
2016-12-27 19:00:00	SPY	ETF	226.06	226.1	226.05	226.07	21647.0
2016-12-27 06:00:00	QQQ	ETF	120.34	120.36	120.34	120.36	1300.0
2016-12-27 07:00:00	QQQ	ETF	120.35	120.39	120.35	120.39	300.0
2016-12-27 08:00:00	QQQ	ETF	120.39	120.46	120.38	120.46	36417.0
2016-12-27 09:00:00	QQQ	ETF	120.43	121.5095	120.41	121.4	4348007.0
2016-12-27 10:00:00	QQQ	ETF	121.41	121.52	121.24	121.28	2551731.0
2016-12-27 11:00:00	QQQ	ETF	121.285	121.33	121.0	121.0312	1505647.0
2016-12-27 12:00:00	QQQ	ETF	121.03	121.059	120.93	121.03	858455.0
2016-12-27 13:00:00	QQQ	ETF	121.035	121.14	120.981	121.04	859973.0
2016-12-27 14:00:00	QQQ	ETF	121.05	121.11	120.97	120.98	753496.0
2016-12-27 15:00:00	QQQ	ETF	120.98	121.06	120.8	120.85	2360182.0
2016-12-27 16:00:00	QQQ	ETF	120.84	120.8606	120.69	120.7	568858.0
2016-12-27 17:00:00	QQQ	ETF	120.74	120.79	120.74	120.79	10286.0
2016-12-27 18:00:00	QQQ	ETF	120.78	120.78	120.73	120.76	1900.0
2016-12-27 19:00:00	QQQ	ETF	120.78	120.78	120.78	120.78	418.0
2016-12-27 05:00:00	IWM	ETF	135.86	135.86	135.86	135.86	100.0
2016-12-27 08:00:00	IWM	ETF	136.07	136.19	136.01	136.18	20951.0
2016-12-27 09:00:00	IWM	ETF	136.13	137.25	136.12	137.1598	2512216.0
2016-12-27 10:00:00	IWM	ETF	137.16	137.3	136.64	136.76	2048941.0
2016-12-27 11:00:00	IWM	ETF	136.75	137.14	136.75	136.81	1484151.0
2016-12-27 12:00:00	IWM	ETF	136.815	136.89	136.67	136.76	665264.0
2016-12-27 13:00:00	IWM	ETF	136.75	136.775	136.54	136.59	697586.0
2016-12-27 14:00:00	IWM	ETF	136.58	136.94	136.54	136.78	1778870.0
2016-12-27 15:00:00	IWM	ETF	136.79	136.93	136.64	136.67	2585531.0
2016-12-27 16:00:00	IWM	ETF	136.65	136.7	136.38	136.4	565437.0
2016-12-27 17:00:00	IWM	ETF	136.41	136.41	136.41	136.41	244.0
2016-12-27 04:00:00	DIA	ETF	198.6	198.6	198.6	198.6	100.0
2016-12-27 06:00:00	DIA	ETF	199.03	199.03	199.03	199.03	100.0
2016-12-27 08:00:00	DIA	ETF	199.0	199.19	199.0	199.17	9300.0
2016-12-27 09:00:00	DIA	ETF	199.18	199.54	199.14	199.43	370814.0
2016-12-27 10:00:00	DIA	ETF	199.43	199.52	199.38	199.4001	247942.0
2016-12-27 11:00:00	DIA	ETF	199.41	199.47	199.25	199.29	221204.0
2016-12-27 12:00:00	DIA	ETF	199.29	199.33	199.21	199.3	150156.0
2016-12-27 13:00:00	DIA	ETF	199.2986	199.41	199.29	199.35	97685.0
2016-12-27 14:00:00	DIA	ETF	199.35	199.4	199.27	199.28	146846.0
2016-12-27 15:00:00	DIA	ETF	199.27	199.34	199.13	199.21	470795.0

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

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