PREVIEW / etf_1hour / 2011-10-05

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-10-05.parquet
  size:    185 KB
  rows:    5,742

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
2011-10-05 04:00:00	SPY	ETF	111.53	112.09	111.53	112.09	7889.0
2011-10-05 05:00:00	SPY	ETF	111.93	111.93	111.56	111.86	4905.0
2011-10-05 06:00:00	SPY	ETF	111.83	113.11	111.8	112.87	252220.0
2011-10-05 07:00:00	SPY	ETF	112.89	112.97	112.4	112.44	1110227.0
2011-10-05 08:00:00	SPY	ETF	112.43	112.89	111.38	112.01	5163814.0
2011-10-05 09:00:00	SPY	ETF	112.04	112.69	111.58	112.06	36953966.0
2011-10-05 10:00:00	SPY	ETF	112.05	113.5	111.94	113.42	62328246.0
2011-10-05 11:00:00	SPY	ETF	113.41	113.46	112.77	113.28	23735936.0
2011-10-05 12:00:00	SPY	ETF	113.28	113.4	112.38	112.8	23009212.0
2011-10-05 13:00:00	SPY	ETF	112.81	113.94	112.8	113.83	24144059.0
2011-10-05 14:00:00	SPY	ETF	113.83	114.0	113.25	113.77	28242071.0
2011-10-05 15:00:00	SPY	ETF	113.77	114.72	113.33	114.46	63076257.0
2011-10-05 16:00:00	SPY	ETF	114.47	114.56	112.4548	114.19	11573487.0
2011-10-05 17:00:00	SPY	ETF	114.19	114.55	114.08	114.2	383648.0
2011-10-05 18:00:00	SPY	ETF	114.17	114.5	113.95	113.95	337969.0
2011-10-05 19:00:00	SPY	ETF	113.95	114.19	113.8	113.94	254785.0
2011-10-05 04:00:00	QQQ	ETF	51.88	51.98	51.77	51.77	11920.0
2011-10-05 05:00:00	QQQ	ETF	51.85	51.93	51.8	51.93	2200.0
2011-10-05 06:00:00	QQQ	ETF	51.9	52.37	51.9	52.3	31729.0
2011-10-05 07:00:00	QQQ	ETF	52.31	52.37	52.13	52.14	489150.0
2011-10-05 08:00:00	QQQ	ETF	52.17	52.34	51.9	51.93	1780928.0
2011-10-05 09:00:00	QQQ	ETF	51.94	52.2	51.66	51.92	12034340.0
2011-10-05 10:00:00	QQQ	ETF	51.93	52.96	51.88	52.92	23911898.0
2011-10-05 11:00:00	QQQ	ETF	52.92	53.12	52.62	53.04	10952421.0
2011-10-05 12:00:00	QQQ	ETF	53.05	53.11	52.57	52.88	9872298.0
2011-10-05 13:00:00	QQQ	ETF	52.88	53.48	52.85	53.42	10756791.0
2011-10-05 14:00:00	QQQ	ETF	53.42	53.57	53.18	53.44	9001638.0
2011-10-05 15:00:00	QQQ	ETF	53.4301	53.6787	53.14	53.54	14907409.0
2011-10-05 16:00:00	QQQ	ETF	53.53	53.5477	53.33	53.41	1796186.0
2011-10-05 17:00:00	QQQ	ETF	53.42	53.48	53.36	53.42	32412.0
2011-10-05 18:00:00	QQQ	ETF	53.36	53.42	53.23	53.24	174492.0
2011-10-05 19:00:00	QQQ	ETF	53.21	53.35	52.98	52.98	260337.0
2011-10-05 04:00:00	IWM	ETF	64.17	64.17	63.98	64.0	1792.0
2011-10-05 05:00:00	IWM	ETF	64.31	64.34	64.21	64.34	800.0
2011-10-05 06:00:00	IWM	ETF	64.3	65.2	64.3	65.18	114480.0
2011-10-05 07:00:00	IWM	ETF	65.01	65.18	64.86	64.88	84058.0
2011-10-05 08:00:00	IWM	ETF	64.9	65.2	63.91	64.58	1446576.0
2011-10-05 09:00:00	IWM	ETF	64.58	64.98	63.92	64.19	11483732.0
2011-10-05 10:00:00	IWM	ETF	64.19	65.57	64.12	65.52	22925977.0
2011-10-05 11:00:00	IWM	ETF	65.52	65.56	64.91	65.248	8000010.0
2011-10-05 12:00:00	IWM	ETF	65.25	65.4	64.39	64.7	8089068.0
2011-10-05 13:00:00	IWM	ETF	64.69	65.38	64.575	65.27	8576985.0
2011-10-05 14:00:00	IWM	ETF	65.28	65.38	64.595	65.21	9070550.0
2011-10-05 15:00:00	IWM	ETF	65.22	66.13	64.94	65.73	21927128.0
2011-10-05 16:00:00	IWM	ETF	65.73	65.9	65.4	65.46	1845867.0
2011-10-05 17:00:00	IWM	ETF	65.46	65.49	65.41	65.46	18268.0
2011-10-05 18:00:00	IWM	ETF	65.45	65.49	65.37	65.43	22546.0
2011-10-05 19:00:00	IWM	ETF	65.47	65.47	65.26	65.26	10947.0
2011-10-05 06:00:00	DIA	ETF	108.0	108.26	108.0	108.16	3300.0
2011-10-05 07:00:00	DIA	ETF	108.06	108.14	107.76	107.86	9550.0

> showing 50 of 5,742 rows — these rows as CSV

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