PREVIEW / etf_1hour / 2017-08-07

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-08-07.parquet
  size:    273 KB
  rows:    8,994

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-08-07 04:00:00	SPY	ETF	247.62	247.63	247.6	247.6	5910.0
2017-08-07 05:00:00	SPY	ETF	247.61	247.61	247.5	247.52	7700.0
2017-08-07 06:00:00	SPY	ETF	247.42	247.5	247.42	247.49	1510.0
2017-08-07 07:00:00	SPY	ETF	247.52	247.52	247.36	247.41	25692.0
2017-08-07 08:00:00	SPY	ETF	247.41	247.56	247.37	247.46	642859.0
2017-08-07 09:00:00	SPY	ETF	247.46	247.6	247.37	247.57	2673297.0
2017-08-07 10:00:00	SPY	ETF	247.57	247.63	247.37	247.4668	4761410.0
2017-08-07 11:00:00	SPY	ETF	247.46	247.66	247.43	247.61	2766015.0
2017-08-07 12:00:00	SPY	ETF	247.615	247.74	247.61	247.73	3092081.0
2017-08-07 13:00:00	SPY	ETF	247.74	247.76	247.6	247.6732	1853930.0
2017-08-07 14:00:00	SPY	ETF	247.6717	247.77	247.65	247.71	2924602.0
2017-08-07 15:00:00	SPY	ETF	247.71	247.87	247.67	247.85	7403570.0
2017-08-07 16:00:00	SPY	ETF	247.84	247.8765	247.6573	247.85	4959053.0
2017-08-07 17:00:00	SPY	ETF	247.83	247.86	247.82	247.85	4078.0
2017-08-07 18:00:00	SPY	ETF	247.82	247.82	247.67	247.72	110619.0
2017-08-07 19:00:00	SPY	ETF	247.72	247.74	247.72	247.73	28610.0
2017-08-07 04:00:00	QQQ	ETF	143.9	144.0	143.9	143.97	3075.0
2017-08-07 05:00:00	QQQ	ETF	143.88	143.88	143.74	143.76	7068.0
2017-08-07 06:00:00	QQQ	ETF	143.77	143.86	143.75	143.85	6433.0
2017-08-07 07:00:00	QQQ	ETF	143.86	143.86	143.69	143.79	5641.0
2017-08-07 08:00:00	QQQ	ETF	143.79	143.94	143.79	143.84	218192.0
2017-08-07 09:00:00	QQQ	ETF	143.84	144.045	143.71	144.01	2230011.0
2017-08-07 10:00:00	QQQ	ETF	144.02	144.21	143.935	144.15	2235367.0
2017-08-07 11:00:00	QQQ	ETF	144.14	144.39	144.09	144.32	2177115.0
2017-08-07 12:00:00	QQQ	ETF	144.32	144.38	144.21	144.369	978589.0
2017-08-07 13:00:00	QQQ	ETF	144.36	144.37	144.22	144.2908	1178597.0
2017-08-07 14:00:00	QQQ	ETF	144.3	144.39	144.26	144.3501	891481.0
2017-08-07 15:00:00	QQQ	ETF	144.355	144.56	144.33	144.48	4000859.0
2017-08-07 16:00:00	QQQ	ETF	144.49	144.61	143.9957	144.61	1098776.0
2017-08-07 17:00:00	QQQ	ETF	144.6	144.6	144.51	144.51	17169.0
2017-08-07 18:00:00	QQQ	ETF	144.53	144.53	144.47	144.5	19335.0
2017-08-07 19:00:00	QQQ	ETF	144.49	144.52	144.49	144.52	850.0
2017-08-07 04:00:00	IWM	ETF	140.47	140.47	140.45	140.45	673.0
2017-08-07 05:00:00	IWM	ETF	140.41	140.41	140.39	140.39	1444.0
2017-08-07 07:00:00	IWM	ETF	140.31	140.32	140.25	140.27	18206.0
2017-08-07 08:00:00	IWM	ETF	140.3	140.37	140.21	140.31	77126.0
2017-08-07 09:00:00	IWM	ETF	140.31	140.46	140.01	140.29	1039743.0
2017-08-07 10:00:00	IWM	ETF	140.3	140.39	139.71	140.07	1289349.0
2017-08-07 11:00:00	IWM	ETF	140.08	140.67	139.95	140.55	1845193.0
2017-08-07 12:00:00	IWM	ETF	140.55	140.74	140.55	140.73	633064.0
2017-08-07 13:00:00	IWM	ETF	140.74	140.85	140.33	140.36	808828.0
2017-08-07 14:00:00	IWM	ETF	140.36	140.6	140.2601	140.48	582183.0
2017-08-07 15:00:00	IWM	ETF	140.48	140.59	140.31	140.47	1756175.0
2017-08-07 16:00:00	IWM	ETF	140.47	140.54	140.41	140.46	498271.0
2017-08-07 17:00:00	IWM	ETF	140.46	140.5	140.46	140.5	1342.0
2017-08-07 18:00:00	IWM	ETF	140.43	140.43	140.43	140.43	100.0
2017-08-07 19:00:00	IWM	ETF	140.42	140.42	140.42	140.42	868.0
2017-08-07 04:00:00	DIA	ETF	220.72	220.72	220.72	220.72	200.0
2017-08-07 07:00:00	DIA	ETF	220.77	220.77	220.77	220.77	110.0
2017-08-07 08:00:00	DIA	ETF	220.77	220.85	220.77	220.85	732.0

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

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