PREVIEW / stock_daily / 2009-03-23

all stock daily files

  file:    by_date/stock_daily/2009/2009-03-23.parquet
  size:    176 KB
  rows:    5,759
  symbols: 3,444

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-23	AAPL	Stock	3.6682	3.8629	3.6339	3.845	666397200.0
2009-03-23	MSFT	Stock	17.37	18.59	17.31	18.33	71600000.0
2009-03-23	NVDA	Stock	0.2458	0.256	0.2402	0.2555	816048000.0
2009-03-23	AMZN	Stock	3.568	3.7805	3.535	3.779	172248000.0
2009-03-23	TLT	Stock	104.29	104.42	102.97	103.02	2096968.0
2009-03-23	ES	Stock	22.13	22.13	21.48	22.0	2325200.0
2009-03-23	CL	Stock	29.085	29.66	28.87	29.655	5760000.0
2009-03-23	A	Stock	10.7296	11.3662	10.7296	11.3662	6473299.0
2009-03-23	AABA-DELISTED	Stock	13.75	14.12	13.62	14.1	18045276.0
2009-03-23	AACC-DELISTED	Stock	5.23	6.4	5.0	6.0	90712.0
2009-03-23	AACG	Stock	4.2	4.61	4.2	4.57	68300.0
2009-03-23	AAI-DELISTED	Stock	3.79	4.1	3.63	4.1	1847899.0
2009-03-23	AAIC-DELISTED	Stock	4.0	4.4	3.6	4.2	787324.0
2009-03-23	AAON	Stock	3.5951	3.7867	3.5832	3.7788	407025.0
2009-03-23	AAP	Stock	40.37	40.68	37.76	40.65	3274800.0
2009-03-23	AATI-DELISTED	Stock	3.46	3.76	3.42	3.72	224390.0
2009-03-23	AAU-DELISTED	Stock	0.82	0.84	0.77	0.7703	66998.0
2009-03-23	AAUAF-DELISTED	Stock	0.82	0.84	0.77	0.7706	69873.0
2009-03-23	AAV-DELISTED	Stock	2.22	2.31	2.1	2.2801	3004805.0
2009-03-23	AAWW-DELISTED	Stock	17.1	20.03	17.05	20.03	328048.0
2009-03-23	AAXJ	Stock	34.9	35.0	32.708	34.196	344449.0
2009-03-23	AAXN-DELISTED	Stock	4.24	4.73	4.15	4.73	855291.0
2009-03-23	AB	Stock	12.81	15.58	12.81	15.5	936600.0
2009-03-23	ABAX-DELISTED	Stock	17.85	18.3	17.54	18.24	302334.0
2009-03-23	ABB-DELISTED	Stock	13.9	14.68	13.83	14.68	5501213.0
2009-03-23	ABBC-DELISTED	Stock	8.9	9.0	8.75	8.99	126990.0
2009-03-23	ABBNY-DELISTED	Stock	13.9	14.69	13.83	14.69	5512013.0
2009-03-23	ABC-DELISTED	Stock	15.515	15.925	15.36	15.9	4260564.0
2009-03-23	ABCB	Stock	5.3398	6.4875	5.3398	6.4875	43695.0
2009-03-23	ABCO-DELISTED	Stock	7.555	8.25	7.52	8.25	160916.0
2009-03-23	ABCW-DELISTED	Stock	0.9293	1.0101	0.8889	1.0	252530.0
2009-03-23	ABD-DELISTED	Stock	1.31	1.31	1.25	1.28	272150.0
2009-03-23	ABE-DELISTED	Stock	13.17	13.17	12.2	12.2	63133.0
2009-03-23	ABEO	Stock	2000.0	2000.0	1887.5	2000.0	3.0
2009-03-23	ABFS-DELISTED	Stock	19.19	20.88	18.91	20.85	630576.0
2009-03-23	ABG	Stock	4.02	4.84	3.82	4.7	733000.0
2009-03-23	ABII-DELISTED	Stock	48.43	48.43	42.4	45.0	70716.0
2009-03-23	ABK-DELISTED	Stock	0.9	0.95	0.8305	0.945	13950541.0
2009-03-23	ABM	Stock	16.54	17.22	15.93	17.22	421200.0
2009-03-23	ABMD-DELISTED	Stock	5.18	5.38	5.05	5.24	252764.0
2009-03-23	ABR	Stock	1.25	1.28	1.07	1.15	153600.0
2009-03-23	ABT	Stock	23.1647	23.395	22.9104	23.395	14928095.0
2009-03-23	ABTL-DELISTED	Stock	1.22	1.2708	1.1697	1.25	33260.0
2009-03-23	ABV-DELISTED	Stock	47.43	49.69	47.25	49.45	1246185.0
2009-03-23	ABVA-DELISTED	Stock	1.65	1.65	1.65	1.65	708.0
2009-03-23	ABVT-DELISTED	Stock	46.0	46.0	45.0	45.0	6887.0
2009-03-23	ABX-DELISTED	Stock	33.44	33.82	32.82	33.16	12555054.0
2009-03-23	ACAD	Stock	0.95	1.05	0.95	1.05	932100.0
2009-03-23	ACAP-DELISTED	Stock	43.1	43.78	41.76	43.76	75477.0
2009-03-23	ACAS-DELISTED	Stock	1.29	1.64	1.22	1.63	9596713.0

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

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