PREVIEW / etf_1hour / 2017-03-08

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-03-08.parquet
  size:    278 KB
  rows:    8,959

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-03-08 04:00:00	SPY	ETF	236.84	236.94	236.84	236.94	6025.0
2017-03-08 05:00:00	SPY	ETF	236.96	237.04	236.92	236.92	4275.0
2017-03-08 06:00:00	SPY	ETF	236.92	236.94	236.73	236.78	9433.0
2017-03-08 07:00:00	SPY	ETF	236.78	237.18	236.75	237.03	356998.0
2017-03-08 08:00:00	SPY	ETF	237.01	237.21	236.77	237.18	807289.0
2017-03-08 09:00:00	SPY	ETF	237.18	237.64	237.14	237.4	6308475.0
2017-03-08 10:00:00	SPY	ETF	237.4	237.53	237.06	237.43	7468435.0
2017-03-08 11:00:00	SPY	ETF	237.43	237.54	236.88	237.04	7522254.0
2017-03-08 12:00:00	SPY	ETF	237.05	237.28	236.96	237.21	5355102.0
2017-03-08 13:00:00	SPY	ETF	237.205	237.5	237.16	237.32	6190126.0
2017-03-08 14:00:00	SPY	ETF	237.32	237.34	236.7	237.05	9475516.0
2017-03-08 15:00:00	SPY	ETF	237.04	237.14	236.4	236.59	18239951.0
2017-03-08 16:00:00	SPY	ETF	236.59	237.1367	236.56	236.56	11495606.0
2017-03-08 17:00:00	SPY	ETF	236.64	236.69	236.55	236.67	1553458.0
2017-03-08 18:00:00	SPY	ETF	236.67	236.82	236.6	236.76	134196.0
2017-03-08 19:00:00	SPY	ETF	236.74	236.84	236.71	236.73	73744.0
2017-03-08 04:00:00	QQQ	ETF	130.5	130.5	130.5	130.5	105.0
2017-03-08 05:00:00	QQQ	ETF	130.56	130.56	130.55	130.55	19399.0
2017-03-08 06:00:00	QQQ	ETF	130.5	130.5	130.42	130.43	22500.0
2017-03-08 07:00:00	QQQ	ETF	130.41	130.56	130.41	130.53	32029.0
2017-03-08 08:00:00	QQQ	ETF	130.53	130.56	130.34	130.51	87418.0
2017-03-08 09:00:00	QQQ	ETF	130.54	130.955	130.46	130.94	1842829.0
2017-03-08 10:00:00	QQQ	ETF	130.94	131.07	130.76	131.02	2229824.0
2017-03-08 11:00:00	QQQ	ETF	131.02	131.15	130.62	130.7499	1864089.0
2017-03-08 12:00:00	QQQ	ETF	130.75	130.915	130.6899	130.9	1155619.0
2017-03-08 13:00:00	QQQ	ETF	130.89	131.08	130.87	131.0	1042719.0
2017-03-08 14:00:00	QQQ	ETF	130.9939	131.05	130.64	130.8195	1652824.0
2017-03-08 15:00:00	QQQ	ETF	130.815	130.9	130.56	130.73	2898472.0
2017-03-08 16:00:00	QQQ	ETF	130.73	130.82	130.72	130.81	1238063.0
2017-03-08 17:00:00	QQQ	ETF	130.8	130.85	130.76	130.8	6560.0
2017-03-08 18:00:00	QQQ	ETF	130.79	130.83	130.77	130.77	6028.0
2017-03-08 19:00:00	QQQ	ETF	130.85	130.85	130.82	130.82	11951.0
2017-03-08 04:00:00	IWM	ETF	136.8	136.8	136.8	136.8	200.0
2017-03-08 05:00:00	IWM	ETF	136.84	136.85	136.81	136.81	5000.0
2017-03-08 06:00:00	IWM	ETF	136.8	136.8	136.61	136.61	1300.0
2017-03-08 07:00:00	IWM	ETF	136.6	136.93	136.6	136.86	223810.0
2017-03-08 08:00:00	IWM	ETF	136.72	137.21	136.72	137.15	328265.0
2017-03-08 09:00:00	IWM	ETF	137.16	137.62	137.04	137.2	3602928.0
2017-03-08 10:00:00	IWM	ETF	137.19	137.26	136.65	136.95	3483420.0
2017-03-08 11:00:00	IWM	ETF	136.95	137.09	136.32	136.51	2781662.0
2017-03-08 12:00:00	IWM	ETF	136.51	136.815	136.42	136.62	2244842.0
2017-03-08 13:00:00	IWM	ETF	136.61	137.06	136.57	136.76	1526246.0
2017-03-08 14:00:00	IWM	ETF	136.77	136.79	136.33	136.56	2144091.0
2017-03-08 15:00:00	IWM	ETF	136.55	136.72	135.78	135.86	6973417.0
2017-03-08 16:00:00	IWM	ETF	135.9	136.05	135.71	135.73	2140614.0
2017-03-08 17:00:00	IWM	ETF	135.75	135.9	135.73	135.79	5132.0
2017-03-08 18:00:00	IWM	ETF	135.8	135.93	135.76	135.93	9337.0
2017-03-08 19:00:00	IWM	ETF	135.94	135.95	135.9	135.9	6232.0
2017-03-08 06:00:00	DIA	ETF	209.01	209.01	209.01	209.01	100.0
2017-03-08 07:00:00	DIA	ETF	209.02	209.02	209.02	209.02	900.0

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

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