PREVIEW / stock_1hour / 2003-07-10

all stock 1-hour files

  file:    by_date/stock_1hour/2003/2003-07-10.parquet
  size:    460 KB
  rows:    22,131
  symbols: 1,589

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
2003-07-10 08:00:00	AAPL	Stock	0.3545	0.3545	0.3545	0.3545	140000.0
2003-07-10 09:00:00	AAPL	Stock	0.3527	0.3561	0.3518	0.3521	23755144.0
2003-07-10 10:00:00	AAPL	Stock	0.3518	0.3557	0.3491	0.3511	29661408.0
2003-07-10 11:00:00	AAPL	Stock	0.3509	0.3525	0.3486	0.3491	17751496.0
2003-07-10 12:00:00	AAPL	Stock	0.3495	0.3511	0.3484	0.3486	11161864.0
2003-07-10 13:00:00	AAPL	Stock	0.3486	0.35	0.348	0.3484	14727104.0
2003-07-10 14:00:00	AAPL	Stock	0.3484	0.3486	0.3459	0.3475	22941520.0
2003-07-10 15:00:00	AAPL	Stock	0.3471	0.3502	0.3464	0.3496	31830400.0
2003-07-10 16:00:00	AAPL	Stock	0.3498	0.3504	0.3488	0.3496	3332000.0
2003-07-10 17:00:00	AAPL	Stock	0.3496	0.3496	0.3496	0.3496	162400.0
2003-07-10 08:00:00	MSFT	Stock	27.337	27.49	27.09	27.185	126041.0
2003-07-10 09:00:00	MSFT	Stock	27.2	27.43	27.15	27.3	7114436.0
2003-07-10 10:00:00	MSFT	Stock	27.3	27.33	27.17	27.21	7427316.0
2003-07-10 11:00:00	MSFT	Stock	27.21	27.25	27.0	27.0303	5735745.0
2003-07-10 12:00:00	MSFT	Stock	27.0302	27.093	26.809	26.81	6668941.0
2003-07-10 13:00:00	MSFT	Stock	26.81	26.92	26.718	26.83	7376027.0
2003-07-10 14:00:00	MSFT	Stock	26.83	26.95	26.73	26.9	5623337.0
2003-07-10 15:00:00	MSFT	Stock	26.8941	26.99	26.8	26.91	7644913.0
2003-07-10 16:00:00	MSFT	Stock	26.9	27.0381	26.86	26.95	890815.0
2003-07-10 17:00:00	MSFT	Stock	26.94	27.0375	26.86	26.86	45748.0
2003-07-10 18:00:00	MSFT	Stock	26.89	26.89	26.81	26.81	6370.0
2003-07-10 08:00:00	NVDA	Stock	0.2113	0.2113	0.2049	0.2049	4220400.0
2003-07-10 09:00:00	NVDA	Stock	0.205	0.2072	0.2042	0.2051	113122080.0
2003-07-10 10:00:00	NVDA	Stock	0.2051	0.2071	0.2047	0.2052	83393280.0
2003-07-10 11:00:00	NVDA	Stock	0.2052	0.2054	0.2029	0.2031	85629240.0
2003-07-10 12:00:00	NVDA	Stock	0.2029	0.2032	0.2005	0.2007	105605760.0
2003-07-10 13:00:00	NVDA	Stock	0.2007	0.2019	0.1989	0.2017	84805560.0
2003-07-10 14:00:00	NVDA	Stock	0.2016	0.2027	0.2004	0.2021	43671960.0
2003-07-10 15:00:00	NVDA	Stock	0.2021	0.2025	0.201	0.202	68049600.0
2003-07-10 16:00:00	NVDA	Stock	0.2018	0.2026	0.2012	0.2022	8418480.0
2003-07-10 17:00:00	NVDA	Stock	0.2025	0.2025	0.2	0.2008	540000.0
2003-07-10 18:00:00	NVDA	Stock	0.2008	0.2022	0.2	0.2	300000.0
2003-07-10 08:00:00	AMZN	Stock	1.97	2.0025	1.95	1.964	1236600.0
2003-07-10 09:00:00	AMZN	Stock	1.9615	2.0275	1.945	1.9615	37888040.0
2003-07-10 10:00:00	AMZN	Stock	1.9615	1.97	1.954	1.9585	23633060.0
2003-07-10 11:00:00	AMZN	Stock	1.9595	1.9615	1.9325	1.934	21787240.0
2003-07-10 12:00:00	AMZN	Stock	1.934	1.946	1.931	1.9335	18007700.0
2003-07-10 13:00:00	AMZN	Stock	1.9326	1.9365	1.9224	1.9235	14945000.0
2003-07-10 14:00:00	AMZN	Stock	1.923	1.929	1.9185	1.922	15840940.0
2003-07-10 15:00:00	AMZN	Stock	1.922	1.929	1.91	1.921	26504040.0
2003-07-10 16:00:00	AMZN	Stock	1.9205	1.9225	1.9065	1.9125	2491380.0
2003-07-10 17:00:00	AMZN	Stock	1.9125	1.9165	1.911	1.915	708000.0
2003-07-10 18:00:00	AMZN	Stock	1.915	1.918	1.915	1.918	70000.0
2003-07-10 09:00:00	CL	Stock	28.81	28.87	28.755	28.81	194200.0
2003-07-10 10:00:00	CL	Stock	28.81	28.825	28.725	28.79	407800.0
2003-07-10 11:00:00	CL	Stock	28.795	28.87	28.65	28.65	424800.0
2003-07-10 12:00:00	CL	Stock	28.655	28.78	28.65	28.65	332800.0
2003-07-10 13:00:00	CL	Stock	28.65	28.65	28.495	28.545	783200.0
2003-07-10 14:00:00	CL	Stock	28.545	28.585	28.505	28.57	373400.0
2003-07-10 15:00:00	CL	Stock	28.57	28.65	28.57	28.645	570800.0

> showing 50 of 22,131 rows — these rows as CSV

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