PREVIEW / stock_daily / 2012-10-08

all stock daily files

  file:    by_date/stock_daily/2012/2012-10-08.parquet
  size:    197 KB
  rows:    6,107
  symbols: 3,454

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
2012-10-08	AAPL	Stock	23.1029	23.1271	22.7182	22.7918	637994000.0
2012-10-08	MSFT	Stock	29.64	29.92	29.55	29.78	29752000.0
2012-10-08	NVDA	Stock	0.3313	0.3328	0.3268	0.3293	240596000.0
2012-10-08	AMZN	Stock	12.8835	12.99	12.778	12.953	35246000.0
2012-10-08	META	Stock	20.4	20.75	20.16	20.4	32236700.0
2012-10-08	TSLA	Stock	1.924	1.96	1.9073	1.95	13345500.0
2012-10-08	TLT	Stock	121.98	122.27	121.686	122.17	1568391.0
2012-10-08	ES	Stock	39.13	39.22	38.91	39.1	1073200.0
2012-10-08	CL	Stock	54.18	54.41	53.975	54.245	1822200.0
2012-10-08	A	Stock	27.6037	27.8326	27.5393	27.6538	3770406.0
2012-10-08	AABA-DELISTED	Stock	16.02	16.16	16.0	16.035	11663562.0
2012-10-08	AACC-DELISTED	Stock	7.91	7.97	7.69	7.78	5212.0
2012-10-08	AACG	Stock	5.1	5.1	4.92	4.92	4500.0
2012-10-08	AAIC-DELISTED	Stock	24.04	24.04	23.88	23.91	66668.0
2012-10-08	AAME	Stock	2.77	2.94	2.71	2.94	36100.0
2012-10-08	AAMRQ-DELISTED	Stock	0.389	0.395	0.387	0.395	461081.0
2012-10-08	AAON	Stock	5.7778	5.8874	5.7778	5.7956	25313.0
2012-10-08	AAP	Stock	69.65	71.07	69.46	70.59	668000.0
2012-10-08	AAT	Stock	27.66	27.81	27.59	27.64	161400.0
2012-10-08	AAU-DELISTED	Stock	2.5	2.64	2.47	2.48	115818.0
2012-10-08	AAUAF-DELISTED	Stock	2.5	2.62	2.45	2.48	117360.0
2012-10-08	AAV-DELISTED	Stock	3.92	3.92	3.84	3.85	119970.0
2012-10-08	AAWW-DELISTED	Stock	52.5	52.68	51.89	51.95	190605.0
2012-10-08	AAXJ	Stock	56.52	56.75	56.5	56.67	237493.0
2012-10-08	AAXN-DELISTED	Stock	5.9	6.02	5.88	5.99	435809.0
2012-10-08	AB	Stock	15.5	15.63	15.37	15.56	161600.0
2012-10-08	ABAC-DELISTED	Stock	1.44	1.57	1.4208	1.57	7248.0
2012-10-08	ABAX-DELISTED	Stock	37.67	37.9	36.994	37.01	41053.0
2012-10-08	ABB-DELISTED	Stock	19.24	19.29	19.17	19.22	1657944.0
2012-10-08	ABBNY-DELISTED	Stock	19.24	19.29	19.17	19.21	1754261.0
2012-10-08	ABC-DELISTED	Stock	39.47	39.87	39.35	39.79	1199087.0
2012-10-08	ABCB	Stock	12.56	12.6	12.42	12.5	23600.0
2012-10-08	ABCD-DELISTED	Stock	0.98	1.05	0.98	0.99	5087.0
2012-10-08	ABCO-DELISTED	Stock	47.98	48.12	47.14	47.71	219489.0
2012-10-08	ABCW-DELISTED	Stock	0.38	0.4	0.38	0.39	26544.0
2012-10-08	ABE-DELISTED	Stock	20.85	20.85	20.6735	20.76	2938.0
2012-10-08	ABEO	Stock	500.0	500.0	487.5	487.5	11.0
2012-10-08	ABFS-DELISTED	Stock	7.84	8.04	7.79	7.93	193001.0
2012-10-08	ABG	Stock	29.63	31.33	29.54	31.06	396000.0
2012-10-08	ABM	Stock	18.43	18.48	18.15	18.3	496500.0
2012-10-08	ABMD-DELISTED	Stock	20.6	20.778	20.33	20.5	331900.0
2012-10-08	ABR	Stock	5.66	5.76	5.66	5.75	541600.0
2012-10-08	ABT	Stock	34.2913	34.3345	33.9938	34.2193	7843476.0
2012-10-08	ABTL-DELISTED	Stock	3.86	3.93	3.86	3.9	17500.0
2012-10-08	ABUS	Stock	3.79	3.83	3.76	3.83	3800.0
2012-10-08	ABV-DELISTED	Stock	40.23	41.29	40.18	41.14	2073820.0
2012-10-08	ABVA-DELISTED	Stock	4.64	4.64	4.64	4.64	188.0
2012-10-08	ABX-DELISTED	Stock	41.53	41.7	41.06	41.38	3312307.0
2012-10-08	ACAD	Stock	2.62	2.79	2.58	2.59	1950900.0
2012-10-08	ACAS-DELISTED	Stock	11.77	11.86	11.76	11.81	1377762.0

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

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