PREVIEW / stock_daily / 2006-10-05

all stock daily files

  file:    by_date/stock_daily/2006/2006-10-05.parquet
  size:    151 KB
  rows:    4,521
  symbols: 2,856

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-05	AAPL	Stock	2.6618	2.72	2.6475	2.6725	683883200.0
2006-10-05	MSFT	Stock	27.92	28.11	27.78	27.92	81967200.0
2006-10-05	NVDA	Stock	0.516	0.5212	0.502	0.5033	662682000.0
2006-10-05	AMZN	Stock	1.634	1.67	1.62	1.666	169118000.0
2006-10-05	CL	Stock	31.125	31.475	31.105	31.445	4472200.0
2006-10-05	A	Stock	23.4907	23.6123	23.2475	23.5336	2375761.0
2006-10-05	AABA-DELISTED	Stock	25.1599998474121	25.25	24.8799991607666	25.1800003051758	17634000.0
2006-10-05	AACC-DELISTED	Stock	16.76	16.97	16.61	16.93	49212.0
2006-10-05	AACQ-DELISTED	Stock	5.36	5.36	5.35	5.35	8000.0
2006-10-05	AACQW-DELISTED	Stock	0.405	0.41	0.38	0.38	92880.0
2006-10-05	AAI-DELISTED	Stock	10.12	10.4	10.05	10.4	1502000.0
2006-10-05	AAIC-DELISTED	Stock	167.4	168.0	162.0	164.8	611500.0
2006-10-05	AAME	Stock	2.45	2.45	2.45	2.45	200.0
2006-10-05	AAON	Stock	3.2145	3.2922	3.2053	3.2882	110109.0
2006-10-05	AAP	Stock	35.14	35.31	34.61	35.27	766100.0
2006-10-05	AATI-DELISTED	Stock	5.01	5.2	4.9	5.0	659849.0
2006-10-05	AAU-DELISTED	Stock	2.45	2.5699	2.37	2.45	96600.0
2006-10-05	AAUAF-DELISTED	Stock	2.45	2.5699	2.37	2.45	96600.0
2006-10-05	AAV-DELISTED	Stock	11.46	11.78	11.46	11.6323	1022100.0
2006-10-05	AAWW-DELISTED	Stock	44.6	45.26	44.3801	45.24	73641.0
2006-10-05	AAXN-DELISTED	Stock	8.17000007629395	8.73999977111816	8.10000038146973	8.53999996185303	6206000.0
2006-10-05	AB	Stock	68.82	70.5	68.6	70.49	330300.0
2006-10-05	ABAX-DELISTED	Stock	24.05	25.45	24.03	25.43	583731.0
2006-10-05	ABB-DELISTED	Stock	13.37	13.51	13.36	13.51	2158400.0
2006-10-05	ABBC-DELISTED	Stock	15.04	15.04	14.93	15.0	7167.0
2006-10-05	ABC-DELISTED	Stock	23.02	23.4	22.96	23.35	3417600.0
2006-10-05	ABCB	Stock	27.234	28.0121	27.0006	27.7883	26937.0
2006-10-05	ABCO-DELISTED	Stock	26.4	27.01	26.19	26.88	159911.0
2006-10-05	ABCW-DELISTED	Stock	28.71	29.04	28.6	28.89	33400.0
2006-10-05	ABD-DELISTED	Stock	22.54	22.66	22.37	22.63	199900.0
2006-10-05	ABE-DELISTED	Stock	14.22	14.6899	14.03	14.5	20100.0
2006-10-05	ABFS-DELISTED	Stock	45.6	47.42	45.21	46.96	671028.0
2006-10-05	ABG	Stock	21.51	21.66	21.38	21.6	262600.0
2006-10-05	ABK-DELISTED	Stock	84.45	84.99	84.26	84.82	543500.0
2006-10-05	ABM	Stock	18.75	19.2	18.75	19.14	239400.0
2006-10-05	ABMD-DELISTED	Stock	14.88	15.14	14.78	15.08	76438.0
2006-10-05	ABP-DELISTED	Stock	3.35	3.46	3.3	3.38	404600.0
2006-10-05	ABR	Stock	25.94	26.07	25.85	26.04	35900.0
2006-10-05	ABT	Stock	22.6178	22.8145	22.1908	22.2387	24858900.0
2006-10-05	ABTL-DELISTED	Stock	14.059	14.848	13.96	14.7	27585.0
2006-10-05	ABV-DELISTED	Stock	46.37	46.5	46.03	46.31	339400.0
2006-10-05	ABVA-DELISTED	Stock	16.9	16.9	16.9	16.9	840.0
2006-10-05	ABX-DELISTED	Stock	29.27	29.61	28.95	29.32	4287400.0
2006-10-05	ACAD	Stock	8.69	9.1	8.65	8.97	204300.0
2006-10-05	ACAP-DELISTED	Stock	50.26	51.72	50.17	51.42	43048.0
2006-10-05	ACAS-DELISTED	Stock	40.39	41.22	40.35	40.96	1477982.0
2006-10-05	ACAT-DELISTED	Stock	17.4	17.47	16.94	17.07	102951.0
2006-10-05	ACC-DELISTED	Stock	25.54	25.99	25.54	25.8	191700.0
2006-10-05	ACCL-DELISTED	Stock	6.05	6.2214	6.05	6.14	49270.0
2006-10-05	ACCO	Stock	22.54	22.66	22.37	22.63	259900.0

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

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