PREVIEW / stock_daily / 2012-03-08

all stock daily files

  file:    by_date/stock_daily/2012/2012-03-08.parquet
  size:    199 KB
  rows:    6,161
  symbols: 3,537

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-03-08	AAPL	Stock	19.0961	19.3925	19.0043	19.3568	516457200.0
2012-03-08	MSFT	Stock	32.04	32.21	31.9	32.01	36747400.0
2012-03-08	NVDA	Stock	0.3713	0.3753	0.3692	0.3715	430852000.0
2012-03-08	AMZN	Stock	9.2085	9.419	9.19	9.382	84430000.0
2012-03-08	TSLA	Stock	2.2073	2.2327	2.2027	2.2047	9499500.0
2012-03-08	TLT	Stock	116.32	116.57	115.64	115.74	7982219.0
2012-03-08	ES	Stock	36.43	36.7	36.3	36.68	1443600.0
2012-03-08	CL	Stock	46.7	46.985	46.64	46.97	2766400.0
2012-03-08	A	Stock	31.402	31.917	30.8727	31.6738	5349028.0
2012-03-08	AABA-DELISTED	Stock	14.7	14.77	14.52	14.62	11254899.0
2012-03-08	AACC-DELISTED	Stock	4.37	4.615	4.35	4.43	62052.0
2012-03-08	AACG	Stock	5.86	6.34	5.86	6.29	19400.0
2012-03-08	AAIC-DELISTED	Stock	23.04	23.73	22.8	23.67	54786.0
2012-03-08	AAME	Stock	2.81	2.88	2.75	2.83	4400.0
2012-03-08	AAMRQ-DELISTED	Stock	0.485	0.534	0.474	0.515	3592044.0
2012-03-08	AAON	Stock	5.3956	5.4133	5.2859	5.3807	123188.0
2012-03-08	AAP	Stock	86.9	87.29	86.51	86.94	785000.0
2012-03-08	AAT	Stock	21.65	22.12	21.58	21.65	263500.0
2012-03-08	AAU-DELISTED	Stock	2.77	2.82	2.73	2.8	136085.0
2012-03-08	AAUAF-DELISTED	Stock	2.77	2.82	2.73	2.8	137285.0
2012-03-08	AAV-DELISTED	Stock	3.75	3.7998	3.62	3.7	493070.0
2012-03-08	AAWW-DELISTED	Stock	43.26	44.07	42.63	43.39	250108.0
2012-03-08	AAXJ	Stock	57.11	57.32	56.93	57.25	807103.0
2012-03-08	AAXN-DELISTED	Stock	4.05	4.05	3.99	4.0	178329.0
2012-03-08	AB	Stock	14.98	15.32	14.87	15.31	432600.0
2012-03-08	ABAC-DELISTED	Stock	1.55	1.69	1.51	1.54	31276.0
2012-03-08	ABAX-DELISTED	Stock	26.85	27.62	26.45	27.28	113030.0
2012-03-08	ABB-DELISTED	Stock	20.13	20.36	20.0	20.28	2078851.0
2012-03-08	ABBNY-DELISTED	Stock	20.13	20.36	20.0	20.28	2079574.0
2012-03-08	ABC-DELISTED	Stock	37.0	37.505	36.91	37.44	3584161.0
2012-03-08	ABCB	Stock	11.78	11.96	11.5	11.78	45600.0
2012-03-08	ABCD-DELISTED	Stock	2.85	3.07	2.85	3.05	12183.0
2012-03-08	ABCO-DELISTED	Stock	41.29	41.59	41.0	41.5	160932.0
2012-03-08	ABCW-DELISTED	Stock	0.492	0.502	0.4217	0.4217	11870.0
2012-03-08	ABD-DELISTED	Stock	11.61	11.662	11.47	11.56	352870.0
2012-03-08	ABE-DELISTED	Stock	19.15	19.35	19.15	19.31	6318.0
2012-03-08	ABEO	Stock	1450.0	1450.0	1362.5	1437.5	13.0
2012-03-08	ABFS-DELISTED	Stock	17.52	17.74	17.3	17.71	526782.0
2012-03-08	ABG	Stock	26.76	27.13	26.47	27.07	316300.0
2012-03-08	ABH-DELISTED	Stock	14.75	14.836	14.53	14.6	122311.0
2012-03-08	ABM	Stock	22.6	23.21	22.38	23.17	303800.0
2012-03-08	ABMD-DELISTED	Stock	20.93	21.51	20.76	21.2	478947.0
2012-03-08	ABR	Stock	5.22	5.4	5.21	5.35	112100.0
2012-03-08	ABT	Stock	27.3966	27.7037	27.3006	27.5837	21693206.0
2012-03-08	ABTL-DELISTED	Stock	4.8	4.904	4.65	4.75	5262.0
2012-03-08	ABUS	Stock	2.39	2.39	2.3	2.31	16700.0
2012-03-08	ABV-DELISTED	Stock	40.49	40.85	40.24	40.72	2104253.0
2012-03-08	ABVA-DELISTED	Stock	4.04	4.04	4.01	4.01	200.0
2012-03-08	ABVT-DELISTED	Stock	69.41	70.05	68.34	69.99	122739.0
2012-03-08	ABX-DELISTED	Stock	46.35	46.4	45.7	46.04	5569902.0

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

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