PREVIEW / stock_1hour / 2002-10-04

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-10-04.parquet
  size:    405 KB
  rows:    19,384
  symbols: 1,482

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-10-04 08:00:00	AAPL	Stock	0.2539	0.2555	0.2539	0.2555	117600.0
2002-10-04 09:00:00	AAPL	Stock	0.2555	0.2571	0.253	0.2532	18391912.0
2002-10-04 10:00:00	AAPL	Stock	0.2534	0.2564	0.2511	0.2555	47066880.0
2002-10-04 11:00:00	AAPL	Stock	0.2555	0.2566	0.2529	0.2552	17249400.0
2002-10-04 12:00:00	AAPL	Stock	0.2554	0.2555	0.252	0.252	12612656.0
2002-10-04 13:00:00	AAPL	Stock	0.2518	0.2527	0.25	0.252	27008856.0
2002-10-04 14:00:00	AAPL	Stock	0.252	0.2534	0.25	0.253	23268560.0
2002-10-04 15:00:00	AAPL	Stock	0.253	0.2543	0.2502	0.2504	30888480.0
2002-10-04 16:00:00	AAPL	Stock	0.2505	0.2529	0.25	0.2505	4541600.0
2002-10-04 08:00:00	MSFT	Stock	22.3	22.6505	22.3	22.619	208394.0
2002-10-04 09:00:00	MSFT	Stock	22.599	22.785	22.395	22.47	16264802.0
2002-10-04 10:00:00	MSFT	Stock	22.4645	22.635	22.27	22.3995	21250956.0
2002-10-04 11:00:00	MSFT	Stock	22.4045	22.5	22.255	22.385	11316276.0
2002-10-04 12:00:00	MSFT	Stock	22.383	22.49	22.065	22.07	8216734.0
2002-10-04 13:00:00	MSFT	Stock	22.0693	22.105	21.845	22.037	11806728.0
2002-10-04 14:00:00	MSFT	Stock	22.037	22.34	21.949	22.325	15990366.0
2002-10-04 15:00:00	MSFT	Stock	22.335	22.5	21.88	21.88	18746070.0
2002-10-04 16:00:00	MSFT	Stock	21.885	22.1175	21.825	21.98	1701994.0
2002-10-04 17:00:00	MSFT	Stock	21.94	21.99	21.885	21.99	20468.0
2002-10-04 18:00:00	MSFT	Stock	21.975	21.975	21.935	21.95	5000.0
2002-10-04 08:00:00	NVDA	Stock	0.0723	0.0726	0.0723	0.0726	372000.0
2002-10-04 09:00:00	NVDA	Stock	0.0726	0.0735	0.0706	0.0708	91354680.0
2002-10-04 10:00:00	NVDA	Stock	0.0708	0.0709	0.0687	0.0699	101593560.0
2002-10-04 11:00:00	NVDA	Stock	0.0699	0.0701	0.0692	0.0695	36297600.0
2002-10-04 12:00:00	NVDA	Stock	0.0696	0.0698	0.0691	0.0691	31063320.0
2002-10-04 13:00:00	NVDA	Stock	0.069	0.0692	0.0667	0.0682	100738080.0
2002-10-04 14:00:00	NVDA	Stock	0.0681	0.069	0.0676	0.0688	51499440.0
2002-10-04 15:00:00	NVDA	Stock	0.0688	0.0708	0.0676	0.0678	93996000.0
2002-10-04 16:00:00	NVDA	Stock	0.0677	0.0682	0.0671	0.0676	4068960.0
2002-10-04 17:00:00	NVDA	Stock	0.0673	0.0676	0.0672	0.0675	816000.0
2002-10-04 18:00:00	NVDA	Stock	0.0675	0.0675	0.0673	0.0675	552000.0
2002-10-04 08:00:00	AMZN	Stock	0.838	0.851	0.838	0.8475	670380.0
2002-10-04 09:00:00	AMZN	Stock	0.8475	0.8545	0.841	0.8515	11980620.0
2002-10-04 10:00:00	AMZN	Stock	0.852	0.8575	0.8455	0.851	26692900.0
2002-10-04 11:00:00	AMZN	Stock	0.8515	0.853	0.8355	0.843	21531320.0
2002-10-04 12:00:00	AMZN	Stock	0.844	0.8475	0.8335	0.8365	19379840.0
2002-10-04 13:00:00	AMZN	Stock	0.836	0.8365	0.8205	0.8245	28951600.0
2002-10-04 14:00:00	AMZN	Stock	0.8245	0.838	0.819	0.837	21047380.0
2002-10-04 15:00:00	AMZN	Stock	0.837	0.846	0.8275	0.8295	18814780.0
2002-10-04 16:00:00	AMZN	Stock	0.83	0.8352	0.8275	0.832	2564720.0
2002-10-04 17:00:00	AMZN	Stock	0.833	0.833	0.8275	0.8275	20000.0
2002-10-04 18:00:00	AMZN	Stock	0.83	0.83	0.83	0.83	2000.0
2002-10-04 09:00:00	CL	Stock	27.15	27.275	27.15	27.26	491000.0
2002-10-04 10:00:00	CL	Stock	27.25	27.325	27.0	27.005	492000.0
2002-10-04 11:00:00	CL	Stock	27.005	27.085	26.925	26.96	469800.0
2002-10-04 12:00:00	CL	Stock	26.96	27.05	26.9	27.0	283800.0
2002-10-04 13:00:00	CL	Stock	27.0	27.005	26.73	26.825	317000.0
2002-10-04 14:00:00	CL	Stock	26.825	27.175	26.8	27.17	494200.0
2002-10-04 15:00:00	CL	Stock	27.2	27.23	27.03	27.085	633400.0
2002-10-04 16:00:00	CL	Stock	27.08	27.085	27.08	27.085	78400.0

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

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