PREVIEW / stock_daily / 2012-08-16

all stock daily files

  file:    by_date/stock_daily/2012/2012-08-16.parquet
  size:    198 KB
  rows:    6,119
  symbols: 3,463

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-16	AAPL	Stock	22.5432	22.7414	22.5179	22.7264	254534000.0
2012-08-16	MSFT	Stock	30.36	30.94	30.26	30.78	35787200.0
2012-08-16	NVDA	Stock	0.3652	0.3708	0.364	0.3695	371008000.0
2012-08-16	AMZN	Stock	11.886	12.141	11.81	12.0775	86242000.0
2012-08-16	META	Stock	20.44	20.48	19.69	19.87	157565300.0
2012-08-16	TSLA	Stock	1.9687	2.026	1.9667	2.02	10035000.0
2012-08-16	TLT	Stock	122.21	122.5	120.52	121.01	13239987.0
2012-08-16	ES	Stock	39.0	39.08	38.73	38.77	1205000.0
2012-08-16	CL	Stock	52.69	52.965	52.565	52.915	2100200.0
2012-08-16	A	Stock	26.824	27.3033	26.2947	26.5737	17888948.0
2012-08-16	AABA-DELISTED	Stock	14.79	15.01	14.75	14.99	24404879.0
2012-08-16	AACC-DELISTED	Stock	5.74	5.89	5.74	5.85	32466.0
2012-08-16	AACG	Stock	4.69	5.21	4.58	4.72	4200.0
2012-08-16	AAIC-DELISTED	Stock	22.95	23.01	22.84	22.99	32037.0
2012-08-16	AAME	Stock	2.54	2.67	2.54	2.65	7400.0
2012-08-16	AAMRQ-DELISTED	Stock	0.496	0.51	0.49	0.4915	848788.0
2012-08-16	AAON	Stock	5.6	5.763	5.5437	5.7363	112388.0
2012-08-16	AAP	Stock	71.36	72.75	71.21	72.46	1519900.0
2012-08-16	AAT	Stock	25.79	25.84	25.52	25.81	102000.0
2012-08-16	AAU-DELISTED	Stock	2.14	2.2	2.14	2.2	90689.0
2012-08-16	AAUAF-DELISTED	Stock	2.16	2.21	2.16	2.18	92461.0
2012-08-16	AAV-DELISTED	Stock	3.29	3.29	3.24	3.28	64619.0
2012-08-16	AAWW-DELISTED	Stock	51.81	53.31	51.81	52.73	165933.0
2012-08-16	AAXJ	Stock	54.34	54.62	54.12	54.44	210003.0
2012-08-16	AAXN-DELISTED	Stock	5.51	5.59	5.49	5.53	510369.0
2012-08-16	AB	Stock	12.82	12.98	12.71	12.87	549000.0
2012-08-16	ABAC-DELISTED	Stock	1.0	1.0	0.9497	0.9999	10600.0
2012-08-16	ABAX-DELISTED	Stock	38.27	38.87	37.11	38.75	56416.0
2012-08-16	ABB-DELISTED	Stock	17.71	18.0	17.68	17.96	1588830.0
2012-08-16	ABBNY-DELISTED	Stock	17.72	18.0	17.68	17.96	1612294.0
2012-08-16	ABC-DELISTED	Stock	37.51	37.7	37.17	37.57	5586381.0
2012-08-16	ABCB	Stock	11.61	11.91	11.58	11.86	23100.0
2012-08-16	ABCD-DELISTED	Stock	0.92	1.02	0.92	0.97	10513.0
2012-08-16	ABCO-DELISTED	Stock	41.71	42.02	41.59	41.8	117505.0
2012-08-16	ABCW-DELISTED	Stock	0.45	0.45	0.39	0.43	28285.0
2012-08-16	ABE-DELISTED	Stock	19.48	19.6	19.44	19.6	10256.0
2012-08-16	ABEO	Stock	562.5	575.0	562.5	562.5	21.0
2012-08-16	ABFS-DELISTED	Stock	10.27	10.47	10.0889	10.44	203537.0
2012-08-16	ABG	Stock	26.55	26.82	26.2	26.77	222800.0
2012-08-16	ABM	Stock	19.4	20.12	19.34	20.09	357500.0
2012-08-16	ABMD-DELISTED	Stock	20.44	20.5689	19.49	19.49	702016.0
2012-08-16	ABR	Stock	5.78	5.85	5.75	5.84	86000.0
2012-08-16	ABT	Stock	31.8251	31.9067	31.6668	31.8731	5578783.0
2012-08-16	ABTL-DELISTED	Stock	3.62	3.93	3.62	3.79	10255.0
2012-08-16	ABUS	Stock	3.81	3.84	3.71	3.78	15500.0
2012-08-16	ABV-DELISTED	Stock	38.11	38.25	37.64	38.18	1397169.0
2012-08-16	ABX-DELISTED	Stock	35.05	36.1	34.94	36.08	9483244.0
2012-08-16	ACAD	Stock	1.61	1.66	1.6	1.66	216000.0
2012-08-16	ACAS-DELISTED	Stock	11.06	11.22	11.02	11.175	3816257.0
2012-08-16	ACAT-DELISTED	Stock	43.08	43.4575	42.26	43.18	161182.0

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

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