PREVIEW / stock_1hour / 2006-01-23

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-01-23.parquet
  size:    580 KB
  rows:    27,476
  symbols: 2,171

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-01-23 04:00:00	AAPL	Stock	2.6982	2.7	2.6964	2.6964	36400.0
2006-01-23 05:00:00	AAPL	Stock	2.7089	2.7089	2.6964	2.6964	25200.0
2006-01-23 06:00:00	AAPL	Stock	2.7125	2.7125	2.7125	2.7125	4620.0
2006-01-23 07:00:00	AAPL	Stock	2.7161	2.7179	2.7143	2.7179	210000.0
2006-01-23 08:00:00	AAPL	Stock	2.7179	2.7357	2.7146	2.7286	4335912.0
2006-01-23 09:00:00	AAPL	Stock	2.7286	2.7325	2.7161	2.7196	129326820.0
2006-01-23 10:00:00	AAPL	Stock	2.7196	2.7732	2.7143	2.7721	183238188.0
2006-01-23 11:00:00	AAPL	Stock	2.7721	2.8414	2.7654	2.8246	206079832.0
2006-01-23 12:00:00	AAPL	Stock	2.8246	2.8268	2.7339	2.7993	127583792.0
2006-01-23 13:00:00	AAPL	Stock	2.7993	2.825	2.7829	2.7854	104604052.0
2006-01-23 14:00:00	AAPL	Stock	2.7857	2.7971	2.7611	2.7832	135699984.0
2006-01-23 15:00:00	AAPL	Stock	2.7832	2.8	2.7686	2.7718	154726908.0
2006-01-23 16:00:00	AAPL	Stock	2.7736	2.7807	2.7586	2.7643	1856036.0
2006-01-23 17:00:00	AAPL	Stock	2.7657	2.7739	2.7643	2.7689	3096352.0
2006-01-23 18:00:00	AAPL	Stock	2.7689	2.7696	2.7661	2.7679	38472.0
2006-01-23 06:00:00	MSFT	Stock	26.45	26.45	26.45	26.45	100.0
2006-01-23 08:00:00	MSFT	Stock	26.47	26.53	26.4	26.52	15629.0
2006-01-23 09:00:00	MSFT	Stock	26.52	26.53	26.39	26.39	6105086.0
2006-01-23 10:00:00	MSFT	Stock	26.39	26.44	26.32	26.41	8984458.0
2006-01-23 11:00:00	MSFT	Stock	26.419	26.49	26.35	26.4	4392816.0
2006-01-23 12:00:00	MSFT	Stock	26.4	26.41	26.3	26.33	5319249.0
2006-01-23 13:00:00	MSFT	Stock	26.34	26.42	26.32	26.37	5623711.0
2006-01-23 14:00:00	MSFT	Stock	26.37	26.42	26.3	26.34	5322080.0
2006-01-23 15:00:00	MSFT	Stock	26.34	26.432	26.32	26.39	9262719.0
2006-01-23 16:00:00	MSFT	Stock	26.38	26.4	26.3	26.36	410428.0
2006-01-23 17:00:00	MSFT	Stock	26.35	26.35	26.35	26.35	293400.0
2006-01-23 18:00:00	MSFT	Stock	26.35	26.35	26.35	26.35	46000.0
2006-01-23 08:00:00	NVDA	Stock	0.3625	0.3625	0.3625	0.3625	120000.0
2006-01-23 09:00:00	NVDA	Stock	0.3707	0.3707	0.3647	0.3653	54067680.0
2006-01-23 10:00:00	NVDA	Stock	0.3652	0.367	0.3629	0.367	51857040.0
2006-01-23 11:00:00	NVDA	Stock	0.3671	0.3692	0.3652	0.3686	42365640.0
2006-01-23 12:00:00	NVDA	Stock	0.3686	0.369	0.3652	0.3664	28317000.0
2006-01-23 13:00:00	NVDA	Stock	0.3666	0.3692	0.3665	0.3672	42496320.0
2006-01-23 14:00:00	NVDA	Stock	0.3672	0.369	0.3672	0.3682	33005160.0
2006-01-23 15:00:00	NVDA	Stock	0.3682	0.3683	0.3666	0.3674	62494920.0
2006-01-23 16:00:00	NVDA	Stock	0.368	0.368	0.3669	0.3672	330480.0
2006-01-23 17:00:00	NVDA	Stock	0.367	0.3672	0.3667	0.3672	10068000.0
2006-01-23 08:00:00	AMZN	Stock	2.2025	2.203	2.2025	2.203	16000.0
2006-01-23 09:00:00	AMZN	Stock	2.1985	2.2375	2.19	2.193	21141360.0
2006-01-23 10:00:00	AMZN	Stock	2.193	2.205	2.175	2.1803	17667720.0
2006-01-23 11:00:00	AMZN	Stock	2.1805	2.196	2.1765	2.1915	9735980.0
2006-01-23 12:00:00	AMZN	Stock	2.191	2.191	2.182	2.1855	8278840.0
2006-01-23 13:00:00	AMZN	Stock	2.1855	2.202	2.185	2.187	10877200.0
2006-01-23 14:00:00	AMZN	Stock	2.187	2.1985	2.184	2.1955	12611340.0
2006-01-23 15:00:00	AMZN	Stock	2.1955	2.196	2.1805	2.186	18798860.0
2006-01-23 16:00:00	AMZN	Stock	2.186	2.1906	2.186	2.1865	10173700.0
2006-01-23 17:00:00	AMZN	Stock	2.1865	2.1865	2.1865	2.1865	2366000.0
2006-01-23 09:00:00	CL	Stock	26.95	26.965	26.815	26.865	554400.0
2006-01-23 10:00:00	CL	Stock	26.865	27.105	26.865	27.095	1048000.0
2006-01-23 11:00:00	CL	Stock	27.095	27.145	27.07	27.105	477800.0

> showing 50 of 27,476 rows — these rows as CSV

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