PREVIEW / stock_daily / 2012-09-05

all stock daily files

  file:    by_date/stock_daily/2012/2012-09-05.parquet
  size:    199 KB
  rows:    6,150
  symbols: 3,486

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-09-05	AAPL	Stock	24.1275	24.1554	23.9143	23.9368	336375200.0
2012-09-05	MSFT	Stock	30.22	30.53	30.21	30.39	33650000.0
2012-09-05	NVDA	Stock	0.3333	0.338	0.3295	0.333	480256000.0
2012-09-05	AMZN	Stock	12.3805	12.4305	12.265	12.311	53052000.0
2012-09-05	META	Stock	18.27	18.75	18.18	18.58	60781800.0
2012-09-05	TSLA	Stock	1.8673	1.9	1.854	1.8627	9589500.0
2012-09-05	TLT	Stock	126.82	127.19	126.55	126.72	3466654.0
2012-09-05	ES	Stock	38.0	38.03	37.66	37.68	1289300.0
2012-09-05	CL	Stock	53.26	53.68	53.22	53.25	4020600.0
2012-09-05	A	Stock	26.5093	26.6094	26.1946	26.2804	5695033.0
2012-09-05	AABA-DELISTED	Stock	14.87	15.14	14.85	15.09	20408512.0
2012-09-05	AACC-DELISTED	Stock	6.52	6.88	6.49	6.86	30412.0
2012-09-05	AACG	Stock	4.36	4.38	4.36	4.36	600.0
2012-09-05	AAIC-DELISTED	Stock	22.83	22.86	22.75	22.75	44073.0
2012-09-05	AAME	Stock	2.69	2.7	2.66	2.7	3700.0
2012-09-05	AAMRQ-DELISTED	Stock	0.479	0.487	0.475	0.48	1031584.0
2012-09-05	AAON	Stock	5.4311	5.5081	5.3719	5.443	221738.0
2012-09-05	AAP	Stock	70.15	71.22	70.01	70.24	845700.0
2012-09-05	AAT	Stock	27.62	27.62	27.18	27.28	199700.0
2012-09-05	AAU-DELISTED	Stock	2.73	2.73	2.69	2.7	271184.0
2012-09-05	AAUAF-DELISTED	Stock	2.74	2.74	2.69	2.69	280693.0
2012-09-05	AAV-DELISTED	Stock	3.5	3.5	3.445	3.47	100165.0
2012-09-05	AAWW-DELISTED	Stock	52.08	52.74	51.04	51.43	239195.0
2012-09-05	AAXJ	Stock	52.46	52.46	52.2	52.4	340191.0
2012-09-05	AAXN-DELISTED	Stock	5.4	5.47	5.35	5.355	386518.0
2012-09-05	AB	Stock	14.21	14.61	14.21	14.26	313300.0
2012-09-05	ABAC-DELISTED	Stock	1.1	1.2	1.1	1.2	23701.0
2012-09-05	ABAX-DELISTED	Stock	38.03	38.49	37.26	37.35	119429.0
2012-09-05	ABB-DELISTED	Stock	17.22	17.39	17.16	17.31	3172792.0
2012-09-05	ABBNY-DELISTED	Stock	17.22	17.39	17.16	17.32	3186555.0
2012-09-05	ABC-DELISTED	Stock	38.7	38.79	38.09	38.19	3813109.0
2012-09-05	ABCB	Stock	12.12	12.15	11.89	12.08	50600.0
2012-09-05	ABCD-DELISTED	Stock	0.97	1.07	0.97	1.07	18892.0
2012-09-05	ABCO-DELISTED	Stock	45.65	46.25	45.06	45.73	269161.0
2012-09-05	ABCW-DELISTED	Stock	0.36	0.45	0.36	0.45	10929.0
2012-09-05	ABE-DELISTED	Stock	19.3	19.42	19.2401	19.42	12732.0
2012-09-05	ABEO	Stock	650.0	825.0	650.0	712.5	32.0
2012-09-05	ABFS-DELISTED	Stock	9.36	9.39	9.02	9.09	357404.0
2012-09-05	ABG	Stock	27.89	28.18	27.65	28.01	203000.0
2012-09-05	ABM	Stock	20.11	20.48	19.95	20.35	403700.0
2012-09-05	ABMD-DELISTED	Stock	22.84	22.93	22.51	22.72	503286.0
2012-09-05	ABR	Stock	5.65	5.68	5.55	5.63	112000.0
2012-09-05	ABT	Stock	31.5037	31.5852	31.3501	31.5468	7666945.0
2012-09-05	ABTL-DELISTED	Stock	3.6	3.74	3.6	3.71	7559.0
2012-09-05	ABUS	Stock	3.25	3.27	3.22	3.22	5600.0
2012-09-05	ABV-DELISTED	Stock	37.05	37.14	36.58	36.88	1151683.0
2012-09-05	ABVA-DELISTED	Stock	4.9299	4.9299	4.59	4.6	4300.0
2012-09-05	ABX-DELISTED	Stock	38.25	38.3048	37.8	38.085	5712325.0
2012-09-05	ACAD	Stock	1.8	1.86	1.73	1.82	1669100.0
2012-09-05	ACAS-DELISTED	Stock	11.13	11.31	11.12	11.29	3069082.0

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

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