PREVIEW / stock_1hour / 2001-07-02

all stock 1-hour files

  file:    by_date/stock_1hour/2001/2001-07-02.parquet
  size:    370 KB
  rows:    17,588
  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-07-02 08:00:00	AAPL	Stock	0.4286	0.4286	0.425	0.425	61600.0
2001-07-02 09:00:00	AAPL	Stock	0.4223	0.4243	0.4132	0.4148	53967200.0
2001-07-02 10:00:00	AAPL	Stock	0.4155	0.4268	0.4132	0.4196	48468000.0
2001-07-02 11:00:00	AAPL	Stock	0.4196	0.4263	0.4188	0.4255	26840800.0
2001-07-02 12:00:00	AAPL	Stock	0.4248	0.4263	0.4229	0.4248	12180000.0
2001-07-02 13:00:00	AAPL	Stock	0.4245	0.4263	0.4223	0.4225	14291200.0
2001-07-02 14:00:00	AAPL	Stock	0.4225	0.4296	0.4223	0.4288	22752800.0
2001-07-02 15:00:00	AAPL	Stock	0.4288	0.4327	0.4204	0.4268	36545600.0
2001-07-02 16:00:00	AAPL	Stock	0.427	0.4295	0.4161	0.4268	9721600.0
2001-07-02 17:00:00	AAPL	Stock	0.428	0.428	0.427	0.427	156800.0
2001-07-02 07:00:00	MSFT	Stock	36.0	36.0	36.0	36.0	200.0
2001-07-02 08:00:00	MSFT	Stock	36.05	36.185	35.875	36.025	44400.0
2001-07-02 09:00:00	MSFT	Stock	36.0	36.3	35.84	36.09	6510400.0
2001-07-02 10:00:00	MSFT	Stock	36.09	36.45	36.01	36.335	9252000.0
2001-07-02 11:00:00	MSFT	Stock	36.335	36.575	36.335	36.45	8605000.0
2001-07-02 12:00:00	MSFT	Stock	36.445	36.51	35.945	35.96	6924000.0
2001-07-02 13:00:00	MSFT	Stock	35.96	36.015	35.7	35.72	6983800.0
2001-07-02 14:00:00	MSFT	Stock	35.72	35.735	35.4	35.525	8449800.0
2001-07-02 15:00:00	MSFT	Stock	35.525	35.635	35.075	35.295	13990000.0
2001-07-02 16:00:00	MSFT	Stock	35.275	35.905	35.165	35.22	8499600.0
2001-07-02 17:00:00	MSFT	Stock	35.25	35.315	35.075	35.105	151800.0
2001-07-02 18:00:00	MSFT	Stock	35.2	35.2	35.165	35.165	600.0
2001-07-02 08:00:00	NVDA	Stock	0.3781	0.3859	0.3646	0.3667	13488000.0
2001-07-02 09:00:00	NVDA	Stock	0.3685	0.3733	0.3638	0.3657	258048000.0
2001-07-02 10:00:00	NVDA	Stock	0.3658	0.3716	0.3645	0.3702	180144000.0
2001-07-02 11:00:00	NVDA	Stock	0.3703	0.3743	0.3677	0.37	131016000.0
2001-07-02 12:00:00	NVDA	Stock	0.3703	0.3703	0.3675	0.3684	87576000.0
2001-07-02 13:00:00	NVDA	Stock	0.3685	0.3696	0.3667	0.3667	72264000.0
2001-07-02 14:00:00	NVDA	Stock	0.3667	0.3712	0.3663	0.3692	96504000.0
2001-07-02 15:00:00	NVDA	Stock	0.3692	0.3717	0.3668	0.3693	140184000.0
2001-07-02 16:00:00	NVDA	Stock	0.3693	0.37	0.3683	0.3695	23712000.0
2001-07-02 17:00:00	NVDA	Stock	0.37	0.3712	0.3683	0.3699	144000.0
2001-07-02 18:00:00	NVDA	Stock	0.3693	0.3693	0.3693	0.3693	48000.0
2001-07-02 08:00:00	AMZN	Stock	0.7125	0.7125	0.7105	0.7105	20000.0
2001-07-02 09:00:00	AMZN	Stock	0.7125	0.7125	0.6925	0.701	10438000.0
2001-07-02 10:00:00	AMZN	Stock	0.701	0.725	0.6995	0.725	14048000.0
2001-07-02 11:00:00	AMZN	Stock	0.726	0.7355	0.7225	0.7305	18808000.0
2001-07-02 12:00:00	AMZN	Stock	0.7305	0.7305	0.718	0.7195	9196000.0
2001-07-02 13:00:00	AMZN	Stock	0.7195	0.725	0.7175	0.718	13042000.0
2001-07-02 14:00:00	AMZN	Stock	0.719	0.727	0.7135	0.7245	14246000.0
2001-07-02 15:00:00	AMZN	Stock	0.724	0.7325	0.7215	0.7265	19360000.0
2001-07-02 16:00:00	AMZN	Stock	0.7265	0.7495	0.723	0.7265	2586000.0
2001-07-02 17:00:00	AMZN	Stock	0.72	0.725	0.72	0.72	38000.0
2001-07-02 09:00:00	CL	Stock	29.495	29.715	29.495	29.715	464000.0
2001-07-02 10:00:00	CL	Stock	29.695	29.785	29.65	29.765	567600.0
2001-07-02 11:00:00	CL	Stock	29.765	30.1	29.765	30.005	485800.0
2001-07-02 12:00:00	CL	Stock	30.025	30.105	29.81	29.82	729600.0
2001-07-02 13:00:00	CL	Stock	29.82	29.91	29.725	29.825	423200.0
2001-07-02 14:00:00	CL	Stock	29.825	29.99	29.82	29.89	367200.0
2001-07-02 15:00:00	CL	Stock	29.9	30.0	29.825	29.99	919200.0

> showing 50 of 17,588 rows — these rows as CSV

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