PREVIEW / stock_1hour / 2003-01-22

all stock 1-hour files

  file:    by_date/stock_1hour/2003/2003-01-22.parquet
  size:    414 KB
  rows:    19,734
  symbols: 1,529

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-01-22 09:00:00	AAPL	Stock	0.2489	0.252	0.2486	0.2516	34542200.0
2003-01-22 10:00:00	AAPL	Stock	0.2513	0.252	0.2502	0.2516	39074840.0
2003-01-22 11:00:00	AAPL	Stock	0.2516	0.2518	0.2507	0.2509	13555024.0
2003-01-22 12:00:00	AAPL	Stock	0.2509	0.2518	0.2502	0.2514	17991624.0
2003-01-22 13:00:00	AAPL	Stock	0.2514	0.2527	0.2507	0.2511	15451576.0
2003-01-22 14:00:00	AAPL	Stock	0.2511	0.2527	0.2502	0.2505	16017624.0
2003-01-22 15:00:00	AAPL	Stock	0.2504	0.2509	0.2473	0.2477	54406968.0
2003-01-22 16:00:00	AAPL	Stock	0.2479	0.2516	0.2464	0.2488	12012000.0
2003-01-22 17:00:00	AAPL	Stock	0.2488	0.2498	0.2479	0.2498	190400.0
2003-01-22 08:00:00	MSFT	Stock	25.542	25.67	25.395	25.6	98396.0
2003-01-22 09:00:00	MSFT	Stock	25.595	25.92	25.505	25.81	10965460.0
2003-01-22 10:00:00	MSFT	Stock	25.81	26.015	25.75	25.88	15563400.0
2003-01-22 11:00:00	MSFT	Stock	25.885	25.9	25.715	25.745	9295680.0
2003-01-22 12:00:00	MSFT	Stock	25.735	25.93	25.7055	25.85	5941458.0
2003-01-22 13:00:00	MSFT	Stock	25.855	25.965	25.85	25.92	5372894.0
2003-01-22 14:00:00	MSFT	Stock	25.92	26.2	25.85	25.88	13317640.0
2003-01-22 15:00:00	MSFT	Stock	25.87	25.895	25.455	25.5	18680946.0
2003-01-22 16:00:00	MSFT	Stock	25.5	25.73	25.45	25.61	2112080.0
2003-01-22 17:00:00	MSFT	Stock	25.61	25.845	25.5	25.835	502940.0
2003-01-22 18:00:00	MSFT	Stock	25.83	26.0	25.78	25.85	134380.0
2003-01-22 08:00:00	NVDA	Stock	0.0879	0.0879	0.0855	0.0867	1074240.0
2003-01-22 09:00:00	NVDA	Stock	0.0874	0.0897	0.0862	0.0887	87166920.0
2003-01-22 10:00:00	NVDA	Stock	0.0886	0.0892	0.0878	0.0886	95812440.0
2003-01-22 11:00:00	NVDA	Stock	0.0887	0.0896	0.0881	0.0891	82873920.0
2003-01-22 12:00:00	NVDA	Stock	0.0892	0.0896	0.089	0.089	42918360.0
2003-01-22 13:00:00	NVDA	Stock	0.0889	0.0895	0.0887	0.0889	41866560.0
2003-01-22 14:00:00	NVDA	Stock	0.0888	0.0893	0.0879	0.0881	58714560.0
2003-01-22 15:00:00	NVDA	Stock	0.088	0.0885	0.0871	0.0875	97881240.0
2003-01-22 16:00:00	NVDA	Stock	0.0876	0.0887	0.0867	0.0883	15387120.0
2003-01-22 17:00:00	NVDA	Stock	0.0887	0.0895	0.0885	0.0892	1732800.0
2003-01-22 18:00:00	NVDA	Stock	0.089	0.0896	0.089	0.0896	1759200.0
2003-01-22 08:00:00	AMZN	Stock	1.05	1.053	1.0385	1.043	114000.0
2003-01-22 09:00:00	AMZN	Stock	1.043	1.061	1.0375	1.043	14663400.0
2003-01-22 10:00:00	AMZN	Stock	1.043	1.0602	1.042	1.055	21638060.0
2003-01-22 11:00:00	AMZN	Stock	1.055	1.065	1.052	1.062	16980540.0
2003-01-22 12:00:00	AMZN	Stock	1.0615	1.0825	1.0605	1.08	18577800.0
2003-01-22 13:00:00	AMZN	Stock	1.08	1.0825	1.076	1.0785	11639560.0
2003-01-22 14:00:00	AMZN	Stock	1.08	1.085	1.07	1.074	11710840.0
2003-01-22 15:00:00	AMZN	Stock	1.0736	1.0755	1.0505	1.059	28344420.0
2003-01-22 16:00:00	AMZN	Stock	1.0585	1.0735	1.0566	1.0625	1229000.0
2003-01-22 17:00:00	AMZN	Stock	1.06	1.0675	1.0585	1.06	524000.0
2003-01-22 18:00:00	AMZN	Stock	1.0765	1.0765	1.075	1.075	34000.0
2003-01-22 09:00:00	CL	Stock	26.475	26.55	26.425	26.475	381800.0
2003-01-22 10:00:00	CL	Stock	26.47	26.5	26.345	26.385	648000.0
2003-01-22 11:00:00	CL	Stock	26.38	26.39	26.0	26.025	675800.0
2003-01-22 12:00:00	CL	Stock	26.025	26.15	26.02	26.125	473800.0
2003-01-22 13:00:00	CL	Stock	26.125	26.13	26.075	26.075	239200.0
2003-01-22 14:00:00	CL	Stock	26.08	26.15	25.95	25.975	362200.0
2003-01-22 15:00:00	CL	Stock	25.975	26.035	25.94	25.955	532000.0
2003-01-22 16:00:00	CL	Stock	25.95	26.11	25.95	26.11	124200.0

> showing 50 of 19,734 rows — these rows as CSV

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