PREVIEW / etf_1hour / 2017-02-02

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-02-02.parquet
  size:    276 KB
  rows:    8,930

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
2017-02-02 04:00:00	SPY	ETF	227.04	227.08	226.75	226.83	7476.0
2017-02-02 05:00:00	SPY	ETF	226.77	226.91	226.68	226.89	72551.0
2017-02-02 06:00:00	SPY	ETF	226.93	227.09	226.9	227.02	5937.0
2017-02-02 07:00:00	SPY	ETF	227.0	227.26	226.94	227.15	99646.0
2017-02-02 08:00:00	SPY	ETF	227.15	227.18	226.839	226.98	361509.0
2017-02-02 09:00:00	SPY	ETF	226.95	227.43	226.82	227.42	10079994.0
2017-02-02 10:00:00	SPY	ETF	227.41	228.01	227.24	227.99	11842644.0
2017-02-02 11:00:00	SPY	ETF	227.99	228.1	227.19	227.23	9358515.0
2017-02-02 12:00:00	SPY	ETF	227.2301	227.79	227.16	227.6959	7649527.0
2017-02-02 13:00:00	SPY	ETF	227.69	227.88	227.37	227.78	4991364.0
2017-02-02 14:00:00	SPY	ETF	227.78	227.79	227.18	227.36	6861952.0
2017-02-02 15:00:00	SPY	ETF	227.3511	227.83	227.29	227.77	12636786.0
2017-02-02 16:00:00	SPY	ETF	227.77	227.82	227.54	227.58	3106575.0
2017-02-02 17:00:00	SPY	ETF	227.57	227.69	227.45	227.5	2068952.0
2017-02-02 18:00:00	SPY	ETF	227.5	227.69	227.5	227.58	93440.0
2017-02-02 19:00:00	SPY	ETF	227.56	227.62	227.5	227.62	33429.0
2017-02-02 04:00:00	QQQ	ETF	124.99	124.99	124.92	124.96	1150.0
2017-02-02 05:00:00	QQQ	ETF	124.93	124.99	124.92	124.99	5905.0
2017-02-02 06:00:00	QQQ	ETF	125.02	125.11	125.01	125.06	2329.0
2017-02-02 07:00:00	QQQ	ETF	125.08	125.25	125.08	125.21	11754.0
2017-02-02 08:00:00	QQQ	ETF	125.15	125.23	125.11	125.18	57280.0
2017-02-02 09:00:00	QQQ	ETF	125.17	125.58	124.86	125.56	3617380.0
2017-02-02 10:00:00	QQQ	ETF	125.56	125.66	125.34	125.635	2042919.0
2017-02-02 11:00:00	QQQ	ETF	125.64	125.7	125.13	125.15	1573838.0
2017-02-02 12:00:00	QQQ	ETF	125.14	125.4	125.09	125.28	1137290.0
2017-02-02 13:00:00	QQQ	ETF	125.29	125.4	125.14	125.33	1079364.0
2017-02-02 14:00:00	QQQ	ETF	125.32	125.339	125.06	125.19	1210422.0
2017-02-02 15:00:00	QQQ	ETF	125.19	125.4	125.17	125.32	2103056.0
2017-02-02 16:00:00	QQQ	ETF	125.33	125.34	124.94	125.01	672825.0
2017-02-02 17:00:00	QQQ	ETF	125.05	125.06	124.97	124.97	18909.0
2017-02-02 18:00:00	QQQ	ETF	125.0	125.08	124.96	124.99	18721.0
2017-02-02 19:00:00	QQQ	ETF	124.97	125.05	124.97	125.03	25967.0
2017-02-02 04:00:00	IWM	ETF	134.63	134.63	134.41	134.52	1769.0
2017-02-02 05:00:00	IWM	ETF	134.48	134.48	134.48	134.48	100.0
2017-02-02 06:00:00	IWM	ETF	134.71	134.71	134.71	134.71	2000.0
2017-02-02 07:00:00	IWM	ETF	134.68	134.89	134.68	134.86	42060.0
2017-02-02 08:00:00	IWM	ETF	134.83	134.99	134.68	134.92	30633.0
2017-02-02 09:00:00	IWM	ETF	134.94	135.34	134.5	134.98	2274306.0
2017-02-02 10:00:00	IWM	ETF	134.98	135.55	134.765	135.54	2500052.0
2017-02-02 11:00:00	IWM	ETF	135.54	135.67	134.62	134.655	2647277.0
2017-02-02 12:00:00	IWM	ETF	134.6533	135.12	134.54	135.04	1829778.0
2017-02-02 13:00:00	IWM	ETF	135.04	135.0767	134.66	134.96	1635728.0
2017-02-02 14:00:00	IWM	ETF	134.97	134.99	134.49	134.61	1971170.0
2017-02-02 15:00:00	IWM	ETF	134.62	134.89	134.56	134.76	3650796.0
2017-02-02 16:00:00	IWM	ETF	134.81	135.2472	134.55	134.55	1112122.0
2017-02-02 17:00:00	IWM	ETF	134.59	135.2	134.58	134.7	470928.0
2017-02-02 18:00:00	IWM	ETF	134.71	134.81	134.71	134.71	14080.0
2017-02-02 19:00:00	IWM	ETF	134.79	134.8	134.71	134.73	2724.0
2017-02-02 04:00:00	DIA	ETF	198.14	198.14	197.99	197.99	550.0
2017-02-02 07:00:00	DIA	ETF	198.2	198.2	198.2	198.2	100.0

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

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