PREVIEW / etf_1hour / 2014-01-23

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-01-23.parquet
  size:    225 KB
  rows:    7,118

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
2014-01-23 04:00:00	SPY	ETF	184.03	184.03	183.67	183.8	26611.0
2014-01-23 05:00:00	SPY	ETF	183.85	183.88	183.77	183.83	16175.0
2014-01-23 06:00:00	SPY	ETF	183.78	183.78	183.44	183.51	53630.0
2014-01-23 07:00:00	SPY	ETF	183.51	183.75	183.44	183.73	480900.0
2014-01-23 08:00:00	SPY	ETF	183.68	184.73	183.2	183.25	1545934.0
2014-01-23 09:00:00	SPY	ETF	183.25	183.42	182.73	182.82	18670228.0
2014-01-23 10:00:00	SPY	ETF	182.82	183.05	182.4	182.5	18306008.0
2014-01-23 11:00:00	SPY	ETF	182.505	182.74	182.27	182.72	17715519.0
2014-01-23 12:00:00	SPY	ETF	182.7199	182.76	182.24	182.47	14802421.0
2014-01-23 13:00:00	SPY	ETF	182.47	182.48	181.82	181.85	12113915.0
2014-01-23 14:00:00	SPY	ETF	181.855	182.45	181.84	182.405	15662338.0
2014-01-23 15:00:00	SPY	ETF	182.41	182.78	182.26	182.78	19454176.0
2014-01-23 16:00:00	SPY	ETF	182.78	184.3381	182.5033	182.91	11511215.0
2014-01-23 17:00:00	SPY	ETF	182.9	182.93	182.78	182.85	769562.0
2014-01-23 18:00:00	SPY	ETF	182.85	182.89	182.77	182.8	87596.0
2014-01-23 19:00:00	SPY	ETF	182.8	182.97	182.8	182.84	107715.0
2014-01-23 04:00:00	QQQ	ETF	88.97	88.97	88.77	88.77	1100.0
2014-01-23 05:00:00	QQQ	ETF	88.84	88.84	88.84	88.84	100.0
2014-01-23 06:00:00	QQQ	ETF	88.75	88.78	88.64	88.69	37020.0
2014-01-23 07:00:00	QQQ	ETF	88.63	88.76	88.63	88.76	28411.0
2014-01-23 08:00:00	QQQ	ETF	88.77	88.77	88.389	88.43	393127.0
2014-01-23 09:00:00	QQQ	ETF	88.42	88.52	88.09	88.2	5829727.0
2014-01-23 10:00:00	QQQ	ETF	88.2001	88.29	87.929	88.0	5142844.0
2014-01-23 11:00:00	QQQ	ETF	88.01	88.239	87.89	88.22	3542061.0
2014-01-23 12:00:00	QQQ	ETF	88.225	88.25	87.98	88.1593	2413792.0
2014-01-23 13:00:00	QQQ	ETF	88.159	88.159	87.87	87.88	3022114.0
2014-01-23 14:00:00	QQQ	ETF	87.88	88.28	87.86	88.23	2723700.0
2014-01-23 15:00:00	QQQ	ETF	88.235	88.48	88.15	88.48	4585031.0
2014-01-23 16:00:00	QQQ	ETF	88.48	88.8275	88.196	88.67	3917989.0
2014-01-23 17:00:00	QQQ	ETF	88.81	88.8276	88.6	88.6	541509.0
2014-01-23 18:00:00	QQQ	ETF	88.63	88.69	88.6	88.6	44595.0
2014-01-23 19:00:00	QQQ	ETF	88.6	88.7	88.6	88.68	14930.0
2014-01-23 04:00:00	IWM	ETF	116.9	116.9	116.9	116.9	200.0
2014-01-23 05:00:00	IWM	ETF	116.95	116.95	116.95	116.95	1500.0
2014-01-23 06:00:00	IWM	ETF	116.9	116.9	116.7	116.7	1500.0
2014-01-23 07:00:00	IWM	ETF	116.77	116.89	116.77	116.87	17011.0
2014-01-23 08:00:00	IWM	ETF	116.87	116.92	116.52	116.53	219923.0
2014-01-23 09:00:00	IWM	ETF	116.52	116.78	116.29	116.36	3786062.0
2014-01-23 10:00:00	IWM	ETF	116.37	116.44	116.03	116.111	4583413.0
2014-01-23 11:00:00	IWM	ETF	116.11	116.22	115.94	116.17	2789582.0
2014-01-23 12:00:00	IWM	ETF	116.18	116.22	115.94	116.0665	4090786.0
2014-01-23 13:00:00	IWM	ETF	116.06	116.08	115.68	115.68	3229094.0
2014-01-23 14:00:00	IWM	ETF	115.68	116.15	115.66	116.08	2812940.0
2014-01-23 15:00:00	IWM	ETF	116.089	116.39	115.94	116.39	5665886.0
2014-01-23 16:00:00	IWM	ETF	116.38	116.63	116.38	116.62	3389231.0
2014-01-23 17:00:00	IWM	ETF	116.63	116.64	116.5	116.5	22481.0
2014-01-23 18:00:00	IWM	ETF	116.5	116.5	116.5	116.5	200.0
2014-01-23 04:00:00	DIA	ETF	162.85	162.85	162.8	162.8	8100.0
2014-01-23 06:00:00	DIA	ETF	162.71	162.71	162.7	162.7	500.0
2014-01-23 07:00:00	DIA	ETF	162.65	162.95	162.65	162.95	18700.0

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

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