PREVIEW / stock_daily / 2009-10-16

all stock daily files

  file:    by_date/stock_daily/2009/2009-10-16.parquet
  size:    186 KB
  rows:    5,847
  symbols: 3,476

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-16	AAPL	Stock	6.7625	6.7986	6.7086	6.7161	431426800.0
2009-10-16	MSFT	Stock	26.45	26.63	26.1	26.5	56500900.0
2009-10-16	NVDA	Stock	0.334	0.335	0.3245	0.3305	1018832000.0
2009-10-16	AMZN	Stock	4.765	4.806	4.6805	4.766	140768000.0
2009-10-16	TLT	Stock	95.19	95.53	94.73	95.45	3716781.0
2009-10-16	ES	Stock	23.5	23.71	23.21	23.62	1587800.0
2009-10-16	CL	Stock	39.265	39.845	39.175	39.63	4797800.0
2009-10-16	A	Stock	19.6137	19.6638	19.2704	19.4635	4231327.0
2009-10-16	AABA-DELISTED	Stock	16.61	16.85	16.4	16.81	20361225.0
2009-10-16	AACC-DELISTED	Stock	7.04	7.18	7.0	7.13	35075.0
2009-10-16	AACG	Stock	5.94	5.94	5.94	5.94	100.0
2009-10-16	AAI-DELISTED	Stock	5.22	5.24	4.96	5.11	8892505.0
2009-10-16	AAIC-DELISTED	Stock	13.05	13.5	13.05	13.36	82769.0
2009-10-16	AAME	Stock	1.44	1.47	1.44	1.44	1000.0
2009-10-16	AAON	Stock	3.6978	3.763	3.6583	3.7156	258694.0
2009-10-16	AAP	Stock	39.22	39.76	39.02	39.65	1638700.0
2009-10-16	AATI-DELISTED	Stock	3.38	3.45	3.33	3.44	345057.0
2009-10-16	AAU-DELISTED	Stock	0.77	0.78	0.75	0.77	134850.0
2009-10-16	AAUAF-DELISTED	Stock	0.77	0.78	0.75	0.77	137350.0
2009-10-16	AAV-DELISTED	Stock	7.64	7.7	7.53	7.57	1219146.0
2009-10-16	AAWW-DELISTED	Stock	36.75	37.3	36.17	36.46	229253.0
2009-10-16	AAXJ	Stock	54.15	54.29	53.58	53.86	456989.0
2009-10-16	AAXN-DELISTED	Stock	4.63	4.66	4.53	4.61	264972.0
2009-10-16	AB	Stock	28.32	28.32	26.39	27.55	751500.0
2009-10-16	ABAX-DELISTED	Stock	24.53	24.61	24.0	24.22	235163.0
2009-10-16	ABB-DELISTED	Stock	21.45	21.5	21.2	21.42	2397288.0
2009-10-16	ABBC-DELISTED	Stock	7.58	7.67	7.48	7.48	35832.0
2009-10-16	ABBNY-DELISTED	Stock	21.45	21.5	21.2	21.43	2398688.0
2009-10-16	ABC-DELISTED	Stock	23.24	23.73	23.24	23.52	3452777.0
2009-10-16	ABCB	Stock	6.4493	6.6158	6.312	6.5962	17039.0
2009-10-16	ABCO-DELISTED	Stock	12.956	13.191	12.956	13.029	138475.0
2009-10-16	ABCW-DELISTED	Stock	1.2	1.2	1.14	1.15	58740.0
2009-10-16	ABD-DELISTED	Stock	7.23	7.62	6.9895	7.33	504460.0
2009-10-16	ABE-DELISTED	Stock	17.91	17.91	17.5	17.732	9095.0
2009-10-16	ABEO	Stock	4375.0	4375.0	4187.5	4237.5	25.0
2009-10-16	ABFS-DELISTED	Stock	29.95	30.38	29.54	29.9	883668.0
2009-10-16	ABG	Stock	13.91	14.19	13.49	13.86	175800.0
2009-10-16	ABII-DELISTED	Stock	37.46	38.49	36.93	37.88	30786.0
2009-10-16	ABK-DELISTED	Stock	1.42	1.43	1.38	1.38	8040132.0
2009-10-16	ABM	Stock	20.36	20.39	19.77	20.27	152100.0
2009-10-16	ABMD-DELISTED	Stock	10.79	10.96	10.68	10.92	254199.0
2009-10-16	ABR	Stock	2.62	2.67	2.56	2.64	149000.0
2009-10-16	ABT	Stock	24.7673	24.892	24.6281	24.6761	18110671.0
2009-10-16	ABTL-DELISTED	Stock	3.0	3.15	3.0	3.05	3643.0
2009-10-16	ABV-DELISTED	Stock	93.99	94.87	93.14	94.04	532256.0
2009-10-16	ABVA-DELISTED	Stock	2.3499	2.38	2.2095	2.38	655.0
2009-10-16	ABVT-DELISTED	Stock	50.85	51.57	49.32	50.13	66182.0
2009-10-16	ABX-DELISTED	Stock	38.69	39.315	38.42	38.64	13023700.0
2009-10-16	ACAD	Stock	1.81	1.82	1.72	1.78	716500.0
2009-10-16	ACAP-DELISTED	Stock	29.81	30.1	29.81	30.04	28990.0

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

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