PREVIEW / stock_1hour / 2002-04-22

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-04-22.parquet
  size:    395 KB
  rows:    18,837
  symbols: 1,407

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-04-22 08:00:00	AAPL	Stock	0.4455	0.4462	0.4446	0.4454	2122400.0
2002-04-22 09:00:00	AAPL	Stock	0.4454	0.4457	0.4386	0.44	32082400.0
2002-04-22 10:00:00	AAPL	Stock	0.4398	0.4425	0.4395	0.4416	31500000.0
2002-04-22 11:00:00	AAPL	Stock	0.4414	0.442	0.4379	0.4386	24024000.0
2002-04-22 12:00:00	AAPL	Stock	0.4382	0.4402	0.4379	0.4391	16587200.0
2002-04-22 13:00:00	AAPL	Stock	0.4391	0.4402	0.4379	0.4379	9732800.0
2002-04-22 14:00:00	AAPL	Stock	0.4379	0.4382	0.4343	0.4348	21537600.0
2002-04-22 15:00:00	AAPL	Stock	0.4345	0.4389	0.4327	0.438	84655200.0
2002-04-22 16:00:00	AAPL	Stock	0.438	0.4389	0.4359	0.438	22820000.0
2002-04-22 08:00:00	MSFT	Stock	28.43	28.55	28.2	28.35	94800.0
2002-04-22 09:00:00	MSFT	Stock	28.35	28.585	28.15	28.18	7140600.0
2002-04-22 10:00:00	MSFT	Stock	28.186	28.19	27.875	28.005	8173800.0
2002-04-22 11:00:00	MSFT	Stock	28.005	28.04	27.75	27.75	5567200.0
2002-04-22 12:00:00	MSFT	Stock	27.75	27.84	27.575	27.625	6569400.0
2002-04-22 13:00:00	MSFT	Stock	27.595	27.7355	27.555	27.61	4836200.0
2002-04-22 14:00:00	MSFT	Stock	27.61	27.65	27.5	27.59	6310000.0
2002-04-22 15:00:00	MSFT	Stock	27.58	27.835	27.5	27.795	8579800.0
2002-04-22 16:00:00	MSFT	Stock	27.815	27.9008	27.52	27.836	1917400.0
2002-04-22 17:00:00	MSFT	Stock	27.825	27.85	27.81	27.81	7000.0
2002-04-22 18:00:00	MSFT	Stock	27.845	27.95	27.845	27.95	8600.0
2002-04-22 08:00:00	NVDA	Stock	0.3067	0.3075	0.3006	0.3032	1008000.0
2002-04-22 09:00:00	NVDA	Stock	0.3032	0.3154	0.3021	0.3124	158028000.0
2002-04-22 10:00:00	NVDA	Stock	0.3127	0.3146	0.3103	0.3141	174408000.0
2002-04-22 11:00:00	NVDA	Stock	0.3141	0.3147	0.3083	0.309	107040000.0
2002-04-22 12:00:00	NVDA	Stock	0.309	0.3104	0.3078	0.3094	65064000.0
2002-04-22 13:00:00	NVDA	Stock	0.3091	0.3102	0.306	0.3077	55536000.0
2002-04-22 14:00:00	NVDA	Stock	0.3077	0.3099	0.3067	0.3071	69264000.0
2002-04-22 15:00:00	NVDA	Stock	0.3069	0.31	0.3054	0.3092	128088000.0
2002-04-22 16:00:00	NVDA	Stock	0.3093	0.3102	0.3075	0.3091	11532000.0
2002-04-22 17:00:00	NVDA	Stock	0.3091	0.3093	0.3082	0.3082	480000.0
2002-04-22 08:00:00	AMZN	Stock	0.712	0.735	0.712	0.735	698000.0
2002-04-22 09:00:00	AMZN	Stock	0.733	0.7425	0.7255	0.7335	25946000.0
2002-04-22 10:00:00	AMZN	Stock	0.7335	0.7365	0.718	0.733	20046000.0
2002-04-22 11:00:00	AMZN	Stock	0.7335	0.734	0.718	0.7195	13386000.0
2002-04-22 12:00:00	AMZN	Stock	0.7195	0.725	0.7145	0.716	8982000.0
2002-04-22 13:00:00	AMZN	Stock	0.7175	0.7245	0.708	0.708	7492000.0
2002-04-22 14:00:00	AMZN	Stock	0.711	0.7155	0.7075	0.7125	6754000.0
2002-04-22 15:00:00	AMZN	Stock	0.712	0.7205	0.71	0.7155	16118000.0
2002-04-22 16:00:00	AMZN	Stock	0.716	0.7268	0.7118	0.717	1966000.0
2002-04-22 17:00:00	AMZN	Stock	0.7155	0.717	0.7155	0.717	26000.0
2002-04-22 09:00:00	CL	Stock	27.325	27.46	27.275	27.39	430200.0
2002-04-22 10:00:00	CL	Stock	27.395	27.395	27.0	27.1	944000.0
2002-04-22 11:00:00	CL	Stock	27.1	27.525	27.1	27.41	972600.0
2002-04-22 12:00:00	CL	Stock	27.41	27.535	27.4	27.415	615800.0
2002-04-22 13:00:00	CL	Stock	27.415	27.45	27.38	27.43	888600.0
2002-04-22 14:00:00	CL	Stock	27.425	27.425	27.28	27.28	504400.0
2002-04-22 15:00:00	CL	Stock	27.285	27.375	27.23	27.295	861400.0
2002-04-22 16:00:00	CL	Stock	27.3	27.335	27.3	27.325	151400.0
2002-04-22 18:00:00	CL	Stock	27.375	27.375	27.375	27.375	200.0

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

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