PREVIEW / stock_1hour / 2001-06-29

all stock 1-hour files

  file:    by_date/stock_1hour/2001/2001-06-29.parquet
  size:    399 KB
  rows:    18,741
  symbols: 1,316

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-06-29 08:00:00	AAPL	Stock	0.4204	0.4214	0.4196	0.4205	1097600.0
2001-06-29 09:00:00	AAPL	Stock	0.4211	0.4277	0.4189	0.4243	36288000.0
2001-06-29 10:00:00	AAPL	Stock	0.4241	0.4277	0.4232	0.4252	59987200.0
2001-06-29 11:00:00	AAPL	Stock	0.4259	0.4371	0.425	0.4363	68320000.0
2001-06-29 12:00:00	AAPL	Stock	0.4363	0.4463	0.4357	0.4448	90031200.0
2001-06-29 13:00:00	AAPL	Stock	0.4448	0.4482	0.4427	0.4429	73001600.0
2001-06-29 14:00:00	AAPL	Stock	0.4425	0.4438	0.4357	0.4389	39676000.0
2001-06-29 15:00:00	AAPL	Stock	0.4391	0.4411	0.4313	0.4316	35252000.0
2001-06-29 16:00:00	AAPL	Stock	0.4307	0.435	0.4143	0.418	53519200.0
2001-06-29 17:00:00	AAPL	Stock	0.418	0.4411	0.4152	0.4152	24953600.0
2001-06-29 18:00:00	AAPL	Stock	0.4202	0.4282	0.4152	0.4152	39849600.0
2001-06-29 08:00:00	MSFT	Stock	36.37	36.65	36.095	36.355	349200.0
2001-06-29 09:00:00	MSFT	Stock	36.225	36.475	36.075	36.25	14722600.0
2001-06-29 10:00:00	MSFT	Stock	36.25	36.705	36.195	36.3	18942800.0
2001-06-29 11:00:00	MSFT	Stock	36.295	36.375	35.95	36.1	9132600.0
2001-06-29 12:00:00	MSFT	Stock	36.1	36.155	35.73	35.945	10210400.0
2001-06-29 13:00:00	MSFT	Stock	35.95	36.31	35.845	36.08	10059600.0
2001-06-29 14:00:00	MSFT	Stock	36.08	36.15	35.9	36.05	4360600.0
2001-06-29 15:00:00	MSFT	Stock	36.0	36.15	35.945	36.025	5897400.0
2001-06-29 16:00:00	MSFT	Stock	36.025	36.5	35.7	36.47	4588400.0
2001-06-29 17:00:00	MSFT	Stock	36.0	36.75	35.785	36.15	11709000.0
2001-06-29 18:00:00	MSFT	Stock	36.005	36.575	36.005	36.02	168400.0
2001-06-29 08:00:00	NVDA	Stock	0.3852	0.386	0.3832	0.3854	1392000.0
2001-06-29 09:00:00	NVDA	Stock	0.3854	0.389	0.38	0.3863	110640000.0
2001-06-29 10:00:00	NVDA	Stock	0.3863	0.3904	0.3842	0.3851	160872000.0
2001-06-29 11:00:00	NVDA	Stock	0.3849	0.3879	0.3846	0.3875	77544000.0
2001-06-29 12:00:00	NVDA	Stock	0.3876	0.3891	0.3859	0.389	61176000.0
2001-06-29 13:00:00	NVDA	Stock	0.3883	0.3925	0.3883	0.3896	141864000.0
2001-06-29 14:00:00	NVDA	Stock	0.3898	0.3907	0.3879	0.3889	28080000.0
2001-06-29 15:00:00	NVDA	Stock	0.389	0.3896	0.3839	0.384	68568000.0
2001-06-29 16:00:00	NVDA	Stock	0.3845	0.3912	0.3813	0.3865	38856000.0
2001-06-29 17:00:00	NVDA	Stock	0.3865	0.3883	0.3828	0.3865	9048000.0
2001-06-29 18:00:00	NVDA	Stock	0.3848	0.3873	0.3848	0.3865	8208000.0
2001-06-29 08:00:00	AMZN	Stock	0.72	0.72	0.72	0.72	16000.0
2001-06-29 09:00:00	AMZN	Stock	0.717	0.7205	0.686	0.715	11352000.0
2001-06-29 10:00:00	AMZN	Stock	0.7155	0.7325	0.712	0.718	20322000.0
2001-06-29 11:00:00	AMZN	Stock	0.7185	0.72	0.7025	0.717	6748000.0
2001-06-29 12:00:00	AMZN	Stock	0.7165	0.7275	0.715	0.724	11480000.0
2001-06-29 13:00:00	AMZN	Stock	0.7245	0.7295	0.723	0.7275	6446000.0
2001-06-29 14:00:00	AMZN	Stock	0.7275	0.728	0.7205	0.723	11956000.0
2001-06-29 15:00:00	AMZN	Stock	0.7205	0.7255	0.7165	0.7185	11212000.0
2001-06-29 16:00:00	AMZN	Stock	0.7175	0.7215	0.7075	0.7075	3662000.0
2001-06-29 17:00:00	AMZN	Stock	0.7075	0.72	0.707	0.7075	1548000.0
2001-06-29 18:00:00	AMZN	Stock	0.7075	0.7075	0.7075	0.7075	620000.0
2001-06-29 09:00:00	CL	Stock	30.475	30.5	30.065	30.09	644400.0
2001-06-29 10:00:00	CL	Stock	30.075	30.15	29.975	30.025	559600.0
2001-06-29 11:00:00	CL	Stock	30.05	30.075	29.95	30.005	454600.0
2001-06-29 12:00:00	CL	Stock	30.005	30.02	29.95	29.96	632800.0
2001-06-29 13:00:00	CL	Stock	29.96	29.985	29.845	29.855	576200.0
2001-06-29 14:00:00	CL	Stock	29.85	29.95	29.75	29.885	2064200.0

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

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