PREVIEW / stock_daily / 2016-03-31

all stock daily files

  file:    by_date/stock_daily/2016/2016-03-31.parquet
  size:    220 KB
  rows:    6,626
  symbols: 3,364

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
2016-03-31	AAPL	Stock	27.43	27.475	27.22	27.2475	103553600.0
2016-03-31	MSFT	Stock	54.95	55.59	54.86	55.23	26360500.0
2016-03-31	NVDA	Stock	0.898	0.9	0.8838	0.8908	379884000.0
2016-03-31	AMZN	Stock	29.964	30.0375	29.6105	29.682	53636000.0
2016-03-31	GOOGL	Stock	38.417	38.4542	37.9125	38.145	32553380.0
2016-03-31	META	Stock	114.7	115.01	113.77	114.1	21207500.0
2016-03-31	TSLA	Stock	15.2893	15.828	15.0007	15.318	120193500.0
2016-03-31	TLT	Stock	129.98	130.805	129.79	130.61	7832575.0
2016-03-31	ES	Stock	58.06	58.51	58.03	58.34	2432400.0
2016-03-31	CL	Stock	70.72	71.0	70.51	70.65	2944600.0
2016-03-31	A	Stock	40.01	40.1	39.66	39.85	3143500.0
2016-03-31	AA.B-DELISTED	Stock	32.99	33.199	32.21	32.91	48780.0
2016-03-31	AAAP-DELISTED	Stock	35.44	35.75	35.35	35.42	27469.0
2016-03-31	AABA-DELISTED	Stock	36.51	37.02	36.5	36.81	17307965.0
2016-03-31	AAC-DELISTED	Stock	19.68	20.44	19.4807	19.79	410682.0
2016-03-31	AACG	Stock	5.05	5.47	5.05	5.19	21000.0
2016-03-31	AAIC-DELISTED	Stock	12.66	12.78	12.53	12.53	344771.0
2016-03-31	AAL	Stock	41.5	41.68	40.98	41.01	8138000.0
2016-03-31	AAMC-DELISTED	Stock	3.5	3.5265	3.3706	3.4706	116205.0
2016-03-31	AAME	Stock	4.25	4.64	4.25	4.45	6900.0
2016-03-31	AAMI	Stock	13.29	13.47	13.2	13.35	206400.0
2016-03-31	AAOI	Stock	15.21	15.25	14.71	14.91	237300.0
2016-03-31	AAON	Stock	18.5467	18.7733	18.46	18.6667	310800.0
2016-03-31	AAP	Stock	162.48	162.71	160.25	160.34	1037300.0
2016-03-31	AAT	Stock	39.47	39.95	39.18	39.92	183300.0
2016-03-31	AAU-DELISTED	Stock	0.69	0.7179	0.69	0.7062	63981.0
2016-03-31	AAUAF-DELISTED	Stock	0.69	0.7179	0.69	0.7062	65154.0
2016-03-31	AAV-DELISTED	Stock	5.47	5.54	5.36	5.48	59213.0
2016-03-31	AAVL-DELISTED	Stock	5.01	5.39	4.94	5.16	329246.0
2016-03-31	AAWW-DELISTED	Stock	42.18	42.43	41.47	42.28	177617.0
2016-03-31	AAXJ	Stock	54.91	54.99	54.58	54.63	583107.0
2016-03-31	AAXN-DELISTED	Stock	19.58	19.89	19.38	19.63	826230.0
2016-03-31	AB	Stock	22.43	23.81	22.43	23.43	352200.0
2016-03-31	ABAC-DELISTED	Stock	0.69	0.69	0.69	0.69	300.0
2016-03-31	ABAX-DELISTED	Stock	44.24	45.81	44.24	45.39	140209.0
2016-03-31	ABB-DELISTED	Stock	19.46	19.52	19.38	19.42	1515102.0
2016-03-31	ABBNY-DELISTED	Stock	19.46	19.52	19.38	19.42	1551985.0
2016-03-31	ABBV	Stock	57.02	57.46	56.82	57.12	4930300.0
2016-03-31	ABC-DELISTED	Stock	87.13	87.74	86.3	86.56	1532550.0
2016-03-31	ABCB	Stock	29.08	29.67	28.96	29.58	169800.0
2016-03-31	ABCD-DELISTED	Stock	4.35	4.41	4.27	4.27	22909.0
2016-03-31	ABCO-DELISTED	Stock	32.13	32.3599	31.81	32.25	306027.0
2016-03-31	ABCW-DELISTED	Stock	45.38	45.51	44.95	45.08	81419.0
2016-03-31	ABDC-DELISTED	Stock	11.54	11.65	11.34	11.62	35841.0
2016-03-31	ABE-DELISTED	Stock	11.58	11.716	11.58	11.63	4962.0
2016-03-31	ABEO	Stock	66.75	69.5	63.75	64.0	1884.0
2016-03-31	ABEOW-DELISTED	Stock	0.85	0.85	0.85	0.85	100.0
2016-03-31	ABEV	Stock	5.24	5.27	5.15	5.18	16452800.0
2016-03-31	ABG	Stock	61.7	62.0	59.47	59.84	454000.0
2016-03-31	ABGB-DELISTED	Stock	1.48	1.5	1.43	1.43	60370.0

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

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