PREVIEW / stock_daily / 2009-10-23

all stock daily files

  file:    by_date/stock_daily/2009/2009-10-23.parquet
  size:    186 KB
  rows:    5,828
  symbols: 3,458

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-10-23	AAPL	Stock	7.3464	7.35	7.2582	7.2836	420786800.0
2009-10-23	MSFT	Stock	29.2	29.35	27.88	28.02	281761000.0
2009-10-23	NVDA	Stock	0.3413	0.3413	0.3268	0.3288	429528000.0
2009-10-23	AMZN	Stock	5.5525	5.9825	5.531	5.9245	1166116000.0
2009-10-23	TLT	Stock	94.88	95.42	94.87	94.95	2996179.0
2009-10-23	ES	Stock	23.53	23.65	23.02	23.08	1450100.0
2009-10-23	CL	Stock	39.82	39.9	38.715	38.86	6374000.0
2009-10-23	A	Stock	19.4564	19.4564	18.6266	18.7411	3930197.0
2009-10-23	AABA-DELISTED	Stock	17.73	17.75	17.09	17.23	17441175.0
2009-10-23	AACC-DELISTED	Stock	7.2	7.2	7.0	7.0	28554.0
2009-10-23	AACG	Stock	5.52	5.61	5.1	5.12	30600.0
2009-10-23	AAI-DELISTED	Stock	4.91	4.95	4.76	4.77	3650198.0
2009-10-23	AAIC-DELISTED	Stock	14.15	14.15	13.2	14.0	176496.0
2009-10-23	AAME	Stock	1.41	1.41	1.4	1.4	1000.0
2009-10-23	AAON	Stock	3.8005	3.8005	3.7333	3.7472	356906.0
2009-10-23	AAP	Stock	37.74	37.83	36.48	36.7	3128300.0
2009-10-23	AATI-DELISTED	Stock	3.34	3.44	3.29	3.35	391575.0
2009-10-23	AAU-DELISTED	Stock	0.72	0.79	0.71	0.73	215154.0
2009-10-23	AAUAF-DELISTED	Stock	0.72	0.79	0.71	0.73	218654.0
2009-10-23	AAV-DELISTED	Stock	7.4	7.41	7.05	7.1918	1018369.0
2009-10-23	AAWW-DELISTED	Stock	36.32	36.4	34.6	35.47	408836.0
2009-10-23	AAXJ	Stock	55.05	55.05	53.994	54.31	193614.0
2009-10-23	AAXN-DELISTED	Stock	4.4	4.52	4.28	4.38	1582161.0
2009-10-23	AB	Stock	28.03	28.25	27.31	27.47	336300.0
2009-10-23	ABAX-DELISTED	Stock	25.49	26.33	25.32	25.81	407276.0
2009-10-23	ABB-DELISTED	Stock	21.56	21.64	21.24	21.37	3444082.0
2009-10-23	ABBC-DELISTED	Stock	7.25	7.25	7.02	7.09	91398.0
2009-10-23	ABBNY-DELISTED	Stock	21.53	21.64	21.24	21.38	3646095.0
2009-10-23	ABC-DELISTED	Stock	23.62	23.67	23.0	23.19	3106067.0
2009-10-23	ABCB	Stock	6.655	6.6942	6.1454	6.1454	26323.0
2009-10-23	ABCO-DELISTED	Stock	12.87	12.895	12.56	12.63	49209.0
2009-10-23	ABCW-DELISTED	Stock	0.931	0.951	0.901	0.949	121800.0
2009-10-23	ABD-DELISTED	Stock	7.48	7.64	7.07	7.1	325970.0
2009-10-23	ABE-DELISTED	Stock	17.36	17.36	17.14	17.227	43290.0
2009-10-23	ABEO	Stock	4175.0	4250.0	4125.0	4187.5	15.0
2009-10-23	ABFS-DELISTED	Stock	28.14	28.61	27.14	27.25	794183.0
2009-10-23	ABG	Stock	14.61	14.71	13.79	14.3	299500.0
2009-10-23	ABII-DELISTED	Stock	34.535	35.89	34.51	35.13	29055.0
2009-10-23	ABK-DELISTED	Stock	1.27	1.28	1.18	1.2	8438327.0
2009-10-23	ABM	Stock	19.79	19.85	19.4	19.48	148500.0
2009-10-23	ABMD-DELISTED	Stock	10.58	10.6	10.05	10.16	148057.0
2009-10-23	ABR	Stock	2.49	2.5	2.35	2.44	126000.0
2009-10-23	ABT	Stock	24.94	25.0312	24.4554	24.6185	12462901.0
2009-10-23	ABTL-DELISTED	Stock	3.15	3.7	3.15	3.5	46460.0
2009-10-23	ABV-DELISTED	Stock	97.25	97.5	95.0	95.63	548274.0
2009-10-23	ABVA-DELISTED	Stock	2.71	2.71	2.52	2.69	2540.0
2009-10-23	ABVT-DELISTED	Stock	48.75	50.4	48.51	49.92	136815.0
2009-10-23	ABX-DELISTED	Stock	38.45	38.66	37.38	37.56	12324020.0
2009-10-23	ACAD	Stock	1.61	1.66	1.52	1.6	681000.0
2009-10-23	ACAP-DELISTED	Stock	30.69	30.69	29.83	30.15	40163.0

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

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