PREVIEW / stock_daily / 2014-08-06

all stock daily files

  file:    by_date/stock_daily/2014/2014-08-06.parquet
  size:    219 KB
  rows:    6,592
  symbols: 3,554

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-08-06	AAPL	Stock	23.6875	23.87	23.6775	23.74	154232000.0
2014-08-06	MSFT	Stock	42.74	43.17	42.21	42.74	24634000.0
2014-08-06	NVDA	Stock	0.4385	0.4465	0.4352	0.441	223456000.0
2014-08-06	AMZN	Stock	15.5415	15.789	15.51	15.6945	45938000.0
2014-08-06	GOOGL	Stock	28.475	28.9322	28.3725	28.7245	26457560.0
2014-08-06	META	Stock	72.02	73.72	71.79	72.47	30986000.0
2014-08-06	TSLA	Stock	15.9267	16.7613	15.9053	16.5953	138739500.0
2014-08-06	TLT	Stock	115.47	115.47	114.6	114.7	7289215.0
2014-08-06	ES	Stock	42.51	42.55	41.92	42.04	3295500.0
2014-08-06	CL	Stock	63.92	65.25	63.92	64.8	5742500.0
2014-08-06	A	Stock	39.5064	39.8569	39.2704	39.7639	2193182.0
2014-08-06	AABA-DELISTED	Stock	35.57	35.94	35.44	35.78	11359673.0
2014-08-06	AACG	Stock	4.57	4.73	4.4	4.46	26600.0
2014-08-06	AAIC-DELISTED	Stock	26.27	26.7	26.27	26.64	158641.0
2014-08-06	AAL	Stock	36.56	38.0	36.14	37.46	9501300.0
2014-08-06	AAMC-DELISTED	Stock	166.3682	177.9412	166.3682	175.8971	24123.0
2014-08-06	AAME	Stock	4.31	4.37	3.96	4.22	12400.0
2014-08-06	AAOI	Stock	18.99	19.7	18.8	19.54	148000.0
2014-08-06	AAON	Stock	13.1067	13.3333	12.8667	13.0467	253200.0
2014-08-06	AAP	Stock	123.59	124.51	122.99	122.99	810700.0
2014-08-06	AAT	Stock	34.19	34.79	34.19	34.34	257200.0
2014-08-06	AAU-DELISTED	Stock	1.39	1.4	1.38	1.39	39219.0
2014-08-06	AAUAF-DELISTED	Stock	1.39	1.4	1.38	1.39	39749.0
2014-08-06	AAV-DELISTED	Stock	5.28	5.4499	5.26	5.39	283298.0
2014-08-06	AAVL-DELISTED	Stock	22.95	24.86	22.06	23.39	132845.0
2014-08-06	AAWW-DELISTED	Stock	31.9	32.72	31.77	32.37	268163.0
2014-08-06	AAXJ	Stock	64.12	64.45	64.12	64.26	1033248.0
2014-08-06	AAXN-DELISTED	Stock	11.86	12.38	11.8	12.335	1535601.0
2014-08-06	AB	Stock	25.91	26.39	25.66	26.31	190600.0
2014-08-06	ABAC-DELISTED	Stock	1.83	2.0	1.83	2.0	25638.0
2014-08-06	ABAX-DELISTED	Stock	46.21	47.06	46.21	46.38	116422.0
2014-08-06	ABB-DELISTED	Stock	22.36	22.62	22.34	22.54	946145.0
2014-08-06	ABBNY-DELISTED	Stock	22.36	22.62	22.34	22.54	978264.0
2014-08-06	ABBV	Stock	51.48	52.66	51.37	52.05	18126200.0
2014-08-06	ABC-DELISTED	Stock	76.67	76.87	75.4901	76.02	2058542.0
2014-08-06	ABCB	Stock	21.61	21.94	21.61	21.75	69300.0
2014-08-06	ABCD-DELISTED	Stock	1.97	1.97	1.96	1.96	300.0
2014-08-06	ABCO-DELISTED	Stock	47.58	48.65	47.45	48.31	252159.0
2014-08-06	ABDC-DELISTED	Stock	12.78	13.0	12.52	12.57	60357.0
2014-08-06	ABE-DELISTED	Stock	14.25	14.36	14.25	14.3214	17658.0
2014-08-06	ABEO	Stock	337.5	337.5	337.5	337.5	1.0
2014-08-06	ABEV	Stock	6.67	6.82	6.55	6.76	30303600.0
2014-08-06	ABG	Stock	67.85	69.41	67.85	68.08	251000.0
2014-08-06	ABGB-DELISTED	Stock	24.7	24.74	24.39	24.59	20025.0
2014-08-06	ABM	Stock	24.7	25.21	24.7	24.96	197400.0
2014-08-06	ABMD-DELISTED	Stock	25.2	25.64	25.2	25.35	246758.0
2014-08-06	ABR	Stock	7.0	7.06	6.95	6.99	55700.0
2014-08-06	ABR.A-DELISTED	Stock	24.92	24.92	24.7	24.7894	21352.0
2014-08-06	ABR.B-DELISTED	Stock	24.67	24.68	24.37	24.37	4765.0
2014-08-06	ABR.C-DELISTED	Stock	25.26	25.29	25.2	25.25	1900.0

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

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