PREVIEW / stock_daily / 2011-12-07

all stock daily files

  file:    by_date/stock_daily/2011/2011-12-07.parquet
  size:    196 KB
  rows:    6,108
  symbols: 3,528

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-12-07	AAPL	Stock	13.9261	13.9621	13.8129	13.8961	304746400.0
2011-12-07	MSFT	Stock	25.67	25.76	25.34	25.6	62667000.0
2011-12-07	NVDA	Stock	0.379	0.382	0.3713	0.3793	510016000.0
2011-12-07	AMZN	Stock	9.5515	9.8355	9.456	9.766	128546000.0
2011-12-07	TSLA	Stock	2.3087	2.326	2.2533	2.2793	10114500.0
2011-12-07	TLT	Stock	117.33	118.24	116.85	117.69	6588269.0
2011-12-07	ES	Stock	34.21	34.33	33.97	34.21	1587300.0
2011-12-07	CL	Stock	45.29	45.785	44.95	45.6	3932000.0
2011-12-07	A	Stock	26.2303	26.4664	25.4721	26.2232	4219024.0
2011-12-07	AABA-DELISTED	Stock	15.82	15.86	15.56	15.61	19446567.0
2011-12-07	AACC-DELISTED	Stock	3.46	3.47	3.41	3.41	13450.0
2011-12-07	AACG	Stock	9.55	9.67	9.55	9.55	4000.0
2011-12-07	AAIC-DELISTED	Stock	20.4	21.45	20.4	21.29	76622.0
2011-12-07	AAME	Stock	1.99	1.99	1.95	1.99	8700.0
2011-12-07	AAON	Stock	6.4059	6.4889	6.317	6.3674	314550.0
2011-12-07	AAP	Stock	69.7	70.31	69.63	70.0	610600.0
2011-12-07	AAT	Stock	20.37	20.46	20.03	20.42	465900.0
2011-12-07	AATI-DELISTED	Stock	5.74	5.75	5.73	5.745	797977.0
2011-12-07	AAU-DELISTED	Stock	2.66	2.67	2.52	2.54	110578.0
2011-12-07	AAUAF-DELISTED	Stock	2.66	2.66	2.52	2.54	113087.0
2011-12-07	AAV-DELISTED	Stock	4.63	4.64	4.4097	4.43	374802.0
2011-12-07	AAWW-DELISTED	Stock	39.43	41.27	38.86	40.5	278703.0
2011-12-07	AAXJ	Stock	52.22	52.52	51.8	52.37	481251.0
2011-12-07	AAXN-DELISTED	Stock	6.34	6.44	6.3	6.36	397623.0
2011-12-07	AB	Stock	13.41	13.52	13.26	13.38	464700.0
2011-12-07	ABAC-DELISTED	Stock	1.51	1.56	1.45	1.46	27596.0
2011-12-07	ABAX-DELISTED	Stock	28.29	28.464	27.92	28.37	78319.0
2011-12-07	ABB-DELISTED	Stock	18.7	19.12	18.57	19.04	3365717.0
2011-12-07	ABBNY-DELISTED	Stock	18.7	19.12	18.57	19.03	3465217.0
2011-12-07	ABC-DELISTED	Stock	36.32	36.78	36.22	36.57	2920494.0
2011-12-07	ABCB	Stock	10.24	10.34	10.12	10.23	29600.0
2011-12-07	ABCD-DELISTED	Stock	2.94	3.01	2.88	3.0	29664.0
2011-12-07	ABCO-DELISTED	Stock	36.72	37.12	36.57	36.82	129359.0
2011-12-07	ABCW-DELISTED	Stock	0.3916	0.4217	0.3765	0.3916	72640.0
2011-12-07	ABD-DELISTED	Stock	9.51	9.92	9.36	9.84	372200.0
2011-12-07	ABE-DELISTED	Stock	17.82	18.0	17.8	17.97	5197.0
2011-12-07	ABEO	Stock	1787.5	1850.0	1625.0	1750.0	14.0
2011-12-07	ABFS-DELISTED	Stock	19.13	19.44	18.77	19.27	250717.0
2011-12-07	ABG	Stock	20.35	20.65	19.89	20.51	299100.0
2011-12-07	ABH-DELISTED	Stock	15.11	15.37	15.09	15.27	144154.0
2011-12-07	ABM	Stock	21.31	21.46	20.93	21.3	3271900.0
2011-12-07	ABMD-DELISTED	Stock	20.42	20.73	19.92	20.54	189157.0
2011-12-07	ABR	Stock	3.31	3.32	3.2	3.31	31700.0
2011-12-07	ABT	Stock	26.0963	26.3314	25.938	26.2451	18115048.0
2011-12-07	ABTL-DELISTED	Stock	3.85	3.85	3.725	3.8	2860.0
2011-12-07	ABUS	Stock	1.64	1.65	1.64	1.65	2100.0
2011-12-07	ABV-DELISTED	Stock	35.02	35.95	34.87	35.87	2447908.0
2011-12-07	ABVA-DELISTED	Stock	3.856	3.86	3.8	3.82	5867.0
2011-12-07	ABVT-DELISTED	Stock	62.51	62.97	61.2	62.43	104567.0
2011-12-07	ABX-DELISTED	Stock	51.2	51.39	50.61	51.17	4818714.0

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

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