PREVIEW / stock_1hour / 2000-04-18

all stock 1-hour files

  file:    by_date/stock_1hour/2000/2000-04-18.parquet
  size:    283 KB
  rows:    14,689
  symbols: 1,162

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-18 09:00:00	AAPL	Stock	1.1027	1.1183	1.077	1.1071	53368000.0
2000-04-18 10:00:00	AAPL	Stock	1.1077	1.111	1.0658	1.082	62552000.0
2000-04-18 11:00:00	AAPL	Stock	1.0798	1.1083	1.0759	1.0988	47633600.0
2000-04-18 12:00:00	AAPL	Stock	1.0985	1.1272	1.0965	1.1161	44116800.0
2000-04-18 13:00:00	AAPL	Stock	1.1161	1.1228	1.0993	1.1071	32088000.0
2000-04-18 14:00:00	AAPL	Stock	1.1069	1.1211	1.0882	1.1049	44419200.0
2000-04-18 15:00:00	AAPL	Stock	1.1049	1.1328	1.0926	1.1323	71344000.0
2000-04-18 16:00:00	AAPL	Stock	1.13	1.1328	1.13	1.1328	324800.0
2000-04-18 09:00:00	MSFT	Stock	38.25	38.9688	38.0	38.8125	9961400.0
2000-04-18 10:00:00	MSFT	Stock	38.875	39.25	38.625	39.1562	13719600.0
2000-04-18 11:00:00	MSFT	Stock	39.125	40.5938	39.125	40.5469	19557000.0
2000-04-18 12:00:00	MSFT	Stock	40.5781	40.9688	40.0625	40.25	14882600.0
2000-04-18 13:00:00	MSFT	Stock	40.2188	40.3125	39.7812	40.3125	6246600.0
2000-04-18 14:00:00	MSFT	Stock	40.3125	40.4688	39.75	40.0938	7281800.0
2000-04-18 15:00:00	MSFT	Stock	40.0938	40.4375	39.5	40.3125	11209800.0
2000-04-18 16:00:00	MSFT	Stock	40.2812	40.3125	40.2812	40.2812	228600.0
2000-04-18 09:00:00	NVDA	Stock	0.1658	0.1745	0.1609	0.1721	83856000.0
2000-04-18 10:00:00	NVDA	Stock	0.1729	0.1833	0.1687	0.1762	92784000.0
2000-04-18 11:00:00	NVDA	Stock	0.1763	0.1826	0.1718	0.1799	71952000.0
2000-04-18 12:00:00	NVDA	Stock	0.1799	0.187	0.174	0.1755	55920000.0
2000-04-18 13:00:00	NVDA	Stock	0.1755	0.181	0.1701	0.181	27360000.0
2000-04-18 14:00:00	NVDA	Stock	0.1811	0.1812	0.1714	0.1781	30336000.0
2000-04-18 15:00:00	NVDA	Stock	0.1792	0.1796	0.1742	0.1773	77280000.0
2000-04-18 16:00:00	NVDA	Stock	0.1773	0.1773	0.1773	0.1773	240000.0
2000-04-18 09:00:00	AMZN	Stock	2.3812	2.4313	2.3562	2.3719	15982000.0
2000-04-18 10:00:00	AMZN	Stock	2.3719	2.5813	2.3719	2.5719	24906000.0
2000-04-18 11:00:00	AMZN	Stock	2.5688	2.6625	2.5531	2.6594	32918000.0
2000-04-18 12:00:00	AMZN	Stock	2.6625	2.8125	2.6312	2.6875	42284000.0
2000-04-18 13:00:00	AMZN	Stock	2.6813	2.7	2.6438	2.6438	18246000.0
2000-04-18 14:00:00	AMZN	Stock	2.6469	2.7594	2.6438	2.7	36346000.0
2000-04-18 15:00:00	AMZN	Stock	2.7	2.75	2.6312	2.75	32116000.0
2000-04-18 16:00:00	AMZN	Stock	2.75	2.75	2.7375	2.7469	752000.0
2000-04-18 09:00:00	CL	Stock	28.5	28.5	28.0312	28.1562	299600.0
2000-04-18 10:00:00	CL	Stock	28.1875	28.25	27.3125	27.3125	596400.0
2000-04-18 11:00:00	CL	Stock	27.375	27.625	27.3125	27.5	777600.0
2000-04-18 12:00:00	CL	Stock	27.4375	27.6562	27.3438	27.4688	528400.0
2000-04-18 13:00:00	CL	Stock	27.4688	27.625	27.3438	27.5312	663200.0
2000-04-18 14:00:00	CL	Stock	27.5625	27.625	27.4062	27.4688	483400.0
2000-04-18 15:00:00	CL	Stock	27.4375	27.6875	27.4375	27.5312	972600.0
2000-04-18 16:00:00	CL	Stock	27.5312	27.6562	27.5312	27.625	244800.0

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

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