PREVIEW / stock_1hour / 2004-04-23

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-04-23.parquet
  size:    508 KB
  rows:    24,024
  symbols: 1,755

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
2004-04-23 08:00:00	AAPL	Stock	0.4979	0.4979	0.4959	0.4964	464800.0
2004-04-23 09:00:00	AAPL	Stock	0.4964	0.5	0.4905	0.4986	33039216.0
2004-04-23 10:00:00	AAPL	Stock	0.4989	0.4995	0.4893	0.4909	47604480.0
2004-04-23 11:00:00	AAPL	Stock	0.4909	0.4913	0.483	0.4871	46048408.0
2004-04-23 12:00:00	AAPL	Stock	0.4873	0.4905	0.4841	0.4893	21328944.0
2004-04-23 13:00:00	AAPL	Stock	0.4895	0.4911	0.4875	0.4911	20241480.0
2004-04-23 14:00:00	AAPL	Stock	0.4909	0.4941	0.4902	0.4927	32711560.0
2004-04-23 15:00:00	AAPL	Stock	0.4925	0.4975	0.4918	0.4946	94627456.0
2004-04-23 16:00:00	AAPL	Stock	0.4946	0.4954	0.4945	0.4946	2801960.0
2004-04-23 17:00:00	AAPL	Stock	0.4943	0.4946	0.4911	0.4911	577640.0
2004-04-23 18:00:00	AAPL	Stock	0.4893	0.4955	0.4893	0.492	39200.0
2004-04-23 08:00:00	MSFT	Stock	27.35	27.54	27.14	27.46	2096433.0
2004-04-23 09:00:00	MSFT	Stock	27.46	27.7	27.32	27.7	68235397.0
2004-04-23 10:00:00	MSFT	Stock	27.68	27.69	27.5	27.55	51557260.0
2004-04-23 11:00:00	MSFT	Stock	27.54	27.6	27.46	27.48	34050278.0
2004-04-23 12:00:00	MSFT	Stock	27.48	27.57	27.44	27.49	21331675.0
2004-04-23 13:00:00	MSFT	Stock	27.48	27.52	27.45	27.47	18171177.0
2004-04-23 14:00:00	MSFT	Stock	27.47	27.5	27.41	27.49	21273951.0
2004-04-23 15:00:00	MSFT	Stock	27.49	27.57	27.45	27.54	25423000.0
2004-04-23 16:00:00	MSFT	Stock	27.53	27.58	27.52	27.55	2190160.0
2004-04-23 17:00:00	MSFT	Stock	27.56	27.57	27.53	27.55	134493.0
2004-04-23 18:00:00	MSFT	Stock	27.55	27.56	27.55	27.55	12036.0
2004-04-23 08:00:00	NVDA	Stock	0.1898	0.1925	0.1898	0.1925	720000.0
2004-04-23 09:00:00	NVDA	Stock	0.1912	0.1963	0.1904	0.1952	72997680.0
2004-04-23 10:00:00	NVDA	Stock	0.1952	0.1969	0.1915	0.1933	127225440.0
2004-04-23 11:00:00	NVDA	Stock	0.1933	0.1935	0.1912	0.1916	36617280.0
2004-04-23 12:00:00	NVDA	Stock	0.1915	0.1942	0.1912	0.1937	45565680.0
2004-04-23 13:00:00	NVDA	Stock	0.1937	0.1944	0.1926	0.1938	21248280.0
2004-04-23 14:00:00	NVDA	Stock	0.1938	0.195	0.1929	0.1938	38156520.0
2004-04-23 15:00:00	NVDA	Stock	0.1938	0.1945	0.1932	0.1937	63736080.0
2004-04-23 16:00:00	NVDA	Stock	0.1936	0.1939	0.1936	0.1937	3224040.0
2004-04-23 17:00:00	NVDA	Stock	0.1937	0.1937	0.1937	0.1937	111600.0
2004-04-23 08:00:00	AMZN	Stock	2.345	2.394	2.286	2.325	6833820.0
2004-04-23 09:00:00	AMZN	Stock	2.325	2.3444	2.2755	2.327	96004520.0
2004-04-23 10:00:00	AMZN	Stock	2.3275	2.3275	2.28	2.2955	54269140.0
2004-04-23 11:00:00	AMZN	Stock	2.2955	2.306	2.286	2.2925	18651740.0
2004-04-23 12:00:00	AMZN	Stock	2.292	2.3135	2.2915	2.306	14762680.0
2004-04-23 13:00:00	AMZN	Stock	2.306	2.306	2.296	2.297	21835640.0
2004-04-23 14:00:00	AMZN	Stock	2.297	2.308	2.296	2.306	32164180.0
2004-04-23 15:00:00	AMZN	Stock	2.306	2.329	2.2955	2.3135	38715940.0
2004-04-23 16:00:00	AMZN	Stock	2.313	2.3225	2.3125	2.32	542300.0
2004-04-23 17:00:00	AMZN	Stock	2.32	2.3255	2.3125	2.3195	141040.0
2004-04-23 18:00:00	AMZN	Stock	2.3155	2.3155	2.3155	2.3155	3000.0
2004-04-23 09:00:00	CL	Stock	28.11	28.245	28.085	28.16	358800.0
2004-04-23 10:00:00	CL	Stock	28.16	28.165	28.0205	28.045	408800.0
2004-04-23 11:00:00	CL	Stock	28.04	28.095	28.0	28.035	401000.0
2004-04-23 12:00:00	CL	Stock	28.045	28.195	27.995	28.125	344400.0
2004-04-23 13:00:00	CL	Stock	28.12	28.195	28.1	28.13	136200.0
2004-04-23 14:00:00	CL	Stock	28.13	28.26	28.065	28.235	268800.0
2004-04-23 15:00:00	CL	Stock	28.24	28.4	28.225	28.325	722800.0

> showing 50 of 24,024 rows — these rows as CSV

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