PREVIEW / stock_1hour / 2002-09-25

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-09-25.parquet
  size:    390 KB
  rows:    18,961
  symbols: 1,488

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-25 08:00:00	AAPL	Stock	0.2625	0.2625	0.2607	0.2625	425600.0
2002-09-25 09:00:00	AAPL	Stock	0.2589	0.2645	0.2589	0.2645	28345464.0
2002-09-25 10:00:00	AAPL	Stock	0.2641	0.2643	0.262	0.2636	37955680.0
2002-09-25 11:00:00	AAPL	Stock	0.2638	0.2654	0.2618	0.2652	20775776.0
2002-09-25 12:00:00	AAPL	Stock	0.265	0.2663	0.2634	0.265	22687504.0
2002-09-25 13:00:00	AAPL	Stock	0.2652	0.2709	0.2645	0.2688	44254448.0
2002-09-25 14:00:00	AAPL	Stock	0.2688	0.27	0.2661	0.2664	27088376.0
2002-09-25 15:00:00	AAPL	Stock	0.2664	0.2679	0.2634	0.2666	47072256.0
2002-09-25 16:00:00	AAPL	Stock	0.2666	0.267	0.2661	0.2666	11707136.0
2002-09-25 17:00:00	AAPL	Stock	0.2668	0.2668	0.2666	0.2668	224000.0
2002-09-25 08:00:00	MSFT	Stock	23.06	23.3	22.82	23.2	222480.0
2002-09-25 09:00:00	MSFT	Stock	23.2	23.36	22.745	22.845	13797164.0
2002-09-25 10:00:00	MSFT	Stock	22.855	22.905	22.53	22.62	18720994.0
2002-09-25 11:00:00	MSFT	Stock	22.6265	22.8845	22.55	22.715	12871978.0
2002-09-25 12:00:00	MSFT	Stock	22.7105	22.985	22.695	22.87	8918610.0
2002-09-25 13:00:00	MSFT	Stock	22.865	23.27	22.81	23.16	15311872.0
2002-09-25 14:00:00	MSFT	Stock	23.17	23.425	23.125	23.19	14877930.0
2002-09-25 15:00:00	MSFT	Stock	23.19	23.483	23.065	23.255	17726648.0
2002-09-25 16:00:00	MSFT	Stock	23.26	23.415	23.235	23.35	2209306.0
2002-09-25 17:00:00	MSFT	Stock	23.345	23.375	23.255	23.375	70200.0
2002-09-25 18:00:00	MSFT	Stock	23.38	23.4	23.275	23.4	11000.0
2002-09-25 08:00:00	NVDA	Stock	0.0775	0.08	0.0756	0.0795	7305600.0
2002-09-25 09:00:00	NVDA	Stock	0.0792	0.0801	0.074	0.0762	156953040.0
2002-09-25 10:00:00	NVDA	Stock	0.0762	0.0772	0.0752	0.0762	143697120.0
2002-09-25 11:00:00	NVDA	Stock	0.0761	0.0767	0.0753	0.0757	94451160.0
2002-09-25 12:00:00	NVDA	Stock	0.0757	0.077	0.0753	0.0764	101651520.0
2002-09-25 13:00:00	NVDA	Stock	0.0764	0.0787	0.0761	0.078	104274120.0
2002-09-25 14:00:00	NVDA	Stock	0.078	0.0787	0.0772	0.0779	105734280.0
2002-09-25 15:00:00	NVDA	Stock	0.0779	0.0787	0.0771	0.0782	136630440.0
2002-09-25 16:00:00	NVDA	Stock	0.0781	0.0791	0.0779	0.0791	11284680.0
2002-09-25 17:00:00	NVDA	Stock	0.0791	0.0794	0.0781	0.0792	974760.0
2002-09-25 18:00:00	NVDA	Stock	0.0792	0.0792	0.079	0.079	1079640.0
2002-09-25 08:00:00	AMZN	Stock	0.805	0.812	0.805	0.81	102000.0
2002-09-25 09:00:00	AMZN	Stock	0.7965	0.8195	0.7965	0.8065	11949940.0
2002-09-25 10:00:00	AMZN	Stock	0.806	0.807	0.7875	0.7875	12738420.0
2002-09-25 11:00:00	AMZN	Stock	0.7875	0.7895	0.7645	0.7816	32886220.0
2002-09-25 12:00:00	AMZN	Stock	0.7815	0.7925	0.7735	0.78	25702820.0
2002-09-25 13:00:00	AMZN	Stock	0.7785	0.786	0.775	0.786	25542500.0
2002-09-25 14:00:00	AMZN	Stock	0.7855	0.797	0.781	0.7885	32721480.0
2002-09-25 15:00:00	AMZN	Stock	0.7885	0.7935	0.7835	0.7865	28059140.0
2002-09-25 16:00:00	AMZN	Stock	0.7865	0.794	0.785	0.7895	10220200.0
2002-09-25 17:00:00	AMZN	Stock	0.7925	0.7935	0.7865	0.7865	460000.0
2002-09-25 18:00:00	AMZN	Stock	0.7945	0.7945	0.7945	0.7945	15120.0
2002-09-25 09:00:00	CL	Stock	26.385	26.45	26.335	26.375	302400.0
2002-09-25 10:00:00	CL	Stock	26.37	26.42	26.32	26.34	575200.0
2002-09-25 11:00:00	CL	Stock	26.37	26.595	26.325	26.585	643800.0
2002-09-25 12:00:00	CL	Stock	26.61	26.7	26.565	26.665	770200.0
2002-09-25 13:00:00	CL	Stock	26.67	26.8	26.625	26.8	534800.0
2002-09-25 14:00:00	CL	Stock	26.775	26.93	26.775	26.865	674200.0
2002-09-25 15:00:00	CL	Stock	26.875	26.98	26.81	26.845	693400.0

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

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