PREVIEW / etf_1hour / 2016-05-10

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-05-10.parquet
  size:    251 KB
  rows:    8,105

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-05-10 04:00:00	SPY	ETF	206.98	207.42	206.93	207.36	95437.0
2016-05-10 05:00:00	SPY	ETF	207.36	207.38	207.01	207.01	92431.0
2016-05-10 06:00:00	SPY	ETF	207.02	207.15	206.8	206.8	51117.0
2016-05-10 07:00:00	SPY	ETF	206.77	206.77	206.26	206.53	382116.0
2016-05-10 08:00:00	SPY	ETF	206.5	206.74	206.3475	206.65	665675.0
2016-05-10 09:00:00	SPY	ETF	206.65	207.41	205.89	207.3	9672308.0
2016-05-10 10:00:00	SPY	ETF	207.28	207.75	207.06	207.64	11301817.0
2016-05-10 11:00:00	SPY	ETF	207.64	207.77	207.405	207.7499	7328175.0
2016-05-10 12:00:00	SPY	ETF	207.75	207.975	207.75	207.8789	5179757.0
2016-05-10 13:00:00	SPY	ETF	207.88	208.05	207.71	208.01	6400434.0
2016-05-10 14:00:00	SPY	ETF	208.01	208.12	207.9	207.99	5747308.0
2016-05-10 15:00:00	SPY	ETF	207.98	208.46	207.96	208.43	17296016.0
2016-05-10 16:00:00	SPY	ETF	208.42	208.46	207.8251	208.21	7685366.0
2016-05-10 17:00:00	SPY	ETF	208.2	208.28	208.18	208.22	111231.0
2016-05-10 18:00:00	SPY	ETF	208.21	208.24	208.08	208.18	95832.0
2016-05-10 19:00:00	SPY	ETF	208.15	208.22	208.12	208.17	96725.0
2016-05-10 04:00:00	QQQ	ETF	106.47	106.57	106.34	106.57	5646.0
2016-05-10 05:00:00	QQQ	ETF	106.39	106.45	106.39	106.45	4200.0
2016-05-10 06:00:00	QQQ	ETF	106.42	106.5	106.33	106.33	17799.0
2016-05-10 07:00:00	QQQ	ETF	106.15	106.15	105.94	106.14	66896.0
2016-05-10 08:00:00	QQQ	ETF	106.19	106.19	106.07	106.12	37170.0
2016-05-10 09:00:00	QQQ	ETF	106.11	106.52	106.07	106.4001	2833342.0
2016-05-10 10:00:00	QQQ	ETF	106.41	106.81	106.31	106.75	2782777.0
2016-05-10 11:00:00	QQQ	ETF	106.75	106.91	106.67	106.9	2090507.0
2016-05-10 12:00:00	QQQ	ETF	106.91	107.105	106.89	107.05	2049722.0
2016-05-10 13:00:00	QQQ	ETF	107.04	107.12	106.92	107.08	1752375.0
2016-05-10 14:00:00	QQQ	ETF	107.09	107.15	107.03	107.07	1322650.0
2016-05-10 15:00:00	QQQ	ETF	107.07	107.38	107.0541	107.33	5114516.0
2016-05-10 16:00:00	QQQ	ETF	107.34	107.34	107.21	107.31	427193.0
2016-05-10 17:00:00	QQQ	ETF	107.25	107.37	107.22	107.3	66529.0
2016-05-10 18:00:00	QQQ	ETF	107.31	107.33	107.21	107.23	55326.0
2016-05-10 19:00:00	QQQ	ETF	107.24	107.29	107.23	107.23	5544.0
2016-05-10 04:00:00	IWM	ETF	111.88	112.0	111.88	112.0	800.0
2016-05-10 05:00:00	IWM	ETF	112.17	112.19	112.06	112.07	6200.0
2016-05-10 06:00:00	IWM	ETF	112.05	112.09	111.98	111.98	7400.0
2016-05-10 07:00:00	IWM	ETF	111.8	111.8	111.41	111.57	65354.0
2016-05-10 08:00:00	IWM	ETF	111.61	111.68	111.6	111.63	24609.0
2016-05-10 09:00:00	IWM	ETF	111.62	111.9	111.34	111.53	2571776.0
2016-05-10 10:00:00	IWM	ETF	111.54	111.86	111.07	111.68	2530012.0
2016-05-10 11:00:00	IWM	ETF	111.68	111.71	111.4	111.68	2245227.0
2016-05-10 12:00:00	IWM	ETF	111.69	112.4	111.68	112.23	2514099.0
2016-05-10 13:00:00	IWM	ETF	112.22	112.34	112.08	112.24	1384026.0
2016-05-10 14:00:00	IWM	ETF	112.2399	112.25	112.04	112.07	938794.0
2016-05-10 15:00:00	IWM	ETF	112.06	112.39	112.04	112.32	3597989.0
2016-05-10 16:00:00	IWM	ETF	112.32	112.37	112.1546	112.26	719659.0
2016-05-10 17:00:00	IWM	ETF	112.25	112.27	112.22	112.27	1914.0
2016-05-10 18:00:00	IWM	ETF	112.26	112.26	112.26	112.26	249.0
2016-05-10 04:00:00	DIA	ETF	177.96	177.96	177.9	177.9	541.0
2016-05-10 07:00:00	DIA	ETF	177.6	177.6	177.6	177.6	400.0
2016-05-10 09:00:00	DIA	ETF	177.8	178.5899	177.64	178.54	434851.0

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

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