PREVIEW / etf_1hour / 2017-07-19

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-07-19.parquet
  size:    278 KB
  rows:    9,142

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-07-19 04:00:00	SPY	ETF	245.91	245.91	245.78	245.83	1401.0
2017-07-19 05:00:00	SPY	ETF	245.82	245.85	245.82	245.83	13530.0
2017-07-19 06:00:00	SPY	ETF	245.83	245.83	245.76	245.76	13504.0
2017-07-19 07:00:00	SPY	ETF	245.75	245.82	245.72	245.76	18372.0
2017-07-19 08:00:00	SPY	ETF	245.8	245.98	245.75	245.9	267362.0
2017-07-19 09:00:00	SPY	ETF	245.89	246.39	245.88	246.38	4433310.0
2017-07-19 10:00:00	SPY	ETF	246.38	246.525	246.14	246.34	5733640.0
2017-07-19 11:00:00	SPY	ETF	246.345	246.6	246.31	246.52	6516330.0
2017-07-19 12:00:00	SPY	ETF	246.525	246.665	246.52	246.58	6234594.0
2017-07-19 13:00:00	SPY	ETF	246.58	246.79	246.565	246.72	2596924.0
2017-07-19 14:00:00	SPY	ETF	246.72	246.84	246.7	246.79	3460331.0
2017-07-19 15:00:00	SPY	ETF	246.8	247.0	246.77	246.99	10597982.0
2017-07-19 16:00:00	SPY	ETF	246.98	247.04	246.94	246.99	7831297.0
2017-07-19 17:00:00	SPY	ETF	246.99	247.02	246.94	246.99	83890.0
2017-07-19 18:00:00	SPY	ETF	246.96	246.96	246.82	246.84	104812.0
2017-07-19 19:00:00	SPY	ETF	246.85	246.92	246.82	246.92	37682.0
2017-07-19 04:00:00	QQQ	ETF	143.51	143.58	143.48	143.58	15620.0
2017-07-19 05:00:00	QQQ	ETF	143.55	143.6	143.55	143.6	1807.0
2017-07-19 06:00:00	QQQ	ETF	143.56	143.56	143.47	143.48	3651.0
2017-07-19 07:00:00	QQQ	ETF	143.51	143.53	143.42	143.43	28072.0
2017-07-19 08:00:00	QQQ	ETF	143.44	143.62	143.4	143.56	109905.0
2017-07-19 09:00:00	QQQ	ETF	143.6	143.9	143.5	143.7999	4393116.0
2017-07-19 10:00:00	QQQ	ETF	143.79	143.88	143.505	143.715	5217646.0
2017-07-19 11:00:00	QQQ	ETF	143.72	144.01	143.7	144.0	2251305.0
2017-07-19 12:00:00	QQQ	ETF	144.0	144.15	143.96	144.03	1676907.0
2017-07-19 13:00:00	QQQ	ETF	144.02	144.19	144.02	144.04	1727949.0
2017-07-19 14:00:00	QQQ	ETF	144.04	144.17	144.017	144.055	2472370.0
2017-07-19 15:00:00	QQQ	ETF	144.06	144.12	143.88	143.98	7684656.0
2017-07-19 16:00:00	QQQ	ETF	143.98	144.05	143.6658	144.05	3602705.0
2017-07-19 17:00:00	QQQ	ETF	144.0	144.07	144.0	144.05	3999.0
2017-07-19 18:00:00	QQQ	ETF	144.04	144.06	144.01	144.02	3846.0
2017-07-19 19:00:00	QQQ	ETF	143.99	144.05	143.98	144.05	3217.0
2017-07-19 04:00:00	IWM	ETF	141.61	141.61	141.59	141.59	200.0
2017-07-19 07:00:00	IWM	ETF	141.57	141.6	141.55	141.59	8100.0
2017-07-19 08:00:00	IWM	ETF	141.56	141.78	141.56	141.71	38140.0
2017-07-19 09:00:00	IWM	ETF	141.74	142.5	141.74	142.4499	1724881.0
2017-07-19 10:00:00	IWM	ETF	142.45	142.91	142.45	142.51	3785621.0
2017-07-19 11:00:00	IWM	ETF	142.53	142.93	142.53	142.82	1895600.0
2017-07-19 12:00:00	IWM	ETF	142.83	143.0083	142.65	142.7899	1161060.0
2017-07-19 13:00:00	IWM	ETF	142.78	143.0947	142.78	143.04	937951.0
2017-07-19 14:00:00	IWM	ETF	143.04	143.1	142.97	142.97	1104746.0
2017-07-19 15:00:00	IWM	ETF	142.97	143.14	142.9501	143.13	3694148.0
2017-07-19 16:00:00	IWM	ETF	143.12	143.25	142.997	143.1	1364713.0
2017-07-19 17:00:00	IWM	ETF	143.13	143.2	143.1	143.13	7675.0
2017-07-19 18:00:00	IWM	ETF	143.12	143.2	143.09	143.2	2797.0
2017-07-19 19:00:00	IWM	ETF	143.18	143.2	143.18	143.2	5637.0
2017-07-19 08:00:00	DIA	ETF	215.71	215.71	215.71	215.71	5000.0
2017-07-19 09:00:00	DIA	ETF	215.87	215.89	215.66	215.86	240435.0
2017-07-19 10:00:00	DIA	ETF	215.85	216.05	215.74	215.91	412084.0
2017-07-19 11:00:00	DIA	ETF	215.94	216.13	215.9	215.97	159753.0

> showing 50 of 9,142 rows — these rows as CSV

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