PREVIEW / etf_1hour / 2016-10-13

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-10-13.parquet
  size:    263 KB
  rows:    8,402

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-10-13 04:00:00	SPY	ETF	211.94	212.3	211.75	212.28	185023.0
2016-10-13 05:00:00	SPY	ETF	212.29	212.54	212.28	212.31	28055.0
2016-10-13 06:00:00	SPY	ETF	212.29	212.42	212.2	212.38	23235.0
2016-10-13 07:00:00	SPY	ETF	212.39	212.47	212.18	212.42	671510.0
2016-10-13 08:00:00	SPY	ETF	212.41	213.71	211.89	212.06	973181.0
2016-10-13 09:00:00	SPY	ETF	212.09	212.4	211.27	211.48	17123621.0
2016-10-13 10:00:00	SPY	ETF	211.475	212.105	211.21	211.935	18762727.0
2016-10-13 11:00:00	SPY	ETF	211.94	212.47	211.51	212.25	14398050.0
2016-10-13 12:00:00	SPY	ETF	212.25	212.91	212.08	212.78	7970217.0
2016-10-13 13:00:00	SPY	ETF	212.775	213.23	212.47	213.2101	7716007.0
2016-10-13 14:00:00	SPY	ETF	213.215	213.59	213.05	213.495	8870270.0
2016-10-13 15:00:00	SPY	ETF	213.499	213.59	212.78	213.04	16014757.0
2016-10-13 16:00:00	SPY	ETF	213.03	213.12	212.3984	212.98	6388251.0
2016-10-13 17:00:00	SPY	ETF	212.96	213.04	212.89	213.03	197830.0
2016-10-13 18:00:00	SPY	ETF	213.02	213.04	212.88	212.99	108294.0
2016-10-13 19:00:00	SPY	ETF	212.96	213.07	212.9	212.93	27434.0
2016-10-13 04:00:00	QQQ	ETF	116.61	116.68	116.55	116.68	108046.0
2016-10-13 05:00:00	QQQ	ETF	116.7	116.76	116.65	116.65	7730.0
2016-10-13 06:00:00	QQQ	ETF	116.7	116.73	116.65	116.72	7900.0
2016-10-13 07:00:00	QQQ	ETF	116.72	116.76	116.63	116.71	86988.0
2016-10-13 08:00:00	QQQ	ETF	116.72	116.74	116.48	116.61	228165.0
2016-10-13 09:00:00	QQQ	ETF	116.65	116.72	115.97	116.11	4877446.0
2016-10-13 10:00:00	QQQ	ETF	116.11	116.49	115.94	116.31	3051851.0
2016-10-13 11:00:00	QQQ	ETF	116.318	116.69	116.1	116.649	2406614.0
2016-10-13 12:00:00	QQQ	ETF	116.64	116.97	116.54	116.87	1917386.0
2016-10-13 13:00:00	QQQ	ETF	116.88	117.08	116.69	117.08	1472699.0
2016-10-13 14:00:00	QQQ	ETF	117.08	117.31	116.991	117.265	2068859.0
2016-10-13 15:00:00	QQQ	ETF	117.27	117.32	116.84	117.01	3767000.0
2016-10-13 16:00:00	QQQ	ETF	117.03	117.05	116.3808	116.95	523004.0
2016-10-13 17:00:00	QQQ	ETF	116.99	117.07	116.99	117.07	201743.0
2016-10-13 18:00:00	QQQ	ETF	117.02	117.04	116.93	117.0	61343.0
2016-10-13 19:00:00	QQQ	ETF	117.0	117.06	116.91	116.94	5347.0
2016-10-13 04:00:00	IWM	ETF	120.75	120.83	120.75	120.81	1517.0
2016-10-13 06:00:00	IWM	ETF	121.0	121.05	121.0	121.02	2489.0
2016-10-13 07:00:00	IWM	ETF	121.09	121.12	120.95	121.1	59899.0
2016-10-13 08:00:00	IWM	ETF	121.1	121.93	120.7	120.86	271947.0
2016-10-13 09:00:00	IWM	ETF	120.9	121.135	120.2	120.3699	4236257.0
2016-10-13 10:00:00	IWM	ETF	120.37	120.87	120.11	120.78	5334273.0
2016-10-13 11:00:00	IWM	ETF	120.78	121.09	120.48	120.9	2790362.0
2016-10-13 12:00:00	IWM	ETF	120.9	121.23	120.74	120.95	1928662.0
2016-10-13 13:00:00	IWM	ETF	120.95	121.18	120.7	121.17	2081772.0
2016-10-13 14:00:00	IWM	ETF	121.175	121.41	121.03	121.32	1977300.0
2016-10-13 15:00:00	IWM	ETF	121.3215	121.3215	120.64	120.9	4858468.0
2016-10-13 16:00:00	IWM	ETF	120.92	121.19	120.78	120.91	1206155.0
2016-10-13 17:00:00	IWM	ETF	120.94	121.0	120.94	120.98	32233.0
2016-10-13 18:00:00	IWM	ETF	120.95	120.95	120.85	120.85	1353.0
2016-10-13 19:00:00	IWM	ETF	120.87	120.92	120.83	120.83	5694.0
2016-10-13 04:00:00	DIA	ETF	180.06	180.06	179.99	179.99	2783.0
2016-10-13 07:00:00	DIA	ETF	180.29	180.35	180.29	180.3	1283.0
2016-10-13 08:00:00	DIA	ETF	180.49	180.5	179.96	180.08	15258.0

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

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