PREVIEW / stock_1hour / 2001-10-23

all stock 1-hour files

  file:    by_date/stock_1hour/2001/2001-10-23.parquet
  size:    362 KB
  rows:    17,061
  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-10-23 08:00:00	AAPL	Stock	0.3398	0.3427	0.3398	0.3407	302400.0
2001-10-23 09:00:00	AAPL	Stock	0.3413	0.3421	0.3354	0.3384	32004000.0
2001-10-23 10:00:00	AAPL	Stock	0.3386	0.3464	0.3384	0.3448	107374400.0
2001-10-23 11:00:00	AAPL	Stock	0.345	0.3464	0.3345	0.3354	42078400.0
2001-10-23 12:00:00	AAPL	Stock	0.3357	0.3398	0.3345	0.3375	67569600.0
2001-10-23 13:00:00	AAPL	Stock	0.3377	0.3396	0.3357	0.3393	23777600.0
2001-10-23 14:00:00	AAPL	Stock	0.3391	0.3393	0.3191	0.3223	204332800.0
2001-10-23 15:00:00	AAPL	Stock	0.3214	0.3273	0.3211	0.3239	127192800.0
2001-10-23 16:00:00	AAPL	Stock	0.3241	0.3366	0.3216	0.3239	24556000.0
2001-10-23 08:00:00	MSFT	Stock	30.25	30.375	30.0775	30.25	99400.0
2001-10-23 09:00:00	MSFT	Stock	30.25	30.486	30.065	30.4445	15383000.0
2001-10-23 10:00:00	MSFT	Stock	30.45	30.72	30.325	30.455	13767600.0
2001-10-23 11:00:00	MSFT	Stock	30.445	30.655	30.34	30.415	7574200.0
2001-10-23 12:00:00	MSFT	Stock	30.415	30.43	30.015	30.305	9592600.0
2001-10-23 13:00:00	MSFT	Stock	30.3105	30.4005	30.125	30.32	6142000.0
2001-10-23 14:00:00	MSFT	Stock	30.32	30.33	29.765	29.83	8442200.0
2001-10-23 15:00:00	MSFT	Stock	29.825	30.4	29.7	30.22	13807400.0
2001-10-23 16:00:00	MSFT	Stock	30.22	30.39	30.05	30.2	2589000.0
2001-10-23 17:00:00	MSFT	Stock	30.287	30.287	30.165	30.165	23600.0
2001-10-23 18:00:00	MSFT	Stock	30.22	30.225	30.14	30.16	3000.0
2001-10-23 08:00:00	NVDA	Stock	0.3784	0.3801	0.3775	0.3783	1716000.0
2001-10-23 09:00:00	NVDA	Stock	0.3783	0.385	0.3747	0.3821	115104000.0
2001-10-23 10:00:00	NVDA	Stock	0.3821	0.3901	0.3781	0.3859	193500000.0
2001-10-23 11:00:00	NVDA	Stock	0.3858	0.3871	0.3794	0.3802	94344000.0
2001-10-23 12:00:00	NVDA	Stock	0.3799	0.3823	0.3734	0.3762	94716000.0
2001-10-23 13:00:00	NVDA	Stock	0.3767	0.3783	0.3724	0.3782	78504000.0
2001-10-23 14:00:00	NVDA	Stock	0.3782	0.3783	0.3658	0.3676	142944000.0
2001-10-23 15:00:00	NVDA	Stock	0.3672	0.3771	0.3633	0.372	174792000.0
2001-10-23 16:00:00	NVDA	Stock	0.3717	0.3774	0.371	0.3771	16212000.0
2001-10-23 17:00:00	NVDA	Stock	0.3712	0.3721	0.3712	0.3712	420000.0
2001-10-23 18:00:00	NVDA	Stock	0.3712	0.3712	0.3712	0.3712	60000.0
2001-10-23 08:00:00	AMZN	Stock	0.45	0.49	0.45	0.46	276000.0
2001-10-23 09:00:00	AMZN	Stock	0.46	0.469	0.4525	0.4605	30498000.0
2001-10-23 10:00:00	AMZN	Stock	0.4605	0.477	0.459	0.4615	48242000.0
2001-10-23 11:00:00	AMZN	Stock	0.462	0.4625	0.4425	0.445	20010000.0
2001-10-23 12:00:00	AMZN	Stock	0.4475	0.4625	0.4435	0.4575	13700000.0
2001-10-23 13:00:00	AMZN	Stock	0.456	0.4685	0.4535	0.459	14090000.0
2001-10-23 14:00:00	AMZN	Stock	0.459	0.461	0.446	0.4555	21278000.0
2001-10-23 15:00:00	AMZN	Stock	0.455	0.48	0.4525	0.4795	42336000.0
2001-10-23 16:00:00	AMZN	Stock	0.479	0.4815	0.4425	0.4505	37788000.0
2001-10-23 17:00:00	AMZN	Stock	0.452	0.4525	0.433	0.4465	3086000.0
2001-10-23 18:00:00	AMZN	Stock	0.4465	0.45	0.44	0.445	432000.0
2001-10-23 09:00:00	CL	Stock	29.625	29.63	29.405	29.505	359600.0
2001-10-23 10:00:00	CL	Stock	29.515	29.55	29.405	29.425	338000.0
2001-10-23 11:00:00	CL	Stock	29.41	29.425	29.2	29.375	315000.0
2001-10-23 12:00:00	CL	Stock	29.365	29.48	29.3	29.375	303200.0
2001-10-23 13:00:00	CL	Stock	29.38	29.45	29.365	29.37	145200.0
2001-10-23 14:00:00	CL	Stock	29.37	29.49	29.235	29.36	444400.0
2001-10-23 15:00:00	CL	Stock	29.375	29.445	29.275	29.37	661400.0
2001-10-23 16:00:00	CL	Stock	29.37	29.395	29.35	29.385	370600.0

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

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