PREVIEW / stock_1hour / 2002-08-13

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-08-13.parquet
  size:    393 KB
  rows:    18,562
  symbols: 1,458

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-13 08:00:00	AAPL	Stock	0.2618	0.2618	0.2618	0.2618	56000.0
2002-08-13 09:00:00	AAPL	Stock	0.2677	0.2677	0.2634	0.2648	16645608.0
2002-08-13 10:00:00	AAPL	Stock	0.265	0.2716	0.2643	0.2704	30154824.0
2002-08-13 11:00:00	AAPL	Stock	0.2709	0.2714	0.2666	0.2666	42735672.0
2002-08-13 12:00:00	AAPL	Stock	0.2664	0.2674	0.2643	0.2654	22534960.0
2002-08-13 13:00:00	AAPL	Stock	0.2654	0.2677	0.2634	0.2655	18013688.0
2002-08-13 14:00:00	AAPL	Stock	0.2657	0.2696	0.2623	0.265	50897728.0
2002-08-13 15:00:00	AAPL	Stock	0.2648	0.2661	0.2598	0.2616	66652320.0
2002-08-13 16:00:00	AAPL	Stock	0.2609	0.2609	0.2598	0.2605	6736800.0
2002-08-13 17:00:00	AAPL	Stock	0.2605	0.2605	0.2591	0.2605	128800.0
2002-08-13 08:00:00	MSFT	Stock	24.075	24.3	23.845	24.045	115280.0
2002-08-13 09:00:00	MSFT	Stock	24.035	24.36	23.945	24.265	9783712.0
2002-08-13 10:00:00	MSFT	Stock	24.265	24.68	24.25	24.635	12457134.0
2002-08-13 11:00:00	MSFT	Stock	24.6395	24.745	24.575	24.69	10236234.0
2002-08-13 12:00:00	MSFT	Stock	24.695	24.715	24.6	24.69	6820904.0
2002-08-13 13:00:00	MSFT	Stock	24.685	24.7	24.56	24.655	6903278.0
2002-08-13 14:00:00	MSFT	Stock	24.655	24.85	24.085	24.265	22612450.0
2002-08-13 15:00:00	MSFT	Stock	24.26	24.435	23.46	23.5	25966248.0
2002-08-13 16:00:00	MSFT	Stock	23.5	24.07	23.4515	23.55	1953060.0
2002-08-13 17:00:00	MSFT	Stock	23.545	23.545	23.475	23.485	37800.0
2002-08-13 18:00:00	MSFT	Stock	23.465	23.47	23.43	23.43	23308.0
2002-08-13 08:00:00	NVDA	Stock	0.0771	0.0771	0.0762	0.0767	3054000.0
2002-08-13 09:00:00	NVDA	Stock	0.0775	0.08	0.076	0.0788	118154400.0
2002-08-13 10:00:00	NVDA	Stock	0.0789	0.0809	0.0783	0.0806	108402240.0
2002-08-13 11:00:00	NVDA	Stock	0.0807	0.0808	0.0788	0.0794	73216440.0
2002-08-13 12:00:00	NVDA	Stock	0.0795	0.0796	0.0786	0.0792	44940600.0
2002-08-13 13:00:00	NVDA	Stock	0.0792	0.0792	0.0776	0.0782	51211680.0
2002-08-13 14:00:00	NVDA	Stock	0.0782	0.0793	0.0767	0.0775	107617440.0
2002-08-13 15:00:00	NVDA	Stock	0.0773	0.0779	0.075	0.0752	121225080.0
2002-08-13 16:00:00	NVDA	Stock	0.0751	0.0757	0.075	0.0757	7695960.0
2002-08-13 17:00:00	NVDA	Stock	0.0758	0.0758	0.075	0.075	1434000.0
2002-08-13 18:00:00	NVDA	Stock	0.0756	0.0757	0.0756	0.0757	240000.0
2002-08-13 08:00:00	AMZN	Stock	0.7155	0.721	0.7155	0.721	8000.0
2002-08-13 09:00:00	AMZN	Stock	0.7215	0.7275	0.712	0.7225	8154840.0
2002-08-13 10:00:00	AMZN	Stock	0.7215	0.7335	0.718	0.721	15985400.0
2002-08-13 11:00:00	AMZN	Stock	0.7205	0.723	0.715	0.7175	9617080.0
2002-08-13 12:00:00	AMZN	Stock	0.7175	0.725	0.717	0.7175	10148000.0
2002-08-13 13:00:00	AMZN	Stock	0.718	0.7205	0.709	0.7095	12046300.0
2002-08-13 14:00:00	AMZN	Stock	0.7095	0.715	0.6955	0.7	21311800.0
2002-08-13 15:00:00	AMZN	Stock	0.6995	0.706	0.6955	0.697	19381960.0
2002-08-13 16:00:00	AMZN	Stock	0.6965	0.698	0.695	0.6975	2496760.0
2002-08-13 17:00:00	AMZN	Stock	0.6965	0.6965	0.6965	0.6965	420000.0
2002-08-13 18:00:00	AMZN	Stock	0.6955	0.6955	0.6955	0.6955	8000.0
2002-08-13 09:00:00	CL	Stock	26.5	26.595	26.4	26.425	618800.0
2002-08-13 10:00:00	CL	Stock	26.4	26.73	26.4	26.73	627800.0
2002-08-13 11:00:00	CL	Stock	26.73	26.95	26.73	26.855	503600.0
2002-08-13 12:00:00	CL	Stock	26.86	26.985	26.825	26.97	261600.0
2002-08-13 13:00:00	CL	Stock	26.96	27.075	26.94	27.075	223000.0
2002-08-13 14:00:00	CL	Stock	27.075	27.105	26.79	26.865	414600.0
2002-08-13 15:00:00	CL	Stock	26.875	27.0	26.61	26.615	1018800.0

> showing 50 of 18,562 rows — these rows as CSV

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