PREVIEW / stock_1hour / 2006-09-29

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-09-29.parquet
  size:    634 KB
  rows:    30,217
  symbols: 2,387

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-09-29 07:00:00	AAPL	Stock	2.7607	2.7632	2.7604	2.7632	33600.0
2006-09-29 08:00:00	AAPL	Stock	2.7625	2.7679	2.76	2.7639	1822268.0
2006-09-29 09:00:00	AAPL	Stock	2.7643	2.7686	2.7386	2.7486	85326360.0
2006-09-29 10:00:00	AAPL	Stock	2.7493	2.7589	2.7454	2.7525	90235824.0
2006-09-29 11:00:00	AAPL	Stock	2.7518	2.755	2.7461	2.7511	46342268.0
2006-09-29 12:00:00	AAPL	Stock	2.7514	2.7536	2.7475	2.7536	23733724.0
2006-09-29 13:00:00	AAPL	Stock	2.7536	2.7579	2.75	2.7564	42010164.0
2006-09-29 14:00:00	AAPL	Stock	2.7564	2.7589	2.75	2.7536	33220208.0
2006-09-29 15:00:00	AAPL	Stock	2.7536	2.7546	2.7464	2.7482	63768712.0
2006-09-29 16:00:00	AAPL	Stock	2.7479	2.7529	2.745	2.745	1702876.0
2006-09-29 17:00:00	AAPL	Stock	2.7464	2.7511	2.7429	2.7446	1131620.0
2006-09-29 18:00:00	AAPL	Stock	2.7464	2.7464	2.7454	2.7457	58520.0
2006-09-29 19:00:00	AAPL	Stock	2.7457	2.7457	2.7457	2.7457	19600.0
2006-09-29 08:00:00	MSFT	Stock	27.4	27.44	27.4	27.44	11900.0
2006-09-29 09:00:00	MSFT	Stock	27.41	27.41	27.21	27.24	5257095.0
2006-09-29 10:00:00	MSFT	Stock	27.24	27.4	27.24	27.32	6282071.0
2006-09-29 11:00:00	MSFT	Stock	27.29	27.41	27.29	27.41	3594074.0
2006-09-29 12:00:00	MSFT	Stock	27.41	27.42	27.33	27.36	2735281.0
2006-09-29 13:00:00	MSFT	Stock	27.37	27.4	27.33	27.37	2991046.0
2006-09-29 14:00:00	MSFT	Stock	27.37	27.38	27.31	27.35	2611369.0
2006-09-29 15:00:00	MSFT	Stock	27.34	27.39	27.29	27.33	6315972.0
2006-09-29 16:00:00	MSFT	Stock	27.32	27.38	27.29	27.33	776039.0
2006-09-29 17:00:00	MSFT	Stock	27.3	27.33	27.3	27.32	85800.0
2006-09-29 18:00:00	MSFT	Stock	27.3	27.33	27.3	27.33	1550.0
2006-09-29 08:00:00	NVDA	Stock	0.4958	0.5	0.4958	0.4983	318000.0
2006-09-29 09:00:00	NVDA	Stock	0.4982	0.4983	0.4905	0.493	54664980.0
2006-09-29 10:00:00	NVDA	Stock	0.4932	0.4997	0.4915	0.494	75279780.0
2006-09-29 11:00:00	NVDA	Stock	0.494	0.497	0.4927	0.4965	46550400.0
2006-09-29 12:00:00	NVDA	Stock	0.4965	0.4982	0.495	0.4982	37535100.0
2006-09-29 13:00:00	NVDA	Stock	0.4983	0.5	0.497	0.497	43317420.0
2006-09-29 14:00:00	NVDA	Stock	0.4972	0.4983	0.4933	0.494	32369880.0
2006-09-29 15:00:00	NVDA	Stock	0.494	0.4963	0.4908	0.4932	70620240.0
2006-09-29 16:00:00	NVDA	Stock	0.4928	0.495	0.4913	0.4917	1583340.0
2006-09-29 17:00:00	NVDA	Stock	0.4932	0.4933	0.4932	0.4933	54000.0
2006-09-29 19:00:00	NVDA	Stock	0.4938	0.4938	0.4938	0.4938	60000.0
2006-09-29 09:00:00	AMZN	Stock	1.59	1.607	1.577	1.595	13194760.0
2006-09-29 10:00:00	AMZN	Stock	1.596	1.617	1.596	1.609	21085800.0
2006-09-29 11:00:00	AMZN	Stock	1.609	1.611	1.6025	1.6095	17744340.0
2006-09-29 12:00:00	AMZN	Stock	1.6095	1.6095	1.6	1.606	9008140.0
2006-09-29 13:00:00	AMZN	Stock	1.6065	1.61	1.601	1.609	7075780.0
2006-09-29 14:00:00	AMZN	Stock	1.609	1.614	1.606	1.6085	8333600.0
2006-09-29 15:00:00	AMZN	Stock	1.608	1.611	1.603	1.606	17938140.0
2006-09-29 16:00:00	AMZN	Stock	1.606	1.607	1.606	1.606	137840.0
2006-09-29 17:00:00	AMZN	Stock	1.607	1.607	1.606	1.606	34680.0
2006-09-29 09:00:00	CL	Stock	31.21	31.27	31.165	31.215	285600.0
2006-09-29 10:00:00	CL	Stock	31.215	31.37	31.165	31.29	598400.0
2006-09-29 11:00:00	CL	Stock	31.29	31.315	31.225	31.25	219800.0
2006-09-29 12:00:00	CL	Stock	31.245	31.25	31.085	31.085	297800.0
2006-09-29 13:00:00	CL	Stock	31.08	31.105	30.995	30.995	303200.0
2006-09-29 14:00:00	CL	Stock	30.99	31.01	30.95	30.97	371400.0

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

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