PREVIEW / stock_daily / 2009-11-27

all stock daily files

  file:    by_date/stock_daily/2009/2009-11-27.parquet
  size:    180 KB
  rows:    5,702
  symbols: 3,376

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-27	AAPL	Stock	7.115	7.2486	7.0846	7.1639	295257200.0
2009-11-27	MSFT	Stock	29.11	29.39	28.75	29.22	29357900.0
2009-11-27	NVDA	Stock	0.315	0.3235	0.3133	0.3198	279932000.0
2009-11-27	AMZN	Stock	6.515	6.65	6.494	6.587	88452000.0
2009-11-27	TLT	Stock	96.4	96.56	96.09	96.4	2249046.0
2009-11-27	ES	Stock	24.01	24.17	23.82	24.0	527600.0
2009-11-27	CL	Stock	41.675	42.08	41.05	41.815	2629200.0
2009-11-27	A	Stock	20.3577	20.8083	20.0358	20.6366	1289655.0
2009-11-27	AABA-DELISTED	Stock	15.04	15.09	14.88	15.0	11286838.0
2009-11-27	AACC-DELISTED	Stock	5.62	5.83	5.62	5.75	20643.0
2009-11-27	AACG	Stock	4.71	5.25	4.71	5.01	17800.0
2009-11-27	AAI-DELISTED	Stock	4.05	4.23	4.05	4.13	2404104.0
2009-11-27	AAIC-DELISTED	Stock	12.25	13.35	12.25	13.24	9142.0
2009-11-27	AAME	Stock	1.27	1.27	1.27	1.27	600.0
2009-11-27	AAON	Stock	3.7156	3.8183	3.7156	3.7551	128587.0
2009-11-27	AAP	Stock	38.67	39.94	38.44	39.45	767200.0
2009-11-27	AATI-DELISTED	Stock	3.31	3.43	3.31	3.31	100744.0
2009-11-27	AAU-DELISTED	Stock	0.73	0.77	0.73	0.75	103020.0
2009-11-27	AAUAF-DELISTED	Stock	0.73	0.77	0.73	0.75	104520.0
2009-11-27	AAV-DELISTED	Stock	5.56	5.79	5.47	5.69	384879.0
2009-11-27	AAWW-DELISTED	Stock	29.24	30.18	29.16	29.8	218989.0
2009-11-27	AAXJ	Stock	54.0	54.45	53.2	53.98	145195.0
2009-11-27	AAXN-DELISTED	Stock	4.2	4.37	4.15	4.27	296022.0
2009-11-27	AB	Stock	25.71	25.77	25.22	25.5	211600.0
2009-11-27	ABAX-DELISTED	Stock	23.15	23.68	22.35	22.42	144948.0
2009-11-27	ABB-DELISTED	Stock	18.25	18.619	18.18	18.5	1973887.0
2009-11-27	ABBC-DELISTED	Stock	6.59	6.7	6.55	6.55	26896.0
2009-11-27	ABBNY-DELISTED	Stock	18.25	18.619	18.18	18.5	1979457.0
2009-11-27	ABC-DELISTED	Stock	24.67	25.04	24.49	24.89	1353570.0
2009-11-27	ABCB	Stock	6.3022	6.5178	6.2924	6.3708	42648.0
2009-11-27	ABCO-DELISTED	Stock	12.83	13.2	12.83	12.965	84518.0
2009-11-27	ABCW-DELISTED	Stock	0.595	0.6051	0.575	0.59	88960.0
2009-11-27	ABD-DELISTED	Stock	6.17	6.24	5.98	6.0	169230.0
2009-11-27	ABE-DELISTED	Stock	16.37	16.615	15.96	16.56	13711.0
2009-11-27	ABEO	Stock	3812.5	3912.5	3687.5	3912.5	9.0
2009-11-27	ABFS-DELISTED	Stock	24.22	24.87	24.0101	24.13	128255.0
2009-11-27	ABG	Stock	10.61	10.74	10.25	10.65	181200.0
2009-11-27	ABII-DELISTED	Stock	33.49	35.81	32.4	35.45	18902.0
2009-11-27	ABK-DELISTED	Stock	0.79	0.82	0.77	0.81	5184234.0
2009-11-27	ABM	Stock	18.53	18.88	18.47	18.53	62600.0
2009-11-27	ABMD-DELISTED	Stock	8.74	8.93	8.67	8.7	73581.0
2009-11-27	ABR	Stock	1.75	1.8	1.75	1.78	42700.0
2009-11-27	ABT	Stock	25.6645	26.0723	25.5685	25.9476	6023135.0
2009-11-27	ABTL-DELISTED	Stock	4.9	4.9	4.65	4.75	2479.0
2009-11-27	ABV-DELISTED	Stock	96.09	99.37	96.0	98.48	374543.0
2009-11-27	ABVT-DELISTED	Stock	51.94	52.98	51.48	52.79	68050.0
2009-11-27	ABX-DELISTED	Stock	42.03	43.46	41.7	42.61	7194131.0
2009-11-27	ACAD	Stock	1.24	1.32	1.24	1.29	152400.0
2009-11-27	ACAP-DELISTED	Stock	27.75	28.27	27.7	27.82	25673.0
2009-11-27	ACAS-DELISTED	Stock	2.89	2.94	2.85	2.88	2271441.0

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

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