PREVIEW / stock_daily / 2009-12-16

all stock daily files

  file:    by_date/stock_daily/2009/2009-12-16.parquet
  size:    189 KB
  rows:    5,911
  symbols: 3,496

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-12-16	AAPL	Stock	6.9679	7.0179	6.9482	6.9654	352984800.0
2009-12-16	MSFT	Stock	30.07	30.41	30.04	30.1	55737800.0
2009-12-16	NVDA	Stock	0.4053	0.4272	0.403	0.4228	1683400000.0
2009-12-16	AMZN	Stock	6.5465	6.5725	6.3825	6.418	205226000.0
2009-12-16	TLT	Stock	91.93	92.2501	91.36	91.68	3301591.0
2009-12-16	ES	Stock	25.93	26.0	25.65	25.83	1447200.0
2009-12-16	CL	Stock	42.345	42.52	42.165	42.31	4721600.0
2009-12-16	A	Stock	21.4592	21.5165	21.2232	21.2947	2867018.0
2009-12-16	AABA-DELISTED	Stock	15.58	15.82	15.47	15.81	20426814.0
2009-12-16	AACC-DELISTED	Stock	6.08	6.16	6.0	6.05	24530.0
2009-12-16	AACG	Stock	5.13	5.13	5.06	5.13	1900.0
2009-12-16	AAI-DELISTED	Stock	5.26	5.28	5.2	5.27	2298046.0
2009-12-16	AAIC-DELISTED	Stock	14.99	15.45	14.87	15.45	31753.0
2009-12-16	AAON	Stock	3.7985	3.8044	3.7649	3.7985	292106.0
2009-12-16	AAP	Stock	40.68	41.01	40.57	40.72	954900.0
2009-12-16	AATI-DELISTED	Stock	3.67	3.76	3.605	3.7	361752.0
2009-12-16	AAU-DELISTED	Stock	1.05	1.12	1.05	1.08	199105.0
2009-12-16	AAUAF-DELISTED	Stock	1.05	1.12	1.05	1.08	199505.0
2009-12-16	AAV-DELISTED	Stock	6.13	6.47	6.13	6.4	880884.0
2009-12-16	AAWW-DELISTED	Stock	35.54	37.4	35.52	37.18	554397.0
2009-12-16	AAXJ	Stock	55.6	55.709	55.35	55.53	193215.0
2009-12-16	AAXN-DELISTED	Stock	4.47	4.58	4.44	4.5	433030.0
2009-12-16	AB	Stock	26.58	27.35	26.58	26.99	483300.0
2009-12-16	ABAX-DELISTED	Stock	23.61	23.96	23.38	23.77	185685.0
2009-12-16	ABB-DELISTED	Stock	18.33	18.5	18.22	18.27	5400897.0
2009-12-16	ABBC-DELISTED	Stock	6.72	6.89	6.645	6.71	57191.0
2009-12-16	ABBNY-DELISTED	Stock	18.33	18.5	18.22	18.27	6236386.0
2009-12-16	ABC-DELISTED	Stock	26.17	26.58	26.08	26.13	6291078.0
2009-12-16	ABCB	Stock	6.7531	6.7825	6.6354	6.704	26730.0
2009-12-16	ABCD-DELISTED	Stock	3.94	4.75	3.94	4.75	2883.0
2009-12-16	ABCO-DELISTED	Stock	13.86	14.085	13.6	13.74	191356.0
2009-12-16	ABCW-DELISTED	Stock	0.5897	0.6073	0.5603	0.57	121920.0
2009-12-16	ABD-DELISTED	Stock	7.36	7.55	7.14	7.54	714530.0
2009-12-16	ABE-DELISTED	Stock	16.8459	16.9	16.66	16.66	5228.0
2009-12-16	ABEO	Stock	3812.5	4187.5	3750.0	4000.0	60.0
2009-12-16	ABFS-DELISTED	Stock	28.42	28.87	27.97	28.14	354187.0
2009-12-16	ABG	Stock	11.44	11.74	11.29	11.68	720000.0
2009-12-16	ABII-DELISTED	Stock	38.2	38.43	36.52	37.2	28337.0
2009-12-16	ABK-DELISTED	Stock	0.83	0.84	0.8	0.82	4909721.0
2009-12-16	ABM	Stock	20.18	20.3	19.75	19.98	197500.0
2009-12-16	ABMD-DELISTED	Stock	8.38	8.44	7.9	8.1	1058324.0
2009-12-16	ABR	Stock	1.77	1.78	1.71	1.76	74400.0
2009-12-16	ABT	Stock	26.0292	26.1251	25.7988	25.8516	11245727.0
2009-12-16	ABTL-DELISTED	Stock	5.1	5.25	4.3	5.05	15387.0
2009-12-16	ABV-DELISTED	Stock	98.19	98.87	97.09	97.22	223015.0
2009-12-16	ABVA-DELISTED	Stock	2.73	2.73	2.47	2.47	915.0
2009-12-16	ABVT-DELISTED	Stock	60.65	62.47	60.62	61.71	142732.0
2009-12-16	ABX-DELISTED	Stock	39.61	40.38	39.51	39.95	15501447.0
2009-12-16	ACAD	Stock	1.34	1.49	1.28	1.4	2597100.0
2009-12-16	ACAP-DELISTED	Stock	29.2	29.46	28.86	29.23	51763.0

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

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