PREVIEW / stock_daily / 2009-04-23

all stock daily files

  file:    by_date/stock_daily/2009/2009-04-23.parquet
  size:    176 KB
  rows:    5,701
  symbols: 3,397

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-04-23	AAPL	Stock	4.5221	4.5429	4.4111	4.4786	945156800.0
2009-04-23	MSFT	Stock	18.92	18.94	18.47	18.92	86116300.0
2009-04-23	NVDA	Stock	0.2865	0.289	0.2705	0.2792	753952000.0
2009-04-23	AMZN	Stock	4.0665	4.103	3.954	4.0305	323754000.0
2009-04-23	TLT	Stock	101.35	101.75	100.94	101.59	1688281.0
2009-04-23	ES	Stock	20.37	20.42	20.06	20.14	1615200.0
2009-04-23	CL	Stock	29.53	29.735	29.185	29.485	6511000.0
2009-04-23	A	Stock	11.9742	11.9742	11.4807	11.731	5264169.0
2009-04-23	AABA-DELISTED	Stock	14.5	14.74	14.11	14.55	32642999.0
2009-04-23	AACC-DELISTED	Stock	6.44	6.44	6.13	6.21	13709.0
2009-04-23	AACG	Stock	4.16	4.35	4.16	4.2	500.0
2009-04-23	AAI-DELISTED	Stock	7.0	7.64	7.0	7.56	7869231.0
2009-04-23	AAIC-DELISTED	Stock	5.8	5.8	5.0	5.0	731636.0
2009-04-23	AAME	Stock	0.6	0.71	0.6	0.71	700.0
2009-04-23	AAON	Stock	3.6049	3.6049	3.4568	3.5279	595350.0
2009-04-23	AAP	Stock	43.65	44.64	43.4	44.14	1834200.0
2009-04-23	AATI-DELISTED	Stock	4.91	5.25	4.48	5.02	1659330.0
2009-04-23	AAU-DELISTED	Stock	0.64	0.69	0.63	0.68	146650.0
2009-04-23	AAUAF-DELISTED	Stock	0.64	0.69	0.63	0.68	147650.0
2009-04-23	AAV-DELISTED	Stock	2.88	2.92	2.76	2.81	510078.0
2009-04-23	AAWW-DELISTED	Stock	24.61	24.61	22.58	23.55	334794.0
2009-04-23	AAXJ	Stock	37.39	37.76	36.51	37.138	179507.0
2009-04-23	AAXN-DELISTED	Stock	5.3	5.36	4.86	4.97	722310.0
2009-04-23	AB	Stock	17.03	17.51	15.67	16.34	3258200.0
2009-04-23	ABAX-DELISTED	Stock	15.09	15.09	14.05	14.44	232490.0
2009-04-23	ABB-DELISTED	Stock	14.75	14.85	14.44	14.64	7434790.0
2009-04-23	ABBC-DELISTED	Stock	8.74	9.09	8.52	8.82	43276.0
2009-04-23	ABBNY-DELISTED	Stock	14.75	14.85	14.44	14.71	7539890.0
2009-04-23	ABC-DELISTED	Stock	18.48	18.48	16.91	17.7	7590848.0
2009-04-23	ABCB	Stock	6.7404	6.7404	5.8359	6.0888	34956.0
2009-04-23	ABCO-DELISTED	Stock	8.53	8.61	7.97	8.245	176301.0
2009-04-23	ABCW-DELISTED	Stock	1.82	1.85	1.7093	1.75	115480.0
2009-04-23	ABD-DELISTED	Stock	2.05	2.3	1.7996	2.16	583110.0
2009-04-23	ABE-DELISTED	Stock	12.94	13.02	12.94	13.005	62755.0
2009-04-23	ABEO	Stock	1750.0	1750.0	1625.0	1687.5	5.0
2009-04-23	ABFS-DELISTED	Stock	21.86	21.86	20.33	21.13	944943.0
2009-04-23	ABG	Stock	7.35	8.12	7.21	8.06	677200.0
2009-04-23	ABII-DELISTED	Stock	50.05	53.6	50.0	52.77	17889.0
2009-04-23	ABK-DELISTED	Stock	1.02	1.02	0.96	1.0	5051095.0
2009-04-23	ABM	Stock	17.3	17.3	16.57	16.93	166600.0
2009-04-23	ABMD-DELISTED	Stock	6.3	6.3	5.79	5.87	764487.0
2009-04-23	ABR	Stock	1.34	1.37	1.31	1.35	103600.0
2009-04-23	ABT	Stock	20.4251	20.8425	20.1564	20.8041	22041892.0
2009-04-23	ABTL-DELISTED	Stock	1.894	2.4034	1.894	2.15	22112.0
2009-04-23	ABV-DELISTED	Stock	52.97	54.04	52.5	53.71	694216.0
2009-04-23	ABVA-DELISTED	Stock	1.9	1.95	1.9	1.95	3461.0
2009-04-23	ABVT-DELISTED	Stock	49.0	49.0	48.0	49.0	1535.0
2009-04-23	ABX-DELISTED	Stock	28.58	30.0	28.42	29.55	11486035.0
2009-04-23	ACAD	Stock	1.0	1.03	0.9	0.93	165800.0
2009-04-23	ACAP-DELISTED	Stock	41.9	41.9	39.8	40.26	59574.0

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

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