PREVIEW / stock_daily / 2006-12-26

all stock daily files

  file:    by_date/stock_daily/2006/2006-12-26.parquet
  size:    153 KB
  rows:    4,622
  symbols: 2,923

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-12-26	AAPL	Stock	2.9339	2.9489	2.8889	2.9111	490688800.0
2006-12-26	MSFT	Stock	29.53	30.0	29.4	29.99	37098300.0
2006-12-26	NVDA	Stock	0.6205	0.626	0.6145	0.617	228192000.0
2006-12-26	AMZN	Stock	2.0065	2.0065	1.971	1.99	89472000.0
2006-12-26	CL	Stock	32.325	32.56	32.27	32.5	1923200.0
2006-12-26	A	Stock	24.1059	24.5494	24.0701	24.4635	1315658.0
2006-12-26	AABA-DELISTED	Stock	25.4899997711182	25.6100006103516	25.3400001525879	25.4500007629395	8400500.0
2006-12-26	AACC-DELISTED	Stock	16.07	17.03	16.06	17.01	123189.0
2006-12-26	AACQ-DELISTED	Stock	5.42	5.42	5.42	5.42	4103.0
2006-12-26	AACQW-DELISTED	Stock	0.5	0.55	0.5	0.55	27000.0
2006-12-26	AAI-DELISTED	Stock	11.6	11.99	11.55	11.92	848700.0
2006-12-26	AAIC-DELISTED	Stock	160.0	164.0	159.6	162.2	1057900.0
2006-12-26	AAME	Stock	3.12	3.12	2.99	3.04	4500.0
2006-12-26	AAON	Stock	3.3198	3.3962	3.3198	3.3962	62269.0
2006-12-26	AAP	Stock	35.83	35.89	35.5	35.88	356100.0
2006-12-26	AATI-DELISTED	Stock	5.31	5.42	5.31	5.41	190236.0
2006-12-26	AAU-DELISTED	Stock	2.51	2.527	2.36	2.49	56200.0
2006-12-26	AAUAF-DELISTED	Stock	2.51	2.527	2.36	2.49	56200.0
2006-12-26	AAV-DELISTED	Stock	11.29	11.38	11.18	11.21	642600.0
2006-12-26	AAWW-DELISTED	Stock	44.81	45.02	44.74	44.85	58995.0
2006-12-26	AAXN-DELISTED	Stock	7.5	7.6399998664856	7.42000007629395	7.42999982833862	926800.0
2006-12-26	AB	Stock	79.8	80.4	79.26	79.8	82400.0
2006-12-26	ABAX-DELISTED	Stock	18.82	19.43	18.68	19.36	135095.0
2006-12-26	ABB-DELISTED	Stock	17.45	17.54	17.38	17.53	437700.0
2006-12-26	ABBC-DELISTED	Stock	19.08	19.1	19.04	19.07	6518.0
2006-12-26	ABC-DELISTED	Stock	22.32	22.56	22.22	22.26	3373200.0
2006-12-26	ABCB	Stock	27.234	27.5647	27.1561	27.409	24983.0
2006-12-26	ABCO-DELISTED	Stock	26.46	26.84	26.41	26.79	172006.0
2006-12-26	ABCW-DELISTED	Stock	28.5	29.07	28.5	28.96	30180.0
2006-12-26	ABD-DELISTED	Stock	27.21	27.38	26.87	26.99	299400.0
2006-12-26	ABE-DELISTED	Stock	18.05	18.3	17.5001	17.81	77200.0
2006-12-26	ABFS-DELISTED	Stock	36.6	37.44	36.6	37.35	186058.0
2006-12-26	ABG	Stock	23.7	23.91	23.64	23.85	174400.0
2006-12-26	ABK-DELISTED	Stock	89.05	89.63	88.78	89.29	197300.0
2006-12-26	ABM	Stock	23.02	23.3	23.02	23.09	275800.0
2006-12-26	ABMD-DELISTED	Stock	13.85	13.98	13.75	13.87	90133.0
2006-12-26	ABP-DELISTED	Stock	3.2	3.32	3.07	3.15	279600.0
2006-12-26	ABR	Stock	28.93	29.74	28.93	29.61	54000.0
2006-12-26	ABT	Stock	22.8913	23.1647	22.8721	23.1408	5300750.0
2006-12-26	ABTL-DELISTED	Stock	16.675	16.975	16.625	16.975	44376.0
2006-12-26	ABV-DELISTED	Stock	48.67	48.85	48.51	48.55	198700.0
2006-12-26	ABVA-DELISTED	Stock	15.73	15.88	15.73	15.85	8134.0
2006-12-26	ABX-DELISTED	Stock	30.12	30.47	29.95	30.09	2043642.0
2006-12-26	ACAD	Stock	8.89	9.1	8.88	9.06	73600.0
2006-12-26	ACAP-DELISTED	Stock	39.81	40.69	39.77	40.61	44362.0
2006-12-26	ACAS-DELISTED	Stock	45.29	45.5	45.08	45.45	294662.0
2006-12-26	ACAT-DELISTED	Stock	17.3	17.87	17.3	17.59	104834.0
2006-12-26	ACC-DELISTED	Stock	27.91	28.3	27.76	28.2	68500.0
2006-12-26	ACCL-DELISTED	Stock	5.72	5.99	5.72	5.95	77274.0
2006-12-26	ACCO	Stock	27.21	27.38	26.87	26.99	303000.0

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

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