PREVIEW / stock_daily / 2009-10-28

all stock daily files

  file:    by_date/stock_daily/2009/2009-10-28.parquet
  size:    186 KB
  rows:    5,849
  symbols: 3,487

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-28	AAPL	Stock	7.0611	7.0721	6.825	6.8714	818386800.0
2009-10-28	MSFT	Stock	28.24	28.77	27.95	28.02	73542400.0
2009-10-28	NVDA	Stock	0.3065	0.3135	0.299	0.3005	773632000.0
2009-10-28	AMZN	Stock	6.0785	6.256	6.038	6.082	337754000.0
2009-10-28	TLT	Stock	95.14	95.8	94.96	95.45	4585349.0
2009-10-28	ES	Stock	22.92	23.23	22.82	22.86	1794300.0
2009-10-28	CL	Stock	38.96	39.35	38.625	38.84	6507400.0
2009-10-28	A	Stock	18.2833	18.3906	18.0258	18.1116	5502248.0
2009-10-28	AABA-DELISTED	Stock	16.69	16.77	16.02	16.03	24814457.0
2009-10-28	AACC-DELISTED	Stock	7.01	7.08	6.94	6.95	52894.0
2009-10-28	AACG	Stock	5.29	5.3	5.18	5.26	7900.0
2009-10-28	AAI-DELISTED	Stock	4.62	4.62	4.34	4.41	6320871.0
2009-10-28	AAIC-DELISTED	Stock	12.2	12.33	11.59	11.68	71516.0
2009-10-28	AAME	Stock	1.4	1.4	1.34	1.34	300.0
2009-10-28	AAON	Stock	3.761	3.8005	3.6128	3.6247	273881.0
2009-10-28	AAP	Stock	37.0	37.79	36.13	36.49	3250700.0
2009-10-28	AATI-DELISTED	Stock	3.31	3.33	3.2699	3.29	493073.0
2009-10-28	AAU-DELISTED	Stock	0.69	0.69	0.67	0.67	148619.0
2009-10-28	AAUAF-DELISTED	Stock	0.69	0.69	0.67	0.67	148819.0
2009-10-28	AAV-DELISTED	Stock	6.62	6.67	6.27	6.34	1361897.0
2009-10-28	AAWW-DELISTED	Stock	26.72	27.76	25.53	25.88	1598159.0
2009-10-28	AAXJ	Stock	52.27	52.64	51.2523	51.48	212311.0
2009-10-28	AAXN-DELISTED	Stock	4.39	4.41	4.08	4.08	894368.0
2009-10-28	AB	Stock	26.86	27.0	25.12	25.27	896000.0
2009-10-28	ABAX-DELISTED	Stock	23.88	25.78	23.49	23.6	549251.0
2009-10-28	ABB-DELISTED	Stock	20.04	20.2	19.42	19.53	5605980.0
2009-10-28	ABBC-DELISTED	Stock	6.98	7.03	6.89	6.89	192631.0
2009-10-28	ABBNY-DELISTED	Stock	20.04	20.2	19.42	19.53	5713749.0
2009-10-28	ABC-DELISTED	Stock	22.805	22.89	22.28	22.29	3393240.0
2009-10-28	ABCB	Stock	5.9983	6.0767	5.9102	5.9102	26425.0
2009-10-28	ABCO-DELISTED	Stock	12.347	12.572	12.108	12.263	96819.0
2009-10-28	ABCW-DELISTED	Stock	0.8193	0.8408	0.7229	0.8	92210.0
2009-10-28	ABD-DELISTED	Stock	6.5	6.72	5.97	6.13	906060.0
2009-10-28	ABE-DELISTED	Stock	16.63	16.63	15.92	15.92	44714.0
2009-10-28	ABEO	Stock	4125.0	4125.0	3750.0	3875.0	6.0
2009-10-28	ABFS-DELISTED	Stock	26.78	26.88	25.77	25.84	451877.0
2009-10-28	ABG	Stock	12.66	12.66	11.52	11.7	280300.0
2009-10-28	ABII-DELISTED	Stock	34.15	34.19	31.74	32.04	44533.0
2009-10-28	ABK-DELISTED	Stock	1.07	1.07	1.0	1.02	13189105.0
2009-10-28	ABM	Stock	19.4	19.65	18.94	18.98	174500.0
2009-10-28	ABMD-DELISTED	Stock	9.8	9.8	9.35	9.38	279969.0
2009-10-28	ABR	Stock	2.0	2.12	1.82	1.84	167600.0
2009-10-28	ABT	Stock	24.5322	24.7529	24.4698	24.4794	11977907.0
2009-10-28	ABTL-DELISTED	Stock	4.0	4.0	3.7	3.7	5839.0
2009-10-28	ABV-DELISTED	Stock	92.47	93.05	87.92	88.07	822167.0
2009-10-28	ABVA-DELISTED	Stock	2.44	2.51	2.44	2.44	2045.0
2009-10-28	ABVT-DELISTED	Stock	52.7	53.24	50.7532	51.98	263106.0
2009-10-28	ABX-DELISTED	Stock	36.0	36.61	34.5	34.61	15795962.0
2009-10-28	ACAD	Stock	1.46	1.49	1.32	1.32	797100.0
2009-10-28	ACAP-DELISTED	Stock	30.03	30.33	29.69	29.8	39544.0

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

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