PREVIEW / stock_1hour / 2001-07-05

all stock 1-hour files

  file:    by_date/stock_1hour/2001/2001-07-05.parquet
  size:    358 KB
  rows:    16,956
  symbols: 1,303

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-07-05 08:00:00	AAPL	Stock	0.4168	0.4196	0.4152	0.4168	341600.0
2001-07-05 09:00:00	AAPL	Stock	0.4186	0.4245	0.4116	0.4154	25037600.0
2001-07-05 10:00:00	AAPL	Stock	0.4154	0.4214	0.4148	0.4155	27927200.0
2001-07-05 11:00:00	AAPL	Stock	0.4168	0.4186	0.4118	0.4121	17740800.0
2001-07-05 12:00:00	AAPL	Stock	0.4125	0.4152	0.4118	0.4143	7840000.0
2001-07-05 13:00:00	AAPL	Stock	0.4143	0.4143	0.4109	0.4118	10057600.0
2001-07-05 14:00:00	AAPL	Stock	0.4118	0.4152	0.4114	0.415	16139200.0
2001-07-05 15:00:00	AAPL	Stock	0.4145	0.4188	0.4125	0.4125	21173600.0
2001-07-05 16:00:00	AAPL	Stock	0.4141	0.4157	0.4118	0.4138	13188000.0
2001-07-05 17:00:00	AAPL	Stock	0.4141	0.4141	0.4107	0.4107	106400.0
2001-07-05 18:00:00	AAPL	Stock	0.4109	0.4134	0.4109	0.4109	84000.0
2001-07-05 08:00:00	MSFT	Stock	35.0	35.235	35.0	35.055	15600.0
2001-07-05 09:00:00	MSFT	Stock	35.1	35.36	34.9	34.925	7828000.0
2001-07-05 10:00:00	MSFT	Stock	34.96	35.16	34.85	35.005	7715000.0
2001-07-05 11:00:00	MSFT	Stock	35.01	35.095	34.65	34.71	5795600.0
2001-07-05 12:00:00	MSFT	Stock	34.705	34.775	34.505	34.605	5120000.0
2001-07-05 13:00:00	MSFT	Stock	34.605	34.615	34.34	34.46	5825800.0
2001-07-05 14:00:00	MSFT	Stock	34.465	34.56	34.395	34.49	3784800.0
2001-07-05 15:00:00	MSFT	Stock	34.49	34.525	34.225	34.255	8402800.0
2001-07-05 16:00:00	MSFT	Stock	34.255	34.72	34.155	34.155	2586800.0
2001-07-05 17:00:00	MSFT	Stock	34.165	34.255	33.88	33.88	65200.0
2001-07-05 18:00:00	MSFT	Stock	34.0	34.0	33.825	34.0	25600.0
2001-07-05 08:00:00	NVDA	Stock	0.3727	0.3729	0.3688	0.3719	504000.0
2001-07-05 09:00:00	NVDA	Stock	0.3708	0.3721	0.3631	0.3633	83976000.0
2001-07-05 10:00:00	NVDA	Stock	0.3632	0.3675	0.3531	0.3557	159840000.0
2001-07-05 11:00:00	NVDA	Stock	0.3558	0.3579	0.3465	0.349	265776000.0
2001-07-05 12:00:00	NVDA	Stock	0.3492	0.3533	0.3487	0.3523	113160000.0
2001-07-05 13:00:00	NVDA	Stock	0.3521	0.3529	0.35	0.3517	61992000.0
2001-07-05 14:00:00	NVDA	Stock	0.3519	0.3561	0.3517	0.352	86112000.0
2001-07-05 15:00:00	NVDA	Stock	0.3519	0.3535	0.3468	0.3469	175560000.0
2001-07-05 16:00:00	NVDA	Stock	0.3495	0.35	0.3458	0.3473	18840000.0
2001-07-05 17:00:00	NVDA	Stock	0.3473	0.3475	0.3438	0.3438	3624000.0
2001-07-05 18:00:00	NVDA	Stock	0.3434	0.3458	0.3429	0.3458	288000.0
2001-07-05 08:00:00	AMZN	Stock	0.7	0.715	0.7	0.7125	218000.0
2001-07-05 09:00:00	AMZN	Stock	0.71	0.753	0.7095	0.746	38774000.0
2001-07-05 10:00:00	AMZN	Stock	0.7445	0.7625	0.738	0.746	39568000.0
2001-07-05 11:00:00	AMZN	Stock	0.7455	0.7505	0.736	0.7455	20950000.0
2001-07-05 12:00:00	AMZN	Stock	0.746	0.7595	0.7445	0.757	19270000.0
2001-07-05 13:00:00	AMZN	Stock	0.755	0.7625	0.7515	0.76	18440000.0
2001-07-05 14:00:00	AMZN	Stock	0.7595	0.7725	0.7595	0.766	27168000.0
2001-07-05 15:00:00	AMZN	Stock	0.7665	0.77	0.758	0.7625	37610000.0
2001-07-05 16:00:00	AMZN	Stock	0.763	0.766	0.7565	0.7635	23044000.0
2001-07-05 17:00:00	AMZN	Stock	0.759	0.7635	0.7505	0.7505	160000.0
2001-07-05 18:00:00	AMZN	Stock	0.751	0.751	0.75	0.75	54000.0
2001-07-05 09:00:00	CL	Stock	30.05	30.05	29.875	29.875	328400.0
2001-07-05 10:00:00	CL	Stock	29.875	29.88	29.575	29.665	395400.0
2001-07-05 11:00:00	CL	Stock	29.665	29.745	29.525	29.575	374800.0
2001-07-05 12:00:00	CL	Stock	29.555	29.76	29.555	29.72	208200.0
2001-07-05 13:00:00	CL	Stock	29.73	29.8	29.59	29.59	188600.0
2001-07-05 14:00:00	CL	Stock	29.595	29.725	29.595	29.685	322600.0

> showing 50 of 16,956 rows — these rows as CSV

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