PREVIEW / stock_1hour / 2011-04-06

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-04-06.parquet
  size:    938 KB
  rows:    44,504
  symbols: 3,540

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
2011-04-06 04:00:00	AAPL	Stock	12.1471	12.1607	12.1429	12.15	72800.0
2011-04-06 05:00:00	AAPL	Stock	12.1679	12.1679	12.1679	12.1679	14000.0
2011-04-06 06:00:00	AAPL	Stock	12.1661	12.1768	12.1604	12.1768	77980.0
2011-04-06 07:00:00	AAPL	Stock	12.1768	12.1768	12.1554	12.1729	361732.0
2011-04-06 08:00:00	AAPL	Stock	12.1618	12.2179	12.1607	12.1821	2171988.0
2011-04-06 09:00:00	AAPL	Stock	12.1793	12.2821	12.1032	12.2354	73303748.0
2011-04-06 10:00:00	AAPL	Stock	12.235	12.2589	12.1532	12.1643	70618716.0
2011-04-06 11:00:00	AAPL	Stock	12.1643	12.1679	12.0582	12.0604	67581556.0
2011-04-06 12:00:00	AAPL	Stock	12.0604	12.1	12.0464	12.0686	38273116.0
2011-04-06 13:00:00	AAPL	Stock	12.0679	12.1071	12.0568	12.095	29701196.0
2011-04-06 14:00:00	AAPL	Stock	12.0943	12.1161	12.0464	12.0556	41172656.0
2011-04-06 15:00:00	AAPL	Stock	12.0561	12.0893	12.0407	12.0729	58885876.0
2011-04-06 16:00:00	AAPL	Stock	12.0729	12.2037	12.0625	12.0625	10379264.0
2011-04-06 17:00:00	AAPL	Stock	12.0611	12.0679	12.0536	12.0643	179928.0
2011-04-06 18:00:00	AAPL	Stock	12.0696	12.0739	12.0596	12.0714	184716.0
2011-04-06 19:00:00	AAPL	Stock	12.0718	12.0857	12.0646	12.0775	376908.0
2011-04-06 05:00:00	MSFT	Stock	25.9	25.9	25.9	25.9	200.0
2011-04-06 06:00:00	MSFT	Stock	25.9	25.95	25.9	25.95	700.0
2011-04-06 07:00:00	MSFT	Stock	25.91	25.96	25.9	25.95	46473.0
2011-04-06 08:00:00	MSFT	Stock	25.95	25.95	25.9	25.91	97136.0
2011-04-06 09:00:00	MSFT	Stock	25.78	26.14	25.78	26.11	8346543.0
2011-04-06 10:00:00	MSFT	Stock	26.11	26.31	26.1	26.28	15680675.0
2011-04-06 11:00:00	MSFT	Stock	26.29	26.29	26.08	26.09	9550120.0
2011-04-06 12:00:00	MSFT	Stock	26.08	26.15	26.04	26.07	5913472.0
2011-04-06 13:00:00	MSFT	Stock	26.08	26.17	26.07	26.115	4000829.0
2011-04-06 14:00:00	MSFT	Stock	26.115	26.19	26.11	26.185	6053714.0
2011-04-06 15:00:00	MSFT	Stock	26.19	26.22	26.13	26.15	12232389.0
2011-04-06 16:00:00	MSFT	Stock	26.15	26.172	26.1	26.11	2586030.0
2011-04-06 17:00:00	MSFT	Stock	25.78	26.17	25.78	26.14	7300.0
2011-04-06 18:00:00	MSFT	Stock	26.14	26.19	26.14	26.15	12421.0
2011-04-06 19:00:00	MSFT	Stock	26.15	26.15	26.14	26.14	4020.0
2011-04-06 07:00:00	NVDA	Stock	0.449	0.449	0.449	0.449	40000.0
2011-04-06 08:00:00	NVDA	Stock	0.444	0.4472	0.4425	0.4438	1049200.0
2011-04-06 09:00:00	NVDA	Stock	0.4438	0.4438	0.4345	0.4362	175653560.0
2011-04-06 10:00:00	NVDA	Stock	0.436	0.4405	0.436	0.4378	124335880.0
2011-04-06 11:00:00	NVDA	Stock	0.438	0.438	0.4328	0.4328	127209240.0
2011-04-06 12:00:00	NVDA	Stock	0.433	0.4365	0.4328	0.4342	92223520.0
2011-04-06 13:00:00	NVDA	Stock	0.4345	0.4352	0.4328	0.4342	100236160.0
2011-04-06 14:00:00	NVDA	Stock	0.4345	0.4372	0.4338	0.436	68299320.0
2011-04-06 15:00:00	NVDA	Stock	0.436	0.4388	0.435	0.4365	139589440.0
2011-04-06 16:00:00	NVDA	Stock	0.4358	0.4385	0.4358	0.4375	9692760.0
2011-04-06 17:00:00	NVDA	Stock	0.4375	0.4382	0.4375	0.438	186000.0
2011-04-06 18:00:00	NVDA	Stock	0.4382	0.4382	0.4382	0.4382	80000.0
2011-04-06 19:00:00	NVDA	Stock	0.4382	0.4382	0.4365	0.4365	218760.0
2011-04-06 06:00:00	AMZN	Stock	9.327	9.327	9.327	9.327	2000.0
2011-04-06 07:00:00	AMZN	Stock	9.3275	9.3275	9.315	9.3245	33800.0
2011-04-06 08:00:00	AMZN	Stock	9.315	9.315	9.2825	9.297	236700.0
2011-04-06 09:00:00	AMZN	Stock	9.2935	9.4135	9.25	9.3544	19356740.0
2011-04-06 10:00:00	AMZN	Stock	9.356	9.3625	9.2605	9.2835	17529880.0
2011-04-06 11:00:00	AMZN	Stock	9.284	9.291	9.103	9.1115	18975440.0

> showing 50 of 44,504 rows — these rows as CSV

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