PREVIEW / stock_1hour / 2000-09-29

all stock 1-hour files

  file:    by_date/stock_1hour/2000/2000-09-29.parquet
  size:    320 KB
  rows:    16,598
  symbols: 1,227

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
2000-09-29 08:00:00	AAPL	Stock	0.5089	0.5625	0.4866	0.49	413543200.0
2000-09-29 09:00:00	AAPL	Stock	0.4888	0.5491	0.4821	0.4989	1374385600.0
2000-09-29 10:00:00	AAPL	Stock	0.4989	0.5	0.4621	0.4676	1742216000.0
2000-09-29 11:00:00	AAPL	Stock	0.4688	0.4754	0.4565	0.4632	979899200.0
2000-09-29 12:00:00	AAPL	Stock	0.4632	0.4676	0.4598	0.4665	539050400.0
2000-09-29 13:00:00	AAPL	Stock	0.4665	0.4727	0.4621	0.4643	502863200.0
2000-09-29 14:00:00	AAPL	Stock	0.4643	0.4665	0.4554	0.4565	613194400.0
2000-09-29 15:00:00	AAPL	Stock	0.4565	0.4682	0.4531	0.4587	913197600.0
2000-09-29 16:00:00	AAPL	Stock	0.4598	0.4732	0.4554	0.4598	167546400.0
2000-09-29 17:00:00	AAPL	Stock	0.4621	0.4643	0.4598	0.4643	6109600.0
2000-09-29 18:00:00	AAPL	Stock	0.4643	0.4654	0.4621	0.4643	3068800.0
2000-09-29 08:00:00	MSFT	Stock	30.6562	30.6562	30.125	30.2188	119600.0
2000-09-29 09:00:00	MSFT	Stock	30.1875	30.6562	30.1875	30.2188	6396200.0
2000-09-29 10:00:00	MSFT	Stock	30.2188	30.25	29.5625	29.7812	16674800.0
2000-09-29 11:00:00	MSFT	Stock	29.8125	29.8438	29.375	29.4062	8052000.0
2000-09-29 12:00:00	MSFT	Stock	29.375	29.8438	29.3125	29.75	6836400.0
2000-09-29 13:00:00	MSFT	Stock	29.7812	30.0	29.625	30.0	6940400.0
2000-09-29 14:00:00	MSFT	Stock	30.0	30.3125	29.875	30.2188	9397200.0
2000-09-29 15:00:00	MSFT	Stock	30.1875	30.4688	30.0	30.1562	10603200.0
2000-09-29 16:00:00	MSFT	Stock	30.1562	30.1875	29.5625	30.0	5360000.0
2000-09-29 17:00:00	MSFT	Stock	30.0	30.1719	30.0	30.0938	856000.0
2000-09-29 18:00:00	MSFT	Stock	30.125	30.125	30.0312	30.0312	2600.0
2000-09-29 08:00:00	NVDA	Stock	0.35	0.351	0.35	0.351	192000.0
2000-09-29 09:00:00	NVDA	Stock	0.3458	0.3542	0.3406	0.351	31344000.0
2000-09-29 10:00:00	NVDA	Stock	0.3521	0.3531	0.3393	0.3438	68544000.0
2000-09-29 11:00:00	NVDA	Stock	0.3435	0.3453	0.3422	0.343	19440000.0
2000-09-29 12:00:00	NVDA	Stock	0.3435	0.3435	0.3354	0.3409	63288000.0
2000-09-29 13:00:00	NVDA	Stock	0.3411	0.3417	0.3385	0.3401	15816000.0
2000-09-29 14:00:00	NVDA	Stock	0.341	0.3477	0.3396	0.3445	41280000.0
2000-09-29 15:00:00	NVDA	Stock	0.3432	0.351	0.3398	0.3411	88728000.0
2000-09-29 16:00:00	NVDA	Stock	0.3411	0.3458	0.3406	0.3406	30768000.0
2000-09-29 17:00:00	NVDA	Stock	0.3411	0.3411	0.3411	0.3411	3360000.0
2000-09-29 08:00:00	AMZN	Stock	1.9562	1.9594	1.9375	1.9375	258000.0
2000-09-29 09:00:00	AMZN	Stock	1.9469	2.025	1.9469	2.025	16558000.0
2000-09-29 10:00:00	AMZN	Stock	2.0281	2.0625	2.0062	2.0094	28190000.0
2000-09-29 11:00:00	AMZN	Stock	2.0094	2.0188	1.9688	1.9812	14112000.0
2000-09-29 12:00:00	AMZN	Stock	1.9812	1.9938	1.9625	1.9781	6174000.0
2000-09-29 13:00:00	AMZN	Stock	1.9812	1.9812	1.9625	1.9625	7328000.0
2000-09-29 14:00:00	AMZN	Stock	1.9625	1.9719	1.925	1.9312	9664000.0
2000-09-29 15:00:00	AMZN	Stock	1.9281	1.9344	1.8812	1.9219	30086000.0
2000-09-29 16:00:00	AMZN	Stock	1.925	1.9375	1.8938	1.9188	8838000.0
2000-09-29 17:00:00	AMZN	Stock	1.9	1.9219	1.8938	1.9219	154000.0
2000-09-29 18:00:00	AMZN	Stock	1.9	1.9	1.9	1.9	10000.0
2000-09-29 09:00:00	CL	Stock	23.75	23.815	23.71	23.71	490600.0
2000-09-29 10:00:00	CL	Stock	23.73	23.825	23.685	23.7	408400.0
2000-09-29 11:00:00	CL	Stock	23.71	23.745	23.575	23.65	419000.0
2000-09-29 12:00:00	CL	Stock	23.655	23.8	23.645	23.75	334400.0
2000-09-29 13:00:00	CL	Stock	23.75	23.825	23.705	23.815	467000.0
2000-09-29 14:00:00	CL	Stock	23.845	24.015	23.715	23.715	675400.0
2000-09-29 15:00:00	CL	Stock	23.7	23.795	23.625	23.645	694000.0

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

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