PREVIEW / stock_daily / 2009-11-23

all stock daily files

  file:    by_date/stock_daily/2009/2009-11-23.parquet
  size:    187 KB
  rows:    5,866
  symbols: 3,484

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-11-23	AAPL	Stock	7.25	7.3571	7.2482	7.3529	474896800.0
2009-11-23	MSFT	Stock	29.84	30.01	29.7	29.94	41832700.0
2009-11-23	NVDA	Stock	0.3273	0.3333	0.3235	0.325	390924000.0
2009-11-23	AMZN	Stock	6.5525	6.65	6.55	6.65	137562000.0
2009-11-23	TLT	Stock	94.54	95.1	94.34	95.0	3219280.0
2009-11-23	ES	Stock	24.16	24.51	23.95	24.25	1327900.0
2009-11-23	CL	Stock	42.31	42.55	42.18	42.285	4478200.0
2009-11-23	A	Stock	20.9728	21.123	20.8155	20.9442	2347382.0
2009-11-23	AABA-DELISTED	Stock	15.58	15.65	15.34	15.45	21820425.0
2009-11-23	AACC-DELISTED	Stock	5.6	5.82	5.59	5.76	29304.0
2009-11-23	AACG	Stock	4.95	5.35	4.77	5.24	30400.0
2009-11-23	AAI-DELISTED	Stock	4.17	4.2501	4.09	4.15	3170659.0
2009-11-23	AAIC-DELISTED	Stock	13.75	13.75	12.48	13.2	13579.0
2009-11-23	AAME	Stock	1.25	1.26	1.25	1.25	1400.0
2009-11-23	AAON	Stock	3.8874	3.9743	3.8657	3.8933	363487.0
2009-11-23	AAP	Stock	39.92	40.42	39.02	39.39	2084700.0
2009-11-23	AATI-DELISTED	Stock	3.22	3.38	3.2	3.36	210425.0
2009-11-23	AAU-DELISTED	Stock	0.79	0.79	0.76	0.76	85913.0
2009-11-23	AAUAF-DELISTED	Stock	0.79	0.79	0.76	0.76	87013.0
2009-11-23	AAV-DELISTED	Stock	5.78	5.94	5.78	5.85	828941.0
2009-11-23	AAWW-DELISTED	Stock	30.59	31.2	30.28	30.85	459388.0
2009-11-23	AAXJ	Stock	55.79	56.5	55.79	56.15	96221.0
2009-11-23	AAXN-DELISTED	Stock	4.12	4.37	4.12	4.2	663000.0
2009-11-23	AB	Stock	26.9	26.9	26.5	26.85	333500.0
2009-11-23	ABAX-DELISTED	Stock	22.86	23.66	22.86	23.12	106034.0
2009-11-23	ABB-DELISTED	Stock	19.29	19.36	18.98	19.06	3872253.0
2009-11-23	ABBC-DELISTED	Stock	6.88	7.16	6.88	6.94	35117.0
2009-11-23	ABBNY-DELISTED	Stock	19.29	19.36	18.98	19.07	3985463.0
2009-11-23	ABC-DELISTED	Stock	24.89	25.11	24.67	24.99	4598275.0
2009-11-23	ABCB	Stock	6.214	6.4493	6.1258	6.1748	48565.0
2009-11-23	ABCO-DELISTED	Stock	12.475	12.603	12.295	12.425	166666.0
2009-11-23	ABCW-DELISTED	Stock	0.6305	0.7245	0.5811	0.6295	267810.0
2009-11-23	ABD-DELISTED	Stock	6.26	6.8003	6.24	6.38	322950.0
2009-11-23	ABE-DELISTED	Stock	16.84	16.98	16.84	16.89	11833.0
2009-11-23	ABEO	Stock	3812.5	3912.5	3462.5	3875.0	30.0
2009-11-23	ABFS-DELISTED	Stock	25.15	25.82	24.94	25.36	339610.0
2009-11-23	ABG	Stock	9.95	10.25	9.88	9.98	314000.0
2009-11-23	ABII-DELISTED	Stock	33.8	34.13	33.26	33.47	22323.0
2009-11-23	ABK-DELISTED	Stock	0.94	1.0	0.9	0.9003	12615780.0
2009-11-23	ABM	Stock	19.07	19.56	19.07	19.34	129100.0
2009-11-23	ABMD-DELISTED	Stock	8.28	8.56	8.28	8.55	149049.0
2009-11-23	ABR	Stock	1.85	1.89	1.85	1.86	252800.0
2009-11-23	ABT	Stock	25.7749	25.8324	25.4198	25.4918	19443727.0
2009-11-23	ABTL-DELISTED	Stock	4.4	4.85	4.4	4.75	26521.0
2009-11-23	ABV-DELISTED	Stock	100.08	100.78	97.79	98.99	629466.0
2009-11-23	ABVA-DELISTED	Stock	2.15	2.689	2.01	2.15	4732.0
2009-11-23	ABVT-DELISTED	Stock	53.47	54.508	53.2001	54.05	195568.0
2009-11-23	ABX-DELISTED	Stock	45.34	45.82	43.66	43.85	15305074.0
2009-11-23	ACAD	Stock	1.33	1.39	1.3	1.34	253000.0
2009-11-23	ACAP-DELISTED	Stock	27.82	28.36	27.57	27.82	28966.0

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

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