PREVIEW / stock_1hour / 2002-01-18

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-01-18.parquet
  size:    382 KB
  rows:    18,332
  symbols: 1,350

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
2002-01-18 08:00:00	AAPL	Stock	0.392	0.393	0.3884	0.3929	392000.0
2002-01-18 09:00:00	AAPL	Stock	0.3929	0.3998	0.392	0.3948	56016800.0
2002-01-18 10:00:00	AAPL	Stock	0.3946	0.4036	0.3932	0.3961	61706400.0
2002-01-18 11:00:00	AAPL	Stock	0.3961	0.3964	0.3921	0.3929	35201600.0
2002-01-18 12:00:00	AAPL	Stock	0.3929	0.3952	0.3927	0.395	16945600.0
2002-01-18 13:00:00	AAPL	Stock	0.3952	0.3998	0.395	0.3987	29864800.0
2002-01-18 14:00:00	AAPL	Stock	0.3988	0.3988	0.3941	0.395	30469600.0
2002-01-18 15:00:00	AAPL	Stock	0.395	0.4	0.3936	0.3959	79385600.0
2002-01-18 16:00:00	AAPL	Stock	0.3957	0.3964	0.3957	0.3959	4771200.0
2002-01-18 17:00:00	AAPL	Stock	0.3959	0.3964	0.3959	0.3959	1142400.0
2002-01-18 18:00:00	AAPL	Stock	0.3959	0.3959	0.3959	0.3959	907200.0
2002-01-18 08:00:00	MSFT	Stock	33.75	34.935	33.355	33.55	1985800.0
2002-01-18 09:00:00	MSFT	Stock	33.525	34.935	33.175	33.48	25911600.0
2002-01-18 10:00:00	MSFT	Stock	33.475	33.925	33.2685	33.67	21471200.0
2002-01-18 11:00:00	MSFT	Stock	33.66	33.75	33.335	33.415	11071200.0
2002-01-18 12:00:00	MSFT	Stock	33.42	33.53	33.3	33.3345	6167000.0
2002-01-18 13:00:00	MSFT	Stock	33.335	33.415	33.175	33.325	6118200.0
2002-01-18 14:00:00	MSFT	Stock	33.33	33.34	32.85	32.895	10771400.0
2002-01-18 15:00:00	MSFT	Stock	32.885	33.245	32.725	33.05	16627400.0
2002-01-18 16:00:00	MSFT	Stock	33.065	33.625	33.03	33.175	2922200.0
2002-01-18 17:00:00	MSFT	Stock	33.175	33.3349	33.05	33.165	287000.0
2002-01-18 18:00:00	MSFT	Stock	33.165	33.195	33.05	33.185	129200.0
2002-01-18 08:00:00	NVDA	Stock	0.5242	0.5266	0.523	0.525	1296000.0
2002-01-18 09:00:00	NVDA	Stock	0.525	0.5392	0.5208	0.5261	158028000.0
2002-01-18 10:00:00	NVDA	Stock	0.5258	0.5333	0.5239	0.5294	153804000.0
2002-01-18 11:00:00	NVDA	Stock	0.5287	0.5332	0.5254	0.5297	88500000.0
2002-01-18 12:00:00	NVDA	Stock	0.5292	0.5352	0.5292	0.5327	64800000.0
2002-01-18 13:00:00	NVDA	Stock	0.5327	0.5354	0.5308	0.5321	60420000.0
2002-01-18 14:00:00	NVDA	Stock	0.5322	0.5328	0.5285	0.5303	79440000.0
2002-01-18 15:00:00	NVDA	Stock	0.53	0.5347	0.5282	0.5317	161640000.0
2002-01-18 16:00:00	NVDA	Stock	0.5311	0.5341	0.5296	0.5333	9492000.0
2002-01-18 17:00:00	NVDA	Stock	0.5337	0.5337	0.5317	0.5329	840000.0
2002-01-18 18:00:00	NVDA	Stock	0.5343	0.535	0.5343	0.5348	156000.0
2002-01-18 08:00:00	AMZN	Stock	0.473	0.475	0.472	0.4745	1034000.0
2002-01-18 09:00:00	AMZN	Stock	0.4675	0.486	0.4675	0.4825	17502000.0
2002-01-18 10:00:00	AMZN	Stock	0.4815	0.499	0.478	0.494	26298000.0
2002-01-18 11:00:00	AMZN	Stock	0.4935	0.5055	0.493	0.5005	28404000.0
2002-01-18 12:00:00	AMZN	Stock	0.501	0.509	0.5	0.504	19186000.0
2002-01-18 13:00:00	AMZN	Stock	0.505	0.5225	0.5	0.5218	27568000.0
2002-01-18 14:00:00	AMZN	Stock	0.522	0.5275	0.51	0.5105	33158000.0
2002-01-18 15:00:00	AMZN	Stock	0.5105	0.518	0.502	0.508	45448000.0
2002-01-18 16:00:00	AMZN	Stock	0.507	0.5105	0.502	0.506	22584000.0
2002-01-18 17:00:00	AMZN	Stock	0.508	0.5125	0.505	0.5125	868000.0
2002-01-18 18:00:00	AMZN	Stock	0.51	0.5125	0.5065	0.507	260000.0
2002-01-18 09:00:00	CL	Stock	28.45	28.65	28.41	28.5	242000.0
2002-01-18 10:00:00	CL	Stock	28.48	28.56	28.35	28.43	245400.0
2002-01-18 11:00:00	CL	Stock	28.43	28.49	28.375	28.46	173600.0
2002-01-18 12:00:00	CL	Stock	28.46	28.55	28.42	28.49	142800.0
2002-01-18 13:00:00	CL	Stock	28.5	28.55	28.49	28.53	350200.0
2002-01-18 14:00:00	CL	Stock	28.535	28.575	28.5	28.56	160200.0

> showing 50 of 18,332 rows — these rows as CSV

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