PREVIEW / stock_1hour / 2007-10-04

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-10-04.parquet
  size:    790 KB
  rows:    39,118
  symbols: 3,128

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
2007-10-04 05:00:00	AAPL	Stock	5.6425	5.6464	5.6425	5.6429	28000.0
2007-10-04 06:00:00	AAPL	Stock	5.6429	5.6429	5.6429	5.6429	35560.0
2007-10-04 07:00:00	AAPL	Stock	5.6489	5.6504	5.6361	5.6446	245952.0
2007-10-04 08:00:00	AAPL	Stock	5.6429	5.6554	5.6339	5.6479	3660888.0
2007-10-04 09:00:00	AAPL	Stock	5.6475	5.6539	5.4821	5.5454	174561800.0
2007-10-04 10:00:00	AAPL	Stock	5.5457	5.5946	5.5243	5.5879	146284040.0
2007-10-04 11:00:00	AAPL	Stock	5.5882	5.6029	5.5729	5.5822	70377160.0
2007-10-04 12:00:00	AAPL	Stock	5.5821	5.5893	5.5636	5.5807	46766188.0
2007-10-04 13:00:00	AAPL	Stock	5.5807	5.5846	5.5571	5.5693	46689244.0
2007-10-04 14:00:00	AAPL	Stock	5.5693	5.5761	5.5414	5.555	57491616.0
2007-10-04 15:00:00	AAPL	Stock	5.555	5.5893	5.5546	5.5832	92946196.0
2007-10-04 16:00:00	AAPL	Stock	5.5807	5.5882	5.525	5.5575	15921332.0
2007-10-04 17:00:00	AAPL	Stock	5.5596	5.5836	5.5589	5.5661	596596.0
2007-10-04 18:00:00	AAPL	Stock	5.5704	5.58	5.5543	5.5543	1067752.0
2007-10-04 19:00:00	AAPL	Stock	5.5571	5.5711	5.5539	5.5711	572544.0
2007-10-04 08:00:00	MSFT	Stock	29.4	29.45	29.37	29.45	9473.0
2007-10-04 09:00:00	MSFT	Stock	29.44	29.6	29.44	29.46	3607285.0
2007-10-04 10:00:00	MSFT	Stock	29.46	29.7	29.46	29.69	8779992.0
2007-10-04 11:00:00	MSFT	Stock	29.68	29.75	29.61	29.619	4683770.0
2007-10-04 12:00:00	MSFT	Stock	29.619	29.65	29.58	29.59	2613301.0
2007-10-04 13:00:00	MSFT	Stock	29.59	29.6	29.53	29.541	2976621.0
2007-10-04 14:00:00	MSFT	Stock	29.541	29.6	29.53	29.54	3512775.0
2007-10-04 15:00:00	MSFT	Stock	29.54	29.77	29.53	29.73	9520739.0
2007-10-04 16:00:00	MSFT	Stock	29.73	29.79	29.6	29.7	2046004.0
2007-10-04 17:00:00	MSFT	Stock	29.69	29.73	29.606	29.72	103100.0
2007-10-04 18:00:00	MSFT	Stock	29.71	29.71	29.69	29.69	16663.0
2007-10-04 19:00:00	MSFT	Stock	29.71	29.72	29.69	29.69	550.0
2007-10-04 08:00:00	NVDA	Stock	0.8958	0.9	0.89	0.9	167480.0
2007-10-04 09:00:00	NVDA	Stock	0.9	0.9023	0.8708	0.8762	58407600.0
2007-10-04 10:00:00	NVDA	Stock	0.876	0.8895	0.8758	0.8852	66999120.0
2007-10-04 11:00:00	NVDA	Stock	0.8852	0.8863	0.8688	0.8835	70481440.0
2007-10-04 12:00:00	NVDA	Stock	0.8835	0.8938	0.8835	0.8932	29951800.0
2007-10-04 13:00:00	NVDA	Stock	0.8932	0.897	0.888	0.8904	28422760.0
2007-10-04 14:00:00	NVDA	Stock	0.8902	0.8985	0.8902	0.8978	36832400.0
2007-10-04 15:00:00	NVDA	Stock	0.8975	0.9048	0.897	0.8992	74509160.0
2007-10-04 16:00:00	NVDA	Stock	0.8992	0.9015	0.8885	0.8973	13067120.0
2007-10-04 17:00:00	NVDA	Stock	0.8991	0.8992	0.894	0.8992	140000.0
2007-10-04 18:00:00	NVDA	Stock	0.8975	0.8975	0.8975	0.8975	28000.0
2007-10-04 05:00:00	AMZN	Stock	4.6	4.6	4.6	4.6	4000.0
2007-10-04 06:00:00	AMZN	Stock	4.6	4.6	4.6	4.6	2200.0
2007-10-04 07:00:00	AMZN	Stock	4.591	4.6285	4.591	4.624	18000.0
2007-10-04 08:00:00	AMZN	Stock	4.621	4.6215	4.603	4.6125	150400.0
2007-10-04 09:00:00	AMZN	Stock	4.6125	4.629	4.5725	4.5875	9948660.0
2007-10-04 10:00:00	AMZN	Stock	4.589	4.6148	4.58	4.6125	11536440.0
2007-10-04 11:00:00	AMZN	Stock	4.6125	4.6145	4.6	4.6095	4859500.0
2007-10-04 12:00:00	AMZN	Stock	4.609	4.6125	4.604	4.6095	4226820.0
2007-10-04 13:00:00	AMZN	Stock	4.61	4.622	4.605	4.6085	9027380.0
2007-10-04 14:00:00	AMZN	Stock	4.6085	4.616	4.598	4.601	9390920.0
2007-10-04 15:00:00	AMZN	Stock	4.601	4.616	4.5985	4.6125	14567800.0
2007-10-04 16:00:00	AMZN	Stock	4.6115	4.616	4.5905	4.6125	1653400.0

> showing 50 of 39,118 rows — these rows as CSV

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