PREVIEW / stock_1hour / 2002-01-17

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-01-17.parquet
  size:    383 KB
  rows:    18,011
  symbols: 1,348

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-17 08:00:00	AAPL	Stock	0.3955	0.3964	0.3804	0.392	6120800.0
2002-01-17 09:00:00	AAPL	Stock	0.3925	0.4002	0.3893	0.3938	166006400.0
2002-01-17 10:00:00	AAPL	Stock	0.3938	0.3961	0.3905	0.3946	134926400.0
2002-01-17 11:00:00	AAPL	Stock	0.3946	0.3955	0.3905	0.3932	66595200.0
2002-01-17 12:00:00	AAPL	Stock	0.3934	0.3979	0.393	0.3971	55613600.0
2002-01-17 13:00:00	AAPL	Stock	0.397	0.3979	0.3943	0.3955	23284800.0
2002-01-17 14:00:00	AAPL	Stock	0.3959	0.3969	0.3914	0.3964	46653600.0
2002-01-17 15:00:00	AAPL	Stock	0.3959	0.4061	0.3959	0.4014	128010400.0
2002-01-17 16:00:00	AAPL	Stock	0.4014	0.4018	0.3955	0.3957	19062400.0
2002-01-17 17:00:00	AAPL	Stock	0.4014	0.4014	0.3929	0.393	772800.0
2002-01-17 18:00:00	AAPL	Stock	0.3932	0.3932	0.3857	0.3877	716800.0
2002-01-17 08:00:00	MSFT	Stock	34.325	34.325	34.15	34.255	208400.0
2002-01-17 09:00:00	MSFT	Stock	34.275	34.49	34.2	34.4	7253200.0
2002-01-17 10:00:00	MSFT	Stock	34.3945	34.72	34.3495	34.67	9966800.0
2002-01-17 11:00:00	MSFT	Stock	34.675	34.75	34.515	34.69	7892200.0
2002-01-17 12:00:00	MSFT	Stock	34.7	34.875	34.66	34.795	7447000.0
2002-01-17 13:00:00	MSFT	Stock	34.795	34.87	34.71	34.82	5208000.0
2002-01-17 14:00:00	MSFT	Stock	34.815	34.9	34.65	34.89	7136600.0
2002-01-17 15:00:00	MSFT	Stock	34.8895	35.0005	34.816	34.925	17464000.0
2002-01-17 16:00:00	MSFT	Stock	34.925	34.995	33.85	34.16	11913200.0
2002-01-17 17:00:00	MSFT	Stock	34.18	34.93	34.0	34.15	1695800.0
2002-01-17 18:00:00	MSFT	Stock	34.155	34.18	33.45	33.575	1295800.0
2002-01-17 08:00:00	NVDA	Stock	0.5354	0.5415	0.5312	0.5375	10440000.0
2002-01-17 09:00:00	NVDA	Stock	0.5375	0.5412	0.5313	0.5327	150684000.0
2002-01-17 10:00:00	NVDA	Stock	0.5327	0.537	0.5297	0.531	179556000.0
2002-01-17 11:00:00	NVDA	Stock	0.5313	0.5322	0.521	0.5262	175272000.0
2002-01-17 12:00:00	NVDA	Stock	0.5262	0.533	0.526	0.5305	119784000.0
2002-01-17 13:00:00	NVDA	Stock	0.5303	0.5322	0.528	0.528	68184000.0
2002-01-17 14:00:00	NVDA	Stock	0.528	0.5326	0.5255	0.5312	103104000.0
2002-01-17 15:00:00	NVDA	Stock	0.5322	0.5417	0.5312	0.5415	215256000.0
2002-01-17 16:00:00	NVDA	Stock	0.5416	0.5417	0.5278	0.5292	62184000.0
2002-01-17 17:00:00	NVDA	Stock	0.5292	0.5416	0.5225	0.5246	3264000.0
2002-01-17 18:00:00	NVDA	Stock	0.525	0.5262	0.5225	0.5225	564000.0
2002-01-17 08:00:00	AMZN	Stock	0.475	0.4805	0.475	0.48	928000.0
2002-01-17 09:00:00	AMZN	Stock	0.48	0.4925	0.47	0.4785	69842000.0
2002-01-17 10:00:00	AMZN	Stock	0.4785	0.4845	0.4705	0.484	37764000.0
2002-01-17 11:00:00	AMZN	Stock	0.484	0.4865	0.477	0.4785	46996000.0
2002-01-17 12:00:00	AMZN	Stock	0.4785	0.4815	0.47	0.474	49830000.0
2002-01-17 13:00:00	AMZN	Stock	0.474	0.4795	0.4735	0.478	17560000.0
2002-01-17 14:00:00	AMZN	Stock	0.478	0.4825	0.475	0.481	34230000.0
2002-01-17 15:00:00	AMZN	Stock	0.48	0.489	0.476	0.487	48482000.0
2002-01-17 16:00:00	AMZN	Stock	0.485	0.4885	0.475	0.475	5252000.0
2002-01-17 17:00:00	AMZN	Stock	0.4705	0.487	0.465	0.47	2226000.0
2002-01-17 18:00:00	AMZN	Stock	0.4723	0.475	0.4723	0.475	70000.0
2002-01-17 09:00:00	CL	Stock	28.3	28.375	28.175	28.275	277800.0
2002-01-17 10:00:00	CL	Stock	28.29	28.455	28.275	28.45	232800.0
2002-01-17 11:00:00	CL	Stock	28.44	28.62	28.35	28.585	194400.0
2002-01-17 12:00:00	CL	Stock	28.585	28.62	28.5	28.62	111400.0
2002-01-17 13:00:00	CL	Stock	28.575	28.64	28.53	28.55	190400.0
2002-01-17 14:00:00	CL	Stock	28.545	28.585	28.48	28.51	221000.0

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

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