PREVIEW / stock_daily / 2008-10-27

all stock daily files

  file:    by_date/stock_daily/2008/2008-10-27.parquet
  size:    174 KB
  rows:    5,755
  symbols: 3,461

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
2008-10-27	AAPL	Stock	3.3954	3.4868	3.2807	3.2889	1208771200.0
2008-10-27	MSFT	Stock	21.67	21.96	21.02	21.18	117683900.0
2008-10-27	NVDA	Stock	0.1642	0.1845	0.159	0.1743	698936000.0
2008-10-27	AMZN	Stock	2.45	2.6295	2.4215	2.479	235184000.0
2008-10-27	TLT	Stock	97.77	98.21	96.29	96.8	1534101.0
2008-10-27	CL	Stock	27.46	28.7	27.18	27.385	7561400.0
2008-10-27	A	Stock	13.9127	14.2346	13.412	13.5336	4399786.0
2008-10-27	AABA-DELISTED	Stock	11.83	12.19	11.5	11.56	15819032.0
2008-10-27	AACC-DELISTED	Stock	8.24	8.25	7.5	7.5	91457.0
2008-10-27	AACG	Stock	8.03	8.03	8.03	8.03	100.0
2008-10-27	AAI-DELISTED	Stock	3.18	3.35	3.05	3.27	3022059.0
2008-10-27	AAIC-DELISTED	Stock	10.0	10.398	7.0	7.6	427378.0
2008-10-27	AAON	Stock	2.799	3.0301	2.5264	2.5521	402469.0
2008-10-27	AAP	Stock	25.28	26.22	24.11	24.17	1885000.0
2008-10-27	AATI-DELISTED	Stock	2.29	2.49	2.21	2.45	222129.0
2008-10-27	AAU-DELISTED	Stock	0.48	0.5	0.45	0.46	82325.0
2008-10-27	AAUAF-DELISTED	Stock	0.48	0.5	0.45	0.46	83125.0
2008-10-27	AAV-DELISTED	Stock	5.75	5.79	5.5	5.51	820795.0
2008-10-27	AAWW-DELISTED	Stock	22.09	22.09	18.75	19.02	431647.0
2008-10-27	AAXJ	Stock	27.0	27.76	26.28	26.41	109226.0
2008-10-27	AAXN-DELISTED	Stock	4.51	4.61	4.25	4.254	549192.0
2008-10-27	AB	Stock	19.0	19.37	18.0	18.01	461300.0
2008-10-27	ABAX-DELISTED	Stock	11.61	11.99	10.17	10.31	906668.0
2008-10-27	ABB-DELISTED	Stock	10.22	10.67	10.0	10.0	14317213.0
2008-10-27	ABBC-DELISTED	Stock	9.19	9.44	9.0	9.01	37772.0
2008-10-27	ABBNY-DELISTED	Stock	10.22	10.67	10.0	10.0	14731617.0
2008-10-27	ABC-DELISTED	Stock	15.14	15.36	14.65	14.65	5197578.0
2008-10-27	ABCB	Stock	9.6194	9.9696	9.4833	9.5903	28274.0
2008-10-27	ABCO-DELISTED	Stock	11.05	11.555	10.67	11.12	258260.0
2008-10-27	ABCW-DELISTED	Stock	4.53	5.09	4.4999	4.63	249160.0
2008-10-27	ABD-DELISTED	Stock	2.8	2.8	2.4	2.63	973060.0
2008-10-27	ABE-DELISTED	Stock	10.93	11.25	10.15	10.3	52199.0
2008-10-27	ABFS-DELISTED	Stock	24.97	27.82	24.66	26.59	801574.0
2008-10-27	ABG	Stock	2.0	2.17	2.0	2.05	481100.0
2008-10-27	ABII-DELISTED	Stock	60.62	63.95	60.62	63.0	9337.0
2008-10-27	ABK-DELISTED	Stock	2.5	2.73	2.16	2.2	26504859.0
2008-10-27	ABM	Stock	13.92	14.02	13.28	13.28	374300.0
2008-10-27	ABMD-DELISTED	Stock	11.84	11.84	10.76	10.77	312104.0
2008-10-27	ABR	Stock	4.25	4.43	3.85	3.85	184500.0
2008-10-27	ABT	Stock	25.7461	26.4754	25.3718	25.511	18434348.0
2008-10-27	ABTL-DELISTED	Stock	2.36	2.95	2.36	2.95	28748.0
2008-10-27	ABV-DELISTED	Stock	37.09	39.68	35.84	37.57	869365.0
2008-10-27	ABVA-DELISTED	Stock	3.75	3.76	2.55	2.936	19752.0
2008-10-27	ABX-DELISTED	Stock	19.85	20.6	17.8	17.97	18329952.0
2008-10-27	ACAD	Stock	1.48	1.59	1.41	1.41	164300.0
2008-10-27	ACAP-DELISTED	Stock	40.05	40.05	34.0501	34.33	167355.0
2008-10-27	ACAS-DELISTED	Stock	10.42	10.964	9.95	10.03	3292681.0
2008-10-27	ACAT-DELISTED	Stock	6.22	6.74	6.16	6.28	95801.0
2008-10-27	ACC-DELISTED	Stock	24.32	25.19	22.28	22.28	655339.0
2008-10-27	ACCL-DELISTED	Stock	4.73	4.91	4.5	4.5	37230.0

> showing 50 of 5,755 rows — these rows as CSV

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