PREVIEW / stock_1hour / 2001-09-04

all stock 1-hour files

  file:    by_date/stock_1hour/2001/2001-09-04.parquet
  size:    362 KB
  rows:    17,248
  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-09-04 08:00:00	AAPL	Stock	0.3321	0.3321	0.3321	0.3321	50400.0
2001-09-04 09:00:00	AAPL	Stock	0.3321	0.3325	0.3246	0.3282	24248000.0
2001-09-04 10:00:00	AAPL	Stock	0.3282	0.3377	0.3273	0.332	60631200.0
2001-09-04 11:00:00	AAPL	Stock	0.3319	0.3355	0.3288	0.3339	38908800.0
2001-09-04 12:00:00	AAPL	Stock	0.3338	0.3407	0.3338	0.3363	29988000.0
2001-09-04 13:00:00	AAPL	Stock	0.3371	0.338	0.3311	0.3339	20339200.0
2001-09-04 14:00:00	AAPL	Stock	0.3339	0.3357	0.3291	0.3316	37475200.0
2001-09-04 15:00:00	AAPL	Stock	0.3304	0.3309	0.325	0.3263	84151200.0
2001-09-04 16:00:00	AAPL	Stock	0.3261	0.3308	0.3257	0.3289	20221600.0
2001-09-04 17:00:00	AAPL	Stock	0.3259	0.3261	0.3259	0.3261	1243200.0
2001-09-04 08:00:00	MSFT	Stock	28.5275	28.725	28.525	28.53	51600.0
2001-09-04 09:00:00	MSFT	Stock	28.55	28.83	28.3	28.78	6584400.0
2001-09-04 10:00:00	MSFT	Stock	28.78	29.125	28.625	28.955	10952000.0
2001-09-04 11:00:00	MSFT	Stock	28.9545	29.095	28.7845	28.79	6956800.0
2001-09-04 12:00:00	MSFT	Stock	28.795	29.425	28.795	29.416	6890000.0
2001-09-04 13:00:00	MSFT	Stock	29.416	29.54	29.2	29.3645	6825000.0
2001-09-04 14:00:00	MSFT	Stock	29.3697	29.4	28.96	29.1	6659600.0
2001-09-04 15:00:00	MSFT	Stock	29.125	29.145	28.035	28.05	15355800.0
2001-09-04 16:00:00	MSFT	Stock	28.075	28.925	27.95	28.02	2927200.0
2001-09-04 17:00:00	MSFT	Stock	28.05	28.05	27.995	28.045	30400.0
2001-09-04 18:00:00	MSFT	Stock	28.04	28.04	28.015	28.015	400.0
2001-09-04 08:00:00	NVDA	Stock	0.3552	0.3552	0.351	0.3525	1560000.0
2001-09-04 09:00:00	NVDA	Stock	0.351	0.3525	0.3381	0.3417	303600000.0
2001-09-04 10:00:00	NVDA	Stock	0.3417	0.3491	0.3346	0.3405	466896000.0
2001-09-04 11:00:00	NVDA	Stock	0.3408	0.3427	0.3375	0.3395	192840000.0
2001-09-04 12:00:00	NVDA	Stock	0.3396	0.3455	0.3396	0.3444	144432000.0
2001-09-04 13:00:00	NVDA	Stock	0.3441	0.3465	0.3414	0.3464	94944000.0
2001-09-04 14:00:00	NVDA	Stock	0.3465	0.3465	0.34	0.3409	171696000.0
2001-09-04 15:00:00	NVDA	Stock	0.341	0.3416	0.326	0.3289	382368000.0
2001-09-04 16:00:00	NVDA	Stock	0.3284	0.3292	0.3273	0.3284	25176000.0
2001-09-04 17:00:00	NVDA	Stock	0.3275	0.3285	0.3271	0.3277	960000.0
2001-09-04 08:00:00	AMZN	Stock	0.447	0.447	0.447	0.447	100000.0
2001-09-04 09:00:00	AMZN	Stock	0.4476	0.4525	0.4445	0.4515	8034000.0
2001-09-04 10:00:00	AMZN	Stock	0.4515	0.4595	0.45	0.4585	15814000.0
2001-09-04 11:00:00	AMZN	Stock	0.4586	0.4595	0.449	0.4525	17710000.0
2001-09-04 12:00:00	AMZN	Stock	0.453	0.4555	0.4475	0.4485	13864000.0
2001-09-04 13:00:00	AMZN	Stock	0.449	0.4515	0.447	0.4505	7512000.0
2001-09-04 14:00:00	AMZN	Stock	0.4505	0.451	0.447	0.4475	7142000.0
2001-09-04 15:00:00	AMZN	Stock	0.4475	0.449	0.426	0.43	17028000.0
2001-09-04 16:00:00	AMZN	Stock	0.431	0.436	0.4295	0.4295	1304000.0
2001-09-04 17:00:00	AMZN	Stock	0.4295	0.434	0.4295	0.4305	18000.0
2001-09-04 18:00:00	AMZN	Stock	0.432	0.434	0.432	0.434	8000.0
2001-09-04 09:00:00	CL	Stock	27.125	27.31	27.015	27.31	308400.0
2001-09-04 10:00:00	CL	Stock	27.32	27.55	27.3	27.55	360000.0
2001-09-04 11:00:00	CL	Stock	27.55	27.56	27.35	27.545	358400.0
2001-09-04 12:00:00	CL	Stock	27.555	27.61	27.475	27.585	198400.0
2001-09-04 13:00:00	CL	Stock	27.625	27.655	27.57	27.6	268200.0
2001-09-04 14:00:00	CL	Stock	27.6	27.675	27.425	27.56	454800.0
2001-09-04 15:00:00	CL	Stock	27.56	27.645	27.4	27.4	364800.0
2001-09-04 16:00:00	CL	Stock	27.375	27.445	27.35	27.445	69400.0

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

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