PREVIEW / stock_1hour / 2002-10-14

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-10-14.parquet
  size:    389 KB
  rows:    18,680
  symbols: 1,476

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-14 09:00:00	AAPL	Stock	0.258	0.2646	0.2579	0.2639	21661024.0
2002-10-14 10:00:00	AAPL	Stock	0.2638	0.2675	0.2616	0.2645	44693768.0
2002-10-14 11:00:00	AAPL	Stock	0.2645	0.2657	0.2643	0.2643	15230824.0
2002-10-14 12:00:00	AAPL	Stock	0.2641	0.2659	0.262	0.2645	31234560.0
2002-10-14 13:00:00	AAPL	Stock	0.2645	0.2646	0.2616	0.262	10229520.0
2002-10-14 14:00:00	AAPL	Stock	0.2621	0.2627	0.2609	0.2623	20850648.0
2002-10-14 15:00:00	AAPL	Stock	0.2625	0.2652	0.2625	0.2638	37821840.0
2002-10-14 16:00:00	AAPL	Stock	0.2639	0.2639	0.263	0.2639	5264000.0
2002-10-14 17:00:00	AAPL	Stock	0.2638	0.2638	0.2638	0.2638	3343200.0
2002-10-14 08:00:00	MSFT	Stock	24.2	24.445	24.03	24.15	123316.0
2002-10-14 09:00:00	MSFT	Stock	24.125	24.44	23.92	24.225	13004572.0
2002-10-14 10:00:00	MSFT	Stock	24.225	24.265	23.945	23.965	13694790.0
2002-10-14 11:00:00	MSFT	Stock	23.975	24.43	23.955	24.365	8528502.0
2002-10-14 12:00:00	MSFT	Stock	24.37	24.6138	24.325	24.46	9170786.0
2002-10-14 13:00:00	MSFT	Stock	24.46	24.49	24.285	24.375	6617420.0
2002-10-14 14:00:00	MSFT	Stock	24.385	24.525	24.3	24.33	7652770.0
2002-10-14 15:00:00	MSFT	Stock	24.33	24.665	24.33	24.645	12880438.0
2002-10-14 16:00:00	MSFT	Stock	24.65	24.665	24.323	24.615	2131600.0
2002-10-14 17:00:00	MSFT	Stock	24.625	24.69	24.625	24.645	531724.0
2002-10-14 18:00:00	MSFT	Stock	24.645	24.65	24.625	24.645	12800.0
2002-10-14 08:00:00	NVDA	Stock	0.0726	0.0726	0.0703	0.0703	213000.0
2002-10-14 09:00:00	NVDA	Stock	0.0717	0.0727	0.0698	0.0718	124217160.0
2002-10-14 10:00:00	NVDA	Stock	0.0718	0.0723	0.0701	0.0706	100184160.0
2002-10-14 11:00:00	NVDA	Stock	0.0705	0.0717	0.0705	0.0716	64885320.0
2002-10-14 12:00:00	NVDA	Stock	0.0714	0.0734	0.0707	0.0722	86738640.0
2002-10-14 13:00:00	NVDA	Stock	0.0723	0.0725	0.0712	0.0715	48585960.0
2002-10-14 14:00:00	NVDA	Stock	0.0715	0.0717	0.0697	0.0699	87392280.0
2002-10-14 15:00:00	NVDA	Stock	0.0701	0.0714	0.0699	0.0711	81627840.0
2002-10-14 16:00:00	NVDA	Stock	0.0711	0.0721	0.0708	0.0714	11053800.0
2002-10-14 17:00:00	NVDA	Stock	0.0712	0.0715	0.071	0.0714	4068000.0
2002-10-14 18:00:00	NVDA	Stock	0.0716	0.0717	0.0716	0.0717	120000.0
2002-10-14 09:00:00	AMZN	Stock	0.9125	0.9395	0.909	0.936	17275940.0
2002-10-14 10:00:00	AMZN	Stock	0.936	0.9415	0.93	0.9355	32729880.0
2002-10-14 11:00:00	AMZN	Stock	0.935	0.94	0.9325	0.9385	17191300.0
2002-10-14 12:00:00	AMZN	Stock	0.9384	0.9545	0.9365	0.9505	35556620.0
2002-10-14 13:00:00	AMZN	Stock	0.9505	0.9575	0.944	0.9485	32875380.0
2002-10-14 14:00:00	AMZN	Stock	0.9485	0.95	0.9355	0.939	19562460.0
2002-10-14 15:00:00	AMZN	Stock	0.939	0.9615	0.9365	0.9585	33927700.0
2002-10-14 16:00:00	AMZN	Stock	0.959	0.962	0.9363	0.9605	3683140.0
2002-10-14 17:00:00	AMZN	Stock	0.96	0.96	0.959	0.959	1460200.0
2002-10-14 18:00:00	AMZN	Stock	0.959	0.959	0.959	0.959	9000.0
2002-10-14 09:00:00	CL	Stock	27.95	28.325	27.95	28.27	357600.0
2002-10-14 10:00:00	CL	Stock	28.275	28.275	27.96	28.005	499800.0
2002-10-14 11:00:00	CL	Stock	28.0	28.075	27.975	28.07	468600.0
2002-10-14 12:00:00	CL	Stock	28.065	28.115	27.97	28.115	474200.0
2002-10-14 13:00:00	CL	Stock	28.12	28.425	28.09	28.38	655000.0
2002-10-14 14:00:00	CL	Stock	28.375	28.425	28.255	28.275	550400.0
2002-10-14 15:00:00	CL	Stock	28.275	28.5	28.275	28.49	785400.0
2002-10-14 16:00:00	CL	Stock	28.49	28.5	28.465	28.465	65400.0

> showing 49 of 18,680 rows — these rows as CSV

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