PREVIEW / stock_daily / 2009-10-09

all stock daily files

  file:    by_date/stock_daily/2009/2009-10-09.parquet
  size:    186 KB
  rows:    5,833
  symbols: 3,465

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-09	AAPL	Stock	6.7489	6.8107	6.7364	6.8025	293272000.0
2009-10-09	MSFT	Stock	25.57	25.79	25.46	25.55	39520000.0
2009-10-09	NVDA	Stock	0.3478	0.3548	0.3473	0.3542	618540000.0
2009-10-09	AMZN	Stock	4.75	4.7975	4.713	4.7855	93880000.0
2009-10-09	TLT	Stock	97.62	97.71	95.5	95.9	8135818.0
2009-10-09	ES	Stock	23.46	23.58	23.45	23.5	1259100.0
2009-10-09	CL	Stock	39.42	39.425	39.15	39.355	3933200.0
2009-10-09	A	Stock	19.5923	19.6996	19.5708	19.6495	2916647.0
2009-10-09	AABA-DELISTED	Stock	17.44	17.48	16.84	16.86	28655837.0
2009-10-09	AACC-DELISTED	Stock	7.395	7.51	7.13	7.22	37750.0
2009-10-09	AACG	Stock	6.05	6.05	6.05	6.05	300.0
2009-10-09	AAI-DELISTED	Stock	5.25	5.3	5.11	5.2	6911107.0
2009-10-09	AAIC-DELISTED	Stock	11.02	11.5	11.02	11.3801	60166.0
2009-10-09	AAME	Stock	1.33	1.49	1.3	1.3	19300.0
2009-10-09	AAON	Stock	3.6523	3.7195	3.603	3.6938	598894.0
2009-10-09	AAP	Stock	38.28	38.76	37.72	38.47	2695700.0
2009-10-09	AATI-DELISTED	Stock	3.2	3.23	3.15	3.17	603820.0
2009-10-09	AAU-DELISTED	Stock	0.79	0.839	0.76	0.8	682391.0
2009-10-09	AAUAF-DELISTED	Stock	0.79	0.839	0.76	0.8	678607.0
2009-10-09	AAV-DELISTED	Stock	6.99	7.24	6.94	7.18	1199889.0
2009-10-09	AAWW-DELISTED	Stock	33.8	34.23	33.38	34.13	236634.0
2009-10-09	AAXJ	Stock	53.02	53.5	52.94	53.5	353391.0
2009-10-09	AAXN-DELISTED	Stock	4.51	4.58	4.5	4.57	160637.0
2009-10-09	AB	Stock	27.07	28.6	27.01	27.98	647900.0
2009-10-09	ABAX-DELISTED	Stock	27.01	27.32	26.48	26.49	155766.0
2009-10-09	ABB-DELISTED	Stock	20.66	20.84	20.58	20.75	1980595.0
2009-10-09	ABBC-DELISTED	Stock	7.97	7.97	7.81	7.94	33358.0
2009-10-09	ABBNY-DELISTED	Stock	20.66	20.84	20.58	20.72	1982056.0
2009-10-09	ABC-DELISTED	Stock	22.39	22.72	22.15	22.61	3006549.0
2009-10-09	ABCB	Stock	6.7236	6.9589	6.4689	6.8707	26119.0
2009-10-09	ABCO-DELISTED	Stock	13.15	13.18	12.975	13.165	59958.0
2009-10-09	ABCW-DELISTED	Stock	1.321	1.321	1.28	1.28	20790.0
2009-10-09	ABD-DELISTED	Stock	7.29	7.76	7.23	7.42	238620.0
2009-10-09	ABE-DELISTED	Stock	17.48	17.75	17.44	17.52	14265.0
2009-10-09	ABEO	Stock	4287.5	4375.0	4262.5	4375.0	62.0
2009-10-09	ABFS-DELISTED	Stock	28.96	29.28	28.24	28.91	682582.0
2009-10-09	ABG	Stock	12.84	13.17	12.84	13.05	217100.0
2009-10-09	ABII-DELISTED	Stock	38.5	38.5	37.48	38.21	24610.0
2009-10-09	ABK-DELISTED	Stock	1.5	1.51	1.43	1.49	8608622.0
2009-10-09	ABM	Stock	20.27	20.67	20.24	20.6	106800.0
2009-10-09	ABMD-DELISTED	Stock	10.24	10.59	10.08	10.57	218469.0
2009-10-09	ABR	Stock	2.71	2.97	2.67	2.8	326900.0
2009-10-09	ABT	Stock	24.014	24.2059	23.9468	24.0284	11378074.0
2009-10-09	ABTL-DELISTED	Stock	3.5017	3.6684	3.4461	3.5	4633.0
2009-10-09	ABV-DELISTED	Stock	90.11	91.0	89.81	90.88	276359.0
2009-10-09	ABVA-DELISTED	Stock	2.48	2.48	2.48	2.48	250.0
2009-10-09	ABVT-DELISTED	Stock	49.03	49.03	48.35	48.89	75960.0
2009-10-09	ABX-DELISTED	Stock	39.3	39.8916	38.95	39.49	11438938.0
2009-10-09	ACAD	Stock	1.79	1.81	1.72	1.77	747900.0
2009-10-09	ACAP-DELISTED	Stock	29.29	29.74	29.22	29.42	51719.0

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

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