PREVIEW / stock_daily / 2009-12-23

all stock daily files

  file:    by_date/stock_daily/2009/2009-12-23.parquet
  size:    189 KB
  rows:    5,916
  symbols: 3,504

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-12-23	AAPL	Stock	7.1857	7.2279	7.1718	7.2179	345525600.0
2009-12-23	MSFT	Stock	30.71	30.95	30.69	30.92	28362700.0
2009-12-23	NVDA	Stock	0.4512	0.4545	0.4455	0.4532	442196000.0
2009-12-23	AMZN	Stock	6.74	6.9525	6.7175	6.947	190922000.0
2009-12-23	TLT	Stock	90.96	91.39	90.5	90.65	2335992.0
2009-12-23	ES	Stock	26.12	26.17	25.82	25.94	882900.0
2009-12-23	CL	Stock	41.655	41.84	41.525	41.72	3231600.0
2009-12-23	A	Stock	21.6023	21.7454	21.5665	21.6738	3101323.0
2009-12-23	AABA-DELISTED	Stock	16.35	16.7	16.0	16.67	23264973.0
2009-12-23	AACC-DELISTED	Stock	6.01	6.22	6.0	6.17	21034.0
2009-12-23	AACG	Stock	4.4	4.56	4.38	4.56	1600.0
2009-12-23	AAI-DELISTED	Stock	5.38	5.4401	5.16	5.36	2619218.0
2009-12-23	AAIC-DELISTED	Stock	16.01	16.12	15.5101	15.69	24338.0
2009-12-23	AAME	Stock	1.27	1.3	1.27	1.3	2300.0
2009-12-23	AAON	Stock	3.8854	3.9348	3.8558	3.8835	245531.0
2009-12-23	AAP	Stock	41.7	41.77	41.18	41.37	1056700.0
2009-12-23	AATI-DELISTED	Stock	3.68	3.72	3.6	3.68	213988.0
2009-12-23	AAU-DELISTED	Stock	1.02	1.09	1.02	1.08	88190.0
2009-12-23	AAUAF-DELISTED	Stock	1.02	1.09	1.02	1.08	88590.0
2009-12-23	AAV-DELISTED	Stock	6.58	6.77	6.58	6.7	483736.0
2009-12-23	AAWW-DELISTED	Stock	37.6	38.25	36.66	38.08	231355.0
2009-12-23	AAXJ	Stock	55.07	55.07	54.56	54.62	152451.0
2009-12-23	AAXN-DELISTED	Stock	4.5	4.5	4.36	4.47	291902.0
2009-12-23	AB	Stock	26.4	26.74	26.18	26.63	294400.0
2009-12-23	ABAX-DELISTED	Stock	22.59	24.1	22.59	24.04	158722.0
2009-12-23	ABB-DELISTED	Stock	18.9	19.09	18.79	18.98	1909543.0
2009-12-23	ABBC-DELISTED	Stock	6.7	6.74	6.61	6.71	38742.0
2009-12-23	ABBNY-DELISTED	Stock	18.9	19.09	18.79	18.95	1911923.0
2009-12-23	ABC-DELISTED	Stock	26.29	26.45	26.2	26.33	2604197.0
2009-12-23	ABCB	Stock	6.5766	6.6942	6.5178	6.6256	65910.0
2009-12-23	ABCD-DELISTED	Stock	4.42	4.74	3.95	4.3999	340081.0
2009-12-23	ABCO-DELISTED	Stock	14.355	14.825	14.335	14.785	244052.0
2009-12-23	ABCW-DELISTED	Stock	0.7003	0.71	0.6699	0.68	121750.0
2009-12-23	ABD-DELISTED	Stock	7.455	7.635	7.355	7.605	203170.0
2009-12-23	ABE-DELISTED	Stock	16.5	16.6491	16.5	16.6491	3740.0
2009-12-23	ABEO	Stock	3625.0	3937.5	3625.0	3937.5	30.0
2009-12-23	ABFS-DELISTED	Stock	30.99	32.24	30.68	31.63	294877.0
2009-12-23	ABG	Stock	11.72	11.9	11.54	11.83	131500.0
2009-12-23	ABII-DELISTED	Stock	38.54	39.64	37.72	39.64	29840.0
2009-12-23	ABK-DELISTED	Stock	0.869	0.87	0.8	0.803	11945018.0
2009-12-23	ABM	Stock	20.93	21.09	20.66	21.0	131100.0
2009-12-23	ABMD-DELISTED	Stock	8.59	8.87	8.5852	8.85	187151.0
2009-12-23	ABR	Stock	1.65	1.97	1.65	1.97	339700.0
2009-12-23	ABT	Stock	26.0148	26.0867	25.8948	25.9524	5747812.0
2009-12-23	ABTL-DELISTED	Stock	4.5469	4.951	4.5469	4.85	1733.0
2009-12-23	ABV-DELISTED	Stock	96.49	97.3	95.52	96.64	221015.0
2009-12-23	ABVA-DELISTED	Stock	3.5	3.5	3.15	3.48	2700.0
2009-12-23	ABVT-DELISTED	Stock	65.8	66.0	65.04	65.5	93833.0
2009-12-23	ABX-DELISTED	Stock	39.21	40.81	39.11	40.2	10340633.0
2009-12-23	ACAD	Stock	1.38	1.4	1.35	1.35	277800.0

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

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