PREVIEW / etf_1hour / 2013-02-05

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-02-05.parquet
  size:    199 KB
  rows:    6,268

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
2013-02-05 04:00:00	SPY	ETF	150.09	150.23	150.09	150.23	38210.0
2013-02-05 05:00:00	SPY	ETF	150.11	150.33	150.09	150.29	70200.0
2013-02-05 06:00:00	SPY	ETF	150.33	150.49	150.3	150.43	217275.0
2013-02-05 07:00:00	SPY	ETF	150.43	150.56	150.41	150.41	903627.0
2013-02-05 08:00:00	SPY	ETF	150.42	150.53	150.2	150.37	1284293.0
2013-02-05 09:00:00	SPY	ETF	150.37	150.81	150.29	150.72	16219256.0
2013-02-05 10:00:00	SPY	ETF	150.73	150.99	150.62	150.87	18870715.0
2013-02-05 11:00:00	SPY	ETF	150.87	150.99	150.79	150.87	12229784.0
2013-02-05 12:00:00	SPY	ETF	150.86	150.91	150.74	150.8805	8951566.0
2013-02-05 13:00:00	SPY	ETF	150.88	151.21	150.88	151.148	10694949.0
2013-02-05 14:00:00	SPY	ETF	151.145	151.48	151.12	151.35	11790494.0
2013-02-05 15:00:00	SPY	ETF	151.35	151.44	151.01	151.06	23625195.0
2013-02-05 16:00:00	SPY	ETF	151.06	151.2	149.5424	151.18	6158621.0
2013-02-05 17:00:00	SPY	ETF	151.17	151.2	151.1	151.12	98019.0
2013-02-05 18:00:00	SPY	ETF	151.1	151.1	151.01	151.03	43605.0
2013-02-05 19:00:00	SPY	ETF	151.04	151.11	151.02	151.04	32978.0
2013-02-05 05:00:00	QQQ	ETF	66.65	66.68	66.65	66.68	8300.0
2013-02-05 06:00:00	QQQ	ETF	66.72	66.8	66.72	66.78	20805.0
2013-02-05 07:00:00	QQQ	ETF	66.84	66.85	66.8	66.8	39027.0
2013-02-05 08:00:00	QQQ	ETF	66.85	66.85	66.75	66.81	670740.0
2013-02-05 09:00:00	QQQ	ETF	66.83	67.02	66.61	66.955	4995730.0
2013-02-05 10:00:00	QQQ	ETF	66.96	67.19	66.88	67.16	5109758.0
2013-02-05 11:00:00	QQQ	ETF	67.16	67.25	67.12	67.21	4805124.0
2013-02-05 12:00:00	QQQ	ETF	67.2	67.31	67.1799	67.27	2040710.0
2013-02-05 13:00:00	QQQ	ETF	67.27	67.465	67.26	67.41	2954190.0
2013-02-05 14:00:00	QQQ	ETF	67.4146	67.67	67.41	67.59	3756884.0
2013-02-05 15:00:00	QQQ	ETF	67.58	67.61	67.4	67.46	3940390.0
2013-02-05 16:00:00	QQQ	ETF	67.46	67.614	66.4967	67.53	5031523.0
2013-02-05 17:00:00	QQQ	ETF	66.48	67.54	66.48	67.52	19416.0
2013-02-05 18:00:00	QQQ	ETF	67.49	67.49	67.47	67.48	3700.0
2013-02-05 19:00:00	QQQ	ETF	67.49	67.5	67.49	67.5	9650.0
2013-02-05 04:00:00	IWM	ETF	89.65	89.65	89.65	89.65	167.0
2013-02-05 06:00:00	IWM	ETF	89.75	89.75	89.75	89.75	3000.0
2013-02-05 07:00:00	IWM	ETF	89.8	89.89	89.79	89.81	77337.0
2013-02-05 08:00:00	IWM	ETF	89.82	89.82	89.66	89.74	169378.0
2013-02-05 09:00:00	IWM	ETF	89.75	89.9215	89.585	89.84	3447392.0
2013-02-05 10:00:00	IWM	ETF	89.84	90.19	89.77	90.12	4997830.0
2013-02-05 11:00:00	IWM	ETF	90.12	90.19	89.95	90.01	2267759.0
2013-02-05 12:00:00	IWM	ETF	90.0099	90.0984	89.96	90.08	774714.0
2013-02-05 13:00:00	IWM	ETF	90.09	90.16	89.99	90.05	2672423.0
2013-02-05 14:00:00	IWM	ETF	90.0422	90.27	90.0422	90.22	2351883.0
2013-02-05 15:00:00	IWM	ETF	90.21	90.38	90.09	90.13	6593861.0
2013-02-05 16:00:00	IWM	ETF	90.13	90.16	89.89	90.15	1993652.0
2013-02-05 17:00:00	IWM	ETF	90.15	90.16	90.15	90.16	4180.0
2013-02-05 18:00:00	IWM	ETF	90.12	90.12	90.12	90.12	1120.0
2013-02-05 19:00:00	IWM	ETF	90.15	90.15	90.12	90.12	500.0
2013-02-05 04:00:00	DIA	ETF	138.97	138.97	138.97	138.97	100.0
2013-02-05 06:00:00	DIA	ETF	139.18	139.48	139.18	139.48	600.0
2013-02-05 07:00:00	DIA	ETF	139.37	139.37	139.37	139.37	500.0
2013-02-05 08:00:00	DIA	ETF	139.39	139.42	139.17	139.31	24105.0

> showing 50 of 6,268 rows — these rows as CSV

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