PREVIEW / stock_daily / 2014-05-29

all stock daily files

  file:    by_date/stock_daily/2014/2014-05-29.parquet
  size:    219 KB
  rows:    6,558
  symbols: 3,548

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
2014-05-29	AAPL	Stock	22.4232	22.7454	22.4204	22.6921	376474000.0
2014-05-29	MSFT	Stock	40.15	40.35	39.91	40.34	19888200.0
2014-05-29	NVDA	Stock	0.4742	0.4782	0.4728	0.4738	171884000.0
2014-05-29	AMZN	Stock	15.521	15.7435	15.51	15.689	47310000.0
2014-05-29	GOOGL	Stock	28.6695	28.674	28.4226	28.528	28225920.0
2014-05-29	META	Stock	63.84	64.3	63.51	63.83	42700000.0
2014-05-29	TSLA	Stock	14.038	14.166	13.848	14.016	55387500.0
2014-05-29	TLT	Stock	114.87	115.19	114.13	114.15	10692041.0
2014-05-29	ES	Stock	45.19	45.29	44.77	45.03	1739200.0
2014-05-29	CL	Stock	66.38	66.96	66.26	66.92	6367200.0
2014-05-29	A	Stock	40.9013	41.0443	40.515	40.7439	2179063.0
2014-05-29	AABA-DELISTED	Stock	34.9	35.1	34.67	34.9	9428360.0
2014-05-29	AACG	Stock	4.95	4.95	4.77	4.88	10000.0
2014-05-29	AAIC-DELISTED	Stock	27.55	27.57	27.43	27.53	147072.0
2014-05-29	AAL	Stock	39.89	40.27	39.36	39.82	9667100.0
2014-05-29	AAMC-DELISTED	Stock	281.6897	284.4059	274.1206	282.6618	18394.0
2014-05-29	AAME	Stock	3.56	3.61	3.47	3.52	7200.0
2014-05-29	AAOI	Stock	20.49	22.05	20.48	21.63	346700.0
2014-05-29	AAON	Stock	14.0622	14.0622	13.7644	13.9244	141750.0
2014-05-29	AAP	Stock	122.11	123.35	121.58	122.31	606800.0
2014-05-29	AAT	Stock	34.58	34.71	34.32	34.5	180500.0
2014-05-29	AAU-DELISTED	Stock	1.35	1.371	1.3	1.35	68988.0
2014-05-29	AAUAF-DELISTED	Stock	1.31	1.35	1.29	1.35	71859.0
2014-05-29	AAV-DELISTED	Stock	5.79	5.855	5.71	5.85	199563.0
2014-05-29	AAWW-DELISTED	Stock	37.28	37.75	37.012	37.37	161894.0
2014-05-29	AAXJ	Stock	62.15	62.26	62.09	62.19	886696.0
2014-05-29	AAXN-DELISTED	Stock	13.41	13.555	13.23	13.52	558285.0
2014-05-29	AB	Stock	23.61	23.8	23.41	23.75	271900.0
2014-05-29	ABAC-DELISTED	Stock	2.22	2.2699	2.12	2.18	68575.0
2014-05-29	ABAX-DELISTED	Stock	41.49	42.47	41.1	41.94	87820.0
2014-05-29	ABB-DELISTED	Stock	23.77	23.81	23.66	23.76	719630.0
2014-05-29	ABBNY-DELISTED	Stock	23.77	23.81	23.66	23.77	744762.0
2014-05-29	ABBV	Stock	54.1	54.45	53.75	54.03	2768600.0
2014-05-29	ABC-DELISTED	Stock	72.69	73.42	72.69	73.29	1352913.0
2014-05-29	ABCB	Stock	21.12	21.15	20.62	21.06	47500.0
2014-05-29	ABCD-DELISTED	Stock	2.25	2.28	2.217	2.242	1850.0
2014-05-29	ABCO-DELISTED	Stock	49.48	49.72	48.92	49.01	140747.0
2014-05-29	ABDC-DELISTED	Stock	14.85	14.9386	14.74	14.84	14400.0
2014-05-29	ABE-DELISTED	Stock	14.22	14.22	14.08	14.12	10000.0
2014-05-29	ABEV	Stock	7.21	7.25	7.18	7.2	6036000.0
2014-05-29	ABG	Stock	64.47	64.71	63.72	64.63	143300.0
2014-05-29	ABGB-DELISTED	Stock	22.6499	22.77	22.39	22.77	7959.0
2014-05-29	ABIL-DELISTED	Stock	9.77	9.77	9.77	9.77	272.0
2014-05-29	ABM	Stock	27.37	27.48	27.02	27.33	107800.0
2014-05-29	ABMD-DELISTED	Stock	21.88	22.35	21.62	21.98	262473.0
2014-05-29	ABR	Stock	7.14	7.3	7.12	7.3	66200.0
2014-05-29	ABR.A-DELISTED	Stock	24.25	24.43	24.24	24.43	27110.0
2014-05-29	ABR.B-DELISTED	Stock	23.82	23.83	23.77	23.83	2637.0
2014-05-29	ABR.C-DELISTED	Stock	25.0	25.057	24.958	25.02	6025.0
2014-05-29	ABRN-DELISTED	Stock	25.1	25.1	24.999	25.0	29808.0

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

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