PREVIEW / stock_1hour / 2001-04-23

all stock 1-hour files

  file:    by_date/stock_1hour/2001/2001-04-23.parquet
  size:    346 KB
  rows:    16,547
  symbols: 1,286

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-04-23 08:00:00	AAPL	Stock	0.447	0.447	0.4393	0.4446	2122400.0
2001-04-23 09:00:00	AAPL	Stock	0.4429	0.4446	0.4327	0.437	50327200.0
2001-04-23 10:00:00	AAPL	Stock	0.4371	0.4464	0.435	0.4393	79710400.0
2001-04-23 11:00:00	AAPL	Stock	0.4393	0.4409	0.4323	0.4346	65609600.0
2001-04-23 12:00:00	AAPL	Stock	0.4346	0.4364	0.4296	0.4332	25776800.0
2001-04-23 13:00:00	AAPL	Stock	0.433	0.4366	0.4321	0.4363	31651200.0
2001-04-23 14:00:00	AAPL	Stock	0.4366	0.437	0.4304	0.4327	55832000.0
2001-04-23 15:00:00	AAPL	Stock	0.4323	0.4393	0.4286	0.433	86368800.0
2001-04-23 16:00:00	AAPL	Stock	0.433	0.4393	0.432	0.433	54639200.0
2001-04-23 17:00:00	AAPL	Stock	0.433	0.433	0.4295	0.4295	224000.0
2001-04-23 18:00:00	AAPL	Stock	0.4321	0.4321	0.4313	0.4313	229600.0
2001-04-23 08:00:00	MSFT	Stock	34.39	36.155	34.0	34.075	201800.0
2001-04-23 09:00:00	MSFT	Stock	34.075	34.5	33.76	33.8	20016000.0
2001-04-23 10:00:00	MSFT	Stock	33.8	33.815	33.46	33.665	22610000.0
2001-04-23 11:00:00	MSFT	Stock	33.675	33.75	33.45	33.525	6931000.0
2001-04-23 12:00:00	MSFT	Stock	33.52	33.65	33.45	33.565	5630000.0
2001-04-23 13:00:00	MSFT	Stock	33.57	33.775	33.53	33.61	5348200.0
2001-04-23 14:00:00	MSFT	Stock	33.61	33.895	33.52	33.735	7331200.0
2001-04-23 15:00:00	MSFT	Stock	33.73	34.235	33.65	34.105	13543000.0
2001-04-23 16:00:00	MSFT	Stock	34.13	34.26	33.7	34.06	2581000.0
2001-04-23 17:00:00	MSFT	Stock	34.05	34.125	34.0	34.0	35800.0
2001-04-23 18:00:00	MSFT	Stock	33.98	34.1	33.945	33.945	2600.0
2001-04-23 08:00:00	NVDA	Stock	0.3622	0.3622	0.3542	0.357	1704000.0
2001-04-23 09:00:00	NVDA	Stock	0.3542	0.3558	0.3484	0.3512	213960000.0
2001-04-23 10:00:00	NVDA	Stock	0.3515	0.3527	0.3428	0.3453	341616000.0
2001-04-23 11:00:00	NVDA	Stock	0.3454	0.3508	0.3453	0.3483	123864000.0
2001-04-23 12:00:00	NVDA	Stock	0.3484	0.3498	0.3458	0.3467	75960000.0
2001-04-23 13:00:00	NVDA	Stock	0.3467	0.3508	0.3453	0.3453	65712000.0
2001-04-23 14:00:00	NVDA	Stock	0.3452	0.3457	0.34	0.3415	141960000.0
2001-04-23 15:00:00	NVDA	Stock	0.3413	0.3448	0.3396	0.3432	164208000.0
2001-04-23 16:00:00	NVDA	Stock	0.3437	0.3449	0.3417	0.3432	5472000.0
2001-04-23 17:00:00	NVDA	Stock	0.3461	0.3461	0.3431	0.3431	384000.0
2001-04-23 18:00:00	NVDA	Stock	0.3436	0.3436	0.3436	0.3436	48000.0
2001-04-23 08:00:00	AMZN	Stock	0.8	0.8355	0.788	0.788	492000.0
2001-04-23 09:00:00	AMZN	Stock	0.7895	0.8725	0.785	0.8725	49120000.0
2001-04-23 10:00:00	AMZN	Stock	0.869	0.873	0.814	0.837	59084000.0
2001-04-23 11:00:00	AMZN	Stock	0.84	0.845	0.802	0.806	22146000.0
2001-04-23 12:00:00	AMZN	Stock	0.806	0.8225	0.8025	0.8225	15626000.0
2001-04-23 13:00:00	AMZN	Stock	0.8225	0.83	0.8125	0.8185	16262000.0
2001-04-23 14:00:00	AMZN	Stock	0.818	0.823	0.8035	0.8105	16552000.0
2001-04-23 15:00:00	AMZN	Stock	0.8105	0.825	0.8015	0.81	30294000.0
2001-04-23 16:00:00	AMZN	Stock	0.8105	0.82	0.8025	0.805	3660000.0
2001-04-23 17:00:00	AMZN	Stock	0.8025	0.8125	0.8025	0.8075	178000.0
2001-04-23 18:00:00	AMZN	Stock	0.8075	0.8125	0.805	0.805	62000.0
2001-04-23 09:00:00	CL	Stock	26.75	26.985	26.66	26.66	327000.0
2001-04-23 10:00:00	CL	Stock	26.655	26.695	26.425	26.52	552000.0
2001-04-23 11:00:00	CL	Stock	26.54	26.9	26.5	26.87	519800.0
2001-04-23 12:00:00	CL	Stock	26.865	26.95	26.835	26.835	361600.0
2001-04-23 13:00:00	CL	Stock	26.86	26.93	26.575	26.625	236200.0
2001-04-23 14:00:00	CL	Stock	26.625	26.635	26.505	26.515	352200.0

> showing 50 of 16,547 rows — these rows as CSV

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