PREVIEW / etf_1hour / 2016-07-27

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-07-27.parquet
  size:    256 KB
  rows:    8,122

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-07-27 04:00:00	SPY	ETF	217.15	217.22	217.12	217.17	15742.0
2016-07-27 05:00:00	SPY	ETF	217.17	217.17	217.0	217.0	9534.0
2016-07-27 06:00:00	SPY	ETF	217.0	217.1	217.0	217.07	12553.0
2016-07-27 07:00:00	SPY	ETF	217.06	217.16	216.97	217.15	107705.0
2016-07-27 08:00:00	SPY	ETF	217.14	217.22	216.96	217.16	447172.0
2016-07-27 09:00:00	SPY	ETF	217.2	217.27	216.8	217.07	5759876.0
2016-07-27 10:00:00	SPY	ETF	217.07	217.11	216.21	216.39	13791458.0
2016-07-27 11:00:00	SPY	ETF	216.385	216.5	216.07	216.105	6985561.0
2016-07-27 12:00:00	SPY	ETF	216.1	216.24	216.0	216.11	6160263.0
2016-07-27 13:00:00	SPY	ETF	216.109	216.36	215.92	216.2328	5825896.0
2016-07-27 14:00:00	SPY	ETF	216.24	216.81	215.62	216.61	17646762.0
2016-07-27 15:00:00	SPY	ETF	216.615	217.02	216.32	216.53	16888154.0
2016-07-27 16:00:00	SPY	ETF	216.54	216.66	216.21	216.66	9440418.0
2016-07-27 17:00:00	SPY	ETF	216.64	216.64	216.54	216.6	104495.0
2016-07-27 18:00:00	SPY	ETF	216.6	216.65	216.52	216.59	86952.0
2016-07-27 19:00:00	SPY	ETF	216.56	216.58	216.48	216.54	38638.0
2016-07-27 04:00:00	QQQ	ETF	114.5	114.53	114.5	114.53	2600.0
2016-07-27 05:00:00	QQQ	ETF	114.48	114.5	114.48	114.5	1095.0
2016-07-27 06:00:00	QQQ	ETF	114.51	114.51	114.5	114.5	600.0
2016-07-27 07:00:00	QQQ	ETF	114.53	114.71	114.51	114.7	13619.0
2016-07-27 08:00:00	QQQ	ETF	114.68	114.73	114.53	114.68	78067.0
2016-07-27 09:00:00	QQQ	ETF	114.72	114.85	114.44	114.7205	4091450.0
2016-07-27 10:00:00	QQQ	ETF	114.73	114.76	114.34	114.4	2898021.0
2016-07-27 11:00:00	QQQ	ETF	114.4	114.56	114.34	114.35	1365505.0
2016-07-27 12:00:00	QQQ	ETF	114.35	114.37	114.2343	114.3	1023036.0
2016-07-27 13:00:00	QQQ	ETF	114.3	114.47	114.25	114.43	1025685.0
2016-07-27 14:00:00	QQQ	ETF	114.4	114.69	114.1	114.61	3745014.0
2016-07-27 15:00:00	QQQ	ETF	114.61	114.88	114.485	114.57	6594994.0
2016-07-27 16:00:00	QQQ	ETF	114.55	114.98	114.24	114.96	1155865.0
2016-07-27 17:00:00	QQQ	ETF	114.9	114.94	114.8	114.81	25641.0
2016-07-27 18:00:00	QQQ	ETF	114.84	114.88	114.77	114.79	26030.0
2016-07-27 19:00:00	QQQ	ETF	114.79	114.84	114.78	114.82	5238.0
2016-07-27 07:00:00	IWM	ETF	121.01	121.02	120.88	121.0	12461.0
2016-07-27 08:00:00	IWM	ETF	121.0	121.08	120.9	121.08	60360.0
2016-07-27 09:00:00	IWM	ETF	121.08	121.41	120.98	121.39	1453084.0
2016-07-27 10:00:00	IWM	ETF	121.39	121.4675	120.6	120.94	2771605.0
2016-07-27 11:00:00	IWM	ETF	120.94	121.07	120.67	120.71	1677657.0
2016-07-27 12:00:00	IWM	ETF	120.71	120.76	120.53	120.64	1099950.0
2016-07-27 13:00:00	IWM	ETF	120.635	120.9	120.48	120.77	1122960.0
2016-07-27 14:00:00	IWM	ETF	120.8	120.95	120.35	120.92	3847147.0
2016-07-27 15:00:00	IWM	ETF	120.93	121.1709	120.88	121.1	3734865.0
2016-07-27 16:00:00	IWM	ETF	121.1	121.19	120.92	121.09	593671.0
2016-07-27 17:00:00	IWM	ETF	121.11	121.19	121.11	121.19	821.0
2016-07-27 04:00:00	DIA	ETF	185.03	185.08	185.03	185.08	1000.0
2016-07-27 07:00:00	DIA	ETF	184.78	185.05	184.78	185.05	11356.0
2016-07-27 08:00:00	DIA	ETF	185.12	185.12	184.89	185.12	4329.0
2016-07-27 09:00:00	DIA	ETF	185.18	185.28	185.06	185.22	325006.0
2016-07-27 10:00:00	DIA	ETF	185.25	185.28	184.54	184.6	308916.0
2016-07-27 11:00:00	DIA	ETF	184.6	184.73	184.3	184.34	251616.0
2016-07-27 12:00:00	DIA	ETF	184.33	184.5	184.24	184.37	169558.0

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

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