PREVIEW / stock_1hour / 2011-03-24

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-03-24.parquet
  size:    925 KB
  rows:    43,982
  symbols: 3,510

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-24 04:00:00	AAPL	Stock	12.1139	12.1139	12.1139	12.1139	2800.0
2011-03-24 05:00:00	AAPL	Stock	12.1475	12.1475	12.1475	12.1475	8400.0
2011-03-24 06:00:00	AAPL	Stock	12.1707	12.1821	12.1707	12.1821	5600.0
2011-03-24 07:00:00	AAPL	Stock	12.1768	12.2039	12.1768	12.1886	219380.0
2011-03-24 08:00:00	AAPL	Stock	12.1879	12.2314	12.1786	12.1968	2518544.0
2011-03-24 09:00:00	AAPL	Stock	12.1986	12.2136	12.1021	12.1436	57939252.0
2011-03-24 10:00:00	AAPL	Stock	12.1439	12.2293	12.1218	12.2257	65324252.0
2011-03-24 11:00:00	AAPL	Stock	12.2236	12.2607	12.2171	12.24	62985552.0
2011-03-24 12:00:00	AAPL	Stock	12.2411	12.2679	12.2332	12.2557	34993868.0
2011-03-24 13:00:00	AAPL	Stock	12.2561	12.3	12.2439	12.2691	43584352.0
2011-03-24 14:00:00	AAPL	Stock	12.2693	12.3043	12.2687	12.2961	36729056.0
2011-03-24 15:00:00	AAPL	Stock	12.2936	12.3296	12.2872	12.3225	74594072.0
2011-03-24 16:00:00	AAPL	Stock	12.3246	12.3279	12.2321	12.3179	14522732.0
2011-03-24 17:00:00	AAPL	Stock	12.3204	12.3846	12.3204	12.3671	1493604.0
2011-03-24 18:00:00	AAPL	Stock	12.3664	12.3929	12.3204	12.3825	959560.0
2011-03-24 19:00:00	AAPL	Stock	12.3839	12.3893	12.375	12.3839	267232.0
2011-03-24 05:00:00	MSFT	Stock	25.69	25.7	25.68	25.68	6600.0
2011-03-24 07:00:00	MSFT	Stock	25.64	25.67	25.55	25.67	5000.0
2011-03-24 08:00:00	MSFT	Stock	25.63	25.68	25.63	25.67	14120.0
2011-03-24 09:00:00	MSFT	Stock	25.65	25.68	25.5	25.61	4326754.0
2011-03-24 10:00:00	MSFT	Stock	25.61	25.825	25.6	25.81	4943558.0
2011-03-24 11:00:00	MSFT	Stock	25.815	25.86	25.74	25.82	5488247.0
2011-03-24 12:00:00	MSFT	Stock	25.82	25.86	25.77	25.795	4387099.0
2011-03-24 13:00:00	MSFT	Stock	25.8	25.81	25.71	25.774	4105188.0
2011-03-24 14:00:00	MSFT	Stock	25.775	25.83	25.76	25.802	3803428.0
2011-03-24 15:00:00	MSFT	Stock	25.805	25.87	25.76	25.81	7856625.0
2011-03-24 16:00:00	MSFT	Stock	25.815	25.853	25.58	25.79	1932734.0
2011-03-24 17:00:00	MSFT	Stock	25.77	25.89	25.75	25.89	40177.0
2011-03-24 18:00:00	MSFT	Stock	25.89	25.95	25.81	25.89	25714.0
2011-03-24 19:00:00	MSFT	Stock	25.9	25.9	25.9	25.9	1500.0
2011-03-24 07:00:00	NVDA	Stock	0.446	0.446	0.446	0.446	4000.0
2011-03-24 08:00:00	NVDA	Stock	0.4468	0.4515	0.4468	0.45	994240.0
2011-03-24 09:00:00	NVDA	Stock	0.45	0.4635	0.45	0.4612	210428080.0
2011-03-24 10:00:00	NVDA	Stock	0.4615	0.477	0.4593	0.4765	386037400.0
2011-03-24 11:00:00	NVDA	Stock	0.4765	0.4862	0.4763	0.4835	382138760.0
2011-03-24 12:00:00	NVDA	Stock	0.4833	0.484	0.4775	0.4793	178116080.0
2011-03-24 13:00:00	NVDA	Stock	0.4793	0.4832	0.4775	0.4822	136732360.0
2011-03-24 14:00:00	NVDA	Stock	0.482	0.4858	0.4815	0.4845	131935120.0
2011-03-24 15:00:00	NVDA	Stock	0.4845	0.486	0.48	0.4808	320437480.0
2011-03-24 16:00:00	NVDA	Stock	0.481	0.485	0.4742	0.4793	21540000.0
2011-03-24 17:00:00	NVDA	Stock	0.4798	0.484	0.4798	0.484	448840.0
2011-03-24 18:00:00	NVDA	Stock	0.4843	0.488	0.4843	0.485	1105600.0
2011-03-24 19:00:00	NVDA	Stock	0.485	0.4875	0.485	0.4875	334000.0
2011-03-24 07:00:00	AMZN	Stock	8.3175	8.399	8.312	8.396	200300.0
2011-03-24 08:00:00	AMZN	Stock	8.394	8.42	8.371	8.398	635700.0
2011-03-24 09:00:00	AMZN	Stock	8.3975	8.5105	8.368	8.4895	30649540.0
2011-03-24 10:00:00	AMZN	Stock	8.4901	8.5625	8.478	8.5615	26265640.0
2011-03-24 11:00:00	AMZN	Stock	8.5578	8.564	8.5185	8.535	11115040.0
2011-03-24 12:00:00	AMZN	Stock	8.535	8.5537	8.515	8.525	8967620.0
2011-03-24 13:00:00	AMZN	Stock	8.528	8.5416	8.511	8.5365	5895800.0

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

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