PREVIEW / stock_daily / 2016-04-05

all stock daily files

  file:    by_date/stock_daily/2016/2016-04-05.parquet
  size:    218 KB
  rows:    6,547
  symbols: 3,312

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-04-05	AAPL	Stock	27.3775	27.6825	27.355	27.4525	106314800.0
2016-04-05	MSFT	Stock	55.19	55.3	54.46	54.56	19272300.0
2016-04-05	NVDA	Stock	0.887	0.902	0.8835	0.8938	339568000.0
2016-04-05	AMZN	Stock	29.5385	29.6735	29.2625	29.307	46178000.0
2016-04-05	GOOGL	Stock	37.9065	38.1435	37.78	37.9285	24478100.0
2016-04-05	META	Stock	112.11	113.32	111.9	112.22	22962400.0
2016-04-05	TSLA	Stock	16.0333	17.104	16.0	17.0313	149230500.0
2016-04-05	TLT	Stock	132.01	132.36	131.78	132.19	6482810.0
2016-04-05	ES	Stock	58.51	58.66	57.03	57.08	2299900.0
2016-04-05	CL	Stock	71.13	71.47	70.99	71.14	3870600.0
2016-04-05	A	Stock	39.73	39.89	39.19	39.26	1900700.0
2016-04-05	AA.B-DELISTED	Stock	31.28	32.5799	31.28	32.34	21332.0
2016-04-05	AAAP-DELISTED	Stock	35.49	36.455	34.55	34.75	227817.0
2016-04-05	AABA-DELISTED	Stock	36.7	36.925	36.22	36.41	11581997.0
2016-04-05	AAC-DELISTED	Stock	19.92	20.27	18.01	18.4103	253404.0
2016-04-05	AACG	Stock	5.47	6.91	5.36	5.51	94800.0
2016-04-05	AAIC-DELISTED	Stock	12.33	12.53	12.26	12.36	194356.0
2016-04-05	AAL	Stock	39.13	39.38	38.74	38.93	7648400.0
2016-04-05	AAMC-DELISTED	Stock	4.1941	4.2353	3.7765	4.1618	197839.0
2016-04-05	AAME	Stock	4.88	5.0	4.77	4.85	2900.0
2016-04-05	AAMI	Stock	13.21	13.28	12.92	13.0	143800.0
2016-04-05	AAOI	Stock	14.89	15.18	14.26	14.74	282900.0
2016-04-05	AAON	Stock	18.0	18.4533	17.8867	17.9467	330900.0
2016-04-05	AAP	Stock	158.5	160.9	158.1	160.47	724200.0
2016-04-05	AAT	Stock	39.51	39.72	38.86	38.93	146400.0
2016-04-05	AAU-DELISTED	Stock	0.6854	0.6874	0.67	0.6756	74633.0
2016-04-05	AAUAF-DELISTED	Stock	0.6854	0.6874	0.67	0.6756	75714.0
2016-04-05	AAV-DELISTED	Stock	5.02	5.14	4.99	5.11	51828.0
2016-04-05	AAVL-DELISTED	Stock	5.37	5.45	5.25	5.35	142923.0
2016-04-05	AAWW-DELISTED	Stock	40.42	40.58	39.39	39.42	195281.0
2016-04-05	AAXJ	Stock	53.25	53.2678	52.84	52.9	1358278.0
2016-04-05	AAXN-DELISTED	Stock	18.52	18.66	18.41	18.54	577939.0
2016-04-05	AB	Stock	24.0	24.2	23.59	24.01	210900.0
2016-04-05	ABAX-DELISTED	Stock	44.13	44.24	41.78	43.9	155449.0
2016-04-05	ABB-DELISTED	Stock	19.05	19.185	19.01	19.08	1641773.0
2016-04-05	ABBNY-DELISTED	Stock	19.05	19.185	19.01	19.09	1675097.0
2016-04-05	ABBV	Stock	58.54	59.56	58.09	58.54	6779400.0
2016-04-05	ABC-DELISTED	Stock	86.37	87.01	85.58	85.68	2298017.0
2016-04-05	ABCB	Stock	28.84	28.97	28.36	28.37	186300.0
2016-04-05	ABCD-DELISTED	Stock	4.16	4.24	4.1	4.16	13714.0
2016-04-05	ABCO-DELISTED	Stock	32.34	32.91	32.24	32.35	455638.0
2016-04-05	ABCW-DELISTED	Stock	44.93	45.07	44.53	44.56	24746.0
2016-04-05	ABDC-DELISTED	Stock	11.65	11.885	11.5	11.51	17095.0
2016-04-05	ABE-DELISTED	Stock	11.5815	11.583	11.55	11.55	4258.0
2016-04-05	ABEO	Stock	75.0	79.0	66.75	75.75	5972.0
2016-04-05	ABEOW-DELISTED	Stock	1.05	1.05	1.0	1.0	2766.0
2016-04-05	ABEV	Stock	5.06	5.09	4.99	5.09	10188500.0
2016-04-05	ABG	Stock	54.9	57.01	54.9	56.21	589600.0
2016-04-05	ABGB-DELISTED	Stock	1.5	1.51	1.428	1.49	20837.0
2016-04-05	ABIL-DELISTED	Stock	5.95	6.14	5.6901	5.77	2045.0

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

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