PREVIEW / stock_1hour / 2006-08-29

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-08-29.parquet
  size:    617 KB
  rows:    29,863
  symbols: 2,348

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
2006-08-29 07:00:00	AAPL	Stock	2.4036	2.4036	2.3964	2.3964	42000.0
2006-08-29 08:00:00	AAPL	Stock	2.3979	2.4014	2.3868	2.3882	1635956.0
2006-08-29 09:00:00	AAPL	Stock	2.3886	2.4021	2.3475	2.3686	159315744.0
2006-08-29 10:00:00	AAPL	Stock	2.3682	2.3921	2.3375	2.3425	221111940.0
2006-08-29 11:00:00	AAPL	Stock	2.3425	2.3486	2.3257	2.3321	120932616.0
2006-08-29 12:00:00	AAPL	Stock	2.3318	2.3421	2.3271	2.3379	66236912.0
2006-08-29 13:00:00	AAPL	Stock	2.3379	2.3443	2.3357	2.3421	51208892.0
2006-08-29 14:00:00	AAPL	Stock	2.3425	2.3643	2.3369	2.3593	165860156.0
2006-08-29 15:00:00	AAPL	Stock	2.3596	2.3771	2.3561	2.3739	139471500.0
2006-08-29 16:00:00	AAPL	Stock	2.3736	2.3929	2.3732	2.3864	5140912.0
2006-08-29 17:00:00	AAPL	Stock	2.3875	2.3925	2.3861	2.3893	972244.0
2006-08-29 18:00:00	AAPL	Stock	2.3879	2.3879	2.3843	2.3857	129696.0
2006-08-29 08:00:00	MSFT	Stock	25.93	25.99	25.9	25.9	9050.0
2006-08-29 09:00:00	MSFT	Stock	25.96	25.98	25.87	25.93	4416038.0
2006-08-29 10:00:00	MSFT	Stock	25.92	25.94	25.65	25.75	9392977.0
2006-08-29 11:00:00	MSFT	Stock	25.75	25.81	25.68	25.69	3395761.0
2006-08-29 12:00:00	MSFT	Stock	25.68	25.76	25.63	25.67	3608107.0
2006-08-29 13:00:00	MSFT	Stock	25.66	25.75	25.66	25.73	3014872.0
2006-08-29 14:00:00	MSFT	Stock	25.738	25.88	25.66	25.82	6873267.0
2006-08-29 15:00:00	MSFT	Stock	25.83	25.91	25.77	25.81	9760421.0
2006-08-29 16:00:00	MSFT	Stock	25.82	25.84	25.8	25.82	203462.0
2006-08-29 17:00:00	MSFT	Stock	25.81	25.83	25.78	25.83	17929.0
2006-08-29 08:00:00	NVDA	Stock	0.4575	0.4622	0.4575	0.4603	402000.0
2006-08-29 09:00:00	NVDA	Stock	0.4603	0.4665	0.4575	0.4662	83840340.0
2006-08-29 10:00:00	NVDA	Stock	0.4663	0.4667	0.4608	0.4632	96310560.0
2006-08-29 11:00:00	NVDA	Stock	0.463	0.466	0.4595	0.4653	65317980.0
2006-08-29 12:00:00	NVDA	Stock	0.4653	0.4675	0.4613	0.4663	102381840.0
2006-08-29 13:00:00	NVDA	Stock	0.4663	0.4692	0.4663	0.4678	50377080.0
2006-08-29 14:00:00	NVDA	Stock	0.468	0.4747	0.467	0.4743	129742980.0
2006-08-29 15:00:00	NVDA	Stock	0.4745	0.4793	0.4728	0.4777	163798920.0
2006-08-29 16:00:00	NVDA	Stock	0.4777	0.4785	0.477	0.477	2340600.0
2006-08-29 17:00:00	NVDA	Stock	0.4772	0.4772	0.4762	0.4762	1024140.0
2006-08-29 08:00:00	AMZN	Stock	1.449	1.449	1.448	1.448	4000.0
2006-08-29 09:00:00	AMZN	Stock	1.4465	1.455	1.4445	1.4524	14590500.0
2006-08-29 10:00:00	AMZN	Stock	1.452	1.4525	1.44	1.445	17753760.0
2006-08-29 11:00:00	AMZN	Stock	1.445	1.4465	1.4405	1.4425	12666940.0
2006-08-29 12:00:00	AMZN	Stock	1.4425	1.444	1.442	1.444	8222660.0
2006-08-29 13:00:00	AMZN	Stock	1.4435	1.444	1.4385	1.439	6650180.0
2006-08-29 14:00:00	AMZN	Stock	1.4395	1.465	1.4375	1.4595	28028680.0
2006-08-29 15:00:00	AMZN	Stock	1.4595	1.486	1.4575	1.4765	56080700.0
2006-08-29 16:00:00	AMZN	Stock	1.4755	1.48	1.4755	1.476	330240.0
2006-08-29 18:00:00	AMZN	Stock	1.4755	1.4755	1.4755	1.4755	10000.0
2006-08-29 09:00:00	CL	Stock	29.375	29.475	29.335	29.455	256400.0
2006-08-29 10:00:00	CL	Stock	29.46	29.485	29.385	29.465	615600.0
2006-08-29 11:00:00	CL	Stock	29.455	29.49	29.42	29.455	402000.0
2006-08-29 12:00:00	CL	Stock	29.46	29.475	29.425	29.445	164200.0
2006-08-29 13:00:00	CL	Stock	29.445	29.5	29.425	29.455	252600.0
2006-08-29 14:00:00	CL	Stock	29.455	29.56	29.445	29.56	583800.0
2006-08-29 15:00:00	CL	Stock	29.565	29.74	29.535	29.715	771000.0
2006-08-29 16:00:00	CL	Stock	29.725	29.725	29.725	29.725	6400.0

> showing 50 of 29,863 rows — these rows as CSV

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