PREVIEW / stock_1hour / 2001-10-17

all stock 1-hour files

  file:    by_date/stock_1hour/2001/2001-10-17.parquet
  size:    369 KB
  rows:    17,637
  symbols: 1,335

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-17 08:00:00	AAPL	Stock	0.3234	0.3286	0.3234	0.3284	212800.0
2001-10-17 09:00:00	AAPL	Stock	0.3284	0.3304	0.3232	0.3271	30553600.0
2001-10-17 10:00:00	AAPL	Stock	0.3271	0.3275	0.3214	0.3241	40863200.0
2001-10-17 11:00:00	AAPL	Stock	0.3243	0.3252	0.3221	0.3232	20272000.0
2001-10-17 12:00:00	AAPL	Stock	0.3232	0.3238	0.3125	0.3134	39552800.0
2001-10-17 13:00:00	AAPL	Stock	0.3143	0.3171	0.3071	0.3111	39564000.0
2001-10-17 14:00:00	AAPL	Stock	0.3111	0.32	0.3104	0.3193	21616000.0
2001-10-17 15:00:00	AAPL	Stock	0.3191	0.3197	0.3029	0.3032	53317600.0
2001-10-17 16:00:00	AAPL	Stock	0.3034	0.3077	0.2971	0.2971	17018400.0
2001-10-17 17:00:00	AAPL	Stock	0.2991	0.323	0.293	0.3068	11950400.0
2001-10-17 18:00:00	AAPL	Stock	0.3077	0.3077	0.3068	0.3068	246400.0
2001-10-17 08:00:00	MSFT	Stock	29.555	29.75	29.525	29.625	255000.0
2001-10-17 09:00:00	MSFT	Stock	29.625	29.9	29.295	29.61	10484000.0
2001-10-17 10:00:00	MSFT	Stock	29.615	29.625	28.825	29.3755	16199600.0
2001-10-17 11:00:00	MSFT	Stock	29.375	29.52	28.9	29.05	7088000.0
2001-10-17 12:00:00	MSFT	Stock	29.05	29.2	28.615	28.795	7483400.0
2001-10-17 13:00:00	MSFT	Stock	28.795	28.9055	28.475	28.6405	6671800.0
2001-10-17 14:00:00	MSFT	Stock	28.645	28.7505	28.375	28.685	6867200.0
2001-10-17 15:00:00	MSFT	Stock	28.68	28.735	27.99	28.0	12939800.0
2001-10-17 16:00:00	MSFT	Stock	28.015	29.335	27.9	28.05	2780800.0
2001-10-17 17:00:00	MSFT	Stock	28.05	28.1	27.9	28.1	69600.0
2001-10-17 08:00:00	NVDA	Stock	0.3758	0.3832	0.3735	0.3768	4884000.0
2001-10-17 09:00:00	NVDA	Stock	0.3768	0.3791	0.36	0.3617	303420000.0
2001-10-17 10:00:00	NVDA	Stock	0.3617	0.3654	0.3468	0.3531	380052000.0
2001-10-17 11:00:00	NVDA	Stock	0.353	0.3579	0.3512	0.3528	150552000.0
2001-10-17 12:00:00	NVDA	Stock	0.3529	0.3577	0.3508	0.3534	142368000.0
2001-10-17 13:00:00	NVDA	Stock	0.3527	0.3596	0.3502	0.3596	102852000.0
2001-10-17 14:00:00	NVDA	Stock	0.3595	0.3657	0.3583	0.3596	227616000.0
2001-10-17 15:00:00	NVDA	Stock	0.3593	0.3603	0.3458	0.3486	298800000.0
2001-10-17 16:00:00	NVDA	Stock	0.3474	0.3513	0.3472	0.3472	20496000.0
2001-10-17 17:00:00	NVDA	Stock	0.3472	0.3496	0.3472	0.3496	1020000.0
2001-10-17 18:00:00	NVDA	Stock	0.3508	0.3517	0.35	0.3501	612000.0
2001-10-17 08:00:00	AMZN	Stock	0.5005	0.5045	0.4885	0.496	840000.0
2001-10-17 09:00:00	AMZN	Stock	0.495	0.4995	0.4765	0.485	21258000.0
2001-10-17 10:00:00	AMZN	Stock	0.485	0.4855	0.47	0.481	27204000.0
2001-10-17 11:00:00	AMZN	Stock	0.4815	0.4825	0.4554	0.4565	31368000.0
2001-10-17 12:00:00	AMZN	Stock	0.4575	0.465	0.4565	0.4585	25390000.0
2001-10-17 13:00:00	AMZN	Stock	0.458	0.4625	0.446	0.4495	27416000.0
2001-10-17 14:00:00	AMZN	Stock	0.4495	0.46	0.4465	0.458	12926000.0
2001-10-17 15:00:00	AMZN	Stock	0.4585	0.4625	0.4425	0.4445	20954000.0
2001-10-17 16:00:00	AMZN	Stock	0.4455	0.449	0.43	0.435	2740000.0
2001-10-17 17:00:00	AMZN	Stock	0.4375	0.446	0.4375	0.446	106000.0
2001-10-17 09:00:00	CL	Stock	28.65	28.655	28.45	28.45	587200.0
2001-10-17 10:00:00	CL	Stock	28.45	28.475	28.29	28.365	621800.0
2001-10-17 11:00:00	CL	Stock	28.36	28.425	28.21	28.21	360600.0
2001-10-17 12:00:00	CL	Stock	28.21	28.225	28.125	28.165	339400.0
2001-10-17 13:00:00	CL	Stock	28.16	28.325	28.125	28.3	299000.0
2001-10-17 14:00:00	CL	Stock	28.3	28.425	28.29	28.395	237000.0
2001-10-17 15:00:00	CL	Stock	28.385	28.5	28.275	28.39	468200.0
2001-10-17 16:00:00	CL	Stock	28.385	28.41	28.37	28.37	46200.0

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

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