PREVIEW / etf_1hour / 2016-09-07

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-09-07.parquet
  size:    252 KB
  rows:    8,151

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-09-07 04:00:00	SPY	ETF	219.03	219.15	218.97	219.0	4585.0
2016-09-07 05:00:00	SPY	ETF	218.97	219.06	218.93	218.93	7465.0
2016-09-07 06:00:00	SPY	ETF	218.92	218.93	218.86	218.86	2054.0
2016-09-07 07:00:00	SPY	ETF	218.85	218.86	218.76	218.77	53952.0
2016-09-07 08:00:00	SPY	ETF	218.79	219.011	218.67	218.88	353711.0
2016-09-07 09:00:00	SPY	ETF	218.86	219.09	218.69	218.962	5851470.0
2016-09-07 10:00:00	SPY	ETF	218.96	219.22	218.68	218.79	11625938.0
2016-09-07 11:00:00	SPY	ETF	218.78	218.87	218.51	218.685	10187678.0
2016-09-07 12:00:00	SPY	ETF	218.69	218.76	218.3	218.52	9509520.0
2016-09-07 13:00:00	SPY	ETF	218.52	218.81	218.46	218.71	7700922.0
2016-09-07 14:00:00	SPY	ETF	218.72	218.97	218.67	218.895	8802517.0
2016-09-07 15:00:00	SPY	ETF	218.895	219.07	218.87	219.06	15920671.0
2016-09-07 16:00:00	SPY	ETF	219.08	219.1529	218.98	219.03	3883550.0
2016-09-07 17:00:00	SPY	ETF	219.04	219.1	219.0	219.05	245089.0
2016-09-07 18:00:00	SPY	ETF	219.05	219.07	218.98	218.98	92160.0
2016-09-07 19:00:00	SPY	ETF	218.98	219.0	218.96	218.98	38241.0
2016-09-07 04:00:00	QQQ	ETF	117.98	118.03	117.98	118.03	610.0
2016-09-07 05:00:00	QQQ	ETF	117.97	117.97	117.97	117.97	100.0
2016-09-07 06:00:00	QQQ	ETF	117.98	117.99	117.94	117.94	10520.0
2016-09-07 07:00:00	QQQ	ETF	117.92	117.93	117.92	117.93	12696.0
2016-09-07 08:00:00	QQQ	ETF	117.9	117.94	117.88	117.94	15065.0
2016-09-07 09:00:00	QQQ	ETF	117.96	118.086	117.85	117.95	2324788.0
2016-09-07 10:00:00	QQQ	ETF	117.94	118.12	117.79	117.84	2613428.0
2016-09-07 11:00:00	QQQ	ETF	117.83	117.9	117.69	117.7899	1374399.0
2016-09-07 12:00:00	QQQ	ETF	117.79	117.8	117.47	117.6	1474475.0
2016-09-07 13:00:00	QQQ	ETF	117.6	117.73	117.57	117.675	1036598.0
2016-09-07 14:00:00	QQQ	ETF	117.68	117.79	117.6	117.71	1199989.0
2016-09-07 15:00:00	QQQ	ETF	117.71	117.93	117.7	117.93	3124328.0
2016-09-07 16:00:00	QQQ	ETF	117.93	117.93	117.84	117.88	575255.0
2016-09-07 17:00:00	QQQ	ETF	117.88	117.88	117.85	117.87	922.0
2016-09-07 18:00:00	QQQ	ETF	117.87	117.87	117.83	117.84	8499.0
2016-09-07 19:00:00	QQQ	ETF	117.8	117.88	117.8	117.88	4399.0
2016-09-07 05:00:00	IWM	ETF	124.71	124.71	124.71	124.71	216.0
2016-09-07 07:00:00	IWM	ETF	124.63	124.63	124.6	124.61	4949.0
2016-09-07 08:00:00	IWM	ETF	124.59	124.68	124.52	124.59	42514.0
2016-09-07 09:00:00	IWM	ETF	124.61	124.7699	124.48	124.72	1572682.0
2016-09-07 10:00:00	IWM	ETF	124.73	125.06	124.66	124.8	2657431.0
2016-09-07 11:00:00	IWM	ETF	124.8	124.9	124.72	124.86	1311394.0
2016-09-07 12:00:00	IWM	ETF	124.855	124.98	124.5699	124.92	1704510.0
2016-09-07 13:00:00	IWM	ETF	124.92	125.06	124.85	124.95	1500264.0
2016-09-07 14:00:00	IWM	ETF	124.955	125.12	124.87	125.1166	1428921.0
2016-09-07 15:00:00	IWM	ETF	125.12	125.44	125.09	125.4	3793986.0
2016-09-07 16:00:00	IWM	ETF	125.4	125.5	125.38	125.49	950298.0
2016-09-07 17:00:00	IWM	ETF	125.49	125.55	125.47	125.49	8680.0
2016-09-07 18:00:00	IWM	ETF	125.5	125.5	125.41	125.49	2739.0
2016-09-07 19:00:00	IWM	ETF	125.44	125.5	125.43	125.47	2200.0
2016-09-07 05:00:00	DIA	ETF	185.23	185.23	185.23	185.23	100.0
2016-09-07 09:00:00	DIA	ETF	185.28	185.39	185.1	185.26	250720.0
2016-09-07 10:00:00	DIA	ETF	185.26	185.4	184.98	185.0401	421152.0
2016-09-07 11:00:00	DIA	ETF	185.06	185.14	184.807	185.03	226657.0

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

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