PREVIEW / etf_1hour / 2012-11-21

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-11-21.parquet
  size:    177 KB
  rows:    5,552

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
2012-11-21 04:00:00	SPY	ETF	139.07	139.14	139.05	139.12	41795.0
2012-11-21 05:00:00	SPY	ETF	139.07	139.17	138.9	139.15	16450.0
2012-11-21 06:00:00	SPY	ETF	139.17	139.42	139.17	139.41	215850.0
2012-11-21 07:00:00	SPY	ETF	139.41	139.47	139.15	139.29	369226.0
2012-11-21 08:00:00	SPY	ETF	139.28	139.47	139.05	139.45	783445.0
2012-11-21 09:00:00	SPY	ETF	139.44	139.54	139.13	139.45	11857084.0
2012-11-21 10:00:00	SPY	ETF	139.45	139.47	139.03	139.201	17146800.0
2012-11-21 11:00:00	SPY	ETF	139.2	139.37	139.12	139.189	8506776.0
2012-11-21 12:00:00	SPY	ETF	139.19	139.57	139.18	139.45	6405858.0
2012-11-21 13:00:00	SPY	ETF	139.46	139.565	139.36	139.5	5196113.0
2012-11-21 14:00:00	SPY	ETF	139.495	139.55	139.31	139.41	4855804.0
2012-11-21 15:00:00	SPY	ETF	139.41	139.56	139.32	139.52	13668250.0
2012-11-21 16:00:00	SPY	ETF	139.5	139.65	139.3424	139.58	6434454.0
2012-11-21 17:00:00	SPY	ETF	139.58	139.6	139.55	139.58	38090.0
2012-11-21 18:00:00	SPY	ETF	139.58	139.87	139.56	139.73	91622.0
2012-11-21 19:00:00	SPY	ETF	139.72	139.87	139.72	139.85	76455.0
2012-11-21 05:00:00	QQQ	ETF	63.64	63.64	63.64	63.64	200.0
2012-11-21 06:00:00	QQQ	ETF	63.78	63.85	63.75	63.85	6756.0
2012-11-21 07:00:00	QQQ	ETF	63.83	63.85	63.78	63.83	31078.0
2012-11-21 08:00:00	QQQ	ETF	63.82	63.9	63.81	63.88	118387.0
2012-11-21 09:00:00	QQQ	ETF	63.92	64.02	63.77	63.96	4105346.0
2012-11-21 10:00:00	QQQ	ETF	63.959	63.97	63.6	63.72	3075552.0
2012-11-21 11:00:00	QQQ	ETF	63.73	63.87	63.7099	63.7855	1751296.0
2012-11-21 12:00:00	QQQ	ETF	63.79	63.99	63.77	63.94	1439022.0
2012-11-21 13:00:00	QQQ	ETF	63.95	63.99	63.85	63.9599	934000.0
2012-11-21 14:00:00	QQQ	ETF	63.96	64.011	63.93	63.98	1455090.0
2012-11-21 15:00:00	QQQ	ETF	63.98	64.01	63.87	63.93	2397129.0
2012-11-21 16:00:00	QQQ	ETF	63.93	63.97	63.7916	63.97	1909939.0
2012-11-21 17:00:00	QQQ	ETF	63.97	64.0	63.94	64.0	23747.0
2012-11-21 18:00:00	QQQ	ETF	64.0	64.01	63.99	64.01	7550.0
2012-11-21 19:00:00	QQQ	ETF	64.01	64.02	63.99	64.01	6924.0
2012-11-21 04:00:00	IWM	ETF	79.23	79.44	79.23	79.44	1245.0
2012-11-21 05:00:00	IWM	ETF	79.24	79.24	79.24	79.24	645.0
2012-11-21 06:00:00	IWM	ETF	79.5	79.5	79.48	79.48	554.0
2012-11-21 07:00:00	IWM	ETF	79.39	79.51	79.39	79.51	9800.0
2012-11-21 08:00:00	IWM	ETF	79.49	79.59	79.45	79.52	60175.0
2012-11-21 09:00:00	IWM	ETF	79.55	79.65	79.32	79.46	3441032.0
2012-11-21 10:00:00	IWM	ETF	79.46	79.46	79.13	79.29	3452269.0
2012-11-21 11:00:00	IWM	ETF	79.29	79.48	79.26	79.39	1383474.0
2012-11-21 12:00:00	IWM	ETF	79.4	79.66	79.39	79.59	1483499.0
2012-11-21 13:00:00	IWM	ETF	79.6	79.69	79.45	79.58	1995393.0
2012-11-21 14:00:00	IWM	ETF	79.58	79.61	79.41	79.41	1464446.0
2012-11-21 15:00:00	IWM	ETF	79.415	79.73	79.39	79.7	3016776.0
2012-11-21 16:00:00	IWM	ETF	79.7	79.74	79.4281	79.7	840453.0
2012-11-21 18:00:00	IWM	ETF	79.7	79.75	79.64	79.75	13495.0
2012-11-21 19:00:00	IWM	ETF	79.75	79.75	79.73	79.74	3095.0
2012-11-21 07:00:00	DIA	ETF	127.68	127.68	127.62	127.62	1300.0
2012-11-21 08:00:00	DIA	ETF	127.3	127.78	127.3	127.69	404183.0
2012-11-21 09:00:00	DIA	ETF	127.7	128.069	127.54	128.0401	668986.0
2012-11-21 10:00:00	DIA	ETF	128.07	128.07	127.77	127.87	653311.0

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

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