PREVIEW / etf_1hour / 2013-01-25

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-01-25.parquet
  size:    202 KB
  rows:    6,327

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-01-25 04:00:00	SPY	ETF	149.66	149.87	149.66	149.87	14138.0
2013-01-25 05:00:00	SPY	ETF	149.87	149.97	149.87	149.91	58725.0
2013-01-25 06:00:00	SPY	ETF	149.92	149.99	149.81	149.91	74294.0
2013-01-25 07:00:00	SPY	ETF	149.89	150.12	149.87	150.0	663447.0
2013-01-25 08:00:00	SPY	ETF	149.98	150.07	149.88	149.91	905927.0
2013-01-25 09:00:00	SPY	ETF	149.92	150.11	149.75	150.03	14064304.0
2013-01-25 10:00:00	SPY	ETF	150.03	150.032	149.46	149.6305	18393958.0
2013-01-25 11:00:00	SPY	ETF	149.64	150.005	149.6	149.645	9803829.0
2013-01-25 12:00:00	SPY	ETF	149.645	150.05	149.638	149.8602	9067534.0
2013-01-25 13:00:00	SPY	ETF	149.87	150.16	149.85	150.075	10605166.0
2013-01-25 14:00:00	SPY	ETF	150.08	150.24	150.03	150.05	12105170.0
2013-01-25 15:00:00	SPY	ETF	150.05	150.21	149.79	150.2	33323204.0
2013-01-25 16:00:00	SPY	ETF	150.2	150.29	149.3726	149.97	35129960.0
2013-01-25 17:00:00	SPY	ETF	149.96	150.25	149.96	150.0	1098414.0
2013-01-25 18:00:00	SPY	ETF	150.0	150.09	150.0	150.04	59094.0
2013-01-25 19:00:00	SPY	ETF	150.03	150.1	150.0	150.03	14730.0
2013-01-25 04:00:00	QQQ	ETF	66.86	66.88	66.86	66.88	4500.0
2013-01-25 05:00:00	QQQ	ETF	66.92	66.93	66.91	66.91	4478.0
2013-01-25 06:00:00	QQQ	ETF	66.91	66.91	66.91	66.91	200.0
2013-01-25 07:00:00	QQQ	ETF	66.95	66.99	66.95	66.96	24151.0
2013-01-25 08:00:00	QQQ	ETF	66.99	66.99	66.91	66.91	80958.0
2013-01-25 09:00:00	QQQ	ETF	66.89	67.19	66.74	67.14	4036617.0
2013-01-25 10:00:00	QQQ	ETF	67.13	67.14	66.75	66.8185	6393467.0
2013-01-25 11:00:00	QQQ	ETF	66.8199	66.9699	66.7432	66.75	5911178.0
2013-01-25 12:00:00	QQQ	ETF	66.76	66.99	66.75	66.8355	3893492.0
2013-01-25 13:00:00	QQQ	ETF	66.84	67.149	66.82	67.09	3070258.0
2013-01-25 14:00:00	QQQ	ETF	67.09	67.19	67.02	67.0635	3146908.0
2013-01-25 15:00:00	QQQ	ETF	67.07	67.1301	66.89	66.991	8804136.0
2013-01-25 16:00:00	QQQ	ETF	67.0	67.07	66.9	66.96	1389862.0
2013-01-25 17:00:00	QQQ	ETF	66.95	66.97	66.95	66.95	4170.0
2013-01-25 18:00:00	QQQ	ETF	66.96	66.97	66.96	66.96	1250.0
2013-01-25 19:00:00	QQQ	ETF	66.96	66.99	66.95	66.95	8133.0
2013-01-25 04:00:00	IWM	ETF	89.5	89.77	89.5	89.75	965.0
2013-01-25 06:00:00	IWM	ETF	89.81	89.89	89.79	89.79	900.0
2013-01-25 07:00:00	IWM	ETF	89.81	89.89	89.8	89.8	396289.0
2013-01-25 08:00:00	IWM	ETF	89.81	89.87	89.69	89.69	582302.0
2013-01-25 09:00:00	IWM	ETF	89.67	89.77	89.54	89.69	3576464.0
2013-01-25 10:00:00	IWM	ETF	89.69	89.695	89.29	89.425	4617421.0
2013-01-25 11:00:00	IWM	ETF	89.425	89.78	89.395	89.62	3322032.0
2013-01-25 12:00:00	IWM	ETF	89.63	89.84	89.63	89.715	2113483.0
2013-01-25 13:00:00	IWM	ETF	89.715	89.83	89.65	89.82	2087051.0
2013-01-25 14:00:00	IWM	ETF	89.82	89.91	89.72	89.75	2807573.0
2013-01-25 15:00:00	IWM	ETF	89.76	89.87	89.53	89.87	7698320.0
2013-01-25 16:00:00	IWM	ETF	89.86	89.98	89.7093	89.85	2225658.0
2013-01-25 17:00:00	IWM	ETF	89.85	89.86	89.84	89.86	22408.0
2013-01-25 19:00:00	IWM	ETF	89.86	89.86	89.86	89.86	500.0
2013-01-25 04:00:00	DIA	ETF	138.42	138.42	138.42	138.42	100.0
2013-01-25 06:00:00	DIA	ETF	138.4	138.41	138.4	138.41	200.0
2013-01-25 07:00:00	DIA	ETF	138.42	138.51	138.42	138.5	11100.0
2013-01-25 08:00:00	DIA	ETF	138.3	138.47	138.3	138.45	88750.0

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

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