PREVIEW / etf_1hour / 2015-04-28

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-04-28.parquet
  size:    238 KB
  rows:    7,611

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
2015-04-28 04:00:00	SPY	ETF	210.7	210.7	210.11	210.5	5917.0
2015-04-28 05:00:00	SPY	ETF	210.57	210.57	210.42	210.45	14052.0
2015-04-28 06:00:00	SPY	ETF	210.49	210.63	210.11	210.2	73620.0
2015-04-28 07:00:00	SPY	ETF	210.25	210.3	210.05	210.28	258367.0
2015-04-28 08:00:00	SPY	ETF	210.45	210.94	210.12	210.53	690381.0
2015-04-28 09:00:00	SPY	ETF	210.54	210.92	210.4	210.63	10572481.0
2015-04-28 10:00:00	SPY	ETF	210.63	210.63	209.3301	210.4099	24887689.0
2015-04-28 11:00:00	SPY	ETF	210.41	211.27	210.4	211.1	11628599.0
2015-04-28 12:00:00	SPY	ETF	211.1	211.46	210.93	211.3062	7241442.0
2015-04-28 13:00:00	SPY	ETF	211.3	211.5	211.17	211.29	5382509.0
2015-04-28 14:00:00	SPY	ETF	211.29	211.3	210.95	211.18	6414883.0
2015-04-28 15:00:00	SPY	ETF	211.18	211.43	211.06	211.42	13691558.0
2015-04-28 16:00:00	SPY	ETF	211.42	211.7	211.3529	211.63	4555663.0
2015-04-28 17:00:00	SPY	ETF	211.631	211.65	211.57	211.57	874870.0
2015-04-28 18:00:00	SPY	ETF	211.56	211.59	211.49	211.52	57042.0
2015-04-28 19:00:00	SPY	ETF	211.52	211.56	211.5	211.54	22195.0
2015-04-28 06:00:00	QQQ	ETF	110.32	110.38	110.22	110.25	41399.0
2015-04-28 07:00:00	QQQ	ETF	110.24	110.3	110.17	110.29	53626.0
2015-04-28 08:00:00	QQQ	ETF	110.3	110.35	110.23	110.3	171430.0
2015-04-28 09:00:00	QQQ	ETF	110.31	110.41	109.8	109.82	6044287.0
2015-04-28 10:00:00	QQQ	ETF	109.81	110.04	109.11	109.86	8489232.0
2015-04-28 11:00:00	QQQ	ETF	109.86	110.35	109.85	110.303	3720180.0
2015-04-28 12:00:00	QQQ	ETF	110.3	110.55	110.255	110.4362	1865959.0
2015-04-28 13:00:00	QQQ	ETF	110.436	110.54	110.23	110.27	1801701.0
2015-04-28 14:00:00	QQQ	ETF	110.266	110.266	109.97	110.06	2107537.0
2015-04-28 15:00:00	QQQ	ETF	110.05	110.18	109.8	110.03	5334678.0
2015-04-28 16:00:00	QQQ	ETF	110.03	110.19	110.02	110.15	364864.0
2015-04-28 17:00:00	QQQ	ETF	110.15	110.15	110.05	110.11	7576.0
2015-04-28 18:00:00	QQQ	ETF	110.05	110.07	110.03	110.05	20056.0
2015-04-28 19:00:00	QQQ	ETF	110.03	110.05	110.03	110.03	4180.0
2015-04-28 07:00:00	IWM	ETF	124.1	124.17	124.08	124.17	10537.0
2015-04-28 08:00:00	IWM	ETF	124.21	124.4	124.21	124.32	139058.0
2015-04-28 09:00:00	IWM	ETF	124.4	124.86	124.35	124.35	3300198.0
2015-04-28 10:00:00	IWM	ETF	124.35	124.81	123.25	124.54	8857519.0
2015-04-28 11:00:00	IWM	ETF	124.545	125.23	124.53	125.035	3946467.0
2015-04-28 12:00:00	IWM	ETF	125.035	125.37	124.945	125.16	2061680.0
2015-04-28 13:00:00	IWM	ETF	125.165	125.3	125.03	125.1	1664851.0
2015-04-28 14:00:00	IWM	ETF	125.1	125.11	124.67	124.939	2374491.0
2015-04-28 15:00:00	IWM	ETF	124.93	125.2	124.8	125.15	4349949.0
2015-04-28 16:00:00	IWM	ETF	125.14	125.4	125.1027	125.34	1919421.0
2015-04-28 17:00:00	IWM	ETF	125.28	125.28	125.28	125.28	1071.0
2015-04-28 18:00:00	IWM	ETF	125.25	125.25	125.25	125.25	560.0
2015-04-28 19:00:00	IWM	ETF	125.25	125.25	125.25	125.25	300.0
2015-04-28 07:00:00	DIA	ETF	179.78	179.78	179.78	179.78	3000.0
2015-04-28 08:00:00	DIA	ETF	179.95	179.98	179.65	179.83	8130.0
2015-04-28 09:00:00	DIA	ETF	179.971	180.68	179.971	180.21	481904.0
2015-04-28 10:00:00	DIA	ETF	180.19	180.2	178.88	179.89	1691750.0
2015-04-28 11:00:00	DIA	ETF	179.89	180.81	179.87	180.61	757365.0
2015-04-28 12:00:00	DIA	ETF	180.62	180.89	180.46	180.78	308516.0
2015-04-28 13:00:00	DIA	ETF	180.79	180.94	180.6	180.69	260433.0

> showing 50 of 7,611 rows — these rows as CSV

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