PREVIEW / stock_daily / 2015-07-23

all stock daily files

  file:    by_date/stock_daily/2015/2015-07-23.parquet
  size:    224 KB
  rows:    6,659
  symbols: 3,477

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
2015-07-23	AAPL	Stock	31.55	31.7725	31.265	31.29	203998000.0
2015-07-23	MSFT	Stock	45.27	46.23	45.1	46.11	33934000.0
2015-07-23	NVDA	Stock	0.4862	0.4985	0.4852	0.4912	169916000.0
2015-07-23	AMZN	Stock	24.583	24.583	23.785	24.109	187488000.0
2015-07-23	GOOGL	Stock	34.5925	34.8035	33.5795	33.7365	76231960.0
2015-07-23	META	Stock	96.96	97.45	94.81	95.44	29418800.0
2015-07-23	TSLA	Stock	17.9767	17.9933	17.6847	17.8133	33408000.0
2015-07-23	TLT	Stock	119.6	121.1999	119.45	121.09	9087712.0
2015-07-23	ES	Stock	47.82	47.82	46.96	47.35	2689100.0
2015-07-23	CL	Stock	67.0	67.18	66.81	67.04	2667900.0
2015-07-23	A	Stock	40.37	40.37	40.01	40.25	1708800.0
2015-07-23	AA.B-DELISTED	Stock	37.0	37.49	36.76	36.87	21884.0
2015-07-23	AABA-DELISTED	Stock	39.3	39.785	39.06	39.215	8828463.0
2015-07-23	AAC-DELISTED	Stock	38.74	39.27	38.2201	38.79	237775.0
2015-07-23	AACG	Stock	4.33	4.33	4.15	4.18	18600.0
2015-07-23	AAIC-DELISTED	Stock	19.9	19.958	19.34	19.44	481575.0
2015-07-23	AAL	Stock	42.78	43.81	42.0	42.61	16579900.0
2015-07-23	AAMC-DELISTED	Stock	40.0324	42.0588	39.5	40.9206	18911.0
2015-07-23	AAME	Stock	3.7	3.7	3.65	3.65	1500.0
2015-07-23	AAMI	Stock	17.65	17.84	17.5	17.54	169700.0
2015-07-23	AAOI	Stock	18.36	19.0	18.36	18.72	298900.0
2015-07-23	AAON	Stock	15.3333	15.3667	15.0533	15.0667	169650.0
2015-07-23	AAP	Stock	169.05	171.09	168.25	168.39	589400.0
2015-07-23	AAT	Stock	41.23	41.41	40.62	41.38	257900.0
2015-07-23	AAU-DELISTED	Stock	0.6525	0.66	0.624	0.63	128568.0
2015-07-23	AAUAF-DELISTED	Stock	0.6401	0.65	0.612	0.63	132217.0
2015-07-23	AAV-DELISTED	Stock	5.8	5.82	5.47	5.54	110953.0
2015-07-23	AAVL-DELISTED	Stock	16.52	16.73	16.16	16.16	190570.0
2015-07-23	AAWW-DELISTED	Stock	51.0	51.98	49.17	49.59	502279.0
2015-07-23	AAXJ	Stock	60.65	60.79	60.335	60.44	1441639.0
2015-07-23	AAXN-DELISTED	Stock	32.22	32.53	31.62	31.71	1081491.0
2015-07-23	AB	Stock	28.0	28.05	27.42	27.54	164000.0
2015-07-23	ABAC-DELISTED	Stock	1.15	1.2289	1.146	1.1999	3000.0
2015-07-23	ABAX-DELISTED	Stock	56.26	56.79	55.28	55.7	334342.0
2015-07-23	ABB-DELISTED	Stock	21.08	21.11	20.58	20.66	3839942.0
2015-07-23	ABBNY-DELISTED	Stock	21.08	21.11	20.58	20.65	4017163.0
2015-07-23	ABBV	Stock	70.25	70.93	70.14	70.52	5636600.0
2015-07-23	ABC-DELISTED	Stock	110.62	114.02	109.52	110.09	3710493.0
2015-07-23	ABCB	Stock	26.31	26.48	25.72	25.99	125300.0
2015-07-23	ABCD-DELISTED	Stock	5.1	5.1	4.97	5.02	134566.0
2015-07-23	ABCO-DELISTED	Stock	57.75	57.8	56.98	57.37	211948.0
2015-07-23	ABCW-DELISTED	Stock	39.2047	39.65	38.29	38.31	13806.0
2015-07-23	ABDC-DELISTED	Stock	12.8	12.94	12.71	12.87	19332.0
2015-07-23	ABE-DELISTED	Stock	13.12	13.12	12.97	13.01	6901.0
2015-07-23	ABEO	Stock	147.5	153.0	146.0	147.5	11384.0
2015-07-23	ABEV	Stock	5.86	5.91	5.79	5.81	11902500.0
2015-07-23	ABG	Stock	87.05	89.01	86.12	87.87	459600.0
2015-07-23	ABGB-DELISTED	Stock	13.9	14.0	13.25	14.0	35133.0
2015-07-23	ABM	Stock	32.81	32.85	32.32	32.59	195300.0
2015-07-23	ABMD-DELISTED	Stock	75.33	75.8	73.0	73.14	450523.0

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

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