PREVIEW / stock_1hour / 2011-01-10

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-01-10.parquet
  size:    951 KB
  rows:    45,508
  symbols: 3,521

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-01-10 04:00:00	AAPL	Stock	12.0786	12.1093	12.0786	12.1093	22400.0
2011-01-10 05:00:00	AAPL	Stock	12.1071	12.1179	12.1071	12.1071	50400.0
2011-01-10 06:00:00	AAPL	Stock	12.1157	12.1357	12.1046	12.1071	117404.0
2011-01-10 07:00:00	AAPL	Stock	12.1071	12.1071	12.0536	12.0539	850444.0
2011-01-10 08:00:00	AAPL	Stock	12.0618	12.1114	12.0589	12.0893	5035240.0
2011-01-10 09:00:00	AAPL	Stock	12.0929	12.1729	12.0418	12.12	88813088.0
2011-01-10 10:00:00	AAPL	Stock	12.1186	12.1507	12.0811	12.125	65272872.0
2011-01-10 11:00:00	AAPL	Stock	12.1214	12.1757	12.1107	12.1721	40106360.0
2011-01-10 12:00:00	AAPL	Stock	12.1721	12.2043	12.1629	12.1914	51257696.0
2011-01-10 13:00:00	AAPL	Stock	12.1907	12.2168	12.1839	12.2054	37689792.0
2011-01-10 14:00:00	AAPL	Stock	12.2057	12.2071	12.1893	12.2043	25832744.0
2011-01-10 15:00:00	AAPL	Stock	12.2043	12.2582	12.1961	12.225	82858524.0
2011-01-10 16:00:00	AAPL	Stock	12.2232	12.2414	12.0914	12.2321	38180940.0
2011-01-10 17:00:00	AAPL	Stock	12.235	12.2411	12.2254	12.2336	476084.0
2011-01-10 18:00:00	AAPL	Stock	12.2286	12.2339	12.2232	12.2336	312256.0
2011-01-10 19:00:00	AAPL	Stock	12.2321	12.2407	12.2321	12.2343	259140.0
2011-01-10 04:00:00	MSFT	Stock	28.38	28.38	28.38	28.38	100.0
2011-01-10 05:00:00	MSFT	Stock	28.42	28.46	28.42	28.46	500.0
2011-01-10 06:00:00	MSFT	Stock	28.46	28.46	28.46	28.46	500.0
2011-01-10 07:00:00	MSFT	Stock	28.46	28.46	28.4	28.43	500.0
2011-01-10 08:00:00	MSFT	Stock	28.46	28.51	28.4	28.48	24695.0
2011-01-10 09:00:00	MSFT	Stock	28.48	28.48	28.08	28.081	7421254.0
2011-01-10 10:00:00	MSFT	Stock	28.09	28.16	28.04	28.125	10253852.0
2011-01-10 11:00:00	MSFT	Stock	28.12	28.2	28.08	28.191	5386528.0
2011-01-10 12:00:00	MSFT	Stock	28.195	28.28	28.17	28.175	6228603.0
2011-01-10 13:00:00	MSFT	Stock	28.171	28.23	28.15	28.185	4600188.0
2011-01-10 14:00:00	MSFT	Stock	28.185	28.22	28.14	28.21	8475821.0
2011-01-10 15:00:00	MSFT	Stock	28.21	28.26	28.18	28.21	8745701.0
2011-01-10 16:00:00	MSFT	Stock	28.21	28.27	28.15	28.2	3576578.0
2011-01-10 17:00:00	MSFT	Stock	28.21	28.22	28.21	28.22	2500.0
2011-01-10 18:00:00	MSFT	Stock	28.21	28.27	28.21	28.24	21389.0
2011-01-10 19:00:00	MSFT	Stock	28.24	28.28	28.23	28.23	11255.0
2011-01-10 04:00:00	NVDA	Stock	0.4912	0.4912	0.4912	0.4912	8000.0
2011-01-10 05:00:00	NVDA	Stock	0.49	0.49	0.49	0.49	16000.0
2011-01-10 06:00:00	NVDA	Stock	0.4888	0.4888	0.4888	0.4888	4000.0
2011-01-10 07:00:00	NVDA	Stock	0.4888	0.4932	0.4888	0.492	79520.0
2011-01-10 08:00:00	NVDA	Stock	0.4912	0.4912	0.4875	0.49	683360.0
2011-01-10 09:00:00	NVDA	Stock	0.49	0.4992	0.484	0.4895	211608000.0
2011-01-10 10:00:00	NVDA	Stock	0.4892	0.499	0.4883	0.498	238555160.0
2011-01-10 11:00:00	NVDA	Stock	0.498	0.507	0.4978	0.5066	243342440.0
2011-01-10 12:00:00	NVDA	Stock	0.5065	0.5112	0.5045	0.506	193425040.0
2011-01-10 13:00:00	NVDA	Stock	0.506	0.5148	0.5055	0.511	213850160.0
2011-01-10 14:00:00	NVDA	Stock	0.5112	0.5125	0.5082	0.5122	147849320.0
2011-01-10 15:00:00	NVDA	Stock	0.5124	0.5168	0.511	0.5158	346320400.0
2011-01-10 16:00:00	NVDA	Stock	0.516	0.5508	0.5047	0.54	111921400.0
2011-01-10 17:00:00	NVDA	Stock	0.5392	0.5425	0.5293	0.5362	22261040.0
2011-01-10 18:00:00	NVDA	Stock	0.5362	0.5388	0.5332	0.5378	5599480.0
2011-01-10 19:00:00	NVDA	Stock	0.537	0.5452	0.5362	0.545	5650480.0
2011-01-10 05:00:00	AMZN	Stock	9.2525	9.2525	9.2525	9.2525	5500.0
2011-01-10 08:00:00	AMZN	Stock	9.2525	9.2575	9.2355	9.2575	46100.0

> showing 50 of 45,508 rows — these rows as CSV

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