PREVIEW / stock_1hour / 2003-01-23

all stock 1-hour files

  file:    by_date/stock_1hour/2003/2003-01-23.parquet
  size:    414 KB
  rows:    19,617
  symbols: 1,519

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
2003-01-23 08:00:00	AAPL	Stock	0.2488	0.2504	0.2482	0.2502	896000.0
2003-01-23 09:00:00	AAPL	Stock	0.2504	0.2525	0.2489	0.2504	23122736.0
2003-01-23 10:00:00	AAPL	Stock	0.2504	0.2516	0.2491	0.2516	47685120.0
2003-01-23 11:00:00	AAPL	Stock	0.2516	0.2536	0.2507	0.2532	27254192.0
2003-01-23 12:00:00	AAPL	Stock	0.2532	0.2549	0.2518	0.2543	24513944.0
2003-01-23 13:00:00	AAPL	Stock	0.2541	0.2545	0.2529	0.2543	16259600.0
2003-01-23 14:00:00	AAPL	Stock	0.2543	0.2545	0.2525	0.2539	19300792.0
2003-01-23 15:00:00	AAPL	Stock	0.2539	0.2564	0.253	0.2541	49227920.0
2003-01-23 16:00:00	AAPL	Stock	0.2536	0.2554	0.2518	0.253	6305600.0
2003-01-23 17:00:00	AAPL	Stock	0.253	0.2579	0.253	0.2579	1333864.0
2003-01-23 08:00:00	MSFT	Stock	25.84	29.0	25.5	25.95	370318.0
2003-01-23 09:00:00	MSFT	Stock	25.95	28.12	25.79	26.05	11759764.0
2003-01-23 10:00:00	MSFT	Stock	26.05	26.1	25.79	25.995	11737174.0
2003-01-23 11:00:00	MSFT	Stock	25.99	25.995	25.73	25.9	7936666.0
2003-01-23 12:00:00	MSFT	Stock	25.905	26.08	25.875	26.027	5621658.0
2003-01-23 13:00:00	MSFT	Stock	26.0255	26.15	25.95	26.0945	6139954.0
2003-01-23 14:00:00	MSFT	Stock	26.08	26.135	25.8995	26.03	9614440.0
2003-01-23 15:00:00	MSFT	Stock	26.034	26.245	26.026	26.155	11835644.0
2003-01-23 16:00:00	MSFT	Stock	26.155	26.16	26.03	26.105	2109554.0
2003-01-23 17:00:00	MSFT	Stock	26.0905	26.15	26.075	26.135	214016.0
2003-01-23 18:00:00	MSFT	Stock	26.14	26.155	26.115	26.115	3610.0
2003-01-23 08:00:00	NVDA	Stock	0.0905	0.0917	0.0904	0.091	2419800.0
2003-01-23 09:00:00	NVDA	Stock	0.0907	0.0917	0.0883	0.0902	149748600.0
2003-01-23 10:00:00	NVDA	Stock	0.0901	0.0904	0.0885	0.0902	157231680.0
2003-01-23 11:00:00	NVDA	Stock	0.09	0.0902	0.0889	0.0894	37441920.0
2003-01-23 12:00:00	NVDA	Stock	0.0894	0.0898	0.0887	0.089	54498600.0
2003-01-23 13:00:00	NVDA	Stock	0.089	0.089	0.0874	0.0877	86045280.0
2003-01-23 14:00:00	NVDA	Stock	0.0878	0.0892	0.0874	0.089	145514640.0
2003-01-23 15:00:00	NVDA	Stock	0.0889	0.0904	0.0888	0.0897	218438040.0
2003-01-23 16:00:00	NVDA	Stock	0.0898	0.0899	0.0883	0.0886	13773480.0
2003-01-23 17:00:00	NVDA	Stock	0.0887	0.0899	0.0887	0.0889	1965600.0
2003-01-23 18:00:00	NVDA	Stock	0.0892	0.0895	0.0888	0.0888	746400.0
2003-01-23 08:00:00	AMZN	Stock	1.0655	1.0756	1.0655	1.07	221680.0
2003-01-23 09:00:00	AMZN	Stock	1.073	1.0925	1.0725	1.0795	19569420.0
2003-01-23 10:00:00	AMZN	Stock	1.078	1.085	1.0575	1.0735	26683780.0
2003-01-23 11:00:00	AMZN	Stock	1.074	1.081	1.068	1.079	11851280.0
2003-01-23 12:00:00	AMZN	Stock	1.079	1.0925	1.0758	1.09	14092960.0
2003-01-23 13:00:00	AMZN	Stock	1.0896	1.102	1.088	1.1	22342800.0
2003-01-23 14:00:00	AMZN	Stock	1.0985	1.1005	1.083	1.0895	18567540.0
2003-01-23 15:00:00	AMZN	Stock	1.09	1.0995	1.084	1.0875	44058280.0
2003-01-23 16:00:00	AMZN	Stock	1.0895	1.1045	1.0452	1.074	36430680.0
2003-01-23 17:00:00	AMZN	Stock	1.075	1.09	1.0705	1.08	2780400.0
2003-01-23 18:00:00	AMZN	Stock	1.0805	1.083	1.08	1.08	372160.0
2003-01-23 09:00:00	CL	Stock	25.75	25.935	25.75	25.935	502800.0
2003-01-23 10:00:00	CL	Stock	25.935	26.175	25.915	26.165	389200.0
2003-01-23 11:00:00	CL	Stock	26.15	26.175	25.95	25.975	264000.0
2003-01-23 12:00:00	CL	Stock	25.975	26.005	25.815	25.975	333000.0
2003-01-23 13:00:00	CL	Stock	25.98	26.05	25.94	26.01	236400.0
2003-01-23 14:00:00	CL	Stock	26.01	26.06	25.96	26.025	160600.0
2003-01-23 15:00:00	CL	Stock	26.03	26.195	26.025	26.165	504800.0

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

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