PREVIEW / stock_1hour / 2001-12-17

all stock 1-hour files

  file:    by_date/stock_1hour/2001/2001-12-17.parquet
  size:    394 KB
  rows:    18,774
  symbols: 1,365

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
2001-12-17 08:00:00	AAPL	Stock	0.3661	0.3661	0.3661	0.3661	5600.0
2001-12-17 09:00:00	AAPL	Stock	0.3659	0.3686	0.3605	0.3666	16727200.0
2001-12-17 10:00:00	AAPL	Stock	0.3671	0.3746	0.3671	0.3725	37839200.0
2001-12-17 11:00:00	AAPL	Stock	0.3723	0.375	0.3652	0.3681	25799200.0
2001-12-17 12:00:00	AAPL	Stock	0.3688	0.3714	0.3652	0.3654	18194400.0
2001-12-17 13:00:00	AAPL	Stock	0.3659	0.3695	0.3659	0.3682	12762400.0
2001-12-17 14:00:00	AAPL	Stock	0.3686	0.3693	0.3654	0.367	21235200.0
2001-12-17 15:00:00	AAPL	Stock	0.367	0.3696	0.3645	0.3696	27076000.0
2001-12-17 16:00:00	AAPL	Stock	0.3695	0.3696	0.3664	0.3682	5622400.0
2001-12-17 17:00:00	AAPL	Stock	0.3682	0.3682	0.3682	0.3682	604800.0
2001-12-17 08:00:00	MSFT	Stock	33.7	33.775	33.65	33.7	16400.0
2001-12-17 09:00:00	MSFT	Stock	33.72	34.065	33.58	33.95	5710800.0
2001-12-17 10:00:00	MSFT	Stock	33.945	34.23	33.9	34.19	8701800.0
2001-12-17 11:00:00	MSFT	Stock	34.175	34.34	34.145	34.3	7274600.0
2001-12-17 12:00:00	MSFT	Stock	34.3	34.425	34.245	34.305	6360400.0
2001-12-17 13:00:00	MSFT	Stock	34.2905	34.5	34.265	34.46	5566800.0
2001-12-17 14:00:00	MSFT	Stock	34.465	34.555	34.375	34.42	8149400.0
2001-12-17 15:00:00	MSFT	Stock	34.425	34.5	34.275	34.495	11368000.0
2001-12-17 16:00:00	MSFT	Stock	34.49	34.5107	33.585	33.585	2593200.0
2001-12-17 17:00:00	MSFT	Stock	34.49	34.49	34.15	34.375	448400.0
2001-12-17 18:00:00	MSFT	Stock	34.375	34.375	34.375	34.375	400.0
2001-12-17 08:00:00	NVDA	Stock	0.5471	0.5499	0.5471	0.5474	660000.0
2001-12-17 09:00:00	NVDA	Stock	0.5462	0.5532	0.5417	0.5523	88824000.0
2001-12-17 10:00:00	NVDA	Stock	0.5523	0.5599	0.5512	0.5567	220248000.0
2001-12-17 11:00:00	NVDA	Stock	0.5571	0.5613	0.5554	0.557	93540000.0
2001-12-17 12:00:00	NVDA	Stock	0.5569	0.5617	0.5569	0.5597	67572000.0
2001-12-17 13:00:00	NVDA	Stock	0.5597	0.5725	0.5595	0.5717	117300000.0
2001-12-17 14:00:00	NVDA	Stock	0.572	0.5746	0.5691	0.5712	127380000.0
2001-12-17 15:00:00	NVDA	Stock	0.5712	0.5729	0.5658	0.5667	228924000.0
2001-12-17 16:00:00	NVDA	Stock	0.5667	0.569	0.5617	0.5662	130032000.0
2001-12-17 17:00:00	NVDA	Stock	0.5667	0.5686	0.5667	0.5683	492000.0
2001-12-17 18:00:00	NVDA	Stock	0.5683	0.5687	0.5683	0.5687	156000.0
2001-12-17 08:00:00	AMZN	Stock	0.56	0.56	0.5515	0.555	74000.0
2001-12-17 09:00:00	AMZN	Stock	0.555	0.557	0.542	0.546	17158000.0
2001-12-17 10:00:00	AMZN	Stock	0.546	0.5495	0.5175	0.5215	36312000.0
2001-12-17 11:00:00	AMZN	Stock	0.521	0.5325	0.509	0.526	38882000.0
2001-12-17 12:00:00	AMZN	Stock	0.5275	0.5385	0.518	0.535	20876000.0
2001-12-17 13:00:00	AMZN	Stock	0.535	0.5375	0.5245	0.535	12966000.0
2001-12-17 14:00:00	AMZN	Stock	0.5365	0.537	0.525	0.527	12036000.0
2001-12-17 15:00:00	AMZN	Stock	0.527	0.5435	0.5225	0.5435	22170000.0
2001-12-17 16:00:00	AMZN	Stock	0.5405	0.544	0.5275	0.5405	8918000.0
2001-12-17 17:00:00	AMZN	Stock	0.5405	0.5405	0.5325	0.5325	294000.0
2001-12-17 18:00:00	AMZN	Stock	0.5395	0.5415	0.5325	0.5415	162000.0
2001-12-17 09:00:00	CL	Stock	28.275	28.275	28.07	28.185	214200.0
2001-12-17 10:00:00	CL	Stock	28.185	28.35	28.175	28.35	277000.0
2001-12-17 11:00:00	CL	Stock	28.32	28.45	28.275	28.4	277600.0
2001-12-17 12:00:00	CL	Stock	28.4	28.425	28.33	28.375	153400.0
2001-12-17 13:00:00	CL	Stock	28.375	28.435	28.345	28.41	160000.0
2001-12-17 14:00:00	CL	Stock	28.42	28.45	28.35	28.425	290800.0
2001-12-17 15:00:00	CL	Stock	28.425	28.44	28.185	28.2	369400.0

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

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