PREVIEW / stock_1hour / 2002-08-07

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-08-07.parquet
  size:    393 KB
  rows:    18,447
  symbols: 1,457

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-07 08:00:00	AAPL	Stock	0.2679	0.2679	0.2632	0.2632	621600.0
2002-08-07 09:00:00	AAPL	Stock	0.2681	0.2721	0.2607	0.2639	37946720.0
2002-08-07 10:00:00	AAPL	Stock	0.2641	0.265	0.2591	0.2596	38227392.0
2002-08-07 11:00:00	AAPL	Stock	0.2596	0.2623	0.2563	0.2614	38494568.0
2002-08-07 12:00:00	AAPL	Stock	0.2617	0.263	0.2605	0.263	29910440.0
2002-08-07 13:00:00	AAPL	Stock	0.263	0.2634	0.258	0.2598	24596880.0
2002-08-07 14:00:00	AAPL	Stock	0.2588	0.2661	0.2571	0.2648	31296440.0
2002-08-07 15:00:00	AAPL	Stock	0.2648	0.2743	0.2621	0.2679	109754120.0
2002-08-07 16:00:00	AAPL	Stock	0.2679	0.2688	0.2654	0.2664	9088240.0
2002-08-07 17:00:00	AAPL	Stock	0.2664	0.2686	0.2664	0.2686	2032800.0
2002-08-07 08:00:00	MSFT	Stock	23.275	23.5	23.13	23.49	318064.0
2002-08-07 09:00:00	MSFT	Stock	23.49	23.65	22.93	23.045	13500424.0
2002-08-07 10:00:00	MSFT	Stock	23.06	23.3365	22.98	23.1	14052670.0
2002-08-07 11:00:00	MSFT	Stock	23.1	23.145	22.76	23.05	10093016.0
2002-08-07 12:00:00	MSFT	Stock	23.035	23.055	22.835	22.975	5198530.0
2002-08-07 13:00:00	MSFT	Stock	22.98	22.995	22.66	22.765	7640956.0
2002-08-07 14:00:00	MSFT	Stock	22.765	23.34	22.58	23.24	12320372.0
2002-08-07 15:00:00	MSFT	Stock	23.23	23.6	23.2	23.525	20947320.0
2002-08-07 16:00:00	MSFT	Stock	23.53	23.59	23.11	23.59	1287258.0
2002-08-07 17:00:00	MSFT	Stock	23.57	23.625	23.545	23.58	233626.0
2002-08-07 18:00:00	MSFT	Stock	23.575	23.575	23.565	23.565	6030.0
2002-08-07 08:00:00	NVDA	Stock	0.0757	0.0803	0.0757	0.0793	4118880.0
2002-08-07 09:00:00	NVDA	Stock	0.0792	0.0795	0.0772	0.0781	144138120.0
2002-08-07 10:00:00	NVDA	Stock	0.078	0.0785	0.0757	0.0764	148383600.0
2002-08-07 11:00:00	NVDA	Stock	0.0765	0.0767	0.0758	0.0759	88129680.0
2002-08-07 12:00:00	NVDA	Stock	0.0759	0.0762	0.0737	0.0738	79953120.0
2002-08-07 13:00:00	NVDA	Stock	0.0738	0.0738	0.0714	0.0728	121784400.0
2002-08-07 14:00:00	NVDA	Stock	0.0728	0.0754	0.0723	0.0748	107098080.0
2002-08-07 15:00:00	NVDA	Stock	0.0747	0.076	0.0736	0.0736	153636600.0
2002-08-07 16:00:00	NVDA	Stock	0.0736	0.0746	0.0732	0.0737	34006080.0
2002-08-07 17:00:00	NVDA	Stock	0.0731	0.0738	0.0731	0.0737	1533600.0
2002-08-07 18:00:00	NVDA	Stock	0.0739	0.0739	0.0734	0.0734	156000.0
2002-08-07 08:00:00	AMZN	Stock	0.692	0.6999	0.692	0.696	219000.0
2002-08-07 09:00:00	AMZN	Stock	0.696	0.6975	0.6665	0.674	15602200.0
2002-08-07 10:00:00	AMZN	Stock	0.674	0.676	0.659	0.6605	18346480.0
2002-08-07 11:00:00	AMZN	Stock	0.66	0.664	0.6505	0.6585	17001380.0
2002-08-07 12:00:00	AMZN	Stock	0.6585	0.663	0.6555	0.6575	9670000.0
2002-08-07 13:00:00	AMZN	Stock	0.6575	0.658	0.647	0.647	7891660.0
2002-08-07 14:00:00	AMZN	Stock	0.647	0.663	0.6425	0.658	17675160.0
2002-08-07 15:00:00	AMZN	Stock	0.6575	0.679	0.655	0.676	20167280.0
2002-08-07 16:00:00	AMZN	Stock	0.676	0.68	0.671	0.68	1177600.0
2002-08-07 17:00:00	AMZN	Stock	0.6745	0.68	0.673	0.68	298000.0
2002-08-07 09:00:00	CL	Stock	25.83	26.05	25.805	25.83	732400.0
2002-08-07 10:00:00	CL	Stock	25.83	25.96	25.775	25.88	940600.0
2002-08-07 11:00:00	CL	Stock	25.875	26.0	25.76	25.9	576800.0
2002-08-07 12:00:00	CL	Stock	25.9	25.995	25.85	25.97	419200.0
2002-08-07 13:00:00	CL	Stock	25.97	26.02	25.9	25.985	746800.0
2002-08-07 14:00:00	CL	Stock	25.975	25.995	25.865	25.95	379600.0
2002-08-07 15:00:00	CL	Stock	25.955	26.225	25.925	26.21	861600.0
2002-08-07 16:00:00	CL	Stock	26.21	26.25	26.21	26.25	103400.0

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

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