PREVIEW / stock_1hour / 2002-08-14

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-08-14.parquet
  size:    389 KB
  rows:    18,481
  symbols: 1,462

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
2002-08-14 09:00:00	AAPL	Stock	0.2616	0.2627	0.26	0.2622	18508616.0
2002-08-14 10:00:00	AAPL	Stock	0.262	0.2645	0.2604	0.2638	30627800.0
2002-08-14 11:00:00	AAPL	Stock	0.2639	0.2641	0.2613	0.2616	37216704.0
2002-08-14 12:00:00	AAPL	Stock	0.2616	0.2629	0.2597	0.2623	24421600.0
2002-08-14 13:00:00	AAPL	Stock	0.2621	0.2625	0.2596	0.2618	51337440.0
2002-08-14 14:00:00	AAPL	Stock	0.2616	0.2659	0.261	0.2659	90754888.0
2002-08-14 15:00:00	AAPL	Stock	0.2657	0.2741	0.2657	0.2723	109940320.0
2002-08-14 16:00:00	AAPL	Stock	0.2725	0.2725	0.2679	0.2696	17794056.0
2002-08-14 17:00:00	AAPL	Stock	0.2696	0.2726	0.2696	0.2708	184800.0
2002-08-14 08:00:00	MSFT	Stock	23.45	23.65	23.39	23.62	79834.0
2002-08-14 09:00:00	MSFT	Stock	23.625	23.895	23.395	23.82	11188906.0
2002-08-14 10:00:00	MSFT	Stock	23.82	24.195	23.67	24.115	16863188.0
2002-08-14 11:00:00	MSFT	Stock	24.12	24.18	23.875	24.015	8632856.0
2002-08-14 12:00:00	MSFT	Stock	24.02	24.265	23.94	24.205	7072616.0
2002-08-14 13:00:00	MSFT	Stock	24.215	24.46	24.125	24.455	10339524.0
2002-08-14 14:00:00	MSFT	Stock	24.455	24.65	24.4	24.63	15892188.0
2002-08-14 15:00:00	MSFT	Stock	24.625	24.845	24.6	24.83	22612530.0
2002-08-14 16:00:00	MSFT	Stock	24.83	24.865	23.62	24.8	1760992.0
2002-08-14 17:00:00	MSFT	Stock	24.79	24.945	24.728	24.75	151558.0
2002-08-14 18:00:00	MSFT	Stock	24.905	24.95	24.9	24.95	25620.0
2002-08-14 08:00:00	NVDA	Stock	0.0751	0.0762	0.075	0.0758	1560000.0
2002-08-14 09:00:00	NVDA	Stock	0.0762	0.079	0.0758	0.0775	125797800.0
2002-08-14 10:00:00	NVDA	Stock	0.0776	0.0776	0.0758	0.0772	86408880.0
2002-08-14 11:00:00	NVDA	Stock	0.0772	0.0776	0.0762	0.0773	48211440.0
2002-08-14 12:00:00	NVDA	Stock	0.0773	0.0779	0.0767	0.0775	37019280.0
2002-08-14 13:00:00	NVDA	Stock	0.0775	0.0787	0.0769	0.0785	39698280.0
2002-08-14 14:00:00	NVDA	Stock	0.0784	0.0808	0.0783	0.0807	96855120.0
2002-08-14 15:00:00	NVDA	Stock	0.0806	0.0807	0.0787	0.0807	139184400.0
2002-08-14 16:00:00	NVDA	Stock	0.0807	0.0808	0.0781	0.0808	31755480.0
2002-08-14 17:00:00	NVDA	Stock	0.0797	0.0813	0.0797	0.0804	13536000.0
2002-08-14 18:00:00	NVDA	Stock	0.081	0.081	0.081	0.081	24000.0
2002-08-14 08:00:00	AMZN	Stock	0.6968	0.6971	0.695	0.695	157780.0
2002-08-14 09:00:00	AMZN	Stock	0.6965	0.699	0.67	0.671	18325840.0
2002-08-14 10:00:00	AMZN	Stock	0.672	0.676	0.666	0.672	29453300.0
2002-08-14 11:00:00	AMZN	Stock	0.672	0.6725	0.666	0.668	10176740.0
2002-08-14 12:00:00	AMZN	Stock	0.668	0.6735	0.666	0.672	6906580.0
2002-08-14 13:00:00	AMZN	Stock	0.6715	0.674	0.666	0.671	15251420.0
2002-08-14 14:00:00	AMZN	Stock	0.671	0.6975	0.671	0.6967	24752000.0
2002-08-14 15:00:00	AMZN	Stock	0.697	0.703	0.6885	0.6951	26081120.0
2002-08-14 16:00:00	AMZN	Stock	0.695	0.699	0.677	0.6935	2770000.0
2002-08-14 17:00:00	AMZN	Stock	0.6935	0.6958	0.6925	0.6958	210000.0
2002-08-14 09:00:00	CL	Stock	26.74	26.75	26.575	26.585	253400.0
2002-08-14 10:00:00	CL	Stock	26.585	26.6	26.3	26.55	393400.0
2002-08-14 11:00:00	CL	Stock	26.56	26.6	26.36	26.4	240000.0
2002-08-14 12:00:00	CL	Stock	26.4	26.55	26.375	26.51	196800.0
2002-08-14 13:00:00	CL	Stock	26.51	26.6	26.315	26.585	490400.0
2002-08-14 14:00:00	CL	Stock	26.585	26.82	26.53	26.775	468600.0
2002-08-14 15:00:00	CL	Stock	26.785	27.2	26.785	27.195	649000.0
2002-08-14 16:00:00	CL	Stock	27.195	27.21	27.195	27.21	67800.0

> showing 49 of 18,481 rows — these rows as CSV

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