PREVIEW / stock_1hour / 2003-01-27

all stock 1-hour files

  file:    by_date/stock_1hour/2003/2003-01-27.parquet
  size:    434 KB
  rows:    20,479
  symbols: 1,548

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
2003-01-27 08:00:00	AAPL	Stock	0.2464	0.2464	0.2429	0.2429	151200.0
2003-01-27 09:00:00	AAPL	Stock	0.2432	0.253	0.243	0.253	44569224.0
2003-01-27 10:00:00	AAPL	Stock	0.2532	0.2541	0.2498	0.2534	56904064.0
2003-01-27 11:00:00	AAPL	Stock	0.2534	0.2563	0.2531	0.2563	61923904.0
2003-01-27 12:00:00	AAPL	Stock	0.2563	0.2589	0.255	0.2561	56527296.0
2003-01-27 13:00:00	AAPL	Stock	0.2561	0.2561	0.2523	0.2541	31874640.0
2003-01-27 14:00:00	AAPL	Stock	0.2541	0.2545	0.2509	0.2518	34875904.0
2003-01-27 15:00:00	AAPL	Stock	0.2518	0.2548	0.2509	0.2523	58115792.0
2003-01-27 16:00:00	AAPL	Stock	0.2527	0.2552	0.2521	0.253	10410400.0
2003-01-27 17:00:00	AAPL	Stock	0.253	0.2534	0.2524	0.2534	1948800.0
2003-01-27 18:00:00	AAPL	Stock	0.2525	0.2525	0.2525	0.2525	5600.0
2003-01-27 08:00:00	MSFT	Stock	24.575	24.875	24.35	24.42	572194.0
2003-01-27 09:00:00	MSFT	Stock	24.41	25.12	24.38	25.09	16278072.0
2003-01-27 10:00:00	MSFT	Stock	25.09	25.3	24.695	24.8245	20062428.0
2003-01-27 11:00:00	MSFT	Stock	24.825	24.855	24.315	24.3905	16573278.0
2003-01-27 12:00:00	MSFT	Stock	24.39	24.5	24.32	24.385	11772900.0
2003-01-27 13:00:00	MSFT	Stock	24.385	24.55	24.25	24.3005	11385560.0
2003-01-27 14:00:00	MSFT	Stock	24.3	24.38	24.205	24.295	8837734.0
2003-01-27 15:00:00	MSFT	Stock	24.2955	24.67	24.26	24.585	16743342.0
2003-01-27 16:00:00	MSFT	Stock	24.59	24.675	24.4545	24.64	1658080.0
2003-01-27 17:00:00	MSFT	Stock	24.645	24.66	24.4849	24.63	22010.0
2003-01-27 18:00:00	MSFT	Stock	24.63	24.63	24.62	24.625	7000.0
2003-01-27 08:00:00	NVDA	Stock	0.0829	0.0841	0.0812	0.0817	5765160.0
2003-01-27 09:00:00	NVDA	Stock	0.082	0.0856	0.0808	0.0856	169431240.0
2003-01-27 10:00:00	NVDA	Stock	0.0857	0.0872	0.0844	0.0851	138845400.0
2003-01-27 11:00:00	NVDA	Stock	0.0848	0.0853	0.0819	0.0826	110225880.0
2003-01-27 12:00:00	NVDA	Stock	0.0826	0.0833	0.082	0.0831	132191760.0
2003-01-27 13:00:00	NVDA	Stock	0.0832	0.0838	0.0823	0.0831	69422040.0
2003-01-27 14:00:00	NVDA	Stock	0.0831	0.0832	0.0824	0.0826	49019040.0
2003-01-27 15:00:00	NVDA	Stock	0.0825	0.0837	0.0823	0.0835	149236320.0
2003-01-27 16:00:00	NVDA	Stock	0.0834	0.0841	0.083	0.0835	14613600.0
2003-01-27 17:00:00	NVDA	Stock	0.0834	0.0835	0.0834	0.0835	1260000.0
2003-01-27 18:00:00	NVDA	Stock	0.0834	0.0834	0.0833	0.0833	122400.0
2003-01-27 08:00:00	AMZN	Stock	1.09	1.09	1.0665	1.0756	293500.0
2003-01-27 09:00:00	AMZN	Stock	1.08	1.1085	1.0655	1.108	21362120.0
2003-01-27 10:00:00	AMZN	Stock	1.107	1.1185	1.091	1.098	30723940.0
2003-01-27 11:00:00	AMZN	Stock	1.098	1.1025	1.084	1.087	17678080.0
2003-01-27 12:00:00	AMZN	Stock	1.0865	1.1125	1.0835	1.1075	20723080.0
2003-01-27 13:00:00	AMZN	Stock	1.107	1.111	1.1005	1.105	14050280.0
2003-01-27 14:00:00	AMZN	Stock	1.1051	1.106	1.091	1.093	16099480.0
2003-01-27 15:00:00	AMZN	Stock	1.093	1.0965	1.088	1.0885	24958580.0
2003-01-27 16:00:00	AMZN	Stock	1.089	1.095	1.088	1.0925	1971260.0
2003-01-27 17:00:00	AMZN	Stock	1.096	1.0965	1.089	1.096	812000.0
2003-01-27 18:00:00	AMZN	Stock	1.0925	1.0925	1.0925	1.0925	8000.0
2003-01-27 09:00:00	CL	Stock	25.775	25.78	25.33	25.525	561400.0
2003-01-27 10:00:00	CL	Stock	25.55	25.65	25.355	25.5	839800.0
2003-01-27 11:00:00	CL	Stock	25.5	25.5	25.205	25.31	651600.0
2003-01-27 12:00:00	CL	Stock	25.3	25.43	25.27	25.355	408600.0
2003-01-27 13:00:00	CL	Stock	25.355	25.45	25.3	25.435	220200.0
2003-01-27 14:00:00	CL	Stock	25.43	25.445	25.335	25.37	284800.0

> showing 50 of 20,479 rows — these rows as CSV

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