PREVIEW / stock_daily / 2006-03-29

all stock daily files

  file:    by_date/stock_daily/2006/2006-03-29.parquet
  size:    147 KB
  rows:    4,387
  symbols: 2,777

schema

  date         DATE
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

date	symbol	asset_type	open	high	low	close	volume
2006-03-29	AAPL	Stock	2.1118	2.2329	2.0596	2.2261	2346834000.0
2006-03-29	MSFT	Stock	26.95	27.2	26.92	27.02	53150300.0
2006-03-29	NVDA	Stock	0.4533	0.4765	0.4496	0.4757	987096000.0
2006-03-29	AMZN	Stock	1.7845	1.8405	1.7655	1.816	143984000.0
2006-03-29	CL	Stock	28.73	28.995	28.51	28.83	4686600.0
2006-03-29	A	Stock	25.9585	26.5236	25.9585	26.4378	3813604.0
2006-03-29	AABA-DELISTED	Stock	32.439998626709	32.9099998474121	32.1399993896484	32.560001373291	25508200.0
2006-03-29	AACC-DELISTED	Stock	19.42	19.69	19.34	19.45	145881.0
2006-03-29	AACQ-DELISTED	Stock	5.46	5.46	5.46	5.46	150.0
2006-03-29	AACQW-DELISTED	Stock	0.78	0.78	0.78	0.78	9000.0
2006-03-29	AAI-DELISTED	Stock	17.72	18.2	17.68	18.18	1182100.0
2006-03-29	AAIC-DELISTED	Stock	190.0	193.4	186.4	186.4	1177900.0
2006-03-29	AAME	Stock	2.94	2.96	2.6	2.68	30200.0
2006-03-29	AAON	Stock	3.038	3.1012	3.0288	3.0881	140484.0
2006-03-29	AAP	Stock	41.39	41.57	41.3	41.37	553600.0
2006-03-29	AATI-DELISTED	Stock	10.96	11.6	10.96	11.21	952709.0
2006-03-29	AAU-DELISTED	Stock	2.73	2.8991	2.7001	2.83	38900.0
2006-03-29	AAUAF-DELISTED	Stock	2.73	2.8991	2.7001	2.83	38900.0
2006-03-29	AAV-DELISTED	Stock	19.4	19.5	19.26	19.4	217900.0
2006-03-29	AAWW-DELISTED	Stock	45.5	47.25	45.5	46.5	22700.0
2006-03-29	AAXN-DELISTED	Stock	10.5200004577637	10.8000001907349	10.5200004577637	10.7200002670288	895000.0
2006-03-29	AB	Stock	64.13	65.06	64.04	64.87	131700.0
2006-03-29	ABAX-DELISTED	Stock	23.99	24.34	23.6445	23.68	325415.0
2006-03-29	ABB-DELISTED	Stock	12.22	12.4	12.19	12.39	958500.0
2006-03-29	ABBC-DELISTED	Stock	13.3	13.41	13.3	13.4	4095.0
2006-03-29	ABC-DELISTED	Stock	23.86	24.02	23.68	23.98	2337200.0
2006-03-29	ABCB	Stock	21.2425	22.6528	21.2036	22.5263	22516.0
2006-03-29	ABCO-DELISTED	Stock	27.32	27.49	26.99	27.22	182880.0
2006-03-29	ABCW-DELISTED	Stock	29.64	30.05	29.38	30.0	45720.0
2006-03-29	ABD-DELISTED	Stock	21.93	22.08	21.92	21.94	140800.0
2006-03-29	ABE-DELISTED	Stock	12.36	12.57	12.3301	12.53	17500.0
2006-03-29	ABFS-DELISTED	Stock	40.41	40.95	39.83	40.77	480406.0
2006-03-29	ABG	Stock	20.17	20.4	19.97	20.06	84300.0
2006-03-29	ABK-DELISTED	Stock	79.7	80.1	78.99	79.81	514400.0
2006-03-29	ABM	Stock	17.61	17.98	17.61	17.83	192700.0
2006-03-29	ABMD-DELISTED	Stock	12.86	12.9	12.59	12.74	80938.0
2006-03-29	ABP-DELISTED	Stock	6.05	6.05	5.78	5.83	520100.0
2006-03-29	ABR	Stock	27.07	27.34	26.94	26.99	165900.0
2006-03-29	ABT	Stock	20.6458	20.7945	20.4539	20.593	8272197.0
2006-03-29	ABTL-DELISTED	Stock	23.8	24.2	23.4	24.2	78387.0
2006-03-29	ABV-DELISTED	Stock	39.9	42.12	39.85	42.0	516600.0
2006-03-29	ABVA-DELISTED	Stock	18.928	19.059	18.928	19.022	39237.0
2006-03-29	ABX-DELISTED	Stock	26.03	26.73	25.96	26.69	3743900.0
2006-03-29	ACAD	Stock	15.18	15.7	15.01	15.7	401200.0
2006-03-29	ACAP-DELISTED	Stock	47.63	48.04	47.55	47.55	30129.0
2006-03-29	ACAS-DELISTED	Stock	35.38	35.57	35.21	35.32	985543.0
2006-03-29	ACAT-DELISTED	Stock	23.97	24.1	23.74	23.95	154450.0
2006-03-29	ACC-DELISTED	Stock	25.0	25.83	25.0	25.6	62300.0
2006-03-29	ACCL-DELISTED	Stock	7.34	7.36	7.09	7.33	131609.0
2006-03-29	ACCO	Stock	21.93	22.08	21.92	21.94	140900.0

> showing 50 of 4,387 rows — these rows as CSV

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