PREVIEW / stock_1hour / 2000-04-17

all stock 1-hour files

  file:    by_date/stock_1hour/2000/2000-04-17.parquet
  size:    288 KB
  rows:    14,983
  symbols: 1,163

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
2000-04-17 09:00:00	AAPL	Stock	0.9777	1.0379	0.9738	1.0223	37542400.0
2000-04-17 10:00:00	AAPL	Stock	1.0229	1.0536	1.0	1.0513	63828800.0
2000-04-17 11:00:00	AAPL	Stock	1.0525	1.0597	1.0346	1.0363	32513600.0
2000-04-17 12:00:00	AAPL	Stock	1.0363	1.0407	0.9961	1.024	38472000.0
2000-04-17 13:00:00	AAPL	Stock	1.0234	1.0368	1.0112	1.0117	34193600.0
2000-04-17 14:00:00	AAPL	Stock	1.0117	1.0603	1.0117	1.0578	71736000.0
2000-04-17 15:00:00	AAPL	Stock	1.0575	1.1066	1.0446	1.1055	88793600.0
2000-04-17 16:00:00	AAPL	Stock	1.1055	1.106	1.1055	1.106	2060800.0
2000-04-17 09:00:00	MSFT	Stock	37.125	38.0	37.0	37.9062	15618200.0
2000-04-17 10:00:00	MSFT	Stock	37.7188	38.0	36.9375	37.625	24642800.0
2000-04-17 11:00:00	MSFT	Stock	37.625	37.75	37.2188	37.3125	15137000.0
2000-04-17 12:00:00	MSFT	Stock	37.2812	37.4688	36.8125	37.25	14638600.0
2000-04-17 13:00:00	MSFT	Stock	37.25	37.625	36.5	36.5	8251800.0
2000-04-17 14:00:00	MSFT	Stock	36.5	37.625	36.5	37.5	12837400.0
2000-04-17 15:00:00	MSFT	Stock	37.4688	38.0	36.9688	37.9062	15280000.0
2000-04-17 16:00:00	MSFT	Stock	37.9375	38.0	37.8125	37.8125	661200.0
2000-04-17 09:00:00	NVDA	Stock	0.1312	0.152	0.1312	0.1501	21696000.0
2000-04-17 10:00:00	NVDA	Stock	0.1521	0.1562	0.1401	0.1477	39264000.0
2000-04-17 11:00:00	NVDA	Stock	0.1477	0.151	0.1417	0.1453	34272000.0
2000-04-17 12:00:00	NVDA	Stock	0.1454	0.1454	0.1363	0.1398	33360000.0
2000-04-17 13:00:00	NVDA	Stock	0.1398	0.1409	0.1354	0.1354	16272000.0
2000-04-17 14:00:00	NVDA	Stock	0.1354	0.1437	0.1354	0.1427	24720000.0
2000-04-17 15:00:00	NVDA	Stock	0.1418	0.156	0.1411	0.1505	73200000.0
2000-04-17 16:00:00	NVDA	Stock	0.1505	0.1507	0.1505	0.1507	6576000.0
2000-04-17 09:00:00	AMZN	Stock	2.2625	2.4188	2.25	2.3938	23368000.0
2000-04-17 10:00:00	AMZN	Stock	2.4062	2.5813	2.2938	2.425	50938000.0
2000-04-17 11:00:00	AMZN	Stock	2.4344	2.5	2.3562	2.3594	22360000.0
2000-04-17 12:00:00	AMZN	Stock	2.3594	2.3719	2.2312	2.3656	28650000.0
2000-04-17 13:00:00	AMZN	Stock	2.3531	2.425	2.2531	2.2562	22274000.0
2000-04-17 14:00:00	AMZN	Stock	2.2562	2.425	2.2375	2.375	39450000.0
2000-04-17 15:00:00	AMZN	Stock	2.3781	2.45	2.3313	2.3547	34182000.0
2000-04-17 16:00:00	AMZN	Stock	2.3547	2.3547	2.3531	2.3531	56000.0
2000-04-17 09:00:00	CL	Stock	27.5	28.0	27.4375	27.4375	375800.0
2000-04-17 10:00:00	CL	Stock	27.5312	28.0	27.2812	27.9688	552600.0
2000-04-17 11:00:00	CL	Stock	28.0	28.1875	27.875	28.1562	650400.0
2000-04-17 12:00:00	CL	Stock	28.0938	28.375	27.9062	28.375	317600.0
2000-04-17 13:00:00	CL	Stock	28.375	28.5	28.0	28.0625	367800.0
2000-04-17 14:00:00	CL	Stock	28.0312	28.75	28.0312	28.6875	841400.0
2000-04-17 15:00:00	CL	Stock	28.6875	28.7812	28.4688	28.7812	993400.0
2000-04-17 16:00:00	CL	Stock	28.75	28.8125	28.75	28.8125	415200.0

> showing 40 of 14,983 rows — these rows as CSV

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