PREVIEW / stock_1hour / 2012-08-23

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-08-23.parquet
  size:    913 KB
  rows:    43,507
  symbols: 3,444

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-08-23 04:00:00	AAPL	Stock	23.9286	24.0354	23.9286	23.9911	83776.0
2012-08-23 05:00:00	AAPL	Stock	23.9861	24.0071	23.9861	24.0071	64680.0
2012-08-23 06:00:00	AAPL	Stock	24.0154	24.0214	23.9946	23.9946	54880.0
2012-08-23 07:00:00	AAPL	Stock	23.9857	24.0004	23.8629	23.8714	984032.0
2012-08-23 08:00:00	AAPL	Stock	23.8714	23.9786	23.7768	23.8332	3893624.0
2012-08-23 09:00:00	AAPL	Stock	23.8293	23.925	23.704	23.7325	93455124.0
2012-08-23 10:00:00	AAPL	Stock	23.7321	23.8803	23.6125	23.835	89164460.0
2012-08-23 11:00:00	AAPL	Stock	23.835	23.9229	23.7557	23.8075	52704400.0
2012-08-23 12:00:00	AAPL	Stock	23.8046	23.8214	23.6804	23.7322	38017224.0
2012-08-23 13:00:00	AAPL	Stock	23.7364	23.7836	23.6614	23.7532	28170380.0
2012-08-23 14:00:00	AAPL	Stock	23.7529	23.8175	23.7025	23.7836	31022348.0
2012-08-23 15:00:00	AAPL	Stock	23.785	23.8521	23.6521	23.6557	76633648.0
2012-08-23 16:00:00	AAPL	Stock	23.6557	23.8882	23.6557	23.7	1931608.0
2012-08-23 17:00:00	AAPL	Stock	23.6946	23.7	23.6654	23.6929	356748.0
2012-08-23 18:00:00	AAPL	Stock	23.6929	23.7107	23.6807	23.6921	294448.0
2012-08-23 19:00:00	AAPL	Stock	23.6907	23.7032	23.6857	23.6989	236096.0
2012-08-23 07:00:00	MSFT	Stock	30.55	30.59	30.55	30.55	2100.0
2012-08-23 08:00:00	MSFT	Stock	30.42	30.45	30.28	30.32	48263.0
2012-08-23 09:00:00	MSFT	Stock	30.32	30.41	30.08	30.22	4604042.0
2012-08-23 10:00:00	MSFT	Stock	30.22	30.29	30.15	30.24	5556601.0
2012-08-23 11:00:00	MSFT	Stock	30.235	30.4	30.2	30.298	3240003.0
2012-08-23 12:00:00	MSFT	Stock	30.3	30.33	30.2	30.27	2627130.0
2012-08-23 13:00:00	MSFT	Stock	30.265	30.28	30.18	30.255	2259786.0
2012-08-23 14:00:00	MSFT	Stock	30.25	30.345	30.22	30.274	2443757.0
2012-08-23 15:00:00	MSFT	Stock	30.275	30.36	30.2	30.25	5556890.0
2012-08-23 16:00:00	MSFT	Stock	30.25	30.54	30.21	30.29	1634687.0
2012-08-23 17:00:00	MSFT	Stock	30.24	30.24	30.2	30.2	1090.0
2012-08-23 18:00:00	MSFT	Stock	30.29	30.29	30.17	30.25	2962.0
2012-08-23 08:00:00	NVDA	Stock	0.3652	0.3655	0.3652	0.3655	24000.0
2012-08-23 09:00:00	NVDA	Stock	0.3652	0.3655	0.3615	0.3618	26531600.0
2012-08-23 10:00:00	NVDA	Stock	0.3618	0.362	0.3572	0.3588	82895880.0
2012-08-23 11:00:00	NVDA	Stock	0.3585	0.3602	0.358	0.36	35228880.0
2012-08-23 12:00:00	NVDA	Stock	0.36	0.3602	0.3578	0.3579	46432200.0
2012-08-23 13:00:00	NVDA	Stock	0.3579	0.3582	0.3568	0.3575	37578480.0
2012-08-23 14:00:00	NVDA	Stock	0.3575	0.3592	0.3572	0.3582	39298520.0
2012-08-23 15:00:00	NVDA	Stock	0.3582	0.3595	0.3562	0.3576	97590440.0
2012-08-23 16:00:00	NVDA	Stock	0.3578	0.3585	0.3576	0.3578	11406760.0
2012-08-23 17:00:00	NVDA	Stock	0.3562	0.3582	0.3562	0.3562	35200.0
2012-08-23 18:00:00	NVDA	Stock	0.3582	0.3595	0.3582	0.3595	198400.0
2012-08-23 06:00:00	AMZN	Stock	12.15	12.15	12.15	12.15	2000.0
2012-08-23 08:00:00	AMZN	Stock	12.15	12.15	12.102	12.115	152040.0
2012-08-23 09:00:00	AMZN	Stock	12.11	12.1245	12.009	12.027	6862800.0
2012-08-23 10:00:00	AMZN	Stock	12.027	12.071	12.0015	12.0525	6196020.0
2012-08-23 11:00:00	AMZN	Stock	12.058	12.174	12.0395	12.084	7023600.0
2012-08-23 12:00:00	AMZN	Stock	12.0836	12.085	12.0005	12.0015	4674220.0
2012-08-23 13:00:00	AMZN	Stock	12.0045	12.04	11.951	11.989	6743480.0
2012-08-23 14:00:00	AMZN	Stock	11.9845	12.078	11.967	12.065	7100380.0
2012-08-23 15:00:00	AMZN	Stock	12.0635	12.111	12.0525	12.0565	8414800.0
2012-08-23 16:00:00	AMZN	Stock	12.0565	12.0764	12.036	12.0565	1286740.0
2012-08-23 17:00:00	AMZN	Stock	12.155	12.155	12.0355	12.0355	21000.0

> showing 50 of 43,507 rows — these rows as CSV

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