PREVIEW / stock_1hour / 2003-09-03

all stock 1-hour files

  file:    by_date/stock_1hour/2003/2003-09-03.parquet
  size:    486 KB
  rows:    23,048
  symbols: 1,621

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-09-03 08:00:00	AAPL	Stock	0.4107	0.4196	0.4027	0.4107	196000.0
2003-09-03 09:00:00	AAPL	Stock	0.4107	0.4107	0.4066	0.4102	24271128.0
2003-09-03 10:00:00	AAPL	Stock	0.4102	0.4143	0.4093	0.4138	35345576.0
2003-09-03 11:00:00	AAPL	Stock	0.4136	0.4152	0.4109	0.4125	30064160.0
2003-09-03 12:00:00	AAPL	Stock	0.4125	0.4164	0.4123	0.4138	36966048.0
2003-09-03 13:00:00	AAPL	Stock	0.4138	0.4148	0.4127	0.4132	25444328.0
2003-09-03 14:00:00	AAPL	Stock	0.4132	0.4138	0.4102	0.4114	25240488.0
2003-09-03 15:00:00	AAPL	Stock	0.4111	0.4127	0.4064	0.4104	57381576.0
2003-09-03 16:00:00	AAPL	Stock	0.4104	0.4125	0.4089	0.4096	1624000.0
2003-09-03 17:00:00	AAPL	Stock	0.4107	0.4125	0.4107	0.4107	106400.0
2003-09-03 08:00:00	MSFT	Stock	27.25	27.5	27.25	27.38	314361.0
2003-09-03 09:00:00	MSFT	Stock	27.39	27.69	27.36	27.65	13019628.0
2003-09-03 10:00:00	MSFT	Stock	27.65	28.09	27.59	28.07	22265789.0
2003-09-03 11:00:00	MSFT	Stock	28.07	28.24	27.92	28.06	16810772.0
2003-09-03 12:00:00	MSFT	Stock	28.06	28.25	28.03	28.24	8849618.0
2003-09-03 13:00:00	MSFT	Stock	28.24	28.37	28.21	28.24	9886813.0
2003-09-03 14:00:00	MSFT	Stock	28.23	28.4	28.18	28.24	10068464.0
2003-09-03 15:00:00	MSFT	Stock	28.24	28.329	28.04	28.28	13941118.0
2003-09-03 16:00:00	MSFT	Stock	28.31	28.36	27.67	28.36	3891248.0
2003-09-03 17:00:00	MSFT	Stock	28.36	28.36	28.3	28.34	76100.0
2003-09-03 18:00:00	MSFT	Stock	27.5329	28.36	27.5329	28.36	6300.0
2003-09-03 08:00:00	NVDA	Stock	0.1506	0.1508	0.1506	0.1506	582720.0
2003-09-03 09:00:00	NVDA	Stock	0.1502	0.1527	0.1496	0.1507	115375080.0
2003-09-03 10:00:00	NVDA	Stock	0.1507	0.1517	0.1502	0.1512	151012560.0
2003-09-03 11:00:00	NVDA	Stock	0.1512	0.1515	0.1497	0.1499	110741040.0
2003-09-03 12:00:00	NVDA	Stock	0.1498	0.1503	0.1489	0.1497	62143440.0
2003-09-03 13:00:00	NVDA	Stock	0.1497	0.1501	0.1481	0.1487	73717200.0
2003-09-03 14:00:00	NVDA	Stock	0.1487	0.1492	0.148	0.1485	97834320.0
2003-09-03 15:00:00	NVDA	Stock	0.1485	0.1488	0.1464	0.1471	139489320.0
2003-09-03 16:00:00	NVDA	Stock	0.1471	0.1496	0.147	0.1479	28365600.0
2003-09-03 17:00:00	NVDA	Stock	0.1473	0.1476	0.1471	0.1476	552000.0
2003-09-03 08:00:00	AMZN	Stock	2.3695	2.38	2.3695	2.371	81200.0
2003-09-03 09:00:00	AMZN	Stock	2.37	2.383	2.3625	2.3755	30462200.0
2003-09-03 10:00:00	AMZN	Stock	2.3755	2.3875	2.362	2.3645	35235660.0
2003-09-03 11:00:00	AMZN	Stock	2.365	2.367	2.3485	2.3486	23205840.0
2003-09-03 12:00:00	AMZN	Stock	2.3486	2.3545	2.345	2.347	21587960.0
2003-09-03 13:00:00	AMZN	Stock	2.347	2.3515	2.34	2.347	22058580.0
2003-09-03 14:00:00	AMZN	Stock	2.3465	2.3515	2.333	2.337	21353120.0
2003-09-03 15:00:00	AMZN	Stock	2.337	2.338	2.293	2.3125	42048460.0
2003-09-03 16:00:00	AMZN	Stock	2.3125	2.3175	2.3055	2.3101	1185000.0
2003-09-03 17:00:00	AMZN	Stock	2.31	2.317	2.31	2.317	95500.0
2003-09-03 18:00:00	AMZN	Stock	2.3125	2.317	2.3125	2.317	40000.0
2003-09-03 09:00:00	CL	Stock	28.15	28.25	28.09	28.21	338600.0
2003-09-03 10:00:00	CL	Stock	28.215	28.34	28.135	28.32	508400.0
2003-09-03 11:00:00	CL	Stock	28.325	28.38	28.285	28.295	375200.0
2003-09-03 12:00:00	CL	Stock	28.295	28.405	28.255	28.4	271400.0
2003-09-03 13:00:00	CL	Stock	28.395	28.45	28.37	28.415	296200.0
2003-09-03 14:00:00	CL	Stock	28.415	28.475	28.375	28.42	392800.0
2003-09-03 15:00:00	CL	Stock	28.42	28.425	28.23	28.275	799400.0
2003-09-03 16:00:00	CL	Stock	28.3	28.3	28.275	28.2974	96800.0

> showing 50 of 23,048 rows — these rows as CSV

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