PREVIEW / stock_1hour / 2000-10-04

all stock 1-hour files

  file:    by_date/stock_1hour/2000/2000-10-04.parquet
  size:    309 KB
  rows:    15,577
  symbols: 1,229

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
2000-10-04 08:00:00	AAPL	Stock	0.3973	0.4085	0.3884	0.3973	5275200.0
2000-10-04 09:00:00	AAPL	Stock	0.3973	0.4107	0.3906	0.404	196750400.0
2000-10-04 10:00:00	AAPL	Stock	0.404	0.4152	0.3996	0.4129	315582400.0
2000-10-04 11:00:00	AAPL	Stock	0.4118	0.4141	0.4007	0.4063	208168800.0
2000-10-04 12:00:00	AAPL	Stock	0.4063	0.4118	0.404	0.4096	150130400.0
2000-10-04 13:00:00	AAPL	Stock	0.4085	0.4152	0.4085	0.4118	119588000.0
2000-10-04 14:00:00	AAPL	Stock	0.4107	0.4152	0.4018	0.4141	150830400.0
2000-10-04 15:00:00	AAPL	Stock	0.4129	0.4241	0.4113	0.4219	244552000.0
2000-10-04 16:00:00	AAPL	Stock	0.4208	0.423	0.404	0.4107	17388000.0
2000-10-04 17:00:00	AAPL	Stock	0.4096	0.4219	0.404	0.4107	2604000.0
2000-10-04 18:00:00	AAPL	Stock	0.4129	0.4129	0.4096	0.4113	117600.0
2000-10-04 08:00:00	MSFT	Stock	28.2812	28.4688	27.5625	28.3438	792400.0
2000-10-04 09:00:00	MSFT	Stock	28.3438	28.5	27.9688	28.0938	15447000.0
2000-10-04 10:00:00	MSFT	Stock	28.0938	28.1562	27.4688	27.9375	31649400.0
2000-10-04 11:00:00	MSFT	Stock	27.9375	27.9688	27.5625	27.7812	14299800.0
2000-10-04 12:00:00	MSFT	Stock	27.7812	28.0938	27.75	27.8438	15773000.0
2000-10-04 13:00:00	MSFT	Stock	27.8281	27.875	27.5938	27.75	9893200.0
2000-10-04 14:00:00	MSFT	Stock	27.7812	27.7812	27.25	27.5625	19403800.0
2000-10-04 15:00:00	MSFT	Stock	27.5625	28.0938	27.4688	27.7188	19197000.0
2000-10-04 16:00:00	MSFT	Stock	27.6875	27.8438	27.3438	27.4688	3239200.0
2000-10-04 17:00:00	MSFT	Stock	27.4062	27.7344	27.375	27.5625	103000.0
2000-10-04 18:00:00	MSFT	Stock	27.5625	27.5625	27.5312	27.5312	14800.0
2000-10-04 08:00:00	NVDA	Stock	0.3154	0.3154	0.3125	0.3125	4680000.0
2000-10-04 09:00:00	NVDA	Stock	0.3083	0.3104	0.3036	0.3048	60792000.0
2000-10-04 10:00:00	NVDA	Stock	0.3042	0.3167	0.3026	0.3151	56280000.0
2000-10-04 11:00:00	NVDA	Stock	0.3143	0.3151	0.3063	0.3112	44136000.0
2000-10-04 12:00:00	NVDA	Stock	0.3117	0.3117	0.3063	0.3103	49368000.0
2000-10-04 13:00:00	NVDA	Stock	0.3102	0.3143	0.3073	0.3125	37608000.0
2000-10-04 14:00:00	NVDA	Stock	0.3115	0.312	0.3073	0.3083	40896000.0
2000-10-04 15:00:00	NVDA	Stock	0.3102	0.3146	0.309	0.3115	74568000.0
2000-10-04 16:00:00	NVDA	Stock	0.3115	0.3135	0.3094	0.3115	8136000.0
2000-10-04 08:00:00	AMZN	Stock	1.7562	1.7625	1.5188	1.65	1948000.0
2000-10-04 09:00:00	AMZN	Stock	1.65	1.6781	1.625	1.65	27660000.0
2000-10-04 10:00:00	AMZN	Stock	1.6438	1.7562	1.625	1.7531	24404000.0
2000-10-04 11:00:00	AMZN	Stock	1.7562	1.775	1.7125	1.725	22146000.0
2000-10-04 12:00:00	AMZN	Stock	1.7312	1.8156	1.7062	1.8016	18720000.0
2000-10-04 13:00:00	AMZN	Stock	1.8	1.85	1.7875	1.8219	13416000.0
2000-10-04 14:00:00	AMZN	Stock	1.8219	1.8312	1.7562	1.825	12108000.0
2000-10-04 15:00:00	AMZN	Stock	1.825	1.8531	1.7875	1.8	22250000.0
2000-10-04 16:00:00	AMZN	Stock	1.8	1.8375	1.7875	1.8	2194000.0
2000-10-04 17:00:00	AMZN	Stock	1.8	1.8156	1.7938	1.8047	66000.0
2000-10-04 18:00:00	AMZN	Stock	1.8156	1.8156	1.8156	1.8156	22000.0
2000-10-04 09:00:00	CL	Stock	23.875	23.875	23.75	23.82	607000.0
2000-10-04 10:00:00	CL	Stock	23.815	23.815	23.45	23.5	789800.0
2000-10-04 11:00:00	CL	Stock	23.515	23.56	23.45	23.49	374200.0
2000-10-04 12:00:00	CL	Stock	23.49	23.55	23.39	23.49	304600.0
2000-10-04 13:00:00	CL	Stock	23.49	23.52	23.45	23.45	210000.0
2000-10-04 14:00:00	CL	Stock	23.47	23.535	23.43	23.48	378400.0
2000-10-04 15:00:00	CL	Stock	23.395	23.535	23.395	23.475	503800.0
2000-10-04 16:00:00	CL	Stock	23.475	23.475	23.465	23.465	51000.0

> showing 50 of 15,577 rows — these rows as CSV

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