PREVIEW / stock_daily / 2012-08-31

all stock daily files

  file:    by_date/stock_daily/2012/2012-08-31.parquet
  size:    199 KB
  rows:    6,130
  symbols: 3,476

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-08-31	AAPL	Stock	23.8304	23.8786	23.4732	23.7586	338321200.0
2012-08-31	MSFT	Stock	30.6	30.96	30.38	30.82	36590100.0
2012-08-31	NVDA	Stock	0.3538	0.3562	0.3473	0.3508	485064000.0
2012-08-31	AMZN	Stock	12.4035	12.4725	12.275	12.4135	66950000.0
2012-08-31	META	Stock	18.68	18.7	18.03	18.06	58764200.0
2012-08-31	TSLA	Stock	1.9073	1.9227	1.88	1.9013	8097000.0
2012-08-31	TLT	Stock	125.78	127.72	125.73	127.72	9192610.0
2012-08-31	ES	Stock	37.82	37.9	37.52	37.67	1958300.0
2012-08-31	CL	Stock	53.075	53.26	52.88	53.155	2697200.0
2012-08-31	A	Stock	26.7024	26.824	26.3662	26.5808	3210367.0
2012-08-31	AABA-DELISTED	Stock	14.79	14.82	14.59	14.645	11457180.0
2012-08-31	AACC-DELISTED	Stock	6.51	6.53	6.3	6.49	20136.0
2012-08-31	AACG	Stock	4.55	4.55	4.36	4.36	1500.0
2012-08-31	AAIC-DELISTED	Stock	22.96	22.99	22.74	22.9	76279.0
2012-08-31	AAME	Stock	2.73	2.75	2.7	2.75	1800.0
2012-08-31	AAMRQ-DELISTED	Stock	0.458	0.47	0.452	0.4698	1719353.0
2012-08-31	AAON	Stock	5.4696	5.4785	5.4222	5.4519	97538.0
2012-08-31	AAP	Stock	71.5	71.71	70.56	71.12	377500.0
2012-08-31	AAT	Stock	27.36	27.36	26.83	27.26	132500.0
2012-08-31	AAU-DELISTED	Stock	2.5	2.73	2.5	2.73	221642.0
2012-08-31	AAUAF-DELISTED	Stock	2.5	2.74	2.5	2.73	236520.0
2012-08-31	AAV-DELISTED	Stock	3.48	3.52	3.43	3.48	79057.0
2012-08-31	AAWW-DELISTED	Stock	51.92	51.92	50.99	51.53	245876.0
2012-08-31	AAXJ	Stock	53.1	53.33	52.76	53.1	295169.0
2012-08-31	AAXN-DELISTED	Stock	5.54	5.54	5.34	5.36	426194.0
2012-08-31	AB	Stock	14.71	14.74	14.27	14.32	286700.0
2012-08-31	ABAC-DELISTED	Stock	1.18	1.19	1.0401	1.0438	4100.0
2012-08-31	ABAX-DELISTED	Stock	38.1	38.1	37.0	37.5	91811.0
2012-08-31	ABB-DELISTED	Stock	17.47	17.48	17.23	17.32	1426214.0
2012-08-31	ABBNY-DELISTED	Stock	17.47	17.48	17.23	17.32	1452702.0
2012-08-31	ABC-DELISTED	Stock	38.18	38.97	37.98	38.51	2954426.0
2012-08-31	ABCB	Stock	12.1	12.1	11.85	11.87	30200.0
2012-08-31	ABCD-DELISTED	Stock	1.04	1.07	0.95	1.03	50398.0
2012-08-31	ABCO-DELISTED	Stock	44.39	44.5	43.85	44.34	158658.0
2012-08-31	ABCW-DELISTED	Stock	0.365	0.4	0.36	0.4	33423.0
2012-08-31	ABE-DELISTED	Stock	19.2901	19.44	19.2901	19.44	11096.0
2012-08-31	ABEO	Stock	737.5	825.0	737.5	825.0	27.0
2012-08-31	ABFS-DELISTED	Stock	9.16	9.299	9.06	9.19	198377.0
2012-08-31	ABG	Stock	27.79	27.85	27.19	27.69	347500.0
2012-08-31	ABM	Stock	20.39	20.49	20.13	20.22	459200.0
2012-08-31	ABMD-DELISTED	Stock	22.39	22.53	21.92	22.33	281903.0
2012-08-31	ABR	Stock	5.73	5.79	5.7	5.75	40400.0
2012-08-31	ABT	Stock	31.4269	31.6188	31.3789	31.4461	8617757.0
2012-08-31	ABTL-DELISTED	Stock	3.65	3.65	3.61	3.61	1727.0
2012-08-31	ABUS	Stock	3.36	3.45	3.34	3.34	4800.0
2012-08-31	ABV-DELISTED	Stock	37.07	37.75	36.96	37.6	1715381.0
2012-08-31	ABVA-DELISTED	Stock	4.55	4.55	4.54	4.54	1000.0
2012-08-31	ABX-DELISTED	Stock	37.42	38.68	37.15	38.51	10337439.0
2012-08-31	ACAD	Stock	1.79	1.81	1.76	1.78	365000.0
2012-08-31	ACAS-DELISTED	Stock	11.07	11.11	10.96	11.0	3560256.0

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

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