PREVIEW / etf_1hour / 2016-08-15

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-08-15.parquet
  size:    254 KB
  rows:    8,251

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-15 04:00:00	SPY	ETF	218.61	218.93	218.61	218.78	69985.0
2016-08-15 05:00:00	SPY	ETF	218.72	218.78	218.72	218.75	3000.0
2016-08-15 06:00:00	SPY	ETF	218.75	218.81	218.75	218.75	29025.0
2016-08-15 07:00:00	SPY	ETF	218.8	218.88	218.78	218.87	76108.0
2016-08-15 08:00:00	SPY	ETF	218.46	219.0	218.46	218.91	388400.0
2016-08-15 09:00:00	SPY	ETF	218.91	219.24	218.87	219.075	7594249.0
2016-08-15 10:00:00	SPY	ETF	219.08	219.47	219.06	219.39	6749606.0
2016-08-15 11:00:00	SPY	ETF	219.39	219.5	219.335	219.357	4565264.0
2016-08-15 12:00:00	SPY	ETF	219.36	219.49	219.34	219.39	3821342.0
2016-08-15 13:00:00	SPY	ETF	219.38	219.47	219.29	219.3501	3958224.0
2016-08-15 14:00:00	SPY	ETF	219.35	219.44	219.28	219.38	4807874.0
2016-08-15 15:00:00	SPY	ETF	219.38	219.41	219.065	219.125	10632656.0
2016-08-15 16:00:00	SPY	ETF	219.13	219.3767	219.0	219.0	4358807.0
2016-08-15 17:00:00	SPY	ETF	219.0	219.09	218.94	218.97	124780.0
2016-08-15 18:00:00	SPY	ETF	218.98	219.05	218.94	218.95	57355.0
2016-08-15 19:00:00	SPY	ETF	218.95	219.02	218.94	218.95	35101.0
2016-08-15 04:00:00	QQQ	ETF	117.48	117.48	117.48	117.48	100.0
2016-08-15 05:00:00	QQQ	ETF	117.4	117.42	117.4	117.42	2522.0
2016-08-15 06:00:00	QQQ	ETF	117.42	117.43	117.42	117.43	300.0
2016-08-15 07:00:00	QQQ	ETF	117.43	117.46	117.42	117.45	9519.0
2016-08-15 08:00:00	QQQ	ETF	117.43	117.47	117.41	117.41	37270.0
2016-08-15 09:00:00	QQQ	ETF	117.41	117.74	117.31	117.635	2069535.0
2016-08-15 10:00:00	QQQ	ETF	117.6399	117.87	117.59	117.82	1847404.0
2016-08-15 11:00:00	QQQ	ETF	117.821	117.94	117.81	117.86	970696.0
2016-08-15 12:00:00	QQQ	ETF	117.855	117.93	117.825	117.905	914214.0
2016-08-15 13:00:00	QQQ	ETF	117.9	117.97	117.84	117.87	738166.0
2016-08-15 14:00:00	QQQ	ETF	117.8657	117.88	117.79	117.83	716765.0
2016-08-15 15:00:00	QQQ	ETF	117.83	117.848	117.68	117.71	2174598.0
2016-08-15 16:00:00	QQQ	ETF	117.7	117.73	117.64	117.7	406083.0
2016-08-15 17:00:00	QQQ	ETF	117.66	117.66	117.65	117.65	1392.0
2016-08-15 18:00:00	QQQ	ETF	117.67	117.69	117.67	117.69	4400.0
2016-08-15 19:00:00	QQQ	ETF	117.7	117.7	117.66	117.66	7108.0
2016-08-15 04:00:00	IWM	ETF	122.44	122.44	122.44	122.44	100.0
2016-08-15 06:00:00	IWM	ETF	122.37	122.48	122.37	122.48	2458.0
2016-08-15 07:00:00	IWM	ETF	122.4	122.42	122.39	122.39	4600.0
2016-08-15 08:00:00	IWM	ETF	122.4	122.53	122.4	122.53	7580.0
2016-08-15 09:00:00	IWM	ETF	122.49	123.2	122.42	123.04	2822693.0
2016-08-15 10:00:00	IWM	ETF	123.05	123.47	123.05	123.35	2394323.0
2016-08-15 11:00:00	IWM	ETF	123.35	123.54	123.33	123.401	1657521.0
2016-08-15 12:00:00	IWM	ETF	123.41	123.67	123.405	123.59	1430844.0
2016-08-15 13:00:00	IWM	ETF	123.585	123.685	123.47	123.595	1063188.0
2016-08-15 14:00:00	IWM	ETF	123.595	123.66	123.44	123.55	1479953.0
2016-08-15 15:00:00	IWM	ETF	123.55	123.57	123.34	123.41	3355634.0
2016-08-15 16:00:00	IWM	ETF	123.4	123.45	123.32	123.38	1975734.0
2016-08-15 17:00:00	IWM	ETF	123.36	123.38	123.36	123.38	955.0
2016-08-15 18:00:00	IWM	ETF	123.36	123.45	123.36	123.36	5600.0
2016-08-15 19:00:00	IWM	ETF	123.43	123.45	123.38	123.38	2843.0
2016-08-15 04:00:00	DIA	ETF	186.2	186.2	186.2	186.2	126.0
2016-08-15 08:00:00	DIA	ETF	186.27	186.29	186.27	186.29	600.0
2016-08-15 09:00:00	DIA	ETF	186.35	186.74	186.33	186.64	304099.0

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

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