PREVIEW / etf_1hour / 2016-08-11

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-08-11.parquet
  size:    252 KB
  rows:    8,092

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-08-11 04:00:00	SPY	ETF	217.68	217.91	217.62	217.91	40555.0
2016-08-11 05:00:00	SPY	ETF	217.91	218.1	217.91	218.1	46985.0
2016-08-11 06:00:00	SPY	ETF	218.1	218.25	218.05	218.25	72953.0
2016-08-11 07:00:00	SPY	ETF	218.19	218.33	218.16	218.16	113863.0
2016-08-11 08:00:00	SPY	ETF	218.15	218.28	217.734	218.15	409599.0
2016-08-11 09:00:00	SPY	ETF	218.17	218.5	218.16	218.17	6740225.0
2016-08-11 10:00:00	SPY	ETF	218.17	218.67	217.95	218.52	10179073.0
2016-08-11 11:00:00	SPY	ETF	218.53	218.83	218.465	218.74	8959974.0
2016-08-11 12:00:00	SPY	ETF	218.75	218.77	218.63	218.71	4979271.0
2016-08-11 13:00:00	SPY	ETF	218.71	218.83	218.65	218.71	6770090.0
2016-08-11 14:00:00	SPY	ETF	218.71	218.91	218.54	218.665	9465844.0
2016-08-11 15:00:00	SPY	ETF	218.665	218.94	218.64	218.65	14264877.0
2016-08-11 16:00:00	SPY	ETF	218.65	218.68	218.44	218.6	5780080.0
2016-08-11 17:00:00	SPY	ETF	218.59	218.68	218.57	218.61	89306.0
2016-08-11 18:00:00	SPY	ETF	218.61	218.65	218.57	218.61	85593.0
2016-08-11 19:00:00	SPY	ETF	218.63	218.73	218.63	218.67	60693.0
2016-08-11 04:00:00	QQQ	ETF	116.73	116.79	116.73	116.79	700.0
2016-08-11 05:00:00	QQQ	ETF	116.85	116.98	116.85	116.98	31750.0
2016-08-11 06:00:00	QQQ	ETF	116.96	117.02	116.95	117.0	2900.0
2016-08-11 07:00:00	QQQ	ETF	116.99	117.05	116.98	116.98	22350.0
2016-08-11 08:00:00	QQQ	ETF	116.94	116.98	116.9	116.95	35352.0
2016-08-11 09:00:00	QQQ	ETF	116.96	117.37	116.96	117.1	2103561.0
2016-08-11 10:00:00	QQQ	ETF	117.09	117.16	116.78	117.04	1551740.0
2016-08-11 11:00:00	QQQ	ETF	117.05	117.21	116.97	117.18	632405.0
2016-08-11 12:00:00	QQQ	ETF	117.19	117.2	117.09	117.16	594796.0
2016-08-11 13:00:00	QQQ	ETF	117.16	117.26	117.12	117.18	554532.0
2016-08-11 14:00:00	QQQ	ETF	117.18	117.28	117.05	117.11	839415.0
2016-08-11 15:00:00	QQQ	ETF	117.105	117.3	117.1	117.12	1765661.0
2016-08-11 16:00:00	QQQ	ETF	117.11	117.16	117.03	117.13	970160.0
2016-08-11 17:00:00	QQQ	ETF	116.97	117.14	116.97	117.03	1454.0
2016-08-11 18:00:00	QQQ	ETF	117.1	117.14	117.1	117.14	7296.0
2016-08-11 19:00:00	QQQ	ETF	117.14	117.21	117.14	117.15	9589.0
2016-08-11 20:00:00	QQQ	ETF	117.1074	117.1074	117.1074	117.1074	550000.0
2016-08-11 06:00:00	IWM	ETF	121.93	121.93	121.84	121.93	1693.0
2016-08-11 07:00:00	IWM	ETF	121.95	122.0	121.91	121.91	72517.0
2016-08-11 08:00:00	IWM	ETF	121.89	121.93	121.84	121.88	164138.0
2016-08-11 09:00:00	IWM	ETF	121.9	122.259	121.83	121.88	2097819.0
2016-08-11 10:00:00	IWM	ETF	121.88	122.0	121.565	121.86	2683739.0
2016-08-11 11:00:00	IWM	ETF	121.86	122.33	121.82	122.321	1997936.0
2016-08-11 12:00:00	IWM	ETF	122.33	122.38	122.2	122.26	1225932.0
2016-08-11 13:00:00	IWM	ETF	122.265	122.32	122.145	122.24	860663.0
2016-08-11 14:00:00	IWM	ETF	122.24	122.4	122.14	122.22	1563341.0
2016-08-11 15:00:00	IWM	ETF	122.22	122.32	122.03	122.1	2991455.0
2016-08-11 16:00:00	IWM	ETF	122.09	122.18	122.05	122.1	872590.0
2016-08-11 17:00:00	IWM	ETF	122.1	122.1	122.08	122.08	400.0
2016-08-11 18:00:00	IWM	ETF	122.17	122.17	122.17	122.17	529.0
2016-08-11 19:00:00	IWM	ETF	122.15	122.17	122.11	122.15	800.0
2016-08-11 05:00:00	DIA	ETF	185.6	185.6	185.55	185.56	2900.0
2016-08-11 06:00:00	DIA	ETF	185.65	185.7	185.65	185.68	7700.0
2016-08-11 07:00:00	DIA	ETF	185.75	185.75	185.69	185.69	5200.0

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

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