PREVIEW / stock_1hour / 2006-05-01

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-05-01.parquet
  size:    626 KB
  rows:    29,608
  symbols: 2,246

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
2006-05-01 08:00:00	AAPL	Stock	2.5179	2.5314	2.5107	2.5107	3036628.0
2006-05-01 09:00:00	AAPL	Stock	2.5214	2.5536	2.5139	2.5368	89997880.0
2006-05-01 10:00:00	AAPL	Stock	2.5368	2.555	2.5268	2.5457	169328572.0
2006-05-01 11:00:00	AAPL	Stock	2.5457	2.5496	2.5407	2.5429	58391396.0
2006-05-01 12:00:00	AAPL	Stock	2.5429	2.5439	2.5286	2.5411	63088088.0
2006-05-01 13:00:00	AAPL	Stock	2.5418	2.5425	2.5321	2.5343	35846608.0
2006-05-01 14:00:00	AAPL	Stock	2.5343	2.5404	2.5279	2.5357	74568620.0
2006-05-01 15:00:00	AAPL	Stock	2.5354	2.5389	2.47	2.4886	237880188.0
2006-05-01 16:00:00	AAPL	Stock	2.4857	2.4911	2.4843	2.4879	1653624.0
2006-05-01 17:00:00	AAPL	Stock	2.4875	2.4909	2.4857	2.4903	1967924.0
2006-05-01 18:00:00	AAPL	Stock	2.4857	2.49	2.4857	2.4893	212660.0
2006-05-01 07:00:00	MSFT	Stock	24.22	24.27	24.17	24.19	5200.0
2006-05-01 08:00:00	MSFT	Stock	24.2	24.28	24.061	24.25	1397524.0
2006-05-01 09:00:00	MSFT	Stock	24.24	25.0	24.09	24.3	21448056.0
2006-05-01 10:00:00	MSFT	Stock	24.31	24.5	24.25	24.41	29250144.0
2006-05-01 11:00:00	MSFT	Stock	24.408	24.5	24.15	24.44	30530192.0
2006-05-01 12:00:00	MSFT	Stock	24.45	24.48	24.33	24.39	17176907.0
2006-05-01 13:00:00	MSFT	Stock	24.39	24.47	24.35	24.36	22181730.0
2006-05-01 14:00:00	MSFT	Stock	24.36	24.48	24.35	24.4	12799294.0
2006-05-01 15:00:00	MSFT	Stock	24.4	24.48	24.24	24.28	36061079.0
2006-05-01 16:00:00	MSFT	Stock	24.26	24.35	24.24	24.3	925646.0
2006-05-01 17:00:00	MSFT	Stock	24.32	24.33	24.246	24.249	201928.0
2006-05-01 18:00:00	MSFT	Stock	24.33	24.34	24.25	24.34	211582.0
2006-05-01 08:00:00	NVDA	Stock	0.487	0.4917	0.4855	0.4855	4411800.0
2006-05-01 09:00:00	NVDA	Stock	0.489	0.5027	0.487	0.4995	82349100.0
2006-05-01 10:00:00	NVDA	Stock	0.4995	0.5017	0.4933	0.5013	72917880.0
2006-05-01 11:00:00	NVDA	Stock	0.5013	0.5037	0.4972	0.5032	80834820.0
2006-05-01 12:00:00	NVDA	Stock	0.5033	0.506	0.5007	0.504	55877760.0
2006-05-01 13:00:00	NVDA	Stock	0.5042	0.507	0.503	0.5058	59666520.0
2006-05-01 14:00:00	NVDA	Stock	0.5057	0.5172	0.5047	0.5168	148745940.0
2006-05-01 15:00:00	NVDA	Stock	0.5168	0.5245	0.5132	0.515	355719840.0
2006-05-01 16:00:00	NVDA	Stock	0.5163	0.5165	0.5117	0.515	15618180.0
2006-05-01 17:00:00	NVDA	Stock	0.5144	0.5146	0.5117	0.5144	843480.0
2006-05-01 18:00:00	NVDA	Stock	0.515	0.515	0.5147	0.515	78000.0
2006-05-01 08:00:00	AMZN	Stock	1.7605	1.7605	1.7605	1.7605	896000.0
2006-05-01 09:00:00	AMZN	Stock	1.7595	1.7605	1.7315	1.732	20270660.0
2006-05-01 10:00:00	AMZN	Stock	1.732	1.7785	1.7245	1.77	36343400.0
2006-05-01 11:00:00	AMZN	Stock	1.771	1.7713	1.7495	1.75	11313900.0
2006-05-01 12:00:00	AMZN	Stock	1.75	1.7585	1.7455	1.758	9613420.0
2006-05-01 13:00:00	AMZN	Stock	1.758	1.7635	1.752	1.7545	7425920.0
2006-05-01 14:00:00	AMZN	Stock	1.7545	1.7595	1.751	1.756	12427440.0
2006-05-01 15:00:00	AMZN	Stock	1.7561	1.7585	1.722	1.731	37778440.0
2006-05-01 16:00:00	AMZN	Stock	1.726	1.731	1.7225	1.7225	681420.0
2006-05-01 17:00:00	AMZN	Stock	1.73	1.7312	1.73	1.7308	242420.0
2006-05-01 18:00:00	AMZN	Stock	1.73	1.737	1.73	1.737	39200.0
2006-05-01 09:00:00	CL	Stock	29.625	29.7	29.555	29.58	370800.0
2006-05-01 10:00:00	CL	Stock	29.575	29.675	29.465	29.515	803000.0
2006-05-01 11:00:00	CL	Stock	29.525	29.6	29.47	29.51	461400.0
2006-05-01 12:00:00	CL	Stock	29.51	29.51	29.415	29.475	583800.0
2006-05-01 13:00:00	CL	Stock	29.47	29.48	29.405	29.43	389200.0

> showing 50 of 29,608 rows — these rows as CSV

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