PREVIEW / stock_1hour / 2001-11-09

all stock 1-hour files

  file:    by_date/stock_1hour/2001/2001-11-09.parquet
  size:    363 KB
  rows:    17,288
  symbols: 1,343

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
2001-11-09 08:00:00	AAPL	Stock	0.334	0.334	0.333	0.333	375200.0
2001-11-09 09:00:00	AAPL	Stock	0.3338	0.3429	0.332	0.3386	24864000.0
2001-11-09 10:00:00	AAPL	Stock	0.3386	0.3438	0.3338	0.34	31236800.0
2001-11-09 11:00:00	AAPL	Stock	0.3398	0.3398	0.3357	0.337	13546400.0
2001-11-09 12:00:00	AAPL	Stock	0.337	0.3379	0.3336	0.3379	10976000.0
2001-11-09 13:00:00	AAPL	Stock	0.338	0.3396	0.3361	0.3371	15876000.0
2001-11-09 14:00:00	AAPL	Stock	0.3373	0.3386	0.3323	0.3329	15159200.0
2001-11-09 15:00:00	AAPL	Stock	0.333	0.3364	0.3313	0.3341	17556000.0
2001-11-09 16:00:00	AAPL	Stock	0.333	0.337	0.333	0.3341	1937600.0
2001-11-09 17:00:00	AAPL	Stock	0.3341	0.3341	0.3341	0.3341	593600.0
2001-11-09 08:00:00	MSFT	Stock	32.0315	32.3	32.0315	32.2025	62400.0
2001-11-09 09:00:00	MSFT	Stock	32.2	32.34	31.955	32.22	7282200.0
2001-11-09 10:00:00	MSFT	Stock	32.165	32.695	32.025	32.6	12360400.0
2001-11-09 11:00:00	MSFT	Stock	32.5951	32.76	32.376	32.585	7864400.0
2001-11-09 12:00:00	MSFT	Stock	32.59	32.635	32.345	32.595	4216400.0
2001-11-09 13:00:00	MSFT	Stock	32.585	32.75	32.53	32.715	3646200.0
2001-11-09 14:00:00	MSFT	Stock	32.715	32.8	32.47	32.62	4773000.0
2001-11-09 15:00:00	MSFT	Stock	32.61	32.79	32.5	32.6	5874800.0
2001-11-09 16:00:00	MSFT	Stock	32.605	32.65	32.15	32.535	1075000.0
2001-11-09 17:00:00	MSFT	Stock	32.555	32.605	32.53	32.53	96800.0
2001-11-09 18:00:00	MSFT	Stock	32.57	32.57	32.55	32.55	3600.0
2001-11-09 08:00:00	NVDA	Stock	0.4395	0.4417	0.4153	0.4312	27732000.0
2001-11-09 09:00:00	NVDA	Stock	0.43	0.4365	0.4229	0.4322	553980000.0
2001-11-09 10:00:00	NVDA	Stock	0.4323	0.4408	0.4272	0.4309	555732000.0
2001-11-09 11:00:00	NVDA	Stock	0.4312	0.4347	0.4249	0.4306	210900000.0
2001-11-09 12:00:00	NVDA	Stock	0.4308	0.432	0.4265	0.4318	139032000.0
2001-11-09 13:00:00	NVDA	Stock	0.4327	0.4351	0.4311	0.4334	201588000.0
2001-11-09 14:00:00	NVDA	Stock	0.4334	0.4367	0.4299	0.4349	163908000.0
2001-11-09 15:00:00	NVDA	Stock	0.4349	0.4437	0.4349	0.443	358332000.0
2001-11-09 16:00:00	NVDA	Stock	0.4431	0.4437	0.4335	0.4406	38196000.0
2001-11-09 17:00:00	NVDA	Stock	0.4407	0.4433	0.4406	0.4419	780000.0
2001-11-09 18:00:00	NVDA	Stock	0.4419	0.4423	0.4414	0.4414	324000.0
2001-11-09 08:00:00	AMZN	Stock	0.3775	0.3775	0.3495	0.353	422000.0
2001-11-09 09:00:00	AMZN	Stock	0.3506	0.361	0.3485	0.353	15534000.0
2001-11-09 10:00:00	AMZN	Stock	0.353	0.36	0.35	0.3565	15670000.0
2001-11-09 11:00:00	AMZN	Stock	0.3565	0.359	0.351	0.3535	6814000.0
2001-11-09 12:00:00	AMZN	Stock	0.3535	0.355	0.3515	0.354	4422000.0
2001-11-09 13:00:00	AMZN	Stock	0.354	0.3605	0.3515	0.359	14938000.0
2001-11-09 14:00:00	AMZN	Stock	0.3585	0.359	0.355	0.3575	4912000.0
2001-11-09 15:00:00	AMZN	Stock	0.3575	0.359	0.351	0.356	15488000.0
2001-11-09 16:00:00	AMZN	Stock	0.356	0.3595	0.3535	0.356	3464000.0
2001-11-09 17:00:00	AMZN	Stock	0.356	0.3575	0.356	0.3575	110000.0
2001-11-09 18:00:00	AMZN	Stock	0.3575	0.3575	0.3575	0.3575	14000.0
2001-11-09 09:00:00	CL	Stock	29.0	29.05	28.815	28.855	240000.0
2001-11-09 10:00:00	CL	Stock	28.87	28.95	28.68	28.93	586800.0
2001-11-09 11:00:00	CL	Stock	28.94	28.95	28.8	28.805	437000.0
2001-11-09 12:00:00	CL	Stock	28.805	28.805	28.6	28.7	413400.0
2001-11-09 13:00:00	CL	Stock	28.725	28.75	28.63	28.73	233000.0
2001-11-09 14:00:00	CL	Stock	28.73	28.745	28.6	28.725	364000.0
2001-11-09 15:00:00	CL	Stock	28.675	28.75	28.625	28.675	649800.0

> showing 50 of 17,288 rows — these rows as CSV

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