PREVIEW / stock_1hour / 2002-10-23

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-10-23.parquet
  size:    400 KB
  rows:    19,310
  symbols: 1,490

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-23 09:00:00	AAPL	Stock	0.2609	0.2661	0.2589	0.2652	22847608.0
2002-10-23 10:00:00	AAPL	Stock	0.265	0.2652	0.2589	0.2605	41028960.0
2002-10-23 11:00:00	AAPL	Stock	0.2607	0.2609	0.2589	0.26	32812528.0
2002-10-23 12:00:00	AAPL	Stock	0.26	0.2618	0.2595	0.2614	14154672.0
2002-10-23 13:00:00	AAPL	Stock	0.2614	0.2641	0.2611	0.2639	10740576.0
2002-10-23 14:00:00	AAPL	Stock	0.2641	0.2666	0.2621	0.2654	28300608.0
2002-10-23 15:00:00	AAPL	Stock	0.2659	0.2675	0.2607	0.2657	49816256.0
2002-10-23 16:00:00	AAPL	Stock	0.2657	0.2679	0.2657	0.2657	5006456.0
2002-10-23 17:00:00	AAPL	Stock	0.2679	0.2679	0.2679	0.2679	28000.0
2002-10-23 08:00:00	MSFT	Stock	25.675	25.815	25.555	25.675	53020.0
2002-10-23 09:00:00	MSFT	Stock	25.63	26.195	25.63	26.12	12038880.0
2002-10-23 10:00:00	MSFT	Stock	26.1155	26.14	25.635	25.765	16481300.0
2002-10-23 11:00:00	MSFT	Stock	25.7635	25.775	25.5	25.57	10726938.0
2002-10-23 12:00:00	MSFT	Stock	25.575	25.92	25.505	25.915	11367822.0
2002-10-23 13:00:00	MSFT	Stock	25.905	25.945	25.7835	25.93	8326066.0
2002-10-23 14:00:00	MSFT	Stock	25.94	26.555	25.81	26.4005	23039438.0
2002-10-23 15:00:00	MSFT	Stock	26.409	26.63	26.23	26.595	21641460.0
2002-10-23 16:00:00	MSFT	Stock	26.6	26.675	25.895	26.635	5414566.0
2002-10-23 17:00:00	MSFT	Stock	26.64	26.725	26.625	26.675	33590.0
2002-10-23 18:00:00	MSFT	Stock	26.675	26.7	26.6505	26.7	7604.0
2002-10-23 08:00:00	NVDA	Stock	0.0883	0.0896	0.0883	0.0896	1651800.0
2002-10-23 09:00:00	NVDA	Stock	0.0895	0.0931	0.0892	0.0913	166694760.0
2002-10-23 10:00:00	NVDA	Stock	0.0914	0.0921	0.0883	0.09	210134280.0
2002-10-23 11:00:00	NVDA	Stock	0.0901	0.0909	0.0889	0.09	86477520.0
2002-10-23 12:00:00	NVDA	Stock	0.09	0.0914	0.0892	0.091	49667400.0
2002-10-23 13:00:00	NVDA	Stock	0.0911	0.0916	0.09	0.0915	46117920.0
2002-10-23 14:00:00	NVDA	Stock	0.0915	0.0925	0.0909	0.0916	122421840.0
2002-10-23 15:00:00	NVDA	Stock	0.0917	0.0921	0.0901	0.092	216462120.0
2002-10-23 16:00:00	NVDA	Stock	0.0916	0.092	0.0913	0.0917	21088560.0
2002-10-23 17:00:00	NVDA	Stock	0.0918	0.0918	0.0917	0.0917	1403280.0
2002-10-23 18:00:00	NVDA	Stock	0.0917	0.092	0.0912	0.092	600000.0
2002-10-23 08:00:00	AMZN	Stock	0.9695	0.9695	0.9645	0.9645	500000.0
2002-10-23 09:00:00	AMZN	Stock	0.965	0.991	0.96	0.989	20916720.0
2002-10-23 10:00:00	AMZN	Stock	0.988	0.989	0.9785	0.983	19389400.0
2002-10-23 11:00:00	AMZN	Stock	0.9825	0.988	0.981	0.9855	10331840.0
2002-10-23 12:00:00	AMZN	Stock	0.9854	0.9855	0.9735	0.9805	19368600.0
2002-10-23 13:00:00	AMZN	Stock	0.9805	0.9842	0.9775	0.9825	16137700.0
2002-10-23 14:00:00	AMZN	Stock	0.9825	0.983	0.976	0.982	13365320.0
2002-10-23 15:00:00	AMZN	Stock	0.982	0.9875	0.974	0.987	19333380.0
2002-10-23 16:00:00	AMZN	Stock	0.987	1.0	0.981	1.0	10519000.0
2002-10-23 17:00:00	AMZN	Stock	1.0	1.0	0.9875	0.9925	850000.0
2002-10-23 18:00:00	AMZN	Stock	0.9925	0.9925	0.9867	0.9915	245200.0
2002-10-23 09:00:00	CL	Stock	28.225	28.495	28.13	28.425	418000.0
2002-10-23 10:00:00	CL	Stock	28.4	28.405	28.025	28.12	535600.0
2002-10-23 11:00:00	CL	Stock	28.125	28.275	27.87	27.905	464000.0
2002-10-23 12:00:00	CL	Stock	27.905	28.125	27.875	28.075	310800.0
2002-10-23 13:00:00	CL	Stock	28.08	28.105	27.915	27.98	307400.0
2002-10-23 14:00:00	CL	Stock	27.95	28.425	27.94	28.39	664800.0
2002-10-23 15:00:00	CL	Stock	28.375	28.44	28.3	28.335	643600.0
2002-10-23 16:00:00	CL	Stock	28.325	28.325	28.3	28.3	113400.0

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

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