PREVIEW / etf_1hour / 2016-11-04

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-11-04.parquet
  size:    262 KB
  rows:    8,424

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-04 04:00:00	SPY	ETF	209.0	209.1	208.75	208.97	5024.0
2016-11-04 05:00:00	SPY	ETF	208.72	209.0	208.55	208.74	10780.0
2016-11-04 06:00:00	SPY	ETF	208.78	208.89	208.63	208.78	23688.0
2016-11-04 07:00:00	SPY	ETF	208.75	208.85	208.67	208.8	130670.0
2016-11-04 08:00:00	SPY	ETF	208.82	209.32	208.5	209.14	1335858.0
2016-11-04 09:00:00	SPY	ETF	209.15	209.25	208.38	208.51	11599740.0
2016-11-04 10:00:00	SPY	ETF	208.58	209.4399	208.4792	209.27	15524730.0
2016-11-04 11:00:00	SPY	ETF	209.27	209.7	209.22	209.41	15572351.0
2016-11-04 12:00:00	SPY	ETF	209.415	209.89	209.4	209.775	9408107.0
2016-11-04 13:00:00	SPY	ETF	209.78	209.88	209.59	209.71	7140630.0
2016-11-04 14:00:00	SPY	ETF	209.715	209.75	209.14	209.21	7972816.0
2016-11-04 15:00:00	SPY	ETF	209.21	209.21	208.405	208.52	27810155.0
2016-11-04 16:00:00	SPY	ETF	208.52	209.5959	208.38	208.66	8445368.0
2016-11-04 17:00:00	SPY	ETF	208.64	208.67	208.11	208.15	1630321.0
2016-11-04 18:00:00	SPY	ETF	208.14	208.39	208.12	208.32	54066.0
2016-11-04 19:00:00	SPY	ETF	208.32	208.44	208.3	208.44	68665.0
2016-11-04 04:00:00	QQQ	ETF	113.95	113.95	113.95	113.95	680.0
2016-11-04 05:00:00	QQQ	ETF	114.04	114.04	114.04	114.04	1000.0
2016-11-04 06:00:00	QQQ	ETF	113.88	113.88	113.88	113.88	174.0
2016-11-04 07:00:00	QQQ	ETF	113.9	114.03	113.9	114.03	34535.0
2016-11-04 08:00:00	QQQ	ETF	114.04	114.19	113.87	114.14	129802.0
2016-11-04 09:00:00	QQQ	ETF	114.06	114.26	113.45	113.69	6492975.0
2016-11-04 10:00:00	QQQ	ETF	113.7	114.34	113.6608	114.22	4411586.0
2016-11-04 11:00:00	QQQ	ETF	114.23	114.45	114.12	114.26	2346944.0
2016-11-04 12:00:00	QQQ	ETF	114.25	114.51	114.25	114.5	1635420.0
2016-11-04 13:00:00	QQQ	ETF	114.51	114.54	114.33	114.38	1391342.0
2016-11-04 14:00:00	QQQ	ETF	114.371	114.38	113.95	114.01	1875799.0
2016-11-04 15:00:00	QQQ	ETF	113.99	114.0012	113.56	113.63	4388110.0
2016-11-04 16:00:00	QQQ	ETF	113.63	113.76	113.59	113.69	941503.0
2016-11-04 17:00:00	QQQ	ETF	113.71	113.72	113.6	113.6	1264325.0
2016-11-04 18:00:00	QQQ	ETF	113.55	113.64	113.55	113.64	16457.0
2016-11-04 19:00:00	QQQ	ETF	113.6	113.64	113.58	113.6	16976.0
2016-11-04 04:00:00	IWM	ETF	115.06	115.06	115.03	115.03	1395.0
2016-11-04 06:00:00	IWM	ETF	114.84	114.84	114.84	114.84	1000.0
2016-11-04 07:00:00	IWM	ETF	114.9	114.98	114.84	114.95	18488.0
2016-11-04 08:00:00	IWM	ETF	114.93	115.3	114.83	115.28	152793.0
2016-11-04 09:00:00	IWM	ETF	115.28	115.67	115.1	115.33	2949992.0
2016-11-04 10:00:00	IWM	ETF	115.35	116.04	115.31	116.021	4373151.0
2016-11-04 11:00:00	IWM	ETF	116.02	116.365	115.97	116.22	4478642.0
2016-11-04 12:00:00	IWM	ETF	116.21	116.77	116.205	116.73	2501006.0
2016-11-04 13:00:00	IWM	ETF	116.7301	116.9	116.65	116.73	2347660.0
2016-11-04 14:00:00	IWM	ETF	116.73	116.74	116.06	116.15	3335176.0
2016-11-04 15:00:00	IWM	ETF	116.15	116.15	115.66	115.75	6016780.0
2016-11-04 16:00:00	IWM	ETF	115.74	115.94	115.66	115.86	3757473.0
2016-11-04 17:00:00	IWM	ETF	115.77	115.79	115.66	115.66	622933.0
2016-11-04 18:00:00	IWM	ETF	115.45	115.71	115.45	115.71	1299.0
2016-11-04 19:00:00	IWM	ETF	115.71	115.74	115.69	115.7	1497.0
2016-11-04 07:00:00	DIA	ETF	179.0	179.0	179.0	179.0	500.0
2016-11-04 08:00:00	DIA	ETF	178.95	179.19	178.95	179.19	3090.0
2016-11-04 09:00:00	DIA	ETF	179.2	179.21	178.64	178.77	545819.0

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

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