PREVIEW / stock_1hour / 2002-02-05

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-02-05.parquet
  size:    380 KB
  rows:    17,946
  symbols: 1,381

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-02-05 08:00:00	AAPL	Stock	0.4536	0.4536	0.4493	0.4516	1304800.0
2002-02-05 09:00:00	AAPL	Stock	0.4516	0.4623	0.4464	0.4557	71568000.0
2002-02-05 10:00:00	AAPL	Stock	0.4557	0.4586	0.4482	0.4545	88704000.0
2002-02-05 11:00:00	AAPL	Stock	0.4552	0.4623	0.4543	0.4584	49548800.0
2002-02-05 12:00:00	AAPL	Stock	0.458	0.4596	0.4563	0.4586	30458400.0
2002-02-05 13:00:00	AAPL	Stock	0.4588	0.4589	0.4562	0.4586	42336000.0
2002-02-05 14:00:00	AAPL	Stock	0.4588	0.4634	0.4571	0.4582	50422400.0
2002-02-05 15:00:00	AAPL	Stock	0.4582	0.4598	0.4493	0.4546	81866400.0
2002-02-05 16:00:00	AAPL	Stock	0.4541	0.4554	0.4504	0.4545	5611200.0
2002-02-05 08:00:00	MSFT	Stock	30.35	30.59	30.0	30.225	654800.0
2002-02-05 09:00:00	MSFT	Stock	30.175	30.635	30.1	30.46	8123600.0
2002-02-05 10:00:00	MSFT	Stock	30.475	31.09	30.25	30.815	13589000.0
2002-02-05 11:00:00	MSFT	Stock	30.81	31.025	30.675	30.825	7973400.0
2002-02-05 12:00:00	MSFT	Stock	30.79	30.85	30.575	30.595	4588600.0
2002-02-05 13:00:00	MSFT	Stock	30.575	31.015	30.525	30.97	6845200.0
2002-02-05 14:00:00	MSFT	Stock	30.9555	31.115	30.845	30.98	9640600.0
2002-02-05 15:00:00	MSFT	Stock	30.98	31.0205	30.415	30.62	12476200.0
2002-02-05 16:00:00	MSFT	Stock	30.62	31.0059	30.475	30.5	1480400.0
2002-02-05 17:00:00	MSFT	Stock	30.485	30.5895	30.385	30.385	69200.0
2002-02-05 18:00:00	MSFT	Stock	30.405	30.405	30.405	30.405	200.0
2002-02-05 08:00:00	NVDA	Stock	0.5092	0.5092	0.5037	0.5062	25464000.0
2002-02-05 09:00:00	NVDA	Stock	0.5058	0.5087	0.4914	0.4962	263472000.0
2002-02-05 10:00:00	NVDA	Stock	0.4967	0.4979	0.4844	0.4929	329256000.0
2002-02-05 11:00:00	NVDA	Stock	0.4927	0.4988	0.4914	0.4987	114576000.0
2002-02-05 12:00:00	NVDA	Stock	0.4989	0.4991	0.4922	0.4928	74160000.0
2002-02-05 13:00:00	NVDA	Stock	0.4927	0.5032	0.4908	0.5005	115392000.0
2002-02-05 14:00:00	NVDA	Stock	0.5005	0.5102	0.4962	0.5011	174888000.0
2002-02-05 15:00:00	NVDA	Stock	0.5011	0.505	0.4909	0.5042	354012000.0
2002-02-05 16:00:00	NVDA	Stock	0.5042	0.5054	0.4965	0.5054	15156000.0
2002-02-05 17:00:00	NVDA	Stock	0.505	0.505	0.5025	0.5025	60000.0
2002-02-05 18:00:00	NVDA	Stock	0.5025	0.5041	0.5025	0.5041	24000.0
2002-02-05 08:00:00	AMZN	Stock	0.621	0.625	0.605	0.606	238000.0
2002-02-05 09:00:00	AMZN	Stock	0.6055	0.6145	0.589	0.602	45232000.0
2002-02-05 10:00:00	AMZN	Stock	0.6015	0.6025	0.5825	0.5875	55118000.0
2002-02-05 11:00:00	AMZN	Stock	0.587	0.6	0.5825	0.5975	35544000.0
2002-02-05 12:00:00	AMZN	Stock	0.5975	0.61	0.595	0.595	25796000.0
2002-02-05 13:00:00	AMZN	Stock	0.5955	0.6085	0.5945	0.6046	26114000.0
2002-02-05 14:00:00	AMZN	Stock	0.605	0.609	0.59	0.5945	21640000.0
2002-02-05 15:00:00	AMZN	Stock	0.596	0.5968	0.558	0.5735	52378000.0
2002-02-05 16:00:00	AMZN	Stock	0.5735	0.5835	0.5685	0.583	9220000.0
2002-02-05 17:00:00	AMZN	Stock	0.583	0.585	0.576	0.576	82000.0
2002-02-05 18:00:00	AMZN	Stock	0.578	0.578	0.578	0.578	14000.0
2002-02-05 09:00:00	CL	Stock	26.875	27.125	26.745	27.095	1511000.0
2002-02-05 10:00:00	CL	Stock	27.1	27.78	27.06	27.6	2730800.0
2002-02-05 11:00:00	CL	Stock	27.6	27.725	27.475	27.6	1677000.0
2002-02-05 12:00:00	CL	Stock	27.605	27.7	27.585	27.66	469000.0
2002-02-05 13:00:00	CL	Stock	27.68	27.975	27.62	27.905	1216400.0
2002-02-05 14:00:00	CL	Stock	27.975	28.175	27.855	28.03	1014600.0
2002-02-05 15:00:00	CL	Stock	28.03	28.045	27.895	28.005	1559800.0
2002-02-05 16:00:00	CL	Stock	28.005	28.005	27.98	27.98	482400.0

> showing 50 of 17,946 rows — these rows as CSV

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