PREVIEW / stock_daily / 2012-08-20

all stock daily files

  file:    by_date/stock_daily/2012/2012-08-20.parquet
  size:    198 KB
  rows:    6,113
  symbols: 3,475

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-20	AAPL	Stock	23.2146	23.7554	23.2107	23.7554	613384800.0
2012-08-20	MSFT	Stock	30.82	30.85	30.58	30.74	23737700.0
2012-08-20	NVDA	Stock	0.365	0.3668	0.3608	0.3662	314392000.0
2012-08-20	AMZN	Stock	12.0685	12.0825	11.91	12.0175	37798000.0
2012-08-20	META	Stock	19.05	20.13	18.75	20.01	101186600.0
2012-08-20	TSLA	Stock	2.01	2.026	1.94	1.9673	17686500.0
2012-08-20	TLT	Stock	121.55	122.19	121.5	121.85	4427123.0
2012-08-20	ES	Stock	38.49	38.69	38.3	38.68	1197600.0
2012-08-20	CL	Stock	53.09	53.18	52.635	52.975	2601600.0
2012-08-20	A	Stock	26.4807	26.5951	26.1445	26.2375	5554254.0
2012-08-20	AABA-DELISTED	Stock	14.99	15.05	14.88	14.96	11131296.0
2012-08-20	AACC-DELISTED	Stock	5.89	6.25	5.8696	6.24	59205.0
2012-08-20	AACG	Stock	4.58	4.58	4.31	4.55	2100.0
2012-08-20	AAIC-DELISTED	Stock	22.98	23.0	22.58	22.81	86371.0
2012-08-20	AAME	Stock	2.68	2.7	2.68	2.7	300.0
2012-08-20	AAMRQ-DELISTED	Stock	0.495	0.504	0.4901	0.491	746711.0
2012-08-20	AAON	Stock	5.7156	5.7274	5.6119	5.7096	166388.0
2012-08-20	AAP	Stock	72.52	72.8	71.42	71.58	1328100.0
2012-08-20	AAT	Stock	26.34	27.0	26.33	26.89	188900.0
2012-08-20	AAU-DELISTED	Stock	2.14	2.25	2.12	2.25	99039.0
2012-08-20	AAUAF-DELISTED	Stock	2.14	2.25	2.12	2.25	99539.0
2012-08-20	AAV-DELISTED	Stock	3.33	3.35	3.28	3.28	136823.0
2012-08-20	AAWW-DELISTED	Stock	53.27	53.61	52.59	52.68	227268.0
2012-08-20	AAXJ	Stock	54.1	54.37	54.0	54.33	149742.0
2012-08-20	AAXN-DELISTED	Stock	5.43	5.56	5.39	5.55	351865.0
2012-08-20	AB	Stock	12.83	12.95	12.73	12.89	312100.0
2012-08-20	ABAC-DELISTED	Stock	1.05	1.17	1.05	1.17	22523.0
2012-08-20	ABAX-DELISTED	Stock	39.52	39.52	38.63	39.0	38202.0
2012-08-20	ABB-DELISTED	Stock	17.99	18.095	17.91	18.02	1394558.0
2012-08-20	ABBNY-DELISTED	Stock	17.99	18.095	17.91	18.03	1464455.0
2012-08-20	ABC-DELISTED	Stock	37.4	37.82	37.38	37.72	2400935.0
2012-08-20	ABCB	Stock	12.1	12.39	12.01	12.16	64200.0
2012-08-20	ABCD-DELISTED	Stock	0.98	1.048	0.94	0.94	23631.0
2012-08-20	ABCO-DELISTED	Stock	41.14	42.06	39.73	41.78	385138.0
2012-08-20	ABCW-DELISTED	Stock	0.39	0.39	0.365	0.37	35100.0
2012-08-20	ABE-DELISTED	Stock	19.48	19.5699	19.48	19.5699	2917.0
2012-08-20	ABEO	Stock	575.0	625.0	525.0	625.0	16.0
2012-08-20	ABFS-DELISTED	Stock	10.44	10.45	10.16	10.23	193148.0
2012-08-20	ABG	Stock	26.94	27.04	26.32	26.83	129400.0
2012-08-20	ABM	Stock	20.31	20.49	20.17	20.46	214000.0
2012-08-20	ABMD-DELISTED	Stock	20.66	21.97	20.59	21.72	822970.0
2012-08-20	ABR	Stock	5.7	5.7	5.5	5.52	78300.0
2012-08-20	ABT	Stock	31.6572	31.7148	31.5181	31.5373	6974781.0
2012-08-20	ABTL-DELISTED	Stock	3.79	3.84	3.65	3.84	17077.0
2012-08-20	ABUS	Stock	3.72	3.75	3.45	3.57	39500.0
2012-08-20	ABV-DELISTED	Stock	38.01	38.02	37.59	37.89	1372762.0
2012-08-20	ABVA-DELISTED	Stock	4.48	4.48	4.48	4.48	100.0
2012-08-20	ABX-DELISTED	Stock	36.12	36.52	35.7	36.44	6378474.0
2012-08-20	ACAD	Stock	1.7	1.8	1.7	1.74	633100.0
2012-08-20	ACAS-DELISTED	Stock	11.16	11.25	11.13	11.19	4077300.0

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

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