PREVIEW / stock_1hour / 2002-04-16

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-04-16.parquet
  size:    417 KB
  rows:    19,497
  symbols: 1,396

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-16 08:00:00	AAPL	Stock	0.4455	0.4491	0.4455	0.4466	364000.0
2002-04-16 09:00:00	AAPL	Stock	0.4488	0.4554	0.4482	0.4548	76949600.0
2002-04-16 10:00:00	AAPL	Stock	0.4548	0.4643	0.4536	0.4614	165026400.0
2002-04-16 11:00:00	AAPL	Stock	0.4605	0.4641	0.4604	0.4611	77991200.0
2002-04-16 12:00:00	AAPL	Stock	0.4614	0.4625	0.4557	0.457	72833600.0
2002-04-16 13:00:00	AAPL	Stock	0.4579	0.4604	0.4557	0.4598	42795200.0
2002-04-16 14:00:00	AAPL	Stock	0.4602	0.4616	0.4573	0.4582	38763200.0
2002-04-16 15:00:00	AAPL	Stock	0.4586	0.4602	0.4573	0.4591	60776800.0
2002-04-16 16:00:00	AAPL	Stock	0.4596	0.4643	0.4504	0.4643	5544000.0
2002-04-16 17:00:00	AAPL	Stock	0.4596	0.4643	0.4596	0.4629	526400.0
2002-04-16 18:00:00	AAPL	Stock	0.4596	0.4625	0.4596	0.4625	733600.0
2002-04-16 08:00:00	MSFT	Stock	27.6	28.325	27.6	28.16	41600.0
2002-04-16 09:00:00	MSFT	Stock	28.2	28.6	28.1	28.575	8012200.0
2002-04-16 10:00:00	MSFT	Stock	28.575	28.8395	28.56	28.7305	10597200.0
2002-04-16 11:00:00	MSFT	Stock	28.745	28.93	28.7105	28.795	5921000.0
2002-04-16 12:00:00	MSFT	Stock	28.8005	28.95	28.79	28.93	4664200.0
2002-04-16 13:00:00	MSFT	Stock	28.92	28.99	28.79	28.94	4592000.0
2002-04-16 14:00:00	MSFT	Stock	28.9305	29.0	28.895	28.97	3956800.0
2002-04-16 15:00:00	MSFT	Stock	28.97	29.05	28.73	28.905	8709000.0
2002-04-16 16:00:00	MSFT	Stock	28.905	29.59	28.4002	29.5	2179400.0
2002-04-16 17:00:00	MSFT	Stock	28.905	29.55	28.28	29.05	659000.0
2002-04-16 18:00:00	MSFT	Stock	29.0	29.025	28.85	29.0	26000.0
2002-04-16 08:00:00	NVDA	Stock	0.3292	0.3293	0.3271	0.3292	2508000.0
2002-04-16 09:00:00	NVDA	Stock	0.3291	0.3357	0.3273	0.3283	213288000.0
2002-04-16 10:00:00	NVDA	Stock	0.3282	0.3332	0.3253	0.332	195168000.0
2002-04-16 11:00:00	NVDA	Stock	0.332	0.334	0.3308	0.3312	115476000.0
2002-04-16 12:00:00	NVDA	Stock	0.3312	0.3323	0.33	0.3305	49404000.0
2002-04-16 13:00:00	NVDA	Stock	0.3306	0.3329	0.3299	0.3325	39756000.0
2002-04-16 14:00:00	NVDA	Stock	0.3325	0.3336	0.3312	0.3322	56796000.0
2002-04-16 15:00:00	NVDA	Stock	0.3322	0.3331	0.3301	0.3316	113676000.0
2002-04-16 16:00:00	NVDA	Stock	0.3317	0.3457	0.3302	0.3457	24648000.0
2002-04-16 17:00:00	NVDA	Stock	0.3428	0.3433	0.33	0.3352	6996000.0
2002-04-16 18:00:00	NVDA	Stock	0.3333	0.3333	0.3318	0.3333	960000.0
2002-04-16 08:00:00	AMZN	Stock	0.702	0.702	0.702	0.702	8000.0
2002-04-16 09:00:00	AMZN	Stock	0.7075	0.7145	0.6975	0.6975	14396000.0
2002-04-16 10:00:00	AMZN	Stock	0.6975	0.705	0.696	0.7012	11684000.0
2002-04-16 11:00:00	AMZN	Stock	0.701	0.7035	0.695	0.695	9034000.0
2002-04-16 12:00:00	AMZN	Stock	0.6945	0.697	0.686	0.6875	9312000.0
2002-04-16 13:00:00	AMZN	Stock	0.6875	0.6925	0.687	0.69	4490000.0
2002-04-16 14:00:00	AMZN	Stock	0.69	0.697	0.6885	0.696	4516000.0
2002-04-16 15:00:00	AMZN	Stock	0.6965	0.7025	0.689	0.7005	12896000.0
2002-04-16 16:00:00	AMZN	Stock	0.7005	0.7048	0.6975	0.7	2128000.0
2002-04-16 17:00:00	AMZN	Stock	0.7025	0.704	0.7005	0.704	120000.0
2002-04-16 18:00:00	AMZN	Stock	0.7005	0.7005	0.7005	0.7005	80000.0
2002-04-16 09:00:00	CL	Stock	28.85	29.11	28.85	29.025	259200.0
2002-04-16 10:00:00	CL	Stock	29.025	29.035	28.76	28.775	528200.0
2002-04-16 11:00:00	CL	Stock	28.825	28.83	28.725	28.8	327600.0
2002-04-16 12:00:00	CL	Stock	28.8	28.95	28.795	28.94	921200.0
2002-04-16 13:00:00	CL	Stock	28.94	29.05	28.94	29.01	649400.0
2002-04-16 14:00:00	CL	Stock	29.015	29.125	29.01	29.05	738000.0

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

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