PREVIEW / etf_1hour / 2017-01-24

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-01-24.parquet
  size:    282 KB
  rows:    8,988

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-01-24 04:00:00	SPY	ETF	226.14	226.36	226.11	226.29	22912.0
2017-01-24 05:00:00	SPY	ETF	226.36	226.49	226.36	226.44	5600.0
2017-01-24 06:00:00	SPY	ETF	226.34	226.34	226.2	226.25	7525.0
2017-01-24 07:00:00	SPY	ETF	226.26	226.26	226.2	226.25	16275.0
2017-01-24 08:00:00	SPY	ETF	226.21	226.46	226.2	226.45	180339.0
2017-01-24 09:00:00	SPY	ETF	226.41	226.58	226.28	226.445	5397422.0
2017-01-24 10:00:00	SPY	ETF	226.45	226.65	226.27	226.579	5429960.0
2017-01-24 11:00:00	SPY	ETF	226.575	226.95	226.52	226.89	7815601.0
2017-01-24 12:00:00	SPY	ETF	226.89	227.28	226.86	227.23	11200922.0
2017-01-24 13:00:00	SPY	ETF	227.23	227.85	227.22	227.685	12110988.0
2017-01-24 14:00:00	SPY	ETF	227.685	227.89	227.63	227.845	14119153.0
2017-01-24 15:00:00	SPY	ETF	227.845	228.08	227.52	227.58	22681951.0
2017-01-24 16:00:00	SPY	ETF	227.59	227.782	227.1819	227.62	13976205.0
2017-01-24 17:00:00	SPY	ETF	227.62	227.65	227.56	227.6	106341.0
2017-01-24 18:00:00	SPY	ETF	227.62	227.73	227.6	227.68	157285.0
2017-01-24 19:00:00	SPY	ETF	227.7	227.75	227.66	227.68	64904.0
2017-01-24 04:00:00	QQQ	ETF	123.44	123.45	123.4	123.4	800.0
2017-01-24 05:00:00	QQQ	ETF	123.51	123.51	123.51	123.51	1000.0
2017-01-24 06:00:00	QQQ	ETF	123.38	123.43	123.38	123.43	3100.0
2017-01-24 07:00:00	QQQ	ETF	123.39	123.51	123.39	123.47	49679.0
2017-01-24 08:00:00	QQQ	ETF	123.5	123.6	123.46	123.6	65469.0
2017-01-24 09:00:00	QQQ	ETF	123.6	123.77	123.46	123.46	1705790.0
2017-01-24 10:00:00	QQQ	ETF	123.46	123.64	123.3847	123.585	1551997.0
2017-01-24 11:00:00	QQQ	ETF	123.59	123.7	123.53	123.67	1457954.0
2017-01-24 12:00:00	QQQ	ETF	123.6655	123.75	123.63	123.6999	990161.0
2017-01-24 13:00:00	QQQ	ETF	123.7	124.15	123.7	124.09	1945555.0
2017-01-24 14:00:00	QQQ	ETF	124.1	124.26	124.07	124.249	1957672.0
2017-01-24 15:00:00	QQQ	ETF	124.25	124.37	124.13	124.17	3277437.0
2017-01-24 16:00:00	QQQ	ETF	124.18	124.3	124.15	124.28	400079.0
2017-01-24 17:00:00	QQQ	ETF	124.27	124.28	124.24	124.28	4798.0
2017-01-24 18:00:00	QQQ	ETF	124.26	124.37	124.26	124.36	7926.0
2017-01-24 19:00:00	QQQ	ETF	124.36	124.38	124.34	124.35	15467.0
2017-01-24 05:00:00	IWM	ETF	134.1	134.1	134.1	134.1	100.0
2017-01-24 06:00:00	IWM	ETF	133.97	133.98	133.97	133.98	1400.0
2017-01-24 07:00:00	IWM	ETF	133.99	134.0	133.96	133.97	33912.0
2017-01-24 08:00:00	IWM	ETF	133.98	134.26	133.96	134.26	89870.0
2017-01-24 09:00:00	IWM	ETF	134.27	134.85	134.26	134.49	2896235.0
2017-01-24 10:00:00	IWM	ETF	134.49	134.7084	134.22	134.31	2136705.0
2017-01-24 11:00:00	IWM	ETF	134.31	134.87	134.27	134.8	2714511.0
2017-01-24 12:00:00	IWM	ETF	134.805	135.43	134.76	135.33	2952590.0
2017-01-24 13:00:00	IWM	ETF	135.34	136.28	135.34	136.09	4086984.0
2017-01-24 14:00:00	IWM	ETF	136.09	136.21	135.94	136.09	2440652.0
2017-01-24 15:00:00	IWM	ETF	136.09	136.27	135.83	135.87	5253265.0
2017-01-24 16:00:00	IWM	ETF	135.88	135.96	135.82	135.92	1853835.0
2017-01-24 17:00:00	IWM	ETF	135.92	135.96	135.91	135.93	3885.0
2017-01-24 18:00:00	IWM	ETF	135.93	136.02	135.9	135.99	8366.0
2017-01-24 19:00:00	IWM	ETF	136.0125	136.08	136.01	136.01	732003.0
2017-01-24 08:00:00	DIA	ETF	197.94	197.94	197.88	197.88	3120.0
2017-01-24 09:00:00	DIA	ETF	197.8	197.95	197.62	197.94	430657.0
2017-01-24 10:00:00	DIA	ETF	197.95	198.11	197.73	198.07	561944.0

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

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