PREVIEW / etf_1hour / 2017-10-24

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-10-24.parquet
  size:    285 KB
  rows:    9,463

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-10-24 04:00:00	SPY	ETF	256.25	256.26	256.1	256.21	6989.0
2017-10-24 05:00:00	SPY	ETF	256.29	256.41	256.25	256.41	14118.0
2017-10-24 06:00:00	SPY	ETF	256.39	256.54	256.39	256.42	24158.0
2017-10-24 07:00:00	SPY	ETF	256.44	256.69	256.37	256.57	244230.0
2017-10-24 08:00:00	SPY	ETF	256.55	256.72	256.47	256.65	514677.0
2017-10-24 09:00:00	SPY	ETF	256.62	256.74	256.15	256.16	5576391.0
2017-10-24 10:00:00	SPY	ETF	256.165	256.55	256.15	256.48	10676348.0
2017-10-24 11:00:00	SPY	ETF	256.47	256.69	256.47	256.6099	7451840.0
2017-10-24 12:00:00	SPY	ETF	256.61	256.68	256.545	256.585	4401733.0
2017-10-24 13:00:00	SPY	ETF	256.59	256.71	256.51	256.64	4572238.0
2017-10-24 14:00:00	SPY	ETF	256.65	256.83	256.51	256.58	5833643.0
2017-10-24 15:00:00	SPY	ETF	256.59	256.675	256.27	256.55	14668174.0
2017-10-24 16:00:00	SPY	ETF	256.53	256.57	256.26	256.3	7171190.0
2017-10-24 17:00:00	SPY	ETF	256.31	256.4	256.3	256.32	130819.0
2017-10-24 18:00:00	SPY	ETF	256.32	256.4979	256.19	256.21	1821835.0
2017-10-24 19:00:00	SPY	ETF	256.22	256.3	256.15	256.3	17700.0
2017-10-24 04:00:00	QQQ	ETF	147.7	147.7	147.7	147.7	10000.0
2017-10-24 05:00:00	QQQ	ETF	147.76	147.84	147.75	147.76	22897.0
2017-10-24 06:00:00	QQQ	ETF	147.75	147.88	147.75	147.78	9396.0
2017-10-24 07:00:00	QQQ	ETF	147.81	147.91	147.76	147.83	47813.0
2017-10-24 08:00:00	QQQ	ETF	147.84	148.08	147.83	148.02	225568.0
2017-10-24 09:00:00	QQQ	ETF	148.01	148.06	147.44	147.54	3369236.0
2017-10-24 10:00:00	QQQ	ETF	147.55	148.08	147.53	147.99	1970561.0
2017-10-24 11:00:00	QQQ	ETF	147.994	148.21	147.98	148.12	1458369.0
2017-10-24 12:00:00	QQQ	ETF	148.11	148.17	148.02	148.0301	958763.0
2017-10-24 13:00:00	QQQ	ETF	148.04	148.3	147.97	148.1828	1185752.0
2017-10-24 14:00:00	QQQ	ETF	148.19	148.28	148.02	148.05	918219.0
2017-10-24 15:00:00	QQQ	ETF	148.06	148.13	147.84	148.02	3296637.0
2017-10-24 16:00:00	QQQ	ETF	148.02	148.06	147.84	147.85	400461.0
2017-10-24 17:00:00	QQQ	ETF	147.81	147.9	147.7	147.82	13294.0
2017-10-24 18:00:00	QQQ	ETF	147.77	147.88	147.77	147.86	16795.0
2017-10-24 19:00:00	QQQ	ETF	147.82	147.9	147.8	147.89	6600.0
2017-10-24 04:00:00	IWM	ETF	148.88	148.91	148.8	148.8	4566.0
2017-10-24 05:00:00	IWM	ETF	148.93	148.93	148.93	148.93	9600.0
2017-10-24 06:00:00	IWM	ETF	149.03	149.1	149.02	149.1	8794.0
2017-10-24 07:00:00	IWM	ETF	149.07	149.33	149.07	149.3	74382.0
2017-10-24 08:00:00	IWM	ETF	149.24	149.4	149.13	149.39	44198.0
2017-10-24 09:00:00	IWM	ETF	149.35	149.695	149.16	149.2	2565367.0
2017-10-24 10:00:00	IWM	ETF	149.2	149.78	149.17	149.44	2277733.0
2017-10-24 11:00:00	IWM	ETF	149.44	149.54	149.2042	149.275	929376.0
2017-10-24 12:00:00	IWM	ETF	149.275	149.54	149.2625	149.44	765186.0
2017-10-24 13:00:00	IWM	ETF	149.45	149.65	149.38	149.63	1283566.0
2017-10-24 14:00:00	IWM	ETF	149.62	149.7051	149.48	149.515	1395037.0
2017-10-24 15:00:00	IWM	ETF	149.53	149.58	149.0401	149.17	2466968.0
2017-10-24 16:00:00	IWM	ETF	149.17	149.4562	148.96	148.99	640793.0
2017-10-24 17:00:00	IWM	ETF	148.97	148.97	148.97	148.97	300.0
2017-10-24 18:00:00	IWM	ETF	148.97	148.97	148.97	148.97	3600.0
2017-10-24 19:00:00	IWM	ETF	148.9	148.95	148.9	148.94	3464.0
2017-10-24 07:00:00	DIA	ETF	233.15	234.21	233.15	234.18	19526.0
2017-10-24 08:00:00	DIA	ETF	233.5	234.13	233.5	234.11	45603.0

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

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