PREVIEW / stock_1hour / 2003-01-09

all stock 1-hour files

  file:    by_date/stock_1hour/2003/2003-01-09.parquet
  size:    426 KB
  rows:    19,802
  symbols: 1,532

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-09 08:00:00	AAPL	Stock	0.2596	0.2614	0.2596	0.2607	196000.0
2003-01-09 09:00:00	AAPL	Stock	0.2598	0.2641	0.2598	0.2629	31038784.0
2003-01-09 10:00:00	AAPL	Stock	0.2632	0.2648	0.2621	0.2641	36045800.0
2003-01-09 11:00:00	AAPL	Stock	0.2641	0.2664	0.2631	0.2654	28091504.0
2003-01-09 12:00:00	AAPL	Stock	0.2654	0.2655	0.262	0.2632	11378528.0
2003-01-09 13:00:00	AAPL	Stock	0.263	0.2639	0.2589	0.2605	24662344.0
2003-01-09 14:00:00	AAPL	Stock	0.2605	0.2632	0.26	0.2625	14727944.0
2003-01-09 15:00:00	AAPL	Stock	0.2625	0.2634	0.26	0.2618	26406800.0
2003-01-09 16:00:00	AAPL	Stock	0.262	0.2623	0.2595	0.2621	6636000.0
2003-01-09 17:00:00	AAPL	Stock	0.2621	0.2621	0.2621	0.2621	61600.0
2003-01-09 08:00:00	MSFT	Stock	27.325	27.43	27.2	27.375	107806.0
2003-01-09 09:00:00	MSFT	Stock	27.3655	27.53	27.12	27.4995	8060876.0
2003-01-09 10:00:00	MSFT	Stock	27.4995	27.815	27.48	27.785	12588328.0
2003-01-09 11:00:00	MSFT	Stock	27.785	27.915	27.725	27.8995	8002294.0
2003-01-09 12:00:00	MSFT	Stock	27.8945	27.9095	27.775	27.815	3800496.0
2003-01-09 13:00:00	MSFT	Stock	27.815	27.86	27.625	27.7	5702622.0
2003-01-09 14:00:00	MSFT	Stock	27.705	27.91	27.665	27.835	5930324.0
2003-01-09 15:00:00	MSFT	Stock	27.84	27.96	27.7575	27.895	10149302.0
2003-01-09 16:00:00	MSFT	Stock	27.9	27.9115	27.85	27.875	2270458.0
2003-01-09 17:00:00	MSFT	Stock	27.905	27.905	27.835	27.885	40700.0
2003-01-09 18:00:00	MSFT	Stock	27.87	27.935	27.87	27.93	23370.0
2003-01-09 08:00:00	NVDA	Stock	0.1012	0.1033	0.0996	0.1029	15093840.0
2003-01-09 09:00:00	NVDA	Stock	0.1031	0.1037	0.0996	0.1025	275491920.0
2003-01-09 10:00:00	NVDA	Stock	0.1025	0.1037	0.1017	0.1035	322480080.0
2003-01-09 11:00:00	NVDA	Stock	0.1035	0.1035	0.1017	0.102	184692720.0
2003-01-09 12:00:00	NVDA	Stock	0.102	0.1022	0.1003	0.101	144250800.0
2003-01-09 13:00:00	NVDA	Stock	0.101	0.1013	0.1004	0.1007	91647720.0
2003-01-09 14:00:00	NVDA	Stock	0.1007	0.1018	0.1004	0.1014	92350800.0
2003-01-09 15:00:00	NVDA	Stock	0.1015	0.1021	0.1008	0.1012	148995120.0
2003-01-09 16:00:00	NVDA	Stock	0.1013	0.1018	0.1009	0.1015	12777840.0
2003-01-09 17:00:00	NVDA	Stock	0.1015	0.102	0.1015	0.102	624000.0
2003-01-09 18:00:00	NVDA	Stock	0.1017	0.1017	0.1017	0.1017	84000.0
2003-01-09 08:00:00	AMZN	Stock	1.0545	1.0674	1.054	1.0585	150960.0
2003-01-09 09:00:00	AMZN	Stock	1.056	1.06	1.045	1.0575	20089460.0
2003-01-09 10:00:00	AMZN	Stock	1.0575	1.074	1.0525	1.074	25190400.0
2003-01-09 11:00:00	AMZN	Stock	1.0736	1.076	1.068	1.069	12360220.0
2003-01-09 12:00:00	AMZN	Stock	1.069	1.0715	1.0655	1.068	8741080.0
2003-01-09 13:00:00	AMZN	Stock	1.0685	1.069	1.0615	1.065	10058880.0
2003-01-09 14:00:00	AMZN	Stock	1.0646	1.069	1.0635	1.065	8818440.0
2003-01-09 15:00:00	AMZN	Stock	1.065	1.0815	1.061	1.0725	21304420.0
2003-01-09 16:00:00	AMZN	Stock	1.071	1.0725	1.07	1.07	2078520.0
2003-01-09 17:00:00	AMZN	Stock	1.0685	1.0725	1.067	1.0725	858000.0
2003-01-09 09:00:00	CL	Stock	26.5	26.695	26.49	26.625	334200.0
2003-01-09 10:00:00	CL	Stock	26.625	26.72	26.62	26.65	593200.0
2003-01-09 11:00:00	CL	Stock	26.65	26.74	26.615	26.62	252200.0
2003-01-09 12:00:00	CL	Stock	26.62	26.625	26.525	26.53	290800.0
2003-01-09 13:00:00	CL	Stock	26.53	26.62	26.53	26.55	222800.0
2003-01-09 14:00:00	CL	Stock	26.555	26.555	26.45	26.515	379000.0
2003-01-09 15:00:00	CL	Stock	26.51	26.545	26.51	26.54	858200.0
2003-01-09 16:00:00	CL	Stock	26.54	26.55	26.525	26.525	129800.0

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

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