PREVIEW / stock_1hour / 2001-06-28

all stock 1-hour files

  file:    by_date/stock_1hour/2001/2001-06-28.parquet
  size:    371 KB
  rows:    17,662
  symbols: 1,314

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-28 08:00:00	AAPL	Stock	0.4166	0.4196	0.4166	0.4179	1002400.0
2001-06-28 09:00:00	AAPL	Stock	0.4179	0.4241	0.4096	0.4223	64332800.0
2001-06-28 10:00:00	AAPL	Stock	0.4232	0.4238	0.417	0.4198	54404000.0
2001-06-28 11:00:00	AAPL	Stock	0.4198	0.4232	0.4166	0.4205	60788000.0
2001-06-28 12:00:00	AAPL	Stock	0.4205	0.422	0.4189	0.4207	23604000.0
2001-06-28 13:00:00	AAPL	Stock	0.4207	0.4238	0.4196	0.4216	38169600.0
2001-06-28 14:00:00	AAPL	Stock	0.4218	0.427	0.4204	0.4264	35308000.0
2001-06-28 15:00:00	AAPL	Stock	0.4263	0.4268	0.4177	0.4204	53082400.0
2001-06-28 16:00:00	AAPL	Stock	0.4205	0.4236	0.4179	0.4179	8624000.0
2001-06-28 17:00:00	AAPL	Stock	0.4179	0.4179	0.4143	0.4146	33600.0
2001-06-28 08:00:00	MSFT	Stock	35.475	36.075	35.475	35.9	826400.0
2001-06-28 09:00:00	MSFT	Stock	35.9	35.95	35.65	35.835	11886600.0
2001-06-28 10:00:00	MSFT	Stock	35.83	35.885	35.125	35.5	21032600.0
2001-06-28 11:00:00	MSFT	Stock	35.5	37.595	35.29	35.31	12591000.0
2001-06-28 14:00:00	MSFT	Stock	36.5	38.075	36.165	36.8	23528600.0
2001-06-28 15:00:00	MSFT	Stock	36.815	36.975	36.08	36.37	48650800.0
2001-06-28 16:00:00	MSFT	Stock	36.37	37.125	35.265	36.31	3498400.0
2001-06-28 17:00:00	MSFT	Stock	36.3	36.445	36.3	36.445	135800.0
2001-06-28 18:00:00	MSFT	Stock	36.49	36.595	36.425	36.55	34200.0
2001-06-28 08:00:00	NVDA	Stock	0.3833	0.3854	0.3823	0.384	1320000.0
2001-06-28 09:00:00	NVDA	Stock	0.384	0.387	0.3792	0.3822	153840000.0
2001-06-28 10:00:00	NVDA	Stock	0.3822	0.3883	0.3822	0.3836	234480000.0
2001-06-28 11:00:00	NVDA	Stock	0.3836	0.3885	0.3829	0.3863	129096000.0
2001-06-28 12:00:00	NVDA	Stock	0.3863	0.3875	0.383	0.3841	48624000.0
2001-06-28 13:00:00	NVDA	Stock	0.3841	0.3875	0.3825	0.3866	84504000.0
2001-06-28 14:00:00	NVDA	Stock	0.3867	0.3885	0.3844	0.3873	110952000.0
2001-06-28 15:00:00	NVDA	Stock	0.3869	0.3875	0.3829	0.383	90648000.0
2001-06-28 16:00:00	NVDA	Stock	0.3833	0.3836	0.3771	0.3826	4920000.0
2001-06-28 17:00:00	NVDA	Stock	0.383	0.383	0.383	0.383	600000.0
2001-06-28 18:00:00	NVDA	Stock	0.3839	0.384	0.3829	0.384	360000.0
2001-06-28 08:00:00	AMZN	Stock	0.7095	0.723	0.7	0.712	284000.0
2001-06-28 09:00:00	AMZN	Stock	0.71	0.7225	0.708	0.7225	20706000.0
2001-06-28 10:00:00	AMZN	Stock	0.7225	0.7295	0.7145	0.7185	25676000.0
2001-06-28 11:00:00	AMZN	Stock	0.719	0.7285	0.715	0.7225	10150000.0
2001-06-28 12:00:00	AMZN	Stock	0.7225	0.7255	0.7085	0.7085	6402000.0
2001-06-28 13:00:00	AMZN	Stock	0.7075	0.72	0.707	0.714	7314000.0
2001-06-28 14:00:00	AMZN	Stock	0.714	0.72	0.709	0.7155	9626000.0
2001-06-28 15:00:00	AMZN	Stock	0.715	0.7195	0.69	0.718	19120000.0
2001-06-28 16:00:00	AMZN	Stock	0.7175	0.72	0.705	0.715	4200000.0
2001-06-28 17:00:00	AMZN	Stock	0.718	0.718	0.7155	0.7155	4000.0
2001-06-28 18:00:00	AMZN	Stock	0.718	0.718	0.718	0.718	2000.0
2001-06-28 09:00:00	CL	Stock	30.375	30.5	30.275	30.36	386400.0
2001-06-28 10:00:00	CL	Stock	30.36	30.37	30.175	30.225	425400.0
2001-06-28 11:00:00	CL	Stock	30.225	30.32	30.165	30.315	403200.0
2001-06-28 12:00:00	CL	Stock	30.315	30.435	30.315	30.4	402200.0
2001-06-28 13:00:00	CL	Stock	30.405	30.43	30.3	30.415	188600.0
2001-06-28 14:00:00	CL	Stock	30.41	30.465	30.36	30.445	368600.0
2001-06-28 15:00:00	CL	Stock	30.42	30.47	30.395	30.46	575600.0
2001-06-28 16:00:00	CL	Stock	30.46	30.475	30.37	30.37	184800.0

> showing 49 of 17,662 rows — these rows as CSV

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