PREVIEW / stock_daily / 2011-01-25

all stock daily files

  file:    by_date/stock_daily/2011/2011-01-25.parquet
  size:    196 KB
  rows:    6,064
  symbols: 3,551

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
2011-01-25	AAPL	Stock	12.0118	12.1943	11.9489	12.1929	546868000.0
2011-01-25	MSFT	Stock	28.14	28.45	28.12	28.45	42436600.0
2011-01-25	NVDA	Stock	0.6155	0.622	0.5952	0.5992	1086856000.0
2011-01-25	AMZN	Stock	8.775	8.8375	8.714	8.835	93020000.0
2011-01-25	TSLA	Stock	1.6433	1.6593	1.6013	1.6453	19072500.0
2011-01-25	TLT	Stock	91.94	92.9	91.32	92.43	13442365.0
2011-01-25	ES	Stock	32.78	33.05	32.76	33.04	1355200.0
2011-01-25	CL	Stock	39.94	40.18	39.725	40.06	5345200.0
2011-01-25	A	Stock	30.5937	31.1302	30.2432	30.5365	4379654.0
2011-01-25	AABA-DELISTED	Stock	16.17	16.19	15.85	16.03	25759936.0
2011-01-25	AACC-DELISTED	Stock	5.99	6.19	5.99	6.19	14531.0
2011-01-25	AACG	Stock	4.23	4.23	4.23	4.23	2500.0
2011-01-25	AAI-DELISTED	Stock	7.51	7.52	7.46	7.47	1303029.0
2011-01-25	AAIC-DELISTED	Stock	24.09	24.33	24.09	24.31	30822.0
2011-01-25	AAME	Stock	2.2	2.25	2.19	2.19	2300.0
2011-01-25	AAON	Stock	5.3215	5.3353	5.2484	5.3077	90112.0
2011-01-25	AAP	Stock	63.46	64.14	62.94	64.02	747600.0
2011-01-25	AAT	Stock	21.2	21.47	21.15	21.27	295700.0
2011-01-25	AATI-DELISTED	Stock	4.23	4.23	4.1	4.13	96013.0
2011-01-25	AAU-DELISTED	Stock	3.72	3.72	3.54	3.56	507782.0
2011-01-25	AAUAF-DELISTED	Stock	3.69	3.69	3.51	3.56	512304.0
2011-01-25	AAV-DELISTED	Stock	7.19	7.23	7.02	7.09	345706.0
2011-01-25	AAWW-DELISTED	Stock	51.82	51.99	51.0	51.58	193316.0
2011-01-25	AAXJ	Stock	62.35	62.37	61.88	62.31	451824.0
2011-01-25	AAXN-DELISTED	Stock	4.6	4.61	4.15	4.21	1816951.0
2011-01-25	AB	Stock	21.3	21.46	21.12	21.26	614500.0
2011-01-25	ABAC-DELISTED	Stock	5.77	5.7701	5.52	5.71	36010.0
2011-01-25	ABAX-DELISTED	Stock	26.65	26.89	26.309	26.79	62393.0
2011-01-25	ABB-DELISTED	Stock	23.63	23.79	23.42	23.79	2346024.0
2011-01-25	ABBC-DELISTED	Stock	11.25	11.48	11.21	11.48	26623.0
2011-01-25	ABBNY-DELISTED	Stock	23.63	23.8	23.42	23.8	2346604.0
2011-01-25	ABC-DELISTED	Stock	36.19	36.31	35.75	35.94	2396656.0
2011-01-25	ABCB	Stock	9.83	10.07	9.83	9.97	23800.0
2011-01-25	ABCD-DELISTED	Stock	3.21	3.27	3.2	3.22	17102.0
2011-01-25	ABCO-DELISTED	Stock	24.0	24.42	23.21	24.35	525757.0
2011-01-25	ABCW-DELISTED	Stock	1.3303	1.3796	1.3303	1.35	66220.0
2011-01-25	ABD-DELISTED	Stock	8.055	8.315	7.965	8.305	217750.0
2011-01-25	ABE-DELISTED	Stock	18.81	18.9	18.76	18.8559	32019.0
2011-01-25	ABEO	Stock	3000.0	3200.0	3000.0	3200.0	27.0
2011-01-25	ABFS-DELISTED	Stock	25.9	26.42	25.74	26.07	102101.0
2011-01-25	ABG	Stock	18.16	18.36	17.97	18.33	99500.0
2011-01-25	ABH-DELISTED	Stock	28.58	29.1	28.02	29.0	658462.0
2011-01-25	ABM	Stock	25.46	25.46	24.9	25.33	337900.0
2011-01-25	ABMD-DELISTED	Stock	9.8	9.97	9.78	9.96	185852.0
2011-01-25	ABR	Stock	5.66	5.83	5.63	5.81	45400.0
2011-01-25	ABT	Stock	23.1072	23.1264	22.9296	23.0112	20015840.0
2011-01-25	ABTL-DELISTED	Stock	4.45	4.56	4.275	4.45	7602.0
2011-01-25	ABUS	Stock	6.87	7.09	6.83	6.95	34600.0
2011-01-25	ABV-DELISTED	Stock	27.65	27.81	26.8	27.8	2203273.0
2011-01-25	ABVA-DELISTED	Stock	4.301	5.0	4.301	4.93	8069.0

> showing 50 of 6,064 rows — these rows as CSV

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