PREVIEW / stock_daily / 2012-08-14

all stock daily files

  file:    by_date/stock_daily/2012/2012-08-14.parquet
  size:    199 KB
  rows:    6,157
  symbols: 3,503

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-14	AAPL	Stock	22.5668	22.8075	22.5075	22.5604	340169200.0
2012-08-14	MSFT	Stock	30.3	30.39	30.01	30.13	34551400.0
2012-08-14	NVDA	Stock	0.3715	0.372	0.3632	0.3648	388828000.0
2012-08-14	AMZN	Stock	11.7355	11.836	11.631	11.6595	55020000.0
2012-08-14	META	Stock	21.41	21.6	20.25	20.38	39308800.0
2012-08-14	TSLA	Stock	2.05	2.078	1.9507	1.9613	11901000.0
2012-08-14	TLT	Stock	123.96	124.41	123.75	123.79	7994037.0
2012-08-14	ES	Stock	39.29	39.4	38.98	39.15	1463500.0
2012-08-14	CL	Stock	52.73	52.905	52.525	52.71	2428000.0
2012-08-14	A	Stock	29.0558	29.2918	28.7911	28.9628	2788171.0
2012-08-14	AABA-DELISTED	Stock	15.04	15.05	14.69	14.75	28797623.0
2012-08-14	AACC-DELISTED	Stock	5.69	5.8	5.6	5.62	54532.0
2012-08-14	AACG	Stock	4.81	4.88	4.75	4.86	1900.0
2012-08-14	AAIC-DELISTED	Stock	23.07	23.07	22.88	22.97	53125.0
2012-08-14	AAME	Stock	2.51	2.7	2.51	2.55	34000.0
2012-08-14	AAMRQ-DELISTED	Stock	0.5	0.5005	0.496	0.4988	256237.0
2012-08-14	AAON	Stock	5.6622	5.7304	5.5437	5.5615	197100.0
2012-08-14	AAP	Stock	69.25	70.91	69.19	70.67	1305400.0
2012-08-14	AAT	Stock	26.3	26.3	25.69	25.75	78900.0
2012-08-14	AAU-DELISTED	Stock	2.09	2.18	2.08	2.135	74237.0
2012-08-14	AAUAF-DELISTED	Stock	2.09	2.18	2.08	2.135	75687.0
2012-08-14	AAV-DELISTED	Stock	3.23	3.35	3.23	3.27	165104.0
2012-08-14	AAWW-DELISTED	Stock	51.61	52.2	51.04	51.24	274610.0
2012-08-14	AAXJ	Stock	54.66	54.66	54.31	54.44	120746.0
2012-08-14	AAXN-DELISTED	Stock	5.56	5.62	5.4	5.455	419793.0
2012-08-14	AB	Stock	12.95	13.0	12.67	12.74	381200.0
2012-08-14	ABAC-DELISTED	Stock	1.04	1.04	0.94	0.94	10178.0
2012-08-14	ABAX-DELISTED	Stock	37.9	38.2099	37.53	37.84	86056.0
2012-08-14	ABB-DELISTED	Stock	17.91	17.93	17.6699	17.71	3958834.0
2012-08-14	ABBNY-DELISTED	Stock	17.91	17.93	17.6699	17.71	4372199.0
2012-08-14	ABC-DELISTED	Stock	38.69	38.77	38.18	38.31	2291941.0
2012-08-14	ABCB	Stock	11.5	11.69	11.32	11.4	23800.0
2012-08-14	ABCD-DELISTED	Stock	0.9	0.9	0.83	0.83	40345.0
2012-08-14	ABCO-DELISTED	Stock	42.52	42.6	41.83	41.97	139614.0
2012-08-14	ABCW-DELISTED	Stock	0.425	0.435	0.39	0.39	35337.0
2012-08-14	ABE-DELISTED	Stock	19.4	19.53	19.4	19.46	8868.0
2012-08-14	ABEO	Stock	512.5	612.5	512.5	612.5	16.0
2012-08-14	ABFS-DELISTED	Stock	10.45	10.51	10.11	10.17	203400.0
2012-08-14	ABG	Stock	26.94	27.35	26.41	26.51	114800.0
2012-08-14	ABM	Stock	19.11	19.28	18.93	18.98	370900.0
2012-08-14	ABMD-DELISTED	Stock	20.38	20.555	19.78	20.34	573281.0
2012-08-14	ABR	Stock	5.75	5.77	5.65	5.72	69300.0
2012-08-14	ABT	Stock	31.7484	31.8059	31.6188	31.7484	5730721.0
2012-08-14	ABTL-DELISTED	Stock	3.62	3.74	3.57	3.65	2370.0
2012-08-14	ABUS	Stock	3.71	3.78	3.68	3.68	11000.0
2012-08-14	ABV-DELISTED	Stock	38.1	38.39	37.76	37.9	1368764.0
2012-08-14	ABVA-DELISTED	Stock	4.46	4.46	4.39	4.4	11355.0
2012-08-14	ABX-DELISTED	Stock	34.03	34.45	33.92	34.15	4527664.0
2012-08-14	ACAD	Stock	1.71	1.75	1.69	1.7	287600.0
2012-08-14	ACAS-DELISTED	Stock	11.01	11.035	10.93	10.995	3610374.0

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

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