PREVIEW / stock_1hour / 2003-05-23

all stock 1-hour files

  file:    by_date/stock_1hour/2003/2003-05-23.parquet
  size:    411 KB
  rows:    20,129
  symbols: 1,569

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-05-23 08:00:00	AAPL	Stock	0.3282	0.3282	0.3282	0.3282	5600.0
2003-05-23 09:00:00	AAPL	Stock	0.3255	0.3261	0.3207	0.322	20782664.0
2003-05-23 10:00:00	AAPL	Stock	0.3221	0.3245	0.3214	0.3232	30489872.0
2003-05-23 11:00:00	AAPL	Stock	0.3232	0.3286	0.323	0.327	23979368.0
2003-05-23 12:00:00	AAPL	Stock	0.3268	0.3296	0.3257	0.328	21660800.0
2003-05-23 13:00:00	AAPL	Stock	0.328	0.3286	0.3268	0.328	11645592.0
2003-05-23 14:00:00	AAPL	Stock	0.328	0.3286	0.3266	0.3275	10357816.0
2003-05-23 15:00:00	AAPL	Stock	0.3275	0.328	0.3261	0.3264	22509928.0
2003-05-23 16:00:00	AAPL	Stock	0.327	0.3279	0.3257	0.3279	9230312.0
2003-05-23 17:00:00	AAPL	Stock	0.3271	0.3272	0.3271	0.3272	162960.0
2003-05-23 08:00:00	MSFT	Stock	24.15	24.26	24.1	24.21	179196.0
2003-05-23 09:00:00	MSFT	Stock	24.22	24.439	24.03	24.28	20153866.0
2003-05-23 10:00:00	MSFT	Stock	24.281	24.51	24.259	24.46	14843700.0
2003-05-23 11:00:00	MSFT	Stock	24.459	24.49	24.31	24.39	6591495.0
2003-05-23 12:00:00	MSFT	Stock	24.4	24.44	24.33	24.41	5262406.0
2003-05-23 13:00:00	MSFT	Stock	24.42	24.422	24.31	24.37	4000567.0
2003-05-23 14:00:00	MSFT	Stock	24.38	24.41	24.3	24.36	3248523.0
2003-05-23 15:00:00	MSFT	Stock	24.35	24.36	24.18	24.24	6746186.0
2003-05-23 16:00:00	MSFT	Stock	24.231	24.24	24.16	24.229	1052379.0
2003-05-23 17:00:00	MSFT	Stock	24.23	24.23	24.21	24.21	94829.0
2003-05-23 18:00:00	MSFT	Stock	24.22	24.23	24.22	24.23	6300.0
2003-05-23 08:00:00	NVDA	Stock	0.1749	0.1752	0.1749	0.1752	643800.0
2003-05-23 09:00:00	NVDA	Stock	0.1752	0.1762	0.1739	0.1746	136623720.0
2003-05-23 10:00:00	NVDA	Stock	0.1746	0.1761	0.1744	0.1758	86305800.0
2003-05-23 11:00:00	NVDA	Stock	0.1758	0.1783	0.1757	0.1768	168227040.0
2003-05-23 12:00:00	NVDA	Stock	0.1767	0.1772	0.1762	0.1763	39312960.0
2003-05-23 13:00:00	NVDA	Stock	0.1764	0.1767	0.1742	0.175	123668040.0
2003-05-23 14:00:00	NVDA	Stock	0.1749	0.1752	0.1742	0.1745	64198080.0
2003-05-23 15:00:00	NVDA	Stock	0.1746	0.1746	0.1732	0.174	78193680.0
2003-05-23 16:00:00	NVDA	Stock	0.1739	0.1749	0.1739	0.1746	8040000.0
2003-05-23 17:00:00	NVDA	Stock	0.1742	0.1744	0.1742	0.1742	1344000.0
2003-05-23 08:00:00	AMZN	Stock	1.6525	1.657	1.651	1.652	32000.0
2003-05-23 09:00:00	AMZN	Stock	1.65	1.6525	1.633	1.638	20840340.0
2003-05-23 10:00:00	AMZN	Stock	1.638	1.644	1.6305	1.6356	23470180.0
2003-05-23 11:00:00	AMZN	Stock	1.636	1.645	1.6235	1.6285	14631920.0
2003-05-23 12:00:00	AMZN	Stock	1.6285	1.637	1.624	1.631	17151540.0
2003-05-23 13:00:00	AMZN	Stock	1.6315	1.6355	1.6285	1.6351	13983900.0
2003-05-23 14:00:00	AMZN	Stock	1.6355	1.643	1.633	1.6365	10180700.0
2003-05-23 15:00:00	AMZN	Stock	1.6365	1.6405	1.6335	1.637	16013380.0
2003-05-23 16:00:00	AMZN	Stock	1.638	1.65	1.632	1.632	3182240.0
2003-05-23 17:00:00	AMZN	Stock	1.6375	1.6375	1.636	1.637	88000.0
2003-05-23 09:00:00	CL	Stock	29.425	29.425	29.26	29.37	271800.0
2003-05-23 10:00:00	CL	Stock	29.37	29.5	29.37	29.405	524200.0
2003-05-23 11:00:00	CL	Stock	29.415	29.45	29.255	29.275	205400.0
2003-05-23 12:00:00	CL	Stock	29.28	29.37	29.27	29.34	126200.0
2003-05-23 13:00:00	CL	Stock	29.335	29.385	29.325	29.36	95400.0
2003-05-23 14:00:00	CL	Stock	29.355	29.4	29.315	29.37	346800.0
2003-05-23 15:00:00	CL	Stock	29.365	29.405	29.32	29.37	418200.0
2003-05-23 16:00:00	CL	Stock	29.375	29.4	29.375	29.4	60000.0
2003-05-23 17:00:00	CL	Stock	29.4	29.4	29.4	29.4	7400.0

> showing 50 of 20,129 rows — these rows as CSV

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