PREVIEW / stock_1hour / 2011-03-08

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-03-08.parquet
  size:    941 KB
  rows:    44,339
  symbols: 3,530

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-08 04:00:00	AAPL	Stock	12.7318	12.7489	12.7318	12.7489	19600.0
2011-03-08 06:00:00	AAPL	Stock	12.7321	12.7321	12.7321	12.7321	2800.0
2011-03-08 07:00:00	AAPL	Stock	12.7321	12.7411	12.6929	12.7061	240772.0
2011-03-08 08:00:00	AAPL	Stock	12.6804	12.705	12.6557	12.675	1013768.0
2011-03-08 09:00:00	AAPL	Stock	12.6743	12.7054	12.5804	12.6429	58171456.0
2011-03-08 10:00:00	AAPL	Stock	12.6432	12.7414	12.6329	12.7264	100521428.0
2011-03-08 11:00:00	AAPL	Stock	12.7268	12.7632	12.7075	12.7546	50043896.0
2011-03-08 12:00:00	AAPL	Stock	12.7533	12.7643	12.7304	12.7443	28107772.0
2011-03-08 13:00:00	AAPL	Stock	12.745	12.7596	12.74	12.7448	18936260.0
2011-03-08 14:00:00	AAPL	Stock	12.7454	12.7496	12.6814	12.7351	38654028.0
2011-03-08 15:00:00	AAPL	Stock	12.735	12.7429	12.6993	12.7025	45108028.0
2011-03-08 16:00:00	AAPL	Stock	12.7032	12.7322	12.6881	12.6989	10709496.0
2011-03-08 17:00:00	AAPL	Stock	12.6956	12.7082	12.6956	12.7029	577080.0
2011-03-08 18:00:00	AAPL	Stock	12.7018	12.7064	12.7	12.7036	175336.0
2011-03-08 19:00:00	AAPL	Stock	12.7018	12.7057	12.6968	12.7018	217756.0
2011-03-08 04:00:00	MSFT	Stock	25.79	25.79	25.79	25.79	300.0
2011-03-08 05:00:00	MSFT	Stock	25.79	25.79	25.79	25.79	900.0
2011-03-08 06:00:00	MSFT	Stock	25.79	25.79	25.79	25.79	100.0
2011-03-08 07:00:00	MSFT	Stock	25.79	25.82	25.75	25.75	940.0
2011-03-08 08:00:00	MSFT	Stock	25.81	25.81	25.72	25.78	23459.0
2011-03-08 09:00:00	MSFT	Stock	25.78	25.81	25.65	25.715	4657685.0
2011-03-08 10:00:00	MSFT	Stock	25.72	25.94	25.71	25.838	7806563.0
2011-03-08 11:00:00	MSFT	Stock	25.83	25.91	25.782	25.9	6433544.0
2011-03-08 12:00:00	MSFT	Stock	25.9	25.94	25.86	25.93	4673943.0
2011-03-08 13:00:00	MSFT	Stock	25.92	25.94	25.84	25.93	4435175.0
2011-03-08 14:00:00	MSFT	Stock	25.93	25.99	25.84	25.95	8132707.0
2011-03-08 15:00:00	MSFT	Stock	25.955	26.02	25.9	25.9	11502101.0
2011-03-08 16:00:00	MSFT	Stock	25.91	25.996	25.72	25.9	2051631.0
2011-03-08 17:00:00	MSFT	Stock	25.91	25.91	25.85	25.85	20991.0
2011-03-08 18:00:00	MSFT	Stock	25.85	25.91	25.85	25.88	4208.0
2011-03-08 19:00:00	MSFT	Stock	25.88	25.88	25.85	25.85	2777.0
2011-03-08 04:00:00	NVDA	Stock	0.5162	0.5162	0.5162	0.5162	4000.0
2011-03-08 06:00:00	NVDA	Stock	0.5222	0.523	0.5222	0.523	64000.0
2011-03-08 07:00:00	NVDA	Stock	0.523	0.523	0.52	0.5202	420000.0
2011-03-08 08:00:00	NVDA	Stock	0.5195	0.5225	0.5188	0.52	1702920.0
2011-03-08 09:00:00	NVDA	Stock	0.5198	0.52	0.5062	0.5138	147904920.0
2011-03-08 10:00:00	NVDA	Stock	0.514	0.5182	0.5105	0.5139	149027120.0
2011-03-08 11:00:00	NVDA	Stock	0.514	0.52	0.5125	0.5182	123310360.0
2011-03-08 12:00:00	NVDA	Stock	0.5182	0.5192	0.5091	0.5094	110965800.0
2011-03-08 13:00:00	NVDA	Stock	0.5093	0.51	0.4935	0.4942	323820120.0
2011-03-08 14:00:00	NVDA	Stock	0.4942	0.495	0.478	0.4892	701105800.0
2011-03-08 15:00:00	NVDA	Stock	0.4895	0.4966	0.4872	0.4885	355037960.0
2011-03-08 16:00:00	NVDA	Stock	0.4892	0.5118	0.4883	0.4888	18052840.0
2011-03-08 17:00:00	NVDA	Stock	0.4885	0.4898	0.4875	0.488	1219400.0
2011-03-08 18:00:00	NVDA	Stock	0.488	0.4888	0.487	0.4878	584960.0
2011-03-08 19:00:00	NVDA	Stock	0.4878	0.4878	0.4865	0.4865	92800.0
2011-03-08 08:00:00	AMZN	Stock	8.442	8.4465	8.381	8.443	46760.0
2011-03-08 09:00:00	AMZN	Stock	8.435	8.4875	8.36	8.417	12193960.0
2011-03-08 10:00:00	AMZN	Stock	8.4185	8.4855	8.4	8.434	15438020.0
2011-03-08 11:00:00	AMZN	Stock	8.434	8.47	8.4091	8.4615	8851920.0

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

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