PREVIEW / stock_1hour / 2002-10-28

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-10-28.parquet
  size:    410 KB
  rows:    19,294
  symbols: 1,501

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-28 08:00:00	AAPL	Stock	0.2768	0.2786	0.2768	0.2786	397600.0
2002-10-28 09:00:00	AAPL	Stock	0.2786	0.2848	0.2762	0.2798	40927320.0
2002-10-28 10:00:00	AAPL	Stock	0.2798	0.2804	0.2734	0.2748	42291592.0
2002-10-28 11:00:00	AAPL	Stock	0.2748	0.278	0.2723	0.278	69973568.0
2002-10-28 12:00:00	AAPL	Stock	0.2782	0.2811	0.2778	0.2788	49044800.0
2002-10-28 13:00:00	AAPL	Stock	0.2788	0.2821	0.2788	0.2805	25808776.0
2002-10-28 14:00:00	AAPL	Stock	0.2804	0.2809	0.2786	0.2791	31624544.0
2002-10-28 15:00:00	AAPL	Stock	0.2788	0.2796	0.2768	0.2786	46006576.0
2002-10-28 16:00:00	AAPL	Stock	0.2779	0.2788	0.2777	0.2788	4681600.0
2002-10-28 08:00:00	MSFT	Stock	26.625	26.8	26.5355	26.775	202988.0
2002-10-28 09:00:00	MSFT	Stock	26.75	26.8	26.255	26.305	13483812.0
2002-10-28 10:00:00	MSFT	Stock	26.3	26.4	26.1	26.145	13851856.0
2002-10-28 11:00:00	MSFT	Stock	26.135	26.172	25.935	26.135	8557758.0
2002-10-28 12:00:00	MSFT	Stock	26.14	26.34	26.09	26.275	7810814.0
2002-10-28 13:00:00	MSFT	Stock	26.28	26.5	26.26	26.275	8503934.0
2002-10-28 14:00:00	MSFT	Stock	26.28	26.3411	26.0735	26.135	8134306.0
2002-10-28 15:00:00	MSFT	Stock	26.14	26.15	25.755	25.96	13407334.0
2002-10-28 16:00:00	MSFT	Stock	25.96	26.0945	25.93	26.05	1243746.0
2002-10-28 17:00:00	MSFT	Stock	26.04	26.71	25.882	25.882	68508.0
2002-10-28 18:00:00	MSFT	Stock	25.975	25.975	25.975	25.975	8800.0
2002-10-28 08:00:00	NVDA	Stock	0.0937	0.0992	0.0937	0.0983	9046800.0
2002-10-28 09:00:00	NVDA	Stock	0.0983	0.0983	0.0951	0.0952	192132120.0
2002-10-28 10:00:00	NVDA	Stock	0.0954	0.0954	0.0928	0.0937	250406040.0
2002-10-28 11:00:00	NVDA	Stock	0.0942	0.0949	0.0924	0.0927	114896640.0
2002-10-28 12:00:00	NVDA	Stock	0.0928	0.095	0.0927	0.0946	108127200.0
2002-10-28 13:00:00	NVDA	Stock	0.0945	0.0967	0.0945	0.0952	109969440.0
2002-10-28 14:00:00	NVDA	Stock	0.0952	0.0957	0.0938	0.0951	70025760.0
2002-10-28 15:00:00	NVDA	Stock	0.0949	0.0951	0.0924	0.0927	122867280.0
2002-10-28 16:00:00	NVDA	Stock	0.0927	0.0937	0.0927	0.093	12595440.0
2002-10-28 17:00:00	NVDA	Stock	0.093	0.0933	0.0929	0.0932	882000.0
2002-10-28 18:00:00	NVDA	Stock	0.0933	0.0933	0.0933	0.0933	240000.0
2002-10-28 08:00:00	AMZN	Stock	0.965	0.9875	0.965	0.975	321700.0
2002-10-28 09:00:00	AMZN	Stock	0.975	0.9755	0.9525	0.953	23360060.0
2002-10-28 10:00:00	AMZN	Stock	0.953	0.9575	0.938	0.9445	27782820.0
2002-10-28 11:00:00	AMZN	Stock	0.944	0.9455	0.9325	0.9365	22777360.0
2002-10-28 12:00:00	AMZN	Stock	0.9375	0.9425	0.934	0.9375	18860640.0
2002-10-28 13:00:00	AMZN	Stock	0.937	0.9458	0.933	0.935	14850660.0
2002-10-28 14:00:00	AMZN	Stock	0.9345	0.937	0.929	0.931	17504360.0
2002-10-28 15:00:00	AMZN	Stock	0.931	0.9325	0.92	0.9295	33446180.0
2002-10-28 16:00:00	AMZN	Stock	0.9295	0.9375	0.925	0.9375	1434480.0
2002-10-28 17:00:00	AMZN	Stock	0.9295	0.93	0.9274	0.9274	148000.0
2002-10-28 18:00:00	AMZN	Stock	0.932	0.932	0.932	0.932	10000.0
2002-10-28 09:00:00	CL	Stock	27.85	27.85	27.4	27.42	451000.0
2002-10-28 10:00:00	CL	Stock	27.42	27.44	27.2	27.225	718600.0
2002-10-28 11:00:00	CL	Stock	27.23	27.37	27.2	27.265	553200.0
2002-10-28 12:00:00	CL	Stock	27.265	27.375	27.165	27.175	584400.0
2002-10-28 13:00:00	CL	Stock	27.17	27.365	27.155	27.25	334800.0
2002-10-28 14:00:00	CL	Stock	27.25	27.395	27.19	27.245	445000.0
2002-10-28 15:00:00	CL	Stock	27.25	27.345	27.16	27.305	765200.0
2002-10-28 16:00:00	CL	Stock	27.305	27.395	27.305	27.395	136200.0

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

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