PREVIEW / stock_1hour / 2002-09-23

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-09-23.parquet
  size:    391 KB
  rows:    18,743
  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-23 08:00:00	AAPL	Stock	0.2648	0.2648	0.2645	0.2645	78400.0
2002-09-23 09:00:00	AAPL	Stock	0.2634	0.2648	0.2621	0.2638	23946720.0
2002-09-23 10:00:00	AAPL	Stock	0.2638	0.2652	0.258	0.2611	47235944.0
2002-09-23 11:00:00	AAPL	Stock	0.2611	0.2618	0.2605	0.2613	20425216.0
2002-09-23 12:00:00	AAPL	Stock	0.2613	0.2638	0.2611	0.2636	27655880.0
2002-09-23 13:00:00	AAPL	Stock	0.2636	0.2657	0.2634	0.2657	27877360.0
2002-09-23 14:00:00	AAPL	Stock	0.2659	0.2671	0.2638	0.2638	33965288.0
2002-09-23 15:00:00	AAPL	Stock	0.2638	0.2664	0.2634	0.265	37298128.0
2002-09-23 16:00:00	AAPL	Stock	0.2646	0.2671	0.2643	0.2652	5997488.0
2002-09-23 17:00:00	AAPL	Stock	0.267	0.2677	0.267	0.2677	277256.0
2002-09-23 08:00:00	MSFT	Stock	23.165	23.815	22.5	23.325	351080.0
2002-09-23 09:00:00	MSFT	Stock	23.315	23.73	23.02	23.08	14998940.0
2002-09-23 10:00:00	MSFT	Stock	23.075	23.135	22.605	22.665	18669174.0
2002-09-23 11:00:00	MSFT	Stock	22.665	22.77	22.56	22.63	10479018.0
2002-09-23 12:00:00	MSFT	Stock	22.625	22.715	22.585	22.66	6235482.0
2002-09-23 13:00:00	MSFT	Stock	22.655	22.895	22.585	22.6055	8926642.0
2002-09-23 14:00:00	MSFT	Stock	22.605	22.675	22.5	22.5245	9725444.0
2002-09-23 15:00:00	MSFT	Stock	22.515	22.8505	22.405	22.62	16355748.0
2002-09-23 16:00:00	MSFT	Stock	22.615	22.685	22.5	22.65	2869700.0
2002-09-23 17:00:00	MSFT	Stock	22.625	22.645	22.575	22.63	31040.0
2002-09-23 18:00:00	MSFT	Stock	22.63	22.63	22.615	22.615	7000.0
2002-09-23 08:00:00	NVDA	Stock	0.0762	0.0771	0.0751	0.0753	1152000.0
2002-09-23 09:00:00	NVDA	Stock	0.0753	0.0764	0.0751	0.0755	74768760.0
2002-09-23 10:00:00	NVDA	Stock	0.0755	0.0761	0.0741	0.0745	114538440.0
2002-09-23 11:00:00	NVDA	Stock	0.0745	0.075	0.0741	0.0744	56042880.0
2002-09-23 12:00:00	NVDA	Stock	0.0743	0.0752	0.0741	0.0749	46809120.0
2002-09-23 13:00:00	NVDA	Stock	0.0749	0.0756	0.0742	0.0742	40366320.0
2002-09-23 14:00:00	NVDA	Stock	0.0744	0.0747	0.0737	0.0737	46323840.0
2002-09-23 15:00:00	NVDA	Stock	0.0738	0.0748	0.0729	0.0734	111014400.0
2002-09-23 16:00:00	NVDA	Stock	0.0734	0.0735	0.0727	0.0733	14320920.0
2002-09-23 17:00:00	NVDA	Stock	0.0729	0.0737	0.0729	0.0735	262800.0
2002-09-23 18:00:00	NVDA	Stock	0.0735	0.0735	0.0733	0.0733	168000.0
2002-09-23 08:00:00	AMZN	Stock	0.7875	0.801	0.78	0.78	98000.0
2002-09-23 09:00:00	AMZN	Stock	0.7925	0.8165	0.778	0.8155	25041920.0
2002-09-23 10:00:00	AMZN	Stock	0.8155	0.822	0.79	0.7968	44114700.0
2002-09-23 11:00:00	AMZN	Stock	0.797	0.809	0.796	0.797	17409180.0
2002-09-23 12:00:00	AMZN	Stock	0.797	0.81	0.7915	0.809	14246580.0
2002-09-23 13:00:00	AMZN	Stock	0.809	0.8125	0.8	0.8005	9595640.0
2002-09-23 14:00:00	AMZN	Stock	0.801	0.8045	0.792	0.7925	10808220.0
2002-09-23 15:00:00	AMZN	Stock	0.792	0.8085	0.7905	0.805	20642900.0
2002-09-23 16:00:00	AMZN	Stock	0.805	0.806	0.8	0.806	2406120.0
2002-09-23 17:00:00	AMZN	Stock	0.8025	0.8025	0.8025	0.8025	28000.0
2002-09-23 09:00:00	CL	Stock	26.65	26.85	26.635	26.825	343600.0
2002-09-23 10:00:00	CL	Stock	26.825	26.975	26.525	26.53	473200.0
2002-09-23 11:00:00	CL	Stock	26.52	26.735	26.52	26.62	275200.0
2002-09-23 12:00:00	CL	Stock	26.615	26.615	26.35	26.575	269200.0
2002-09-23 13:00:00	CL	Stock	26.575	26.65	26.5	26.625	214000.0
2002-09-23 14:00:00	CL	Stock	26.64	26.725	26.575	26.615	239200.0
2002-09-23 15:00:00	CL	Stock	26.615	26.875	26.58	26.76	448800.0
2002-09-23 16:00:00	CL	Stock	26.745	26.745	26.745	26.745	117600.0

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

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