PREVIEW / etf_1hour / 2016-09-28

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-09-28.parquet
  size:    253 KB
  rows:    8,075

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-28 04:00:00	SPY	ETF	215.76	216.08	215.76	215.89	42530.0
2016-09-28 05:00:00	SPY	ETF	215.81	215.81	215.1	215.26	38395.0
2016-09-28 06:00:00	SPY	ETF	215.24	215.6	215.21	215.56	97544.0
2016-09-28 07:00:00	SPY	ETF	215.55	215.75	215.47	215.59	174016.0
2016-09-28 08:00:00	SPY	ETF	215.59	215.72	215.08	215.51	441067.0
2016-09-28 09:00:00	SPY	ETF	215.51	216.0	215.51	215.78	7284741.0
2016-09-28 10:00:00	SPY	ETF	215.785	215.97	214.97	215.0894	11437715.0
2016-09-28 11:00:00	SPY	ETF	215.08	215.28	214.71	215.22	9467724.0
2016-09-28 12:00:00	SPY	ETF	215.22	215.41	214.965	215.25	5442628.0
2016-09-28 13:00:00	SPY	ETF	215.24	215.67	215.03	215.56	7213114.0
2016-09-28 14:00:00	SPY	ETF	215.555	216.6	215.46	216.47	17547356.0
2016-09-28 15:00:00	SPY	ETF	216.47	216.82	216.145	216.68	19295697.0
2016-09-28 16:00:00	SPY	ETF	216.69	216.7	215.5643	216.56	6131532.0
2016-09-28 17:00:00	SPY	ETF	216.56	216.58	215.28	216.53	326587.0
2016-09-28 18:00:00	SPY	ETF	216.53	216.64	216.48	216.53	196946.0
2016-09-28 19:00:00	SPY	ETF	216.54	216.71	216.48	216.63	105491.0
2016-09-28 04:00:00	QQQ	ETF	118.71	118.77	118.68	118.68	3106.0
2016-09-28 05:00:00	QQQ	ETF	118.64	118.64	118.25	118.35	24648.0
2016-09-28 06:00:00	QQQ	ETF	118.51	118.54	118.47	118.53	15200.0
2016-09-28 07:00:00	QQQ	ETF	118.5	118.61	118.46	118.5	14450.0
2016-09-28 08:00:00	QQQ	ETF	118.53	118.61	118.48	118.5	112279.0
2016-09-28 09:00:00	QQQ	ETF	118.53	118.67	118.5	118.57	1716066.0
2016-09-28 10:00:00	QQQ	ETF	118.57	118.72	118.24	118.29	1915357.0
2016-09-28 11:00:00	QQQ	ETF	118.28	118.38	118.09	118.36	1815684.0
2016-09-28 12:00:00	QQQ	ETF	118.36	118.42	118.2	118.362	997125.0
2016-09-28 13:00:00	QQQ	ETF	118.355	118.56	118.22	118.48	895825.0
2016-09-28 14:00:00	QQQ	ETF	118.47	118.7	118.39	118.64	2275278.0
2016-09-28 15:00:00	QQQ	ETF	118.6499	118.77	118.47	118.705	3335906.0
2016-09-28 16:00:00	QQQ	ETF	118.7	118.73	118.63	118.66	486838.0
2016-09-28 17:00:00	QQQ	ETF	118.61	118.64	118.61	118.61	923.0
2016-09-28 18:00:00	QQQ	ETF	118.61	118.63	118.61	118.62	7694.0
2016-09-28 19:00:00	QQQ	ETF	118.61	118.74	118.61	118.7	12021.0
2016-09-28 04:00:00	IWM	ETF	123.89	123.89	123.89	123.89	8000.0
2016-09-28 06:00:00	IWM	ETF	123.79	123.83	123.79	123.83	1206.0
2016-09-28 07:00:00	IWM	ETF	123.82	123.86	123.78	123.79	5131.0
2016-09-28 08:00:00	IWM	ETF	123.81	123.89	123.75	123.75	68798.0
2016-09-28 09:00:00	IWM	ETF	123.91	124.34	123.86	124.28	1883296.0
2016-09-28 10:00:00	IWM	ETF	124.28	124.49	123.42	123.46	3207603.0
2016-09-28 11:00:00	IWM	ETF	123.45	123.5	123.07	123.5	1961226.0
2016-09-28 12:00:00	IWM	ETF	123.5	123.82	123.32	123.68	1427032.0
2016-09-28 13:00:00	IWM	ETF	123.67	123.98	123.49	123.87	828684.0
2016-09-28 14:00:00	IWM	ETF	123.87	124.45	123.775	124.36	3226751.0
2016-09-28 15:00:00	IWM	ETF	124.37	124.76	124.27	124.69	4101170.0
2016-09-28 16:00:00	IWM	ETF	124.68	124.75	124.57	124.65	1172798.0
2016-09-28 17:00:00	IWM	ETF	124.69	124.72	124.64	124.72	10365.0
2016-09-28 18:00:00	IWM	ETF	124.68	124.68	124.6	124.6	208440.0
2016-09-28 19:00:00	IWM	ETF	124.68	124.68	124.61	124.61	1816.0
2016-09-28 07:00:00	DIA	ETF	182.0	182.0	182.0	182.0	400.0
2016-09-28 08:00:00	DIA	ETF	182.12	182.25	182.12	182.25	600.0
2016-09-28 09:00:00	DIA	ETF	182.03	182.56	182.03	182.38	309639.0

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

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