PREVIEW / stock_1hour / 2003-08-08

all stock 1-hour files

  file:    by_date/stock_1hour/2003/2003-08-08.parquet
  size:    460 KB
  rows:    22,805
  symbols: 1,597

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-08-08 08:00:00	AAPL	Stock	0.3561	0.3561	0.3561	0.3561	1848000.0
2003-08-08 09:00:00	AAPL	Stock	0.357	0.3595	0.3523	0.355	13191192.0
2003-08-08 10:00:00	AAPL	Stock	0.355	0.3564	0.3521	0.3523	15939840.0
2003-08-08 11:00:00	AAPL	Stock	0.3525	0.3548	0.3516	0.353	21093184.0
2003-08-08 12:00:00	AAPL	Stock	0.353	0.3538	0.3516	0.3521	8808800.0
2003-08-08 13:00:00	AAPL	Stock	0.3521	0.3546	0.3516	0.3521	13961024.0
2003-08-08 14:00:00	AAPL	Stock	0.352	0.3529	0.3507	0.3511	16436896.0
2003-08-08 15:00:00	AAPL	Stock	0.3509	0.353	0.35	0.3507	24172344.0
2003-08-08 16:00:00	AAPL	Stock	0.3509	0.3552	0.3504	0.3511	2787456.0
2003-08-08 17:00:00	AAPL	Stock	0.3505	0.3505	0.3505	0.3505	173600.0
2003-08-08 18:00:00	AAPL	Stock	0.3505	0.3505	0.3505	0.3505	16800.0
2003-08-08 08:00:00	MSFT	Stock	25.715	25.85	25.715	25.85	84687.0
2003-08-08 09:00:00	MSFT	Stock	25.85	25.98	25.8	25.86	4486182.0
2003-08-08 10:00:00	MSFT	Stock	25.87	25.89	25.7	25.72	6177012.0
2003-08-08 11:00:00	MSFT	Stock	25.72	25.74	25.54	25.64	4702949.0
2003-08-08 12:00:00	MSFT	Stock	25.64	25.67	25.57	25.64	2278423.0
2003-08-08 13:00:00	MSFT	Stock	25.64	25.75	25.6	25.66	2699638.0
2003-08-08 14:00:00	MSFT	Stock	25.66	25.663	25.54	25.61	4058489.0
2003-08-08 15:00:00	MSFT	Stock	25.61	25.66	25.53	25.57	5018439.0
2003-08-08 16:00:00	MSFT	Stock	25.57	25.6979	25.53	25.578	279145.0
2003-08-08 17:00:00	MSFT	Stock	25.578	25.58	25.55	25.57	76400.0
2003-08-08 18:00:00	MSFT	Stock	25.57	25.578	25.55	25.578	12000.0
2003-08-08 08:00:00	NVDA	Stock	0.1417	0.1471	0.1387	0.139	74434080.0
2003-08-08 09:00:00	NVDA	Stock	0.1387	0.1607	0.1337	0.1348	851581200.0
2003-08-08 10:00:00	NVDA	Stock	0.1347	0.135	0.1298	0.1306	952308360.0
2003-08-08 11:00:00	NVDA	Stock	0.1305	0.1317	0.1272	0.1313	631771560.0
2003-08-08 12:00:00	NVDA	Stock	0.1314	0.1318	0.1293	0.1304	201747840.0
2003-08-08 13:00:00	NVDA	Stock	0.1305	0.1323	0.13	0.1308	200970240.0
2003-08-08 14:00:00	NVDA	Stock	0.131	0.1313	0.1283	0.1287	167906880.0
2003-08-08 15:00:00	NVDA	Stock	0.1287	0.1302	0.128	0.1292	335421120.0
2003-08-08 16:00:00	NVDA	Stock	0.1292	0.13	0.1287	0.1288	58905720.0
2003-08-08 17:00:00	NVDA	Stock	0.1291	0.1296	0.129	0.129	1936920.0
2003-08-08 18:00:00	NVDA	Stock	0.1291	0.1292	0.1286	0.1287	1119600.0
2003-08-08 08:00:00	AMZN	Stock	1.954	1.96	1.951	1.955	666000.0
2003-08-08 09:00:00	AMZN	Stock	1.959	1.97	1.9535	1.963	10777480.0
2003-08-08 10:00:00	AMZN	Stock	1.9635	1.966	1.9495	1.956	14458620.0
2003-08-08 11:00:00	AMZN	Stock	1.956	1.957	1.9315	1.9475	16798800.0
2003-08-08 12:00:00	AMZN	Stock	1.9475	1.9545	1.9426	1.9495	12892180.0
2003-08-08 13:00:00	AMZN	Stock	1.9495	1.96	1.945	1.953	9955820.0
2003-08-08 14:00:00	AMZN	Stock	1.9525	1.9535	1.9425	1.9495	6572540.0
2003-08-08 15:00:00	AMZN	Stock	1.949	1.9625	1.948	1.9565	13081960.0
2003-08-08 16:00:00	AMZN	Stock	1.9556	1.9585	1.953	1.953	518620.0
2003-08-08 17:00:00	AMZN	Stock	1.9615	1.9615	1.9556	1.9556	60000.0
2003-08-08 18:00:00	AMZN	Stock	1.9556	1.9556	1.9556	1.9556	42000.0
2003-08-08 09:00:00	CL	Stock	27.36	27.455	27.345	27.44	165800.0
2003-08-08 10:00:00	CL	Stock	27.445	27.5	27.35	27.405	434400.0
2003-08-08 11:00:00	CL	Stock	27.4	27.45	27.355	27.43	192400.0
2003-08-08 12:00:00	CL	Stock	27.44	27.525	27.44	27.5	157800.0
2003-08-08 13:00:00	CL	Stock	27.5	27.535	27.465	27.52	226200.0
2003-08-08 14:00:00	CL	Stock	27.505	27.55	27.46	27.475	233200.0

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

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