PREVIEW / stock_1hour / 2002-05-07

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-05-07.parquet
  size:    413 KB
  rows:    19,178
  symbols: 1,409

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-05-07 08:00:00	AAPL	Stock	0.4	0.4046	0.4	0.4046	504000.0
2002-05-07 09:00:00	AAPL	Stock	0.4071	0.4107	0.4045	0.4046	21145600.0
2002-05-07 10:00:00	AAPL	Stock	0.4046	0.408	0.3954	0.4071	78344000.0
2002-05-07 11:00:00	AAPL	Stock	0.4068	0.4073	0.4	0.4066	25911200.0
2002-05-07 12:00:00	AAPL	Stock	0.4066	0.4091	0.4064	0.4079	31931200.0
2002-05-07 13:00:00	AAPL	Stock	0.4079	0.4086	0.4041	0.4073	21862400.0
2002-05-07 14:00:00	AAPL	Stock	0.4073	0.408	0.4032	0.4052	22876000.0
2002-05-07 15:00:00	AAPL	Stock	0.4048	0.4071	0.4009	0.4014	29002400.0
2002-05-07 16:00:00	AAPL	Stock	0.4013	0.4068	0.4007	0.4068	10320800.0
2002-05-07 17:00:00	AAPL	Stock	0.4066	0.4071	0.4013	0.4061	39200.0
2002-05-07 18:00:00	AAPL	Stock	0.4036	0.4079	0.4036	0.4079	33600.0
2002-05-07 08:00:00	MSFT	Stock	24.225	24.53	24.185	24.53	302000.0
2002-05-07 09:00:00	MSFT	Stock	24.525	24.65	24.4	24.4545	11649000.0
2002-05-07 10:00:00	MSFT	Stock	24.455	24.865	24.1765	24.62	17273200.0
2002-05-07 11:00:00	MSFT	Stock	24.615	24.775	24.559	24.73	10749200.0
2002-05-07 12:00:00	MSFT	Stock	24.73	25.06	24.73	24.945	10142600.0
2002-05-07 13:00:00	MSFT	Stock	24.95	25.04	24.85	24.96	7315600.0
2002-05-07 14:00:00	MSFT	Stock	24.962	25.11	24.849	25.055	12808000.0
2002-05-07 15:00:00	MSFT	Stock	25.055	25.145	24.605	24.74	13387600.0
2002-05-07 16:00:00	MSFT	Stock	24.735	25.1	24.31	25.095	2487200.0
2002-05-07 17:00:00	MSFT	Stock	25.095	25.465	24.735	25.4	294800.0
2002-05-07 18:00:00	MSFT	Stock	25.4	25.435	25.325	25.365	39800.0
2002-05-07 08:00:00	NVDA	Stock	0.2625	0.275	0.2622	0.2675	1872000.0
2002-05-07 09:00:00	NVDA	Stock	0.2671	0.2699	0.2593	0.2602	125376000.0
2002-05-07 10:00:00	NVDA	Stock	0.2604	0.2688	0.2559	0.2678	374556000.0
2002-05-07 11:00:00	NVDA	Stock	0.268	0.2692	0.265	0.2686	196176000.0
2002-05-07 12:00:00	NVDA	Stock	0.2687	0.2739	0.2687	0.2708	168660000.0
2002-05-07 13:00:00	NVDA	Stock	0.2712	0.2727	0.2665	0.2691	131328000.0
2002-05-07 14:00:00	NVDA	Stock	0.269	0.2733	0.2655	0.2717	201708000.0
2002-05-07 15:00:00	NVDA	Stock	0.2715	0.2727	0.2675	0.2691	174000000.0
2002-05-07 16:00:00	NVDA	Stock	0.2692	0.274	0.2672	0.274	26208000.0
2002-05-07 17:00:00	NVDA	Stock	0.2738	0.2792	0.2691	0.2771	1644000.0
2002-05-07 18:00:00	NVDA	Stock	0.2789	0.2812	0.2783	0.2812	1956000.0
2002-05-07 08:00:00	AMZN	Stock	0.806	0.806	0.8055	0.806	38000.0
2002-05-07 09:00:00	AMZN	Stock	0.81	0.825	0.804	0.8055	9968000.0
2002-05-07 10:00:00	AMZN	Stock	0.8055	0.808	0.8016	0.8075	28690000.0
2002-05-07 11:00:00	AMZN	Stock	0.807	0.8075	0.803	0.805	11074000.0
2002-05-07 12:00:00	AMZN	Stock	0.8045	0.8105	0.8035	0.8085	11684000.0
2002-05-07 13:00:00	AMZN	Stock	0.8075	0.8125	0.8075	0.8115	5442000.0
2002-05-07 14:00:00	AMZN	Stock	0.8111	0.8175	0.81	0.813	10510000.0
2002-05-07 15:00:00	AMZN	Stock	0.8125	0.813	0.805	0.8055	21162000.0
2002-05-07 16:00:00	AMZN	Stock	0.805	0.8115	0.804	0.811	5708000.0
2002-05-07 17:00:00	AMZN	Stock	0.8125	0.8145	0.8055	0.8105	192000.0
2002-05-07 18:00:00	AMZN	Stock	0.8145	0.815	0.8115	0.815	100000.0
2002-05-07 09:00:00	CL	Stock	27.7	27.7	27.455	27.545	415200.0
2002-05-07 10:00:00	CL	Stock	27.54	27.655	27.515	27.655	351400.0
2002-05-07 11:00:00	CL	Stock	27.65	27.875	27.63	27.7	606400.0
2002-05-07 12:00:00	CL	Stock	27.705	27.755	27.61	27.615	295800.0
2002-05-07 13:00:00	CL	Stock	27.615	27.66	27.55	27.59	418000.0
2002-05-07 14:00:00	CL	Stock	27.565	27.6	27.5	27.52	445000.0

> showing 50 of 19,178 rows — these rows as CSV

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