PREVIEW / stock_1hour / 2002-09-16

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-09-16.parquet
  size:    378 KB
  rows:    18,351
  symbols: 1,468

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-09-16 08:00:00	AAPL	Stock	0.2518	0.2518	0.2518	0.2518	11200.0
2002-09-16 09:00:00	AAPL	Stock	0.2541	0.2561	0.2521	0.2557	35140336.0
2002-09-16 10:00:00	AAPL	Stock	0.2555	0.2566	0.2532	0.2541	67317432.0
2002-09-16 11:00:00	AAPL	Stock	0.2541	0.2563	0.2532	0.2557	33278168.0
2002-09-16 12:00:00	AAPL	Stock	0.2557	0.2588	0.2557	0.258	36667512.0
2002-09-16 13:00:00	AAPL	Stock	0.2582	0.2593	0.2571	0.2588	16265536.0
2002-09-16 14:00:00	AAPL	Stock	0.2586	0.2595	0.2582	0.2589	18816560.0
2002-09-16 15:00:00	AAPL	Stock	0.2589	0.2609	0.2568	0.2588	53464992.0
2002-09-16 16:00:00	AAPL	Stock	0.2588	0.2596	0.2579	0.2589	3533600.0
2002-09-16 17:00:00	AAPL	Stock	0.2589	0.2589	0.2589	0.2589	78400.0
2002-09-16 08:00:00	MSFT	Stock	24.0	24.05	23.905	23.905	61628.0
2002-09-16 09:00:00	MSFT	Stock	23.905	24.065	23.74	23.8745	5785976.0
2002-09-16 10:00:00	MSFT	Stock	23.865	23.9	23.575	23.61	10823194.0
2002-09-16 11:00:00	MSFT	Stock	23.61	23.685	23.525	23.6	5246264.0
2002-09-16 12:00:00	MSFT	Stock	23.595	23.8	23.5935	23.665	4518112.0
2002-09-16 13:00:00	MSFT	Stock	23.66	23.87	23.639	23.775	4172304.0
2002-09-16 14:00:00	MSFT	Stock	23.775	23.785	23.56	23.72	5284872.0
2002-09-16 15:00:00	MSFT	Stock	23.72	23.925	23.675	23.89	8080078.0
2002-09-16 16:00:00	MSFT	Stock	23.89	24.0	23.74	23.825	2078816.0
2002-09-16 17:00:00	MSFT	Stock	23.865	23.925	23.7118	23.7574	369000.0
2002-09-16 18:00:00	MSFT	Stock	23.87	23.925	23.845	23.925	7000.0
2002-09-16 08:00:00	NVDA	Stock	0.0883	0.0887	0.0873	0.0873	1325520.0
2002-09-16 09:00:00	NVDA	Stock	0.0872	0.0881	0.0842	0.0842	141630600.0
2002-09-16 10:00:00	NVDA	Stock	0.0843	0.0844	0.0804	0.0812	231491520.0
2002-09-16 11:00:00	NVDA	Stock	0.0812	0.0824	0.0807	0.0815	141886800.0
2002-09-16 12:00:00	NVDA	Stock	0.0816	0.0828	0.0814	0.082	58061880.0
2002-09-16 13:00:00	NVDA	Stock	0.0822	0.0835	0.0817	0.0829	61464840.0
2002-09-16 14:00:00	NVDA	Stock	0.0828	0.0832	0.082	0.0825	57562560.0
2002-09-16 15:00:00	NVDA	Stock	0.0825	0.0839	0.0815	0.0828	178548600.0
2002-09-16 16:00:00	NVDA	Stock	0.0827	0.0828	0.0822	0.0825	12006480.0
2002-09-16 17:00:00	NVDA	Stock	0.0823	0.0829	0.0821	0.0829	3635520.0
2002-09-16 18:00:00	NVDA	Stock	0.0829	0.0829	0.0825	0.0825	132000.0
2002-09-16 08:00:00	AMZN	Stock	0.83	0.83	0.825	0.825	18000.0
2002-09-16 09:00:00	AMZN	Stock	0.83	0.841	0.8225	0.8375	8211600.0
2002-09-16 10:00:00	AMZN	Stock	0.837	0.8375	0.824	0.831	11312720.0
2002-09-16 11:00:00	AMZN	Stock	0.8315	0.8405	0.8275	0.835	8059160.0
2002-09-16 12:00:00	AMZN	Stock	0.8355	0.846	0.8355	0.8405	9333100.0
2002-09-16 13:00:00	AMZN	Stock	0.8405	0.844	0.837	0.841	4386680.0
2002-09-16 14:00:00	AMZN	Stock	0.8415	0.8425	0.8364	0.837	4149860.0
2002-09-16 15:00:00	AMZN	Stock	0.837	0.8465	0.833	0.839	10239700.0
2002-09-16 16:00:00	AMZN	Stock	0.836	0.839	0.834	0.835	1576000.0
2002-09-16 17:00:00	AMZN	Stock	0.8375	0.8375	0.8355	0.8355	420000.0
2002-09-16 09:00:00	CL	Stock	27.875	27.94	27.71	27.75	270600.0
2002-09-16 10:00:00	CL	Stock	27.745	27.745	27.525	27.57	378800.0
2002-09-16 11:00:00	CL	Stock	27.57	27.765	27.535	27.73	375000.0
2002-09-16 12:00:00	CL	Stock	27.73	27.825	27.715	27.715	146000.0
2002-09-16 13:00:00	CL	Stock	27.71	27.995	27.71	27.95	243600.0
2002-09-16 14:00:00	CL	Stock	27.95	28.0	27.75	27.845	431800.0
2002-09-16 15:00:00	CL	Stock	27.85	28.1	27.79	27.985	722800.0
2002-09-16 16:00:00	CL	Stock	27.98	28.03	27.98	28.03	124000.0

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

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