PREVIEW / stock_1hour / 2002-09-10

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-09-10.parquet
  size:    386 KB
  rows:    18,419
  symbols: 1,466

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-10 09:00:00	AAPL	Stock	0.2575	0.2589	0.2546	0.2546	25607344.0
2002-09-10 10:00:00	AAPL	Stock	0.255	0.2571	0.2536	0.2559	71851024.0
2002-09-10 11:00:00	AAPL	Stock	0.2559	0.2568	0.2534	0.2539	18039504.0
2002-09-10 12:00:00	AAPL	Stock	0.2538	0.2552	0.253	0.2543	23552088.0
2002-09-10 13:00:00	AAPL	Stock	0.2539	0.2546	0.2536	0.2541	10823512.0
2002-09-10 14:00:00	AAPL	Stock	0.2538	0.2554	0.2521	0.2545	37350544.0
2002-09-10 15:00:00	AAPL	Stock	0.2546	0.2561	0.2536	0.2557	29522528.0
2002-09-10 16:00:00	AAPL	Stock	0.2563	0.258	0.2554	0.2566	3708992.0
2002-09-10 08:00:00	MSFT	Stock	24.35	24.4	24.025	24.3155	215716.0
2002-09-10 09:00:00	MSFT	Stock	24.315	24.51	24.185	24.405	13899508.0
2002-09-10 10:00:00	MSFT	Stock	24.4035	24.86	24.365	24.835	13668594.0
2002-09-10 11:00:00	MSFT	Stock	24.831	24.85	24.5	24.53	10236300.0
2002-09-10 12:00:00	MSFT	Stock	24.53	24.625	24.355	24.61	8177270.0
2002-09-10 13:00:00	MSFT	Stock	24.61	24.69	24.435	24.4865	7442248.0
2002-09-10 14:00:00	MSFT	Stock	24.49	24.69	24.32	24.63	11235504.0
2002-09-10 15:00:00	MSFT	Stock	24.635	24.91	24.58	24.895	14611318.0
2002-09-10 16:00:00	MSFT	Stock	24.895	25.015	24.27	24.97	2843474.0
2002-09-10 17:00:00	MSFT	Stock	24.975	25.045	24.895	25.045	39572.0
2002-09-10 18:00:00	MSFT	Stock	25.05	25.125	25.005	25.125	14400.0
2002-09-10 08:00:00	NVDA	Stock	0.076	0.076	0.076	0.076	120000.0
2002-09-10 09:00:00	NVDA	Stock	0.0769	0.0832	0.0766	0.0832	229069800.0
2002-09-10 10:00:00	NVDA	Stock	0.0833	0.0921	0.0827	0.0907	748051440.0
2002-09-10 11:00:00	NVDA	Stock	0.0907	0.0911	0.0879	0.0885	291633960.0
2002-09-10 12:00:00	NVDA	Stock	0.0883	0.0892	0.0867	0.089	225808320.0
2002-09-10 13:00:00	NVDA	Stock	0.0892	0.09	0.0876	0.0893	223479600.0
2002-09-10 14:00:00	NVDA	Stock	0.0892	0.0901	0.0874	0.0887	258120480.0
2002-09-10 15:00:00	NVDA	Stock	0.0887	0.0895	0.0876	0.0883	248735040.0
2002-09-10 16:00:00	NVDA	Stock	0.0882	0.089	0.088	0.0889	30823080.0
2002-09-10 17:00:00	NVDA	Stock	0.0887	0.0899	0.0887	0.0899	4132920.0
2002-09-10 18:00:00	NVDA	Stock	0.0899	0.09	0.0892	0.0898	1954080.0
2002-09-10 08:00:00	AMZN	Stock	0.827	0.8276	0.825	0.8275	1566000.0
2002-09-10 09:00:00	AMZN	Stock	0.8255	0.8575	0.821	0.849	36628420.0
2002-09-10 10:00:00	AMZN	Stock	0.8475	0.8675	0.846	0.863	51854220.0
2002-09-10 11:00:00	AMZN	Stock	0.863	0.8655	0.8353	0.838	33489960.0
2002-09-10 12:00:00	AMZN	Stock	0.838	0.857	0.835	0.8545	24821000.0
2002-09-10 13:00:00	AMZN	Stock	0.8545	0.8565	0.843	0.846	14459880.0
2002-09-10 14:00:00	AMZN	Stock	0.8455	0.8545	0.8405	0.851	16389120.0
2002-09-10 15:00:00	AMZN	Stock	0.851	0.857	0.848	0.8555	23901760.0
2002-09-10 16:00:00	AMZN	Stock	0.8555	0.8575	0.852	0.8545	2410880.0
2002-09-10 17:00:00	AMZN	Stock	0.8565	0.8565	0.8545	0.8545	614000.0
2002-09-10 18:00:00	AMZN	Stock	0.8515	0.8515	0.8515	0.8515	2000.0
2002-09-10 09:00:00	CL	Stock	27.825	27.915	27.7	27.755	521000.0
2002-09-10 10:00:00	CL	Stock	27.76	28.1	27.76	27.955	848000.0
2002-09-10 11:00:00	CL	Stock	27.955	27.99	27.9	27.93	357400.0
2002-09-10 12:00:00	CL	Stock	27.925	28.005	27.915	27.975	307600.0
2002-09-10 13:00:00	CL	Stock	27.975	27.99	27.905	27.965	218400.0
2002-09-10 14:00:00	CL	Stock	27.96	27.975	27.85	27.975	367000.0
2002-09-10 15:00:00	CL	Stock	27.975	28.05	27.85	27.855	733800.0
2002-09-10 16:00:00	CL	Stock	27.855	27.865	27.85	27.85	71600.0

> showing 49 of 18,419 rows — these rows as CSV

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