PREVIEW / stock_daily / 2006-10-24

all stock daily files

  file:    by_date/stock_daily/2006/2006-10-24.parquet
  size:    152 KB
  rows:    4,534
  symbols: 2,858

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-10-24	AAPL	Stock	2.9004	2.9171	2.8643	2.8946	463212400.0
2006-10-24	MSFT	Stock	28.43	28.43	28.13	28.28	61409600.0
2006-10-24	NVDA	Stock	0.5273	0.5477	0.5258	0.5417	519288000.0
2006-10-24	AMZN	Stock	1.6435	1.9	1.643	1.6815	463106000.0
2006-10-24	CL	Stock	30.075	30.34	30.0	30.235	5002800.0
2006-10-24	A	Stock	24.8569	25.0	24.7353	24.9857	2522971.0
2006-10-24	AABA-DELISTED	Stock	23.3500003814697	23.6399993896484	23.1499996185303	23.5300006866455	31704000.0
2006-10-24	AACC-DELISTED	Stock	17.1	17.21	16.95	16.99	176328.0
2006-10-24	AACQ-DELISTED	Stock	5.33	5.33	5.33	5.33	10000.0
2006-10-24	AACQU-DELISTED	Stock	6.06	6.06	6.06	6.06	5000.0
2006-10-24	AACQW-DELISTED	Stock	0.39	0.41	0.39	0.4	46000.0
2006-10-24	AAI-DELISTED	Stock	11.29	11.38	10.97	11.14	2056900.0
2006-10-24	AAIC-DELISTED	Stock	150.0	153.8	148.8	152.8	1457900.0
2006-10-24	AAME	Stock	2.86	2.87	2.85	2.87	8000.0
2006-10-24	AAON	Stock	3.1197	3.1842	3.0947	3.1605	103275.0
2006-10-24	AAP	Stock	36.15	36.56	35.92	36.36	963200.0
2006-10-24	AATI-DELISTED	Stock	5.69	5.69	5.5	5.5	289635.0
2006-10-24	AAU-DELISTED	Stock	2.48	2.52	2.43	2.44	25500.0
2006-10-24	AAUAF-DELISTED	Stock	2.48	2.52	2.43	2.44	25500.0
2006-10-24	AAV-DELISTED	Stock	13.85	13.95	13.7895	13.95	401000.0
2006-10-24	AAWW-DELISTED	Stock	47.0	47.0	46.62	46.79	64605.0
2006-10-24	AAXN-DELISTED	Stock	9.31999969482422	9.4399995803833	9.07999992370605	9.19999980926514	1158800.0
2006-10-24	AB	Stock	75.0	75.91	74.9	75.57	171300.0
2006-10-24	ABAX-DELISTED	Stock	21.54	21.54	20.46	20.89	402803.0
2006-10-24	ABB-DELISTED	Stock	14.28	14.44	14.26	14.43	1888800.0
2006-10-24	ABBC-DELISTED	Stock	15.97	15.984	15.89	15.926	1020.0
2006-10-24	ABC-DELISTED	Stock	23.65	23.7	23.49	23.7	1212176.0
2006-10-24	ABCB	Stock	27.2535	27.2535	27.0394	27.1075	12852.0
2006-10-24	ABCO-DELISTED	Stock	27.59	27.74	27.41	27.69	70772.0
2006-10-24	ABCW-DELISTED	Stock	29.32	29.32	28.77	29.0	33950.0
2006-10-24	ABD-DELISTED	Stock	24.1	24.31	23.94	24.18	437940.0
2006-10-24	ABE-DELISTED	Stock	15.37	15.39	15.3	15.3	7100.0
2006-10-24	ABFS-DELISTED	Stock	40.85	41.52	39.54	41.51	1254860.0
2006-10-24	ABG	Stock	23.35	23.84	22.97	23.79	485500.0
2006-10-24	ABK-DELISTED	Stock	85.41	85.61	84.41	84.73	988500.0
2006-10-24	ABM	Stock	19.74	19.74	19.52	19.67	71500.0
2006-10-24	ABMD-DELISTED	Stock	14.27	14.47	14.02	14.1	126826.0
2006-10-24	ABP-DELISTED	Stock	3.51	3.59	3.51	3.58	76200.0
2006-10-24	ABR	Stock	27.25	27.45	27.23	27.39	80900.0
2006-10-24	ABT	Stock	23.2799	23.3087	22.8961	23.088	11007503.0
2006-10-24	ABTL-DELISTED	Stock	16.101	16.547	16.101	16.349	11397.0
2006-10-24	ABV-DELISTED	Stock	44.46	44.8	44.19	44.2	307700.0
2006-10-24	ABVA-DELISTED	Stock	17.1999	17.2	17.1	17.1	400.0
2006-10-24	ABX-DELISTED	Stock	30.03	30.82	29.89	30.24	4851107.0
2006-10-24	ACAD	Stock	9.8	9.87	9.48	9.5	137000.0
2006-10-24	ACAP-DELISTED	Stock	52.24	52.32	51.56	52.24	30909.0
2006-10-24	ACAS-DELISTED	Stock	41.45	42.32	41.45	42.24	1018898.0
2006-10-24	ACAT-DELISTED	Stock	16.5	16.61	16.11	16.49	129674.0
2006-10-24	ACC-DELISTED	Stock	27.05	27.05	26.1	26.54	91200.0
2006-10-24	ACCL-DELISTED	Stock	6.07	6.19	6.03	6.15	36667.0

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

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