PREVIEW / stock_daily / 2009-03-27

all stock daily files

  file:    by_date/stock_daily/2009/2009-03-27.parquet
  size:    175 KB
  rows:    5,728
  symbols: 3,419

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-03-27	AAPL	Stock	3.8654	3.8761	3.8	3.8161	492872800.0
2009-03-27	MSFT	Stock	18.54	18.62	18.05	18.13	47670400.0
2009-03-27	NVDA	Stock	0.2612	0.2678	0.2575	0.2615	731892000.0
2009-03-27	AMZN	Stock	3.5805	3.6145	3.505	3.526	171376000.0
2009-03-27	TLT	Stock	104.15	104.93	103.56	104.56	1853877.0
2009-03-27	ES	Stock	21.4	21.89	21.21	21.7	1996400.0
2009-03-27	CL	Stock	29.79	30.11	29.55	29.755	4654600.0
2009-03-27	A	Stock	12.01	12.1316	11.5951	11.5951	4496527.0
2009-03-27	AABA-DELISTED	Stock	13.17	13.61	13.12	13.18	21827991.0
2009-03-27	AACC-DELISTED	Stock	6.11	6.46	5.61	5.65	32128.0
2009-03-27	AACG	Stock	4.11	4.9	4.11	4.48	43800.0
2009-03-27	AAI-DELISTED	Stock	4.59	4.93	4.54	4.57	1880085.0
2009-03-27	AAIC-DELISTED	Stock	4.0	4.6	4.0	4.2	296781.0
2009-03-27	AAME	Stock	0.76	0.76	0.76	0.76	100.0
2009-03-27	AAON	Stock	3.7472	3.8064	3.5595	3.5615	385762.0
2009-03-27	AAP	Stock	41.81	41.98	41.26	41.8	1441500.0
2009-03-27	AATI-DELISTED	Stock	3.83	4.0	3.69	3.7	224625.0
2009-03-27	AAU-DELISTED	Stock	0.82	0.82	0.76	0.78	48305.0
2009-03-27	AAUAF-DELISTED	Stock	0.82	0.82	0.76	0.78	48805.0
2009-03-27	AAV-DELISTED	Stock	2.65	2.66	2.52	2.59	919618.0
2009-03-27	AAWW-DELISTED	Stock	18.82	19.58	17.82	17.89	316337.0
2009-03-27	AAXJ	Stock	34.96	34.96	34.1395	34.28	165477.0
2009-03-27	AAXN-DELISTED	Stock	4.69	4.95	4.55	4.62	545349.0
2009-03-27	AB	Stock	15.79	16.5	15.54	15.62	392000.0
2009-03-27	ABAX-DELISTED	Stock	18.37	18.65	17.58	17.72	268219.0
2009-03-27	ABB-DELISTED	Stock	13.93	14.02	13.72	13.8	4562648.0
2009-03-27	ABBC-DELISTED	Stock	8.71	8.93	8.6	8.67	56326.0
2009-03-27	ABBNY-DELISTED	Stock	13.94	14.02	13.72	13.8	4570178.0
2009-03-27	ABC-DELISTED	Stock	16.2	16.253	15.97	16.17	3480946.0
2009-03-27	ABCB	Stock	6.3903	6.3903	5.583	5.7873	11721.0
2009-03-27	ABCO-DELISTED	Stock	8.595	8.95	8.36	8.38	130919.0
2009-03-27	ABCW-DELISTED	Stock	1.464	1.7763	1.181	1.22	415970.0
2009-03-27	ABD-DELISTED	Stock	1.29	1.31	1.21	1.25	196000.0
2009-03-27	ABE-DELISTED	Stock	12.77	12.77	12.25	12.25	15213.0
2009-03-27	ABEO	Stock	2000.0	2062.5	1912.5	1912.5	3.0
2009-03-27	ABFS-DELISTED	Stock	21.42	21.9	20.57	20.72	685690.0
2009-03-27	ABG	Stock	4.65	5.13	4.58	4.94	499100.0
2009-03-27	ABII-DELISTED	Stock	44.94	45.39	43.6	44.45	12886.0
2009-03-27	ABK-DELISTED	Stock	0.85	0.86	0.81	0.82	4070245.0
2009-03-27	ABM	Stock	16.75	17.06	16.33	16.37	211000.0
2009-03-27	ABMD-DELISTED	Stock	5.42	5.48	5.31	5.38	243375.0
2009-03-27	ABR	Stock	1.05	1.09	0.88	0.9	182200.0
2009-03-27	ABT	Stock	22.09	22.6082	22.0084	22.3587	22966861.0
2009-03-27	ABTL-DELISTED	Stock	1.25	1.3495	1.2	1.3	6124.0
2009-03-27	ABV-DELISTED	Stock	48.76	49.55	48.6	49.09	931024.0
2009-03-27	ABVT-DELISTED	Stock	44.5	44.75	44.5	44.75	5400.0
2009-03-27	ABX-DELISTED	Stock	32.29	32.74	31.82	32.16	6510640.0
2009-03-27	ACAD	Stock	1.11	1.19	1.04	1.06	195300.0
2009-03-27	ACAP-DELISTED	Stock	42.94	43.4	41.49	41.73	36244.0
2009-03-27	ACAS-DELISTED	Stock	2.13	2.3	2.06	2.14	4159065.0

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

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