PREVIEW / etf_1hour / 2017-03-17

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-03-17.parquet
  size:    268 KB
  rows:    8,729

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-17 04:00:00	SPY	ETF	237.42	237.43	237.28	237.4	13885.0
2017-03-17 05:00:00	SPY	ETF	237.4	237.53	237.4	237.47	6211.0
2017-03-17 06:00:00	SPY	ETF	237.45	237.59	237.44	237.57	9230.0
2017-03-17 07:00:00	SPY	ETF	237.57	237.74	237.48	237.55	146868.0
2017-03-17 08:00:00	SPY	ETF	237.48	237.87	237.45	237.85	629940.0
2017-03-17 09:00:00	SPY	ETF	237.84	238.48	237.46	237.5892	11656741.0
2017-03-17 10:00:00	SPY	ETF	237.59	237.65	237.3	237.39	12454155.0
2017-03-17 11:00:00	SPY	ETF	237.38	237.445	237.13	237.445	6697620.0
2017-03-17 12:00:00	SPY	ETF	237.445	237.605	237.43	237.48	6449180.0
2017-03-17 13:00:00	SPY	ETF	237.49	237.74	237.48	237.66	5146553.0
2017-03-17 14:00:00	SPY	ETF	237.67	237.97	237.65	237.66	7979899.0
2017-03-17 15:00:00	SPY	ETF	237.655	237.74	237.07	237.08	17117932.0
2017-03-17 16:00:00	SPY	ETF	237.06	238.2285	237.03	237.29	18306252.0
2017-03-17 17:00:00	SPY	ETF	237.27	237.32	237.01	237.14	1091710.0
2017-03-17 18:00:00	SPY	ETF	237.14	237.15	237.03	237.08	55526.0
2017-03-17 19:00:00	SPY	ETF	237.08	237.09	236.88	236.98	125315.0
2017-03-17 04:00:00	QQQ	ETF	131.77	131.79	131.72	131.74	2100.0
2017-03-17 05:00:00	QQQ	ETF	131.88	131.88	131.87	131.87	2998.0
2017-03-17 06:00:00	QQQ	ETF	131.87	131.91	131.85	131.91	1799.0
2017-03-17 07:00:00	QQQ	ETF	131.97	131.97	131.88	131.89	4055.0
2017-03-17 08:00:00	QQQ	ETF	131.92	132.03	131.85	132.01	170790.0
2017-03-17 09:00:00	QQQ	ETF	132.0	132.0	131.72	131.8101	3739656.0
2017-03-17 10:00:00	QQQ	ETF	131.8167	131.845	131.68	131.77	1560063.0
2017-03-17 11:00:00	QQQ	ETF	131.76	131.8	131.63	131.79	1342374.0
2017-03-17 12:00:00	QQQ	ETF	131.799	131.9	131.79	131.88	1306180.0
2017-03-17 13:00:00	QQQ	ETF	131.88	131.9799	131.87	131.9148	1136550.0
2017-03-17 14:00:00	QQQ	ETF	131.92	132.04	131.9	131.91	1122281.0
2017-03-17 15:00:00	QQQ	ETF	131.905	131.94	131.62	131.62	2617848.0
2017-03-17 16:00:00	QQQ	ETF	131.62	132.0029	131.59	132.0029	1979980.0
2017-03-17 17:00:00	QQQ	ETF	131.62	131.7	131.55	131.63	264148.0
2017-03-17 18:00:00	QQQ	ETF	131.65	131.65	131.58	131.62	11765.0
2017-03-17 19:00:00	QQQ	ETF	131.58	131.58	131.48	131.5	7319.0
2017-03-17 04:00:00	IWM	ETF	137.82	137.82	137.82	137.82	300.0
2017-03-17 06:00:00	IWM	ETF	138.0	138.12	138.0	138.12	1249.0
2017-03-17 07:00:00	IWM	ETF	138.14	138.14	137.88	138.02	20013.0
2017-03-17 08:00:00	IWM	ETF	137.92	138.31	137.89	138.3	85876.0
2017-03-17 09:00:00	IWM	ETF	138.29	138.38	137.49	137.94	2907073.0
2017-03-17 10:00:00	IWM	ETF	137.93	138.2	137.58	137.63	2293971.0
2017-03-17 11:00:00	IWM	ETF	137.62	137.905	137.31	137.88	2662804.0
2017-03-17 12:00:00	IWM	ETF	137.885	138.31	137.87	138.3	2084235.0
2017-03-17 13:00:00	IWM	ETF	138.31	138.39	138.17	138.24	1314732.0
2017-03-17 14:00:00	IWM	ETF	138.24	138.49	138.23	138.4	2043137.0
2017-03-17 15:00:00	IWM	ETF	138.405	138.73	138.23	138.41	5825852.0
2017-03-17 16:00:00	IWM	ETF	138.41	138.84	137.98	138.57	7595979.0
2017-03-17 17:00:00	IWM	ETF	138.58	138.58	138.41	138.41	26932.0
2017-03-17 18:00:00	IWM	ETF	138.46	138.46	138.46	138.46	2865.0
2017-03-17 19:00:00	IWM	ETF	138.46	138.46	138.41	138.41	1500.0
2017-03-17 04:00:00	DIA	ETF	209.05	209.05	209.05	209.05	100.0
2017-03-17 08:00:00	DIA	ETF	209.16	209.38	209.16	209.38	4055.0
2017-03-17 09:00:00	DIA	ETF	209.44	209.53	209.09	209.195	185032.0

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

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