PREVIEW / stock_1hour / 2011-03-22

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-03-22.parquet
  size:    917 KB
  rows:    43,522
  symbols: 3,498

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-03-22 04:00:00	AAPL	Stock	12.1429	12.1675	12.1429	12.1675	61600.0
2011-03-22 06:00:00	AAPL	Stock	12.1818	12.1818	12.1607	12.1607	34020.0
2011-03-22 07:00:00	AAPL	Stock	12.1507	12.2007	12.1429	12.1761	462308.0
2011-03-22 08:00:00	AAPL	Stock	12.1768	12.2654	12.1432	12.2357	3918992.0
2011-03-22 09:00:00	AAPL	Stock	12.2339	12.2411	12.1121	12.1786	73054380.0
2011-03-22 10:00:00	AAPL	Stock	12.1786	12.2214	12.1632	12.1746	62569640.0
2011-03-22 11:00:00	AAPL	Stock	12.1746	12.1964	12.1482	12.1886	38437840.0
2011-03-22 12:00:00	AAPL	Stock	12.1896	12.1975	12.1696	12.1739	22046108.0
2011-03-22 13:00:00	AAPL	Stock	12.1729	12.1782	12.1371	12.1714	38592904.0
2011-03-22 14:00:00	AAPL	Stock	12.1714	12.1726	12.1368	12.1625	28672168.0
2011-03-22 15:00:00	AAPL	Stock	12.1629	12.1996	12.1475	12.1832	43196356.0
2011-03-22 16:00:00	AAPL	Stock	12.1857	12.2025	12.115	12.1929	7552384.0
2011-03-22 17:00:00	AAPL	Stock	12.1929	12.1964	12.1718	12.1786	238280.0
2011-03-22 18:00:00	AAPL	Stock	12.1821	12.1889	12.1821	12.1886	93408.0
2011-03-22 19:00:00	AAPL	Stock	12.1893	12.1911	12.1786	12.1789	224280.0
2011-03-22 06:00:00	MSFT	Stock	25.38	25.4	25.38	25.4	990.0
2011-03-22 07:00:00	MSFT	Stock	25.4	25.4	25.4	25.4	510.0
2011-03-22 08:00:00	MSFT	Stock	25.35	25.4	25.33	25.35	11672.0
2011-03-22 09:00:00	MSFT	Stock	25.34	25.44	25.23	25.38	4381047.0
2011-03-22 10:00:00	MSFT	Stock	25.385	25.45	25.34	25.368	5197611.0
2011-03-22 11:00:00	MSFT	Stock	25.36	25.46	25.35	25.44	3615336.0
2011-03-22 12:00:00	MSFT	Stock	25.43	25.44	25.35	25.35	2546459.0
2011-03-22 13:00:00	MSFT	Stock	25.355	25.37	25.26	25.36	2667163.0
2011-03-22 14:00:00	MSFT	Stock	25.36	25.37	25.27	25.33	2267434.0
2011-03-22 15:00:00	MSFT	Stock	25.32	25.38	25.28	25.29	5310871.0
2011-03-22 16:00:00	MSFT	Stock	25.3	25.465	25.277	25.34	1686379.0
2011-03-22 17:00:00	MSFT	Stock	25.34	25.35	25.3	25.3	6150.0
2011-03-22 18:00:00	MSFT	Stock	25.3	25.3	25.29	25.29	4847.0
2011-03-22 19:00:00	MSFT	Stock	25.3	25.31	25.3	25.3	3495.0
2011-03-22 07:00:00	NVDA	Stock	0.445	0.445	0.443	0.443	36000.0
2011-03-22 08:00:00	NVDA	Stock	0.443	0.4438	0.4412	0.4422	284560.0
2011-03-22 09:00:00	NVDA	Stock	0.4425	0.447	0.4348	0.435	103222400.0
2011-03-22 10:00:00	NVDA	Stock	0.4348	0.4398	0.4342	0.4372	108340680.0
2011-03-22 11:00:00	NVDA	Stock	0.4372	0.4425	0.4362	0.442	80232560.0
2011-03-22 12:00:00	NVDA	Stock	0.442	0.4462	0.4408	0.4422	100027440.0
2011-03-22 13:00:00	NVDA	Stock	0.4422	0.4425	0.4372	0.4395	77575000.0
2011-03-22 14:00:00	NVDA	Stock	0.4395	0.4402	0.435	0.4362	89209880.0
2011-03-22 15:00:00	NVDA	Stock	0.4362	0.4375	0.435	0.4362	140229760.0
2011-03-22 16:00:00	NVDA	Stock	0.436	0.4385	0.435	0.436	10747240.0
2011-03-22 17:00:00	NVDA	Stock	0.436	0.436	0.4358	0.4358	32000.0
2011-03-22 18:00:00	NVDA	Stock	0.436	0.437	0.4355	0.4355	260000.0
2011-03-22 19:00:00	NVDA	Stock	0.437	0.437	0.4368	0.4368	148000.0
2011-03-22 07:00:00	AMZN	Stock	8.225	8.276	8.225	8.2445	8000.0
2011-03-22 08:00:00	AMZN	Stock	8.222	8.222	8.187	8.196	28500.0
2011-03-22 09:00:00	AMZN	Stock	8.2155	8.222	8.128	8.158	9634020.0
2011-03-22 10:00:00	AMZN	Stock	8.156	8.2025	8.1125	8.121	13613800.0
2011-03-22 11:00:00	AMZN	Stock	8.121	8.168	8.116	8.1515	8746220.0
2011-03-22 12:00:00	AMZN	Stock	8.1505	8.167	8.1205	8.1215	6852560.0
2011-03-22 13:00:00	AMZN	Stock	8.1205	8.1335	8.114	8.1302	6582700.0
2011-03-22 14:00:00	AMZN	Stock	8.13	8.1325	8.1135	8.1185	8101340.0

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

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