PREVIEW / stock_1hour / 2002-04-29

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-04-29.parquet
  size:    402 KB
  rows:    19,089
  symbols: 1,404

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-29 08:00:00	AAPL	Stock	0.4196	0.4196	0.4107	0.4107	224000.0
2002-04-29 09:00:00	AAPL	Stock	0.4152	0.4288	0.4048	0.428	45522400.0
2002-04-29 10:00:00	AAPL	Stock	0.4279	0.4295	0.4232	0.4257	55389600.0
2002-04-29 11:00:00	AAPL	Stock	0.4259	0.4286	0.4246	0.4282	18384800.0
2002-04-29 12:00:00	AAPL	Stock	0.4282	0.4296	0.4259	0.427	28263200.0
2002-04-29 13:00:00	AAPL	Stock	0.427	0.4286	0.4238	0.4279	16167200.0
2002-04-29 14:00:00	AAPL	Stock	0.4277	0.4286	0.4204	0.4211	28890400.0
2002-04-29 15:00:00	AAPL	Stock	0.4209	0.4284	0.4204	0.4279	50204000.0
2002-04-29 16:00:00	AAPL	Stock	0.4277	0.4357	0.4248	0.4279	12919200.0
2002-04-29 18:00:00	AAPL	Stock	0.4279	0.4279	0.4279	0.4279	688800.0
2002-04-29 08:00:00	MSFT	Stock	25.85	25.875	25.65	25.775	139000.0
2002-04-29 09:00:00	MSFT	Stock	25.755	26.27	25.73	26.18	11237600.0
2002-04-29 10:00:00	MSFT	Stock	26.175	26.265	25.805	26.1695	10712000.0
2002-04-29 11:00:00	MSFT	Stock	26.1695	26.22	26.03	26.175	8951400.0
2002-04-29 12:00:00	MSFT	Stock	26.185	26.455	26.165	26.369	6880000.0
2002-04-29 13:00:00	MSFT	Stock	26.37	26.45	26.195	26.4	6853400.0
2002-04-29 14:00:00	MSFT	Stock	26.4	26.405	25.72	25.81	8613600.0
2002-04-29 15:00:00	MSFT	Stock	25.815	26.16	25.805	26.11	11632600.0
2002-04-29 16:00:00	MSFT	Stock	26.115	26.25	26.0015	26.12	4597200.0
2002-04-29 17:00:00	MSFT	Stock	26.12	26.25	26.12	26.22	17400.0
2002-04-29 18:00:00	MSFT	Stock	26.12	26.245	26.12	26.245	95000.0
2002-04-29 08:00:00	NVDA	Stock	0.2528	0.2625	0.219	0.247	195780000.0
2002-04-29 09:00:00	NVDA	Stock	0.247	0.2975	0.2467	0.2822	1144200000.0
2002-04-29 10:00:00	NVDA	Stock	0.2824	0.2908	0.2735	0.2893	765996000.0
2002-04-29 11:00:00	NVDA	Stock	0.2894	0.294	0.2883	0.2913	506184000.0
2002-04-29 12:00:00	NVDA	Stock	0.2913	0.2938	0.2903	0.2923	160440000.0
2002-04-29 13:00:00	NVDA	Stock	0.2923	0.2995	0.2887	0.2977	339336000.0
2002-04-29 14:00:00	NVDA	Stock	0.2977	0.2987	0.2892	0.2912	344016000.0
2002-04-29 15:00:00	NVDA	Stock	0.2912	0.2967	0.2896	0.2954	410868000.0
2002-04-29 16:00:00	NVDA	Stock	0.2954	0.2979	0.2877	0.2952	32160000.0
2002-04-29 17:00:00	NVDA	Stock	0.2959	0.3	0.2959	0.2992	3564000.0
2002-04-29 18:00:00	NVDA	Stock	0.2992	0.3012	0.2952	0.3012	1860000.0
2002-04-29 08:00:00	AMZN	Stock	0.848	0.848	0.846	0.846	44000.0
2002-04-29 09:00:00	AMZN	Stock	0.846	0.847	0.8345	0.845	18430000.0
2002-04-29 10:00:00	AMZN	Stock	0.845	0.85	0.836	0.838	19704000.0
2002-04-29 11:00:00	AMZN	Stock	0.8377	0.8385	0.817	0.8182	30852000.0
2002-04-29 12:00:00	AMZN	Stock	0.8185	0.82	0.8015	0.8065	32212000.0
2002-04-29 13:00:00	AMZN	Stock	0.807	0.8085	0.7975	0.8055	20232000.0
2002-04-29 14:00:00	AMZN	Stock	0.8055	0.806	0.795	0.8015	18488000.0
2002-04-29 15:00:00	AMZN	Stock	0.801	0.814	0.801	0.809	23788000.0
2002-04-29 16:00:00	AMZN	Stock	0.8105	0.8155	0.805	0.8105	1754000.0
2002-04-29 17:00:00	AMZN	Stock	0.8105	0.811	0.805	0.809	98000.0
2002-04-29 18:00:00	AMZN	Stock	0.805	0.811	0.805	0.811	140000.0
2002-04-29 09:00:00	CL	Stock	27.425	27.47	27.35	27.435	368600.0
2002-04-29 10:00:00	CL	Stock	27.435	27.615	27.29	27.6	551600.0
2002-04-29 11:00:00	CL	Stock	27.6	27.6	27.465	27.56	254200.0
2002-04-29 12:00:00	CL	Stock	27.525	27.59	27.375	27.375	471600.0
2002-04-29 13:00:00	CL	Stock	27.375	27.38	27.225	27.295	580200.0
2002-04-29 14:00:00	CL	Stock	27.305	27.31	27.1	27.11	485400.0
2002-04-29 15:00:00	CL	Stock	27.115	27.17	26.985	26.995	1171800.0

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

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