PREVIEW / stock_1hour / 2002-04-19

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-04-19.parquet
  size:    394 KB
  rows:    18,451
  symbols: 1,395

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-19 08:00:00	AAPL	Stock	0.4538	0.4545	0.4509	0.4545	660800.0
2002-04-19 09:00:00	AAPL	Stock	0.4552	0.4554	0.4375	0.4532	79531200.0
2002-04-19 10:00:00	AAPL	Stock	0.4529	0.4536	0.4486	0.4507	61756800.0
2002-04-19 11:00:00	AAPL	Stock	0.4509	0.4514	0.4455	0.4486	39362400.0
2002-04-19 12:00:00	AAPL	Stock	0.4488	0.45	0.4482	0.4482	14504000.0
2002-04-19 13:00:00	AAPL	Stock	0.4484	0.4496	0.4466	0.4473	23564800.0
2002-04-19 14:00:00	AAPL	Stock	0.4471	0.4484	0.4457	0.4471	49795200.0
2002-04-19 15:00:00	AAPL	Stock	0.4466	0.4473	0.4452	0.4461	64316000.0
2002-04-19 16:00:00	AAPL	Stock	0.4461	0.4494	0.4457	0.4457	20244000.0
2002-04-19 08:00:00	MSFT	Stock	27.775	28.75	27.351	28.5	6205000.0
2002-04-19 09:00:00	MSFT	Stock	28.505	28.9	27.795	28.55	32210600.0
2002-04-19 10:00:00	MSFT	Stock	28.55	28.65	28.43	28.575	16686600.0
2002-04-19 11:00:00	MSFT	Stock	28.575	28.73	28.515	28.685	7795400.0
2002-04-19 12:00:00	MSFT	Stock	28.68	28.875	28.635	28.835	6957800.0
2002-04-19 13:00:00	MSFT	Stock	28.84	28.945	28.675	28.785	6252200.0
2002-04-19 14:00:00	MSFT	Stock	28.795	28.99	28.73	28.895	6993200.0
2002-04-19 15:00:00	MSFT	Stock	28.89	28.91	28.55	28.555	9746600.0
2002-04-19 16:00:00	MSFT	Stock	28.555	28.8153	28.555	28.65	5001400.0
2002-04-19 17:00:00	MSFT	Stock	28.6165	28.65	28.575	28.575	17200.0
2002-04-19 18:00:00	MSFT	Stock	28.58	28.6	28.565	28.585	4400.0
2002-04-19 08:00:00	NVDA	Stock	0.3242	0.3304	0.3167	0.3237	16272120.0
2002-04-19 09:00:00	NVDA	Stock	0.325	0.3283	0.3125	0.3167	224472000.0
2002-04-19 10:00:00	NVDA	Stock	0.3167	0.3222	0.315	0.3182	177144000.0
2002-04-19 11:00:00	NVDA	Stock	0.318	0.319	0.3111	0.3127	163908000.0
2002-04-19 12:00:00	NVDA	Stock	0.3127	0.315	0.3125	0.3141	81276000.0
2002-04-19 13:00:00	NVDA	Stock	0.3142	0.3154	0.3111	0.3128	88692000.0
2002-04-19 14:00:00	NVDA	Stock	0.3125	0.3147	0.312	0.3137	54900000.0
2002-04-19 15:00:00	NVDA	Stock	0.3138	0.314	0.3073	0.3077	228396000.0
2002-04-19 16:00:00	NVDA	Stock	0.3076	0.3171	0.3062	0.3073	16968000.0
2002-04-19 17:00:00	NVDA	Stock	0.3082	0.3082	0.3075	0.3077	480000.0
2002-04-19 18:00:00	NVDA	Stock	0.3075	0.3076	0.3067	0.3076	252000.0
2002-04-19 08:00:00	AMZN	Stock	0.7095	0.7175	0.708	0.7175	20000.0
2002-04-19 09:00:00	AMZN	Stock	0.709	0.7225	0.709	0.718	12450000.0
2002-04-19 10:00:00	AMZN	Stock	0.718	0.7195	0.7075	0.7125	13560000.0
2002-04-19 11:00:00	AMZN	Stock	0.7135	0.719	0.7125	0.718	5770000.0
2002-04-19 12:00:00	AMZN	Stock	0.7185	0.736	0.7175	0.7352	10436000.0
2002-04-19 13:00:00	AMZN	Stock	0.7355	0.737	0.718	0.7225	9714000.0
2002-04-19 14:00:00	AMZN	Stock	0.724	0.7325	0.7225	0.7285	5406000.0
2002-04-19 15:00:00	AMZN	Stock	0.7285	0.735	0.726	0.727	8156000.0
2002-04-19 16:00:00	AMZN	Stock	0.729	0.7295	0.72	0.727	1798000.0
2002-04-19 17:00:00	AMZN	Stock	0.7265	0.7265	0.7265	0.7265	10000.0
2002-04-19 09:00:00	CL	Stock	27.4	27.4	27.15	27.2	2872400.0
2002-04-19 10:00:00	CL	Stock	27.225	27.25	27.0	27.125	2538600.0
2002-04-19 11:00:00	CL	Stock	27.125	27.235	27.11	27.225	1059800.0
2002-04-19 12:00:00	CL	Stock	27.22	27.255	27.17	27.235	724200.0
2002-04-19 13:00:00	CL	Stock	27.24	27.28	27.205	27.275	383800.0
2002-04-19 14:00:00	CL	Stock	27.275	27.4	27.24	27.34	1188600.0
2002-04-19 15:00:00	CL	Stock	27.34	27.34	27.1	27.22	1383400.0
2002-04-19 16:00:00	CL	Stock	27.215	27.22	27.2	27.2	238600.0

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

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