PREVIEW / stock_daily / 2009-01-02

all stock daily files

  file:    by_date/stock_daily/2009/2009-01-02.parquet
  size:    178 KB
  rows:    5,731
  symbols: 3,437

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-01-02	AAPL	Stock	3.0671	3.2514	3.0414	3.2411	746015200.0
2009-01-02	MSFT	Stock	19.53	20.4	19.37	20.33	50084000.0
2009-01-02	NVDA	Stock	0.2018	0.2192	0.201	0.2178	497124000.0
2009-01-02	AMZN	Stock	2.5675	2.7265	2.5535	2.718	145928000.0
2009-01-02	TLT	Stock	120.05	120.45	116.35	116.35	3464102.0
2009-01-02	CL	Stock	34.235	34.855	33.85	34.66	6090600.0
2009-01-02	A	Stock	11.1588	11.6595	11.0944	11.6166	4236220.0
2009-01-02	AABA-DELISTED	Stock	12.17	12.84	12.12	12.83	9934612.0
2009-01-02	AACC-DELISTED	Stock	5.12	5.61	5.1	5.5	94577.0
2009-01-02	AACG	Stock	5.0	5.25	5.0	5.25	1100.0
2009-01-02	AAI-DELISTED	Stock	4.36	4.55	4.36	4.5	1551494.0
2009-01-02	AAIC-DELISTED	Stock	3.2	4.4	3.026	4.4	1214932.0
2009-01-02	AAME	Stock	0.79	0.79	0.79	0.79	100.0
2009-01-02	AAON	Stock	4.1837	4.1837	4.0375	4.1244	923400.0
2009-01-02	AAP	Stock	33.86	34.3	33.07	34.14	795900.0
2009-01-02	AATI-DELISTED	Stock	3.02	3.09	2.91	2.99	172550.0
2009-01-02	AAU-DELISTED	Stock	0.6799	0.73	0.6786	0.73	40600.0
2009-01-02	AAUAF-DELISTED	Stock	0.6799	0.73	0.6786	0.73	40801.0
2009-01-02	AAV-DELISTED	Stock	4.2	4.5	4.17	4.44	921937.0
2009-01-02	AAWW-DELISTED	Stock	19.0	20.28	18.87	20.02	134414.0
2009-01-02	AAXJ	Stock	34.37	35.3	34.21	35.15	45599.0
2009-01-02	AAXN-DELISTED	Stock	5.3	5.5	5.22	5.39	677766.0
2009-01-02	AB	Stock	20.98	22.14	20.39	21.25	661600.0
2009-01-02	ABAX-DELISTED	Stock	16.03	16.99	15.97	16.82	97889.0
2009-01-02	ABB-DELISTED	Stock	15.19	15.35	14.89	15.24	3308736.0
2009-01-02	ABBC-DELISTED	Stock	9.25	9.3	9.14	9.16	94978.0
2009-01-02	ABBNY-DELISTED	Stock	15.19	15.35	14.89	15.25	3310036.0
2009-01-02	ABC-DELISTED	Stock	18.0	18.028	17.54	17.78	3933086.0
2009-01-02	ABCB	Stock	11.5452	11.623	10.7087	11.1562	43593.0
2009-01-02	ABCO-DELISTED	Stock	11.245	11.31	11.07	11.235	183400.0
2009-01-02	ABCW-DELISTED	Stock	2.75	2.9902	2.43	2.51	171600.0
2009-01-02	ABD-DELISTED	Stock	3.494	3.9524	3.1681	3.82	380530.0
2009-01-02	ABE-DELISTED	Stock	13.49	14.13	13.35	14.0	23050.0
2009-01-02	ABEO	Stock	1062.5	1125.0	1062.5	1125.0	7.0
2009-01-02	ABFS-DELISTED	Stock	30.56	31.24	29.75	30.56	452414.0
2009-01-02	ABG	Stock	4.58	4.9	4.35	4.7	310100.0
2009-01-02	ABII-DELISTED	Stock	65.01	70.0	65.01	69.71	10758.0
2009-01-02	ABK-DELISTED	Stock	1.26	1.54	1.22	1.49	12304108.0
2009-01-02	ABM	Stock	18.71	19.19	18.64	18.87	171400.0
2009-01-02	ABMD-DELISTED	Stock	16.46	16.74	16.07	16.33	136567.0
2009-01-02	ABR	Stock	3.0	3.25	2.91	3.17	259100.0
2009-01-02	ABT	Stock	25.6837	25.8372	25.1271	25.6981	13163193.0
2009-01-02	ABTL-DELISTED	Stock	2.4946	2.6609	2.4946	2.55	2082.0
2009-01-02	ABV-DELISTED	Stock	43.7	46.22	43.49	45.89	516349.0
2009-01-02	ABVA-DELISTED	Stock	1.57	1.57	1.57	1.57	100.0
2009-01-02	ABX-DELISTED	Stock	35.97	37.66	35.94	35.98	11799947.0
2009-01-02	ACAD	Stock	0.91	1.15	0.89	1.11	82600.0
2009-01-02	ACAP-DELISTED	Stock	47.8	47.9	46.68	47.1	145035.0
2009-01-02	ACAS-DELISTED	Stock	3.32	3.84	3.22	3.67	5328250.0
2009-01-02	ACAT-DELISTED	Stock	5.08	5.24	5.02	5.16	42149.0

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

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