PREVIEW / stock_1hour / 2001-08-27

all stock 1-hour files

  file:    by_date/stock_1hour/2001/2001-08-27.parquet
  size:    361 KB
  rows:    17,001
  symbols: 1,328

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-27 09:00:00	AAPL	Stock	0.3268	0.3323	0.3259	0.3268	16486400.0
2001-08-27 10:00:00	AAPL	Stock	0.3261	0.3343	0.3243	0.3325	21016800.0
2001-08-27 11:00:00	AAPL	Stock	0.3327	0.3366	0.3316	0.3343	20109600.0
2001-08-27 12:00:00	AAPL	Stock	0.3343	0.3375	0.3338	0.3371	21240800.0
2001-08-27 13:00:00	AAPL	Stock	0.3373	0.3411	0.335	0.3395	25312000.0
2001-08-27 14:00:00	AAPL	Stock	0.3398	0.3446	0.3396	0.3429	23480800.0
2001-08-27 15:00:00	AAPL	Stock	0.3427	0.343	0.3375	0.3377	25844000.0
2001-08-27 16:00:00	AAPL	Stock	0.3379	0.3393	0.3348	0.3348	7162400.0
2001-08-27 08:00:00	MSFT	Stock	31.0225	31.1	30.75	30.9	116600.0
2001-08-27 09:00:00	MSFT	Stock	30.86	31.21	30.815	31.15	5272000.0
2001-08-27 10:00:00	MSFT	Stock	31.16	31.27	30.785	31.125	8967200.0
2001-08-27 11:00:00	MSFT	Stock	31.125	31.31	30.93	30.93	3692200.0
2001-08-27 12:00:00	MSFT	Stock	30.93	31.25	30.9195	31.23	2860400.0
2001-08-27 13:00:00	MSFT	Stock	31.235	31.37	31.01	31.32	4492800.0
2001-08-27 14:00:00	MSFT	Stock	31.32	31.68	31.305	31.65	5677400.0
2001-08-27 15:00:00	MSFT	Stock	31.6495	31.675	31.15	31.155	7870600.0
2001-08-27 16:00:00	MSFT	Stock	31.155	31.4858	31.08	31.1	2829400.0
2001-08-27 17:00:00	MSFT	Stock	31.11	31.2464	31.1	31.1	62000.0
2001-08-27 18:00:00	MSFT	Stock	31.125	31.125	31.125	31.125	200.0
2001-08-27 08:00:00	NVDA	Stock	0.3549	0.3553	0.349	0.3521	8280000.0
2001-08-27 09:00:00	NVDA	Stock	0.3521	0.3573	0.3458	0.3549	211944000.0
2001-08-27 10:00:00	NVDA	Stock	0.3553	0.3618	0.3526	0.3588	279792000.0
2001-08-27 11:00:00	NVDA	Stock	0.3586	0.3629	0.3578	0.3584	126096000.0
2001-08-27 12:00:00	NVDA	Stock	0.3588	0.3608	0.3569	0.3594	53184000.0
2001-08-27 13:00:00	NVDA	Stock	0.3594	0.3635	0.3583	0.3625	88824000.0
2001-08-27 14:00:00	NVDA	Stock	0.3625	0.3712	0.3617	0.3708	233160000.0
2001-08-27 15:00:00	NVDA	Stock	0.3712	0.3723	0.3667	0.3679	209280000.0
2001-08-27 16:00:00	NVDA	Stock	0.3676	0.3681	0.367	0.3675	11904000.0
2001-08-27 17:00:00	NVDA	Stock	0.3674	0.3688	0.3672	0.3677	336000.0
2001-08-27 18:00:00	NVDA	Stock	0.3677	0.3677	0.3677	0.3677	24000.0
2001-08-27 08:00:00	AMZN	Stock	0.498	0.5075	0.498	0.5075	44000.0
2001-08-27 09:00:00	AMZN	Stock	0.5045	0.5075	0.4955	0.503	5166000.0
2001-08-27 10:00:00	AMZN	Stock	0.5025	0.503	0.4955	0.5	4816000.0
2001-08-27 11:00:00	AMZN	Stock	0.5	0.504	0.4995	0.5	5768000.0
2001-08-27 12:00:00	AMZN	Stock	0.5	0.5015	0.4975	0.5015	4960000.0
2001-08-27 13:00:00	AMZN	Stock	0.501	0.504	0.4975	0.503	9868000.0
2001-08-27 14:00:00	AMZN	Stock	0.5025	0.5135	0.5015	0.5135	6296000.0
2001-08-27 15:00:00	AMZN	Stock	0.513	0.5135	0.5065	0.507	8880000.0
2001-08-27 16:00:00	AMZN	Stock	0.507	0.5085	0.5025	0.5065	1822000.0
2001-08-27 17:00:00	AMZN	Stock	0.5025	0.5125	0.5025	0.5125	50000.0
2001-08-27 09:00:00	CL	Stock	27.93	27.93	27.635	27.745	333600.0
2001-08-27 10:00:00	CL	Stock	27.74	27.9	27.7	27.77	302000.0
2001-08-27 11:00:00	CL	Stock	27.77	27.8	27.74	27.75	301200.0
2001-08-27 12:00:00	CL	Stock	27.745	27.745	27.6	27.69	502600.0
2001-08-27 13:00:00	CL	Stock	27.69	27.695	27.575	27.65	323600.0
2001-08-27 14:00:00	CL	Stock	27.66	27.73	27.6	27.725	540400.0
2001-08-27 15:00:00	CL	Stock	27.725	27.74	27.665	27.685	698600.0
2001-08-27 16:00:00	CL	Stock	27.68	27.68	27.63	27.68	355600.0

> showing 48 of 17,001 rows — these rows as CSV

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