PREVIEW / stock_1hour / 2003-08-25

all stock 1-hour files

  file:    by_date/stock_1hour/2003/2003-08-25.parquet
  size:    438 KB
  rows:    21,320
  symbols: 1,610

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-25 09:00:00	AAPL	Stock	0.3714	0.3721	0.3661	0.3688	18484872.0
2003-08-25 10:00:00	AAPL	Stock	0.3688	0.3702	0.3661	0.3666	13535592.0
2003-08-25 11:00:00	AAPL	Stock	0.3666	0.3689	0.3661	0.3666	13327440.0
2003-08-25 12:00:00	AAPL	Stock	0.3666	0.3698	0.3659	0.3698	13848912.0
2003-08-25 13:00:00	AAPL	Stock	0.3697	0.3704	0.3673	0.368	15616720.0
2003-08-25 14:00:00	AAPL	Stock	0.368	0.3691	0.3677	0.3689	11585056.0
2003-08-25 15:00:00	AAPL	Stock	0.3689	0.3734	0.3688	0.3729	39712064.0
2003-08-25 16:00:00	AAPL	Stock	0.3725	0.3734	0.372	0.3729	2923200.0
2003-08-25 17:00:00	AAPL	Stock	0.3666	0.3666	0.3666	0.3666	151200.0
2003-08-25 08:00:00	MSFT	Stock	26.22	26.37	26.2	26.31	51066.0
2003-08-25 09:00:00	MSFT	Stock	26.32	26.45	26.279	26.31	5698359.0
2003-08-25 10:00:00	MSFT	Stock	26.31	26.42	26.23	26.34	8839447.0
2003-08-25 11:00:00	MSFT	Stock	26.35	26.406	26.3	26.37	4257590.0
2003-08-25 12:00:00	MSFT	Stock	26.37	26.5	26.34	26.5	2727895.0
2003-08-25 13:00:00	MSFT	Stock	26.5	26.5	26.38	26.42	2819207.0
2003-08-25 14:00:00	MSFT	Stock	26.41	26.46	26.35	26.38	1897645.0
2003-08-25 15:00:00	MSFT	Stock	26.38	26.54	26.35	26.51	6023198.0
2003-08-25 16:00:00	MSFT	Stock	26.51	26.6	26.49	26.53	352703.0
2003-08-25 17:00:00	MSFT	Stock	26.54	26.56	26.39	26.56	24689.0
2003-08-25 18:00:00	MSFT	Stock	26.56	26.56	26.55	26.56	3000.0
2003-08-25 08:00:00	NVDA	Stock	0.1515	0.1515	0.1507	0.1515	156000.0
2003-08-25 09:00:00	NVDA	Stock	0.1515	0.1551	0.1512	0.1518	80877720.0
2003-08-25 10:00:00	NVDA	Stock	0.1516	0.153	0.15	0.1517	122285400.0
2003-08-25 11:00:00	NVDA	Stock	0.1517	0.152	0.1509	0.1512	46730880.0
2003-08-25 12:00:00	NVDA	Stock	0.1512	0.1521	0.1508	0.1521	32120520.0
2003-08-25 13:00:00	NVDA	Stock	0.1521	0.1522	0.151	0.1512	20749440.0
2003-08-25 14:00:00	NVDA	Stock	0.1512	0.1513	0.1502	0.1502	36857280.0
2003-08-25 15:00:00	NVDA	Stock	0.1502	0.1517	0.1502	0.1516	51221280.0
2003-08-25 16:00:00	NVDA	Stock	0.1515	0.1518	0.1513	0.1517	2292000.0
2003-08-25 17:00:00	NVDA	Stock	0.1528	0.1528	0.1514	0.1514	240000.0
2003-08-25 08:00:00	AMZN	Stock	2.261	2.261	2.2375	2.25	106000.0
2003-08-25 09:00:00	AMZN	Stock	2.25	2.255	2.2265	2.228	18494580.0
2003-08-25 10:00:00	AMZN	Stock	2.2275	2.2625	2.2275	2.2508	23373240.0
2003-08-25 11:00:00	AMZN	Stock	2.2495	2.256	2.242	2.247	13758960.0
2003-08-25 12:00:00	AMZN	Stock	2.2475	2.2625	2.2465	2.2625	12089060.0
2003-08-25 13:00:00	AMZN	Stock	2.2625	2.2745	2.2605	2.2655	13198320.0
2003-08-25 14:00:00	AMZN	Stock	2.2654	2.2725	2.2575	2.264	8080000.0
2003-08-25 15:00:00	AMZN	Stock	2.263	2.308	2.2625	2.297	38381220.0
2003-08-25 16:00:00	AMZN	Stock	2.2955	2.3045	2.2925	2.3	1967260.0
2003-08-25 17:00:00	AMZN	Stock	2.3015	2.3035	2.256	2.3015	124000.0
2003-08-25 18:00:00	AMZN	Stock	2.3032	2.305	2.302	2.3025	42000.0
2003-08-25 09:00:00	CL	Stock	26.625	26.625	26.475	26.56	384400.0
2003-08-25 10:00:00	CL	Stock	26.555	26.65	26.525	26.57	545400.0
2003-08-25 11:00:00	CL	Stock	26.565	26.755	26.565	26.73	445800.0
2003-08-25 12:00:00	CL	Stock	26.735	26.735	26.665	26.71	161000.0
2003-08-25 13:00:00	CL	Stock	26.705	26.725	26.645	26.695	189400.0
2003-08-25 14:00:00	CL	Stock	26.695	26.715	26.655	26.655	171000.0
2003-08-25 15:00:00	CL	Stock	26.655	26.675	26.625	26.67	374400.0
2003-08-25 16:00:00	CL	Stock	26.67	26.7	26.67	26.7	55200.0

> showing 49 of 21,320 rows — these rows as CSV

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