PREVIEW / stock_1hour / 2007-01-29

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-01-29.parquet
  size:    639 KB
  rows:    30,445
  symbols: 2,514

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-01-29 07:00:00	AAPL	Stock	3.0436	3.0707	3.0436	3.0586	849800.0
2007-01-29 08:00:00	AAPL	Stock	3.0625	3.0789	3.0611	3.075	7644140.0
2007-01-29 09:00:00	AAPL	Stock	3.0739	3.0943	3.0643	3.0739	159462156.0
2007-01-29 10:00:00	AAPL	Stock	3.0736	3.0907	3.0575	3.0729	205871484.0
2007-01-29 11:00:00	AAPL	Stock	3.0736	3.0811	3.0661	3.071	95400928.0
2007-01-29 12:00:00	AAPL	Stock	3.0707	3.0914	3.0629	3.0911	110930904.0
2007-01-29 13:00:00	AAPL	Stock	3.0911	3.0946	3.0618	3.0632	106416352.0
2007-01-29 14:00:00	AAPL	Stock	3.0629	3.07	3.0546	3.0607	93846340.0
2007-01-29 15:00:00	AAPL	Stock	3.0607	3.0743	3.06	3.0682	96756688.0
2007-01-29 16:00:00	AAPL	Stock	3.0689	3.0786	3.0675	3.0739	4155704.0
2007-01-29 17:00:00	AAPL	Stock	3.0739	3.0768	3.0693	3.0768	373072.0
2007-01-29 18:00:00	AAPL	Stock	3.0768	3.0804	3.0768	3.0796	464296.0
2007-01-29 19:00:00	AAPL	Stock	3.0771	3.0796	3.0771	3.0779	334796.0
2007-01-29 07:00:00	MSFT	Stock	30.75	30.75	30.65	30.7	6677.0
2007-01-29 08:00:00	MSFT	Stock	30.7	30.72	30.61	30.61	33386.0
2007-01-29 09:00:00	MSFT	Stock	30.64	30.78	30.45	30.53	9586217.0
2007-01-29 10:00:00	MSFT	Stock	30.53	30.65	30.38	30.46	9344021.0
2007-01-29 11:00:00	MSFT	Stock	30.46	30.47	30.34	30.36	6169750.0
2007-01-29 12:00:00	MSFT	Stock	30.37	30.66	30.36	30.59	6622345.0
2007-01-29 13:00:00	MSFT	Stock	30.59	30.62	30.37	30.4	6045364.0
2007-01-29 14:00:00	MSFT	Stock	30.4	30.49	30.34	30.46	6972494.0
2007-01-29 15:00:00	MSFT	Stock	30.46	30.56	30.4	30.53	9611448.0
2007-01-29 16:00:00	MSFT	Stock	30.53	30.7	30.5	30.6	731045.0
2007-01-29 17:00:00	MSFT	Stock	30.6	30.62	30.56	30.62	4300.0
2007-01-29 18:00:00	MSFT	Stock	30.62	30.64	30.62	30.62	8180.0
2007-01-29 19:00:00	MSFT	Stock	30.63	30.65	30.62	30.64	5050.0
2007-01-29 08:00:00	NVDA	Stock	0.5245	0.5258	0.5245	0.5258	342000.0
2007-01-29 09:00:00	NVDA	Stock	0.525	0.525	0.5037	0.5048	181884420.0
2007-01-29 10:00:00	NVDA	Stock	0.5047	0.5173	0.5038	0.5167	200642700.0
2007-01-29 11:00:00	NVDA	Stock	0.5168	0.52	0.5157	0.5173	111354900.0
2007-01-29 12:00:00	NVDA	Stock	0.5175	0.5185	0.5143	0.5183	101696340.0
2007-01-29 13:00:00	NVDA	Stock	0.5182	0.5185	0.5087	0.5092	118448100.0
2007-01-29 14:00:00	NVDA	Stock	0.509	0.5093	0.4985	0.4987	221313540.0
2007-01-29 15:00:00	NVDA	Stock	0.4988	0.5035	0.4987	0.503	272241420.0
2007-01-29 16:00:00	NVDA	Stock	0.503	0.5033	0.5017	0.5033	1910280.0
2007-01-29 17:00:00	NVDA	Stock	0.503	0.5037	0.503	0.5037	113940.0
2007-01-29 18:00:00	NVDA	Stock	0.5033	0.5037	0.5033	0.5033	28140.0
2007-01-29 19:00:00	NVDA	Stock	0.5037	0.5037	0.5037	0.5037	49020.0
2007-01-29 08:00:00	AMZN	Stock	1.84	1.84	1.84	1.84	2000.0
2007-01-29 09:00:00	AMZN	Stock	1.83	1.845	1.82	1.84	9370720.0
2007-01-29 10:00:00	AMZN	Stock	1.84	1.8455	1.8375	1.844	20688200.0
2007-01-29 11:00:00	AMZN	Stock	1.844	1.8525	1.84	1.8485	12234940.0
2007-01-29 12:00:00	AMZN	Stock	1.8485	1.867	1.84	1.8665	37311800.0
2007-01-29 13:00:00	AMZN	Stock	1.867	1.8715	1.858	1.858	9705840.0
2007-01-29 14:00:00	AMZN	Stock	1.858	1.865	1.8555	1.861	20855620.0
2007-01-29 15:00:00	AMZN	Stock	1.861	1.8725	1.858	1.8715	25157160.0
2007-01-29 16:00:00	AMZN	Stock	1.872	1.873	1.8675	1.868	45740.0
2007-01-29 17:00:00	AMZN	Stock	1.8715	1.8715	1.8715	1.8715	5180.0
2007-01-29 18:00:00	AMZN	Stock	1.8675	1.8675	1.8675	1.8675	20000.0
2007-01-29 09:00:00	CL	Stock	32.645	33.375	32.645	33.335	544600.0

> showing 50 of 30,445 rows — these rows as CSV

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