PREVIEW / stock_daily / 2009-10-27

all stock daily files

  file:    by_date/stock_daily/2009/2009-10-27.parquet
  size:    187 KB
  rows:    5,860
  symbols: 3,482

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
2009-10-27	AAPL	Stock	7.2021	7.2432	7.0161	7.0489	756551600.0
2009-10-27	MSFT	Stock	28.73	28.88	28.44	28.59	69685800.0
2009-10-27	NVDA	Stock	0.323	0.3278	0.3103	0.3135	591836000.0
2009-10-27	AMZN	Stock	6.1465	6.213	5.971	6.1035	406084000.0
2009-10-27	TLT	Stock	93.97	95.11	93.92	95.0	4476264.0
2009-10-27	ES	Stock	22.91	23.17	22.8	22.89	1228800.0
2009-10-27	CL	Stock	38.675	39.175	38.62	38.925	5342800.0
2009-10-27	A	Stock	18.3834	18.6338	18.269	18.4049	4801990.0
2009-10-27	AABA-DELISTED	Stock	16.67	16.87	16.35	16.69	19679007.0
2009-10-27	AACC-DELISTED	Stock	7.0988	7.0988	6.97	7.03	72753.0
2009-10-27	AACG	Stock	5.12	5.38	5.12	5.38	1100.0
2009-10-27	AAI-DELISTED	Stock	4.69	4.72	4.51	4.63	4785478.0
2009-10-27	AAIC-DELISTED	Stock	13.15	13.15	11.65	12.4	145389.0
2009-10-27	AAME	Stock	1.29	1.5	1.26	1.5	4100.0
2009-10-27	AAON	Stock	3.7393	3.8005	3.7393	3.7551	303244.0
2009-10-27	AAP	Stock	36.44	37.54	36.11	36.91	2389500.0
2009-10-27	AATI-DELISTED	Stock	3.45	3.49	3.27	3.32	388714.0
2009-10-27	AAU-DELISTED	Stock	0.68	0.7	0.68	0.68	80452.0
2009-10-27	AAUAF-DELISTED	Stock	0.68	0.7	0.68	0.68	80452.0
2009-10-27	AAV-DELISTED	Stock	6.71	6.8595	6.58	6.79	797090.0
2009-10-27	AAWW-DELISTED	Stock	28.97	30.0	27.0	27.08	1276432.0
2009-10-27	AAXJ	Stock	54.1	54.1	53.27	53.48	100625.0
2009-10-27	AAXN-DELISTED	Stock	4.4	4.4668	4.36	4.38	474592.0
2009-10-27	AB	Stock	27.4	27.52	26.46	27.02	380200.0
2009-10-27	ABAX-DELISTED	Stock	25.31	25.62	24.75	25.39	373858.0
2009-10-27	ABB-DELISTED	Stock	20.77	20.81	20.38	20.54	2665359.0
2009-10-27	ABBC-DELISTED	Stock	6.98	7.25	6.921	6.93	55634.0
2009-10-27	ABBNY-DELISTED	Stock	20.78	20.81	20.38	20.56	2667039.0
2009-10-27	ABC-DELISTED	Stock	22.97	23.12	22.75	22.81	2624817.0
2009-10-27	ABCB	Stock	5.9983	6.4493	5.9983	6.0375	34792.0
2009-10-27	ABCO-DELISTED	Stock	12.597	12.737	12.353	12.508	121867.0
2009-10-27	ABCW-DELISTED	Stock	0.7827	0.8697	0.773	0.86	92970.0
2009-10-27	ABD-DELISTED	Stock	6.7	6.79	6.3993	6.48	371180.0
2009-10-27	ABE-DELISTED	Stock	17.17	17.17	16.73	16.73	20146.0
2009-10-27	ABEO	Stock	4250.0	4250.0	3737.5	4037.5	32.0
2009-10-27	ABFS-DELISTED	Stock	26.82	27.41	26.59	26.74	364280.0
2009-10-27	ABG	Stock	13.63	13.74	12.53	12.66	402300.0
2009-10-27	ABII-DELISTED	Stock	35.0	35.09	34.19	34.19	45161.0
2009-10-27	ABK-DELISTED	Stock	1.12	1.14	1.06	1.07	8164341.0
2009-10-27	ABM	Stock	19.43	19.6	19.14	19.42	164600.0
2009-10-27	ABMD-DELISTED	Stock	10.0	10.19	9.84	9.93	277956.0
2009-10-27	ABR	Stock	2.26	2.33	1.92	2.02	209400.0
2009-10-27	ABT	Stock	24.2395	24.7097	24.2395	24.5754	12099833.0
2009-10-27	ABTL-DELISTED	Stock	3.85	3.85	3.6995	3.8	16570.0
2009-10-27	ABV-DELISTED	Stock	94.47	94.71	92.41	92.5	548425.0
2009-10-27	ABVT-DELISTED	Stock	50.65	53.545	50.07	53.14	229639.0
2009-10-27	ABX-DELISTED	Stock	36.25	36.9175	35.86	36.1	13754338.0
2009-10-27	ACAD	Stock	1.49	1.5	1.45	1.48	380300.0
2009-10-27	ACAP-DELISTED	Stock	29.9	30.35	29.73	29.85	40922.0
2009-10-27	ACAS-DELISTED	Stock	3.11	3.22	3.02	3.04	3898780.0

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

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