PREVIEW / stock_1hour / 2001-08-28

all stock 1-hour files

  file:    by_date/stock_1hour/2001/2001-08-28.parquet
  size:    363 KB
  rows:    16,960
  symbols: 1,333

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-08-28 09:00:00	AAPL	Stock	0.3379	0.3391	0.3321	0.3366	16016000.0
2001-08-28 10:00:00	AAPL	Stock	0.3366	0.3395	0.3346	0.3364	27552000.0
2001-08-28 11:00:00	AAPL	Stock	0.3366	0.337	0.3341	0.3354	18244800.0
2001-08-28 12:00:00	AAPL	Stock	0.3354	0.3384	0.3341	0.3373	19034400.0
2001-08-28 13:00:00	AAPL	Stock	0.3371	0.3418	0.3352	0.3404	15668800.0
2001-08-28 14:00:00	AAPL	Stock	0.3405	0.3405	0.3309	0.3341	28593600.0
2001-08-28 15:00:00	AAPL	Stock	0.3341	0.3348	0.3286	0.3286	17276000.0
2001-08-28 16:00:00	AAPL	Stock	0.3291	0.3357	0.3286	0.3286	7252000.0
2001-08-28 17:00:00	AAPL	Stock	0.3286	0.3286	0.3286	0.3286	660800.0
2001-08-28 08:00:00	MSFT	Stock	31.15	31.15	31.025	31.15	55800.0
2001-08-28 09:00:00	MSFT	Stock	31.125	31.475	30.97	31.265	5327000.0
2001-08-28 10:00:00	MSFT	Stock	31.255	31.26	30.65	30.7201	8701200.0
2001-08-28 11:00:00	MSFT	Stock	30.725	30.975	30.605	30.855	5010400.0
2001-08-28 12:00:00	MSFT	Stock	30.86	30.88	30.65	30.785	3171600.0
2001-08-28 13:00:00	MSFT	Stock	30.79	30.97	30.65	30.9	5335000.0
2001-08-28 14:00:00	MSFT	Stock	30.9	30.915	30.29	30.44	6404800.0
2001-08-28 15:00:00	MSFT	Stock	30.435	30.61	30.29	30.365	8272000.0
2001-08-28 16:00:00	MSFT	Stock	30.375	30.7794	30.28	30.37	3139200.0
2001-08-28 17:00:00	MSFT	Stock	30.37	30.37	30.28	30.28	93200.0
2001-08-28 18:00:00	MSFT	Stock	30.3	30.3005	30.28	30.3005	1200.0
2001-08-28 08:00:00	NVDA	Stock	0.3676	0.3676	0.3667	0.367	3048000.0
2001-08-28 09:00:00	NVDA	Stock	0.367	0.3748	0.3659	0.3729	195456000.0
2001-08-28 10:00:00	NVDA	Stock	0.3728	0.373	0.36	0.3643	328968000.0
2001-08-28 11:00:00	NVDA	Stock	0.3642	0.3666	0.3615	0.3653	116256000.0
2001-08-28 12:00:00	NVDA	Stock	0.3654	0.3661	0.3638	0.3644	40008000.0
2001-08-28 13:00:00	NVDA	Stock	0.3642	0.3697	0.362	0.3692	131736000.0
2001-08-28 14:00:00	NVDA	Stock	0.3692	0.3696	0.3605	0.3621	158904000.0
2001-08-28 15:00:00	NVDA	Stock	0.362	0.3646	0.36	0.3629	147600000.0
2001-08-28 16:00:00	NVDA	Stock	0.3628	0.3646	0.3625	0.3628	6984000.0
2001-08-28 17:00:00	NVDA	Stock	0.3628	0.3638	0.3628	0.3638	456000.0
2001-08-28 18:00:00	NVDA	Stock	0.3638	0.3646	0.3638	0.3646	240000.0
2001-08-28 09:00:00	AMZN	Stock	0.506	0.5075	0.498	0.4985	4218000.0
2001-08-28 10:00:00	AMZN	Stock	0.4985	0.499	0.49	0.492	11402000.0
2001-08-28 11:00:00	AMZN	Stock	0.49	0.4934	0.4845	0.486	8842000.0
2001-08-28 12:00:00	AMZN	Stock	0.4855	0.487	0.4835	0.484	3060000.0
2001-08-28 13:00:00	AMZN	Stock	0.4835	0.496	0.4835	0.493	5804000.0
2001-08-28 14:00:00	AMZN	Stock	0.493	0.493	0.4805	0.486	5260000.0
2001-08-28 15:00:00	AMZN	Stock	0.4865	0.5	0.481	0.5	14356000.0
2001-08-28 16:00:00	AMZN	Stock	0.5	0.5005	0.49	0.4985	8116000.0
2001-08-28 17:00:00	AMZN	Stock	0.4985	0.4985	0.493	0.493	126000.0
2001-08-28 18:00:00	AMZN	Stock	0.495	0.496	0.495	0.495	32000.0
2001-08-28 09:00:00	CL	Stock	27.805	27.805	27.45	27.475	425200.0
2001-08-28 10:00:00	CL	Stock	27.475	27.575	27.405	27.425	292400.0
2001-08-28 11:00:00	CL	Stock	27.43	27.525	27.425	27.47	236800.0
2001-08-28 12:00:00	CL	Stock	27.475	27.5	27.43	27.435	300800.0
2001-08-28 13:00:00	CL	Stock	27.445	27.525	27.365	27.44	311000.0
2001-08-28 14:00:00	CL	Stock	27.44	27.44	27.35	27.425	287400.0
2001-08-28 15:00:00	CL	Stock	27.435	27.49	27.35	27.375	492800.0
2001-08-28 16:00:00	CL	Stock	27.35	27.435	27.35	27.435	130400.0
2001-08-28 17:00:00	CL	Stock	27.355	27.355	27.355	27.355	20000.0

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

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