PREVIEW / stock_daily / 2006-11-21

all stock daily files

  file:    by_date/stock_daily/2006/2006-11-21.parquet
  size:    154 KB
  rows:    4,612
  symbols: 2,922

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-11-21	AAPL	Stock	3.1221	3.1643	3.1111	3.1643	622666800.0
2006-11-21	MSFT	Stock	29.91	30.0	29.79	29.92	66446600.0
2006-11-21	NVDA	Stock	0.6128	0.6138	0.5973	0.6015	387384000.0
2006-11-21	AMZN	Stock	2.1275	2.1625	2.106	2.127	139688000.0
2006-11-21	CL	Stock	32.925	33.54	32.925	33.415	5692800.0
2006-11-21	A	Stock	24.1345	24.1345	23.927	24.0558	4763126.0
2006-11-21	AABA-DELISTED	Stock	26.5	27.3400001525879	26.5	27.1399993896484	21138300.0
2006-11-21	AACC-DELISTED	Stock	17.06	17.53	17.06	17.4	92294.0
2006-11-21	AACQ-DELISTED	Stock	5.5	5.5	5.48	5.5	41125.0
2006-11-21	AACQU-DELISTED	Stock	6.6	6.6	6.6	6.6	700.0
2006-11-21	AACQW-DELISTED	Stock	0.65	0.665	0.65	0.665	105000.0
2006-11-21	AAI-DELISTED	Stock	12.75	13.22	12.67	13.14	2863400.0
2006-11-21	AAIC-DELISTED	Stock	142.2	147.4	142.0	147.4	1498500.0
2006-11-21	AAME	Stock	2.8	2.86	2.77	2.79	21400.0
2006-11-21	AAON	Stock	3.6833	3.7057	3.6306	3.6872	132131.0
2006-11-21	AAP	Stock	37.91	38.11	37.74	37.88	396100.0
2006-11-21	AATI-DELISTED	Stock	5.79	5.81	5.65	5.75	83653.0
2006-11-21	AAU-DELISTED	Stock	2.51	2.6	2.51	2.55	53500.0
2006-11-21	AAUAF-DELISTED	Stock	2.51	2.6	2.51	2.55	53500.0
2006-11-21	AAV-DELISTED	Stock	12.43	12.78	12.43	12.7	958100.0
2006-11-21	AAWW-DELISTED	Stock	37.63	40.39	37.32	40.09	561613.0
2006-11-21	AAXN-DELISTED	Stock	8.97000026702881	8.98999977111816	8.77999973297119	8.8100004196167	793400.0
2006-11-21	AB	Stock	75.83	77.43	75.83	76.97	153300.0
2006-11-21	ABAX-DELISTED	Stock	19.95	20.25	19.77	19.98	265045.0
2006-11-21	ABB-DELISTED	Stock	15.88	15.99	15.87	15.97	1904400.0
2006-11-21	ABBC-DELISTED	Stock	16.19	16.42	16.19	16.29	5053.0
2006-11-21	ABC-DELISTED	Stock	23.1	23.14	22.75	22.88	3086400.0
2006-11-21	ABCB	Stock	27.4479	27.7592	27.4382	27.7494	17375.0
2006-11-21	ABCO-DELISTED	Stock	29.03	29.07	28.41	28.5	914500.0
2006-11-21	ABCW-DELISTED	Stock	29.33	29.47	29.17	29.37	15040.0
2006-11-21	ABD-DELISTED	Stock	25.23	25.35	24.95	25.28	118590.0
2006-11-21	ABE-DELISTED	Stock	16.66	17.0	16.63	16.98	27500.0
2006-11-21	ABFS-DELISTED	Stock	39.99	39.99	39.53	39.82	202775.0
2006-11-21	ABG	Stock	23.92	24.14	23.8	24.09	345100.0
2006-11-21	ABK-DELISTED	Stock	85.2	85.2	84.18	84.33	692500.0
2006-11-21	ABM	Stock	20.87	20.87	20.71	20.8	114600.0
2006-11-21	ABMD-DELISTED	Stock	12.95	13.0	12.72	12.77	105391.0
2006-11-21	ABP-DELISTED	Stock	3.42	3.6	3.42	3.6	105100.0
2006-11-21	ABR	Stock	28.5	28.5	28.18	28.23	152600.0
2006-11-21	ABT	Stock	22.8865	22.9344	22.7425	22.7857	7733847.0
2006-11-21	ABTL-DELISTED	Stock	15.4	15.5	14.95	15.25	42739.0
2006-11-21	ABV-DELISTED	Stock	46.9	47.06	45.75	46.07	549100.0
2006-11-21	ABVA-DELISTED	Stock	16.51	16.51	16.3	16.3	1750.0
2006-11-21	ABVT-DELISTED	Stock	59.0	59.0	59.0	59.0	523.0
2006-11-21	ABX-DELISTED	Stock	28.88	29.25	28.74	29.07	5509200.0
2006-11-21	ACAD	Stock	9.8	9.91	9.72	9.74	66600.0
2006-11-21	ACAP-DELISTED	Stock	38.9	39.12	38.45	39.01	41592.0
2006-11-21	ACAS-DELISTED	Stock	44.16	44.4	43.96	44.38	513103.0
2006-11-21	ACAT-DELISTED	Stock	17.66	17.69	17.4	17.5	26842.0
2006-11-21	ACC-DELISTED	Stock	28.51	28.69	28.48	28.66	299700.0

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

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