PREVIEW / stock_1hour / 2008-05-13

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-05-13.parquet
  size:    833 KB
  rows:    40,143
  symbols: 3,301

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
2008-05-13 05:00:00	AAPL	Stock	6.6993	6.6993	6.6993	6.6993	4200.0
2008-05-13 06:00:00	AAPL	Stock	6.7354	6.7354	6.7354	6.7354	2800.0
2008-05-13 07:00:00	AAPL	Stock	6.715	6.715	6.6964	6.7036	172732.0
2008-05-13 08:00:00	AAPL	Stock	6.7093	6.7357	6.6989	6.7346	2567880.0
2008-05-13 09:00:00	AAPL	Stock	6.7346	6.7729	6.7093	6.77	128563036.0
2008-05-13 10:00:00	AAPL	Stock	6.7704	6.8375	6.7529	6.7786	240775696.0
2008-05-13 11:00:00	AAPL	Stock	6.7796	6.7925	6.7618	6.7779	108355828.0
2008-05-13 12:00:00	AAPL	Stock	6.7782	6.8029	6.7696	6.7893	70270536.0
2008-05-13 13:00:00	AAPL	Stock	6.7896	6.8111	6.7714	6.7968	61176248.0
2008-05-13 14:00:00	AAPL	Stock	6.7968	6.8196	6.79	6.8068	70651336.0
2008-05-13 15:00:00	AAPL	Stock	6.8068	6.8207	6.7779	6.7836	115998344.0
2008-05-13 16:00:00	AAPL	Stock	6.7318	6.7928	6.7318	6.7732	7518896.0
2008-05-13 17:00:00	AAPL	Stock	6.7732	6.7857	6.7714	6.7857	489972.0
2008-05-13 18:00:00	AAPL	Stock	6.7829	6.7857	6.7807	6.7832	68180.0
2008-05-13 19:00:00	AAPL	Stock	6.7857	6.7889	6.7832	6.7832	100296.0
2008-05-13 20:00:00	AAPL	Stock	6.8314	6.8314	6.7796	6.7796	1362592.0
2008-05-13 08:00:00	MSFT	Stock	29.76	29.97	29.76	29.97	3561.0
2008-05-13 09:00:00	MSFT	Stock	29.88	30.13	29.88	29.98	6617188.0
2008-05-13 10:00:00	MSFT	Stock	29.97	30.03	29.71	29.75	10976853.0
2008-05-13 11:00:00	MSFT	Stock	29.75	29.9	29.53	29.56	8878267.0
2008-05-13 12:00:00	MSFT	Stock	29.56	29.88	29.56	29.75	10311263.0
2008-05-13 13:00:00	MSFT	Stock	29.75	29.808	29.69	29.72	6565762.0
2008-05-13 14:00:00	MSFT	Stock	29.72	29.8	29.65	29.78	10652723.0
2008-05-13 15:00:00	MSFT	Stock	29.78	29.91	29.71	29.78	13685452.0
2008-05-13 16:00:00	MSFT	Stock	29.78	29.807	29.72	29.72	1436511.0
2008-05-13 17:00:00	MSFT	Stock	29.78	29.78	29.72	29.73	9575.0
2008-05-13 18:00:00	MSFT	Stock	29.74	29.74	29.71	29.71	3680.0
2008-05-13 19:00:00	MSFT	Stock	29.71	29.73	29.6	29.6	21540.0
2008-05-13 20:00:00	MSFT	Stock	29.9	29.9	29.9	29.9	1630.0
2008-05-13 08:00:00	NVDA	Stock	0.5448	0.55	0.544	0.55	215760.0
2008-05-13 09:00:00	NVDA	Stock	0.55	0.5542	0.538	0.5423	65944800.0
2008-05-13 10:00:00	NVDA	Stock	0.5425	0.5485	0.5402	0.5415	95466800.0
2008-05-13 11:00:00	NVDA	Stock	0.5415	0.5418	0.5365	0.5382	117640920.0
2008-05-13 12:00:00	NVDA	Stock	0.5382	0.5402	0.534	0.5345	94949320.0
2008-05-13 13:00:00	NVDA	Stock	0.5348	0.5418	0.532	0.5415	146360160.0
2008-05-13 14:00:00	NVDA	Stock	0.5412	0.543	0.5375	0.5412	114443080.0
2008-05-13 15:00:00	NVDA	Stock	0.5413	0.5422	0.5342	0.536	185128000.0
2008-05-13 16:00:00	NVDA	Stock	0.536	0.5391	0.535	0.536	21797520.0
2008-05-13 17:00:00	NVDA	Stock	0.5352	0.5352	0.5352	0.5352	8200.0
2008-05-13 18:00:00	NVDA	Stock	0.5367	0.5378	0.5367	0.5378	140600.0
2008-05-13 20:00:00	NVDA	Stock	0.547	0.547	0.5405	0.5405	6194120.0
2008-05-13 08:00:00	AMZN	Stock	3.725	3.73	3.725	3.73	20000.0
2008-05-13 09:00:00	AMZN	Stock	3.739	3.75	3.689	3.722	13961900.0
2008-05-13 10:00:00	AMZN	Stock	3.722	3.732	3.6695	3.676	20759060.0
2008-05-13 11:00:00	AMZN	Stock	3.6765	3.7265	3.6655	3.7115	16864400.0
2008-05-13 12:00:00	AMZN	Stock	3.7115	3.7175	3.706	3.71	7018600.0
2008-05-13 13:00:00	AMZN	Stock	3.7115	3.7275	3.708	3.7125	7855560.0
2008-05-13 14:00:00	AMZN	Stock	3.7115	3.735	3.709	3.732	11243280.0
2008-05-13 15:00:00	AMZN	Stock	3.7315	3.748	3.7165	3.729	18963860.0
2008-05-13 16:00:00	AMZN	Stock	3.728	3.73	3.7102	3.728	3031700.0

> showing 50 of 40,143 rows — these rows as CSV

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