PREVIEW / stock_daily / 2009-02-27

all stock daily files

  file:    by_date/stock_daily/2009/2009-02-27.parquet
  size:    175 KB
  rows:    5,753
  symbols: 3,438

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-02-27	AAPL	Stock	3.1404	3.2607	3.1311	3.1896	706658400.0
2009-02-27	MSFT	Stock	16.29	16.52	16.1	16.15	93428000.0
2009-02-27	NVDA	Stock	0.2013	0.2118	0.1998	0.207	755444000.0
2009-02-27	AMZN	Stock	3.063	3.254	3.047	3.2395	229766000.0
2009-02-27	TLT	Stock	102.57	103.01	101.21	101.88	3267743.0
2009-02-27	CL	Stock	29.435	30.49	29.135	30.09	9568400.0
2009-02-27	A	Stock	9.9428	10.1931	9.8712	9.9213	5494420.0
2009-02-27	AABA-DELISTED	Stock	12.63	13.33	12.61	13.16	20030626.0
2009-02-27	AACC-DELISTED	Stock	3.32	3.46	3.27	3.36	115766.0
2009-02-27	AACG	Stock	5.05	5.37	5.03	5.37	10000.0
2009-02-27	AAI-DELISTED	Stock	3.2	3.2	2.88	2.99	2445229.0
2009-02-27	AAIC-DELISTED	Stock	3.2	3.4	3.0	3.0	203081.0
2009-02-27	AAON	Stock	3.1486	3.2099	3.0578	3.0657	521944.0
2009-02-27	AAP	Stock	37.34	38.75	37.1	38.25	2674000.0
2009-02-27	AATI-DELISTED	Stock	2.98	3.2	2.95	3.15	297624.0
2009-02-27	AAU-DELISTED	Stock	0.74	0.74	0.71	0.73	54626.0
2009-02-27	AAUAF-DELISTED	Stock	0.74	0.74	0.71	0.73	57126.0
2009-02-27	AAV-DELISTED	Stock	2.35	2.46	2.31	2.32	578376.0
2009-02-27	AAWW-DELISTED	Stock	13.47	14.71	13.47	14.15	276610.0
2009-02-27	AAXJ	Stock	28.61	28.87	28.37	28.51	134791.0
2009-02-27	AAXN-DELISTED	Stock	4.2	4.44	4.15	4.27	989582.0
2009-02-27	AB	Stock	12.29	12.69	11.93	12.17	475000.0
2009-02-27	ABAX-DELISTED	Stock	16.47	16.54	15.45	15.64	250301.0
2009-02-27	ABB-DELISTED	Stock	11.94	12.46	11.85	12.06	5539501.0
2009-02-27	ABBC-DELISTED	Stock	7.12	7.48	7.05	7.29	97424.0
2009-02-27	ABBNY-DELISTED	Stock	11.94	12.46	11.85	12.05	5557101.0
2009-02-27	ABC-DELISTED	Stock	16.13	16.285	15.82	15.87	7099382.0
2009-02-27	ABCB	Stock	4.9896	5.1063	4.8341	4.8341	21796.0
2009-02-27	ABCO-DELISTED	Stock	7.642	7.742	7.393	7.463	297973.0
2009-02-27	ABCW-DELISTED	Stock	0.81	0.86	0.636	0.7	214750.0
2009-02-27	ABD-DELISTED	Stock	0.72	1.22	0.69	0.95	701070.0
2009-02-27	ABE-DELISTED	Stock	10.99	11.0735	10.98	11.07	12850.0
2009-02-27	ABEO	Stock	1500.0	1750.0	1437.5	1750.0	6.0
2009-02-27	ABFS-DELISTED	Stock	17.59	17.85	17.02	17.44	609132.0
2009-02-27	ABG	Stock	3.06	3.12	2.83	2.85	235600.0
2009-02-27	ABII-DELISTED	Stock	70.72	70.72	58.87	58.87	120997.0
2009-02-27	ABK-DELISTED	Stock	0.75	0.75	0.56	0.62	13541151.0
2009-02-27	ABM	Stock	11.95	12.47	11.94	12.23	454100.0
2009-02-27	ABMD-DELISTED	Stock	6.85	6.97	6.74	6.85	337135.0
2009-02-27	ABR	Stock	0.66	0.74	0.58	0.58	480000.0
2009-02-27	ABT	Stock	23.6685	23.8269	22.6658	22.7137	40436640.0
2009-02-27	ABTL-DELISTED	Stock	1.8	1.95	1.8	1.8	2421.0
2009-02-27	ABV-DELISTED	Stock	41.04	41.48	40.18	40.55	892314.0
2009-02-27	ABVA-DELISTED	Stock	1.42	1.74	1.42	1.73	2784.0
2009-02-27	ABVT-DELISTED	Stock	39.0	41.95	39.0	41.95	800.0
2009-02-27	ABX-DELISTED	Stock	32.33	32.36	29.38	30.18	22726448.0
2009-02-27	ACAD	Stock	0.78	0.84	0.77	0.83	128700.0
2009-02-27	ACAP-DELISTED	Stock	40.97	43.28	40.81	42.37	130567.0
2009-02-27	ACAS-DELISTED	Stock	1.28	1.35	1.15	1.35	12922105.0
2009-02-27	ACAT-DELISTED	Stock	3.049	3.46	3.049	3.45	134447.0

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

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