PREVIEW / stock_daily / 2012-04-20

all stock daily files

  file:    by_date/stock_daily/2012/2012-04-20.parquet
  size:    199 KB
  rows:    6,161
  symbols: 3,536

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-04-20	AAPL	Stock	21.1207	21.2364	20.3721	20.4636	1030985200.0
2012-04-20	MSFT	Stock	32.15	32.89	32.05	32.42	106045000.0
2012-04-20	NVDA	Stock	0.3435	0.3445	0.334	0.3348	509592000.0
2012-04-20	AMZN	Stock	9.617	9.674	9.49	9.499	64872000.0
2012-04-20	TSLA	Stock	2.2093	2.2487	2.196	2.2107	12327000.0
2012-04-20	TLT	Stock	116.56	117.13	116.33	117.07	5044169.0
2012-04-20	ES	Stock	35.93	36.46	35.93	36.46	2156900.0
2012-04-20	CL	Stock	48.91	49.5	48.9	49.44	4065200.0
2012-04-20	A	Stock	30.1645	30.6724	30.0715	30.1144	2782859.0
2012-04-20	AABA-DELISTED	Stock	15.4	15.7	15.38	15.61	24336378.0
2012-04-20	AACC-DELISTED	Stock	5.0	5.0	4.78	5.0	9900.0
2012-04-20	AACG	Stock	6.51	6.51	6.27	6.4	2000.0
2012-04-20	AAIC-DELISTED	Stock	23.09	23.28	22.95	23.1	74731.0
2012-04-20	AAME	Stock	2.84	2.95	2.84	2.95	3100.0
2012-04-20	AAMRQ-DELISTED	Stock	0.5525	0.579	0.516	0.553	5778360.0
2012-04-20	AAON	Stock	5.7985	5.8193	5.6919	5.7689	155250.0
2012-04-20	AAP	Stock	90.95	91.06	90.39	90.78	516100.0
2012-04-20	AAT	Stock	22.74	22.97	22.67	22.88	140400.0
2012-04-20	AAU-DELISTED	Stock	2.2	2.2998	2.2	2.23	54397.0
2012-04-20	AAUAF-DELISTED	Stock	2.22	2.2998	2.21	2.23	53497.0
2012-04-20	AAV-DELISTED	Stock	2.93	2.96	2.84	2.87	321552.0
2012-04-20	AAWW-DELISTED	Stock	47.84	47.85	44.35	45.42	580346.0
2012-04-20	AAXJ	Stock	56.17	56.34	56.02	56.05	107017.0
2012-04-20	AAXN-DELISTED	Stock	4.17	4.2	4.04	4.08	243368.0
2012-04-20	AB	Stock	14.15	14.46	14.07	14.26	105800.0
2012-04-20	ABAC-DELISTED	Stock	2.17	2.17	1.91	1.96	81279.0
2012-04-20	ABAX-DELISTED	Stock	27.1	29.84	26.85	29.64	412584.0
2012-04-20	ABB-DELISTED	Stock	20.41	20.66	20.32	20.469	2586291.0
2012-04-20	ABBNY-DELISTED	Stock	20.41	20.66	20.32	20.48	2655151.0
2012-04-20	ABC-DELISTED	Stock	37.71	37.9	37.52	37.73	2232682.0
2012-04-20	ABCB	Stock	12.98	13.05	12.74	12.95	66000.0
2012-04-20	ABCD-DELISTED	Stock	2.39	2.5	2.32	2.46	24269.0
2012-04-20	ABCO-DELISTED	Stock	45.02	45.24	44.4	45.05	214252.0
2012-04-20	ABCW-DELISTED	Stock	0.7731	0.7731	0.7731	0.7731	1100.0
2012-04-20	ABD-DELISTED	Stock	11.13	11.22	10.92	11.03	748720.0
2012-04-20	ABE-DELISTED	Stock	19.14	19.172	19.1	19.1	5789.0
2012-04-20	ABEO	Stock	1475.0	1475.0	1375.0	1462.5	7.0
2012-04-20	ABFS-DELISTED	Stock	17.86	17.86	17.4134	17.75	438196.0
2012-04-20	ABG	Stock	26.73	26.89	26.2	26.43	599800.0
2012-04-20	ABH-DELISTED	Stock	13.16	13.22	13.02	13.07	122307.0
2012-04-20	ABM	Stock	23.34	23.63	23.19	23.31	167000.0
2012-04-20	ABMD-DELISTED	Stock	21.0	21.62	20.45	21.37	426026.0
2012-04-20	ABR	Stock	5.7	5.7	5.52	5.52	22000.0
2012-04-20	ABT	Stock	28.4905	28.8936	28.4521	28.7304	18132972.0
2012-04-20	ABTL-DELISTED	Stock	4.5056	4.5944	4.3113	4.5944	11825.0
2012-04-20	ABUS	Stock	2.4	2.41	2.4	2.41	600.0
2012-04-20	ABV-DELISTED	Stock	43.31	44.63	43.31	44.18	4326414.0
2012-04-20	ABVT-DELISTED	Stock	83.05	83.36	83.0	83.06	318761.0
2012-04-20	ABX-DELISTED	Stock	41.24	41.26	40.22	40.26	8119433.0
2012-04-20	ACAD	Stock	1.48	1.51	1.48	1.48	197000.0

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

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