PREVIEW / stock_1hour / 2006-09-07

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-09-07.parquet
  size:    593 KB
  rows:    28,461
  symbols: 2,357

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-07 04:00:00	AAPL	Stock	2.4964	2.4964	2.4964	2.4964	28000.0
2006-09-07 06:00:00	AAPL	Stock	2.5018	2.5018	2.5004	2.5004	8400.0
2006-09-07 07:00:00	AAPL	Stock	2.5089	2.5179	2.5089	2.5136	245700.0
2006-09-07 08:00:00	AAPL	Stock	2.5175	2.525	2.5107	2.5232	5943392.0
2006-09-07 09:00:00	AAPL	Stock	2.5218	2.5493	2.5089	2.5371	162759156.0
2006-09-07 10:00:00	AAPL	Stock	2.5375	2.5714	2.5296	2.5586	250050304.0
2006-09-07 11:00:00	AAPL	Stock	2.5586	2.6	2.5579	2.595	202884304.0
2006-09-07 12:00:00	AAPL	Stock	2.595	2.6018	2.5875	2.5911	103479768.0
2006-09-07 13:00:00	AAPL	Stock	2.5914	2.6179	2.5839	2.6086	138149536.0
2006-09-07 14:00:00	AAPL	Stock	2.6089	2.6243	2.5964	2.5993	169770664.0
2006-09-07 15:00:00	AAPL	Stock	2.5996	2.6086	2.5875	2.5989	220111612.0
2006-09-07 16:00:00	AAPL	Stock	2.5989	2.6046	2.5957	2.5964	3529708.0
2006-09-07 17:00:00	AAPL	Stock	2.5982	2.6018	2.5979	2.6011	216048.0
2006-09-07 18:00:00	AAPL	Stock	2.6	2.6021	2.5993	2.6011	56980.0
2006-09-07 04:00:00	MSFT	Stock	25.56	25.56	25.31	25.31	400.0
2006-09-07 07:00:00	MSFT	Stock	25.52	25.55	25.47	25.55	4050.0
2006-09-07 08:00:00	MSFT	Stock	25.55	25.55	25.5	25.54	38207.0
2006-09-07 09:00:00	MSFT	Stock	25.53	25.7	25.39	25.61	7042440.0
2006-09-07 10:00:00	MSFT	Stock	25.61	25.62	25.52	25.57	7795749.0
2006-09-07 11:00:00	MSFT	Stock	25.56	25.62	25.54	25.61	5049202.0
2006-09-07 12:00:00	MSFT	Stock	25.61	25.65	25.54	25.55	3322355.0
2006-09-07 13:00:00	MSFT	Stock	25.56	25.68	25.55	25.65	5651435.0
2006-09-07 14:00:00	MSFT	Stock	25.66	25.67	25.56	25.6	6104414.0
2006-09-07 15:00:00	MSFT	Stock	25.6	25.61	25.43	25.43	12052138.0
2006-09-07 16:00:00	MSFT	Stock	25.43	25.472	25.4	25.42	1304883.0
2006-09-07 17:00:00	MSFT	Stock	25.43	25.44	25.42	25.42	4200.0
2006-09-07 18:00:00	MSFT	Stock	25.43	25.43	25.43	25.43	499.0
2006-09-07 08:00:00	NVDA	Stock	0.4458	0.4465	0.4433	0.4448	634200.0
2006-09-07 09:00:00	NVDA	Stock	0.4435	0.4528	0.439	0.4517	126081720.0
2006-09-07 10:00:00	NVDA	Stock	0.4517	0.4598	0.4443	0.4545	130516260.0
2006-09-07 11:00:00	NVDA	Stock	0.4543	0.4633	0.4543	0.4628	98732340.0
2006-09-07 12:00:00	NVDA	Stock	0.4628	0.466	0.4592	0.462	92059500.0
2006-09-07 13:00:00	NVDA	Stock	0.462	0.4703	0.4602	0.4687	85899780.0
2006-09-07 14:00:00	NVDA	Stock	0.4688	0.4698	0.4603	0.4655	94059660.0
2006-09-07 15:00:00	NVDA	Stock	0.4653	0.4655	0.4592	0.4607	93694200.0
2006-09-07 16:00:00	NVDA	Stock	0.4603	0.4612	0.4602	0.4602	544920.0
2006-09-07 17:00:00	NVDA	Stock	0.4602	0.4602	0.4602	0.4602	66000.0
2006-09-07 08:00:00	AMZN	Stock	1.5305	1.5305	1.525	1.525	35000.0
2006-09-07 09:00:00	AMZN	Stock	1.5255	1.535	1.504	1.51	24251700.0
2006-09-07 10:00:00	AMZN	Stock	1.51	1.51	1.4945	1.5025	36418240.0
2006-09-07 11:00:00	AMZN	Stock	1.5025	1.51	1.501	1.5035	26756840.0
2006-09-07 12:00:00	AMZN	Stock	1.5035	1.51	1.5	1.501	18062160.0
2006-09-07 13:00:00	AMZN	Stock	1.501	1.514	1.498	1.5095	13404540.0
2006-09-07 14:00:00	AMZN	Stock	1.5095	1.5135	1.5045	1.505	11886560.0
2006-09-07 15:00:00	AMZN	Stock	1.505	1.5055	1.484	1.4865	41668180.0
2006-09-07 16:00:00	AMZN	Stock	1.4865	1.489	1.485	1.485	1337740.0
2006-09-07 17:00:00	AMZN	Stock	1.4865	1.5	1.4865	1.496	282500.0
2006-09-07 18:00:00	AMZN	Stock	1.495	1.495	1.495	1.495	22500.0
2006-09-07 09:00:00	CL	Stock	30.635	30.85	30.525	30.79	499000.0
2006-09-07 10:00:00	CL	Stock	30.79	30.81	30.61	30.62	724800.0

> showing 50 of 28,461 rows — these rows as CSV

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