PREVIEW / stock_daily / 2016-03-08

all stock daily files

  file:    by_date/stock_daily/2016/2016-03-08.parquet
  size:    219 KB
  rows:    6,558
  symbols: 3,320

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-08	AAPL	Stock	25.195	25.44	25.1	25.2575	126247600.0
2016-03-08	MSFT	Stock	50.8	52.13	50.6	51.65	33835100.0
2016-03-08	NVDA	Stock	0.8002	0.805	0.7912	0.7938	274940000.0
2016-03-08	AMZN	Stock	27.8935	28.5675	27.737	28.013	94600000.0
2016-03-08	GOOGL	Stock	35.4195	36.1125	35.2	35.6765	52529900.0
2016-03-08	META	Stock	104.78	107.37	104.4	105.93	25617000.0
2016-03-08	TSLA	Stock	13.5667	13.8333	13.48	13.5067	62680500.0
2016-03-08	TLT	Stock	130.35	130.99	129.95	129.98	7175371.0
2016-03-08	ES	Stock	56.35	57.03	55.89	56.69	1955800.0
2016-03-08	CL	Stock	67.21	67.93	66.86	67.53	2253000.0
2016-03-08	A	Stock	38.97	39.13	38.01	38.09	1801500.0
2016-03-08	AA.B-DELISTED	Stock	33.28	33.28	31.4	31.5	105278.0
2016-03-08	AAAP-DELISTED	Stock	34.65	35.65	33.72	34.59	89734.0
2016-03-08	AABA-DELISTED	Stock	33.66	33.82	32.84	32.94	17835634.0
2016-03-08	AAC-DELISTED	Stock	17.75	17.75	16.6	16.61	410314.0
2016-03-08	AACG	Stock	4.78	4.93	4.64	4.79	2600.0
2016-03-08	AAIC-DELISTED	Stock	13.06	13.135	12.65	12.75	272025.0
2016-03-08	AAL	Stock	41.3	41.41	40.05	40.77	8418300.0
2016-03-08	AAMC-DELISTED	Stock	4.0588	4.1294	3.7324	3.9176	58065.0
2016-03-08	AAMI	Stock	11.88	11.88	11.4	11.56	96400.0
2016-03-08	AAOI	Stock	17.84	17.84	16.96	16.99	164800.0
2016-03-08	AAON	Stock	17.1667	17.1667	16.56	16.9267	335100.0
2016-03-08	AAP	Stock	150.59	152.65	149.17	149.68	1016200.0
2016-03-08	AAT	Stock	38.01	38.33	37.8	37.85	128200.0
2016-03-08	AAU-DELISTED	Stock	0.7425	0.7599	0.69	0.6923	248272.0
2016-03-08	AAUAF-DELISTED	Stock	0.7425	0.7599	0.69	0.6906	249401.0
2016-03-08	AAV-DELISTED	Stock	5.0	5.22	4.817	5.22	123950.0
2016-03-08	AAVL-DELISTED	Stock	5.66	5.7	5.16	5.19	241910.0
2016-03-08	AAWW-DELISTED	Stock	39.88	40.37	38.45	38.46	219578.0
2016-03-08	AAXJ	Stock	51.83	51.9	51.5	51.54	614277.0
2016-03-08	AAXN-DELISTED	Stock	19.81	20.22	19.52	19.54	1191338.0
2016-03-08	AB	Stock	21.53	21.9	21.44	21.65	223800.0
2016-03-08	ABAC-DELISTED	Stock	0.639	0.6529	0.6284	0.629	11718.0
2016-03-08	ABAX-DELISTED	Stock	42.14	42.14	40.53	41.01	167422.0
2016-03-08	ABB-DELISTED	Stock	18.4	18.42	18.195	18.21	1634842.0
2016-03-08	ABBNY-DELISTED	Stock	18.4	18.42	18.195	18.22	1689527.0
2016-03-08	ABBV	Stock	56.18	56.47	55.23	55.32	5303700.0
2016-03-08	ABC-DELISTED	Stock	88.33	88.34	87.14	87.8	1684527.0
2016-03-08	ABCB	Stock	28.02	28.21	27.28	27.93	101900.0
2016-03-08	ABCD-DELISTED	Stock	4.54	4.64	4.42	4.46	25701.0
2016-03-08	ABCO-DELISTED	Stock	30.19	30.3099	29.26	29.31	253103.0
2016-03-08	ABCW-DELISTED	Stock	43.32	43.55	43.102	43.19	28377.0
2016-03-08	ABDC-DELISTED	Stock	10.15	10.24	10.07	10.16	20465.0
2016-03-08	ABE-DELISTED	Stock	10.99	10.99	10.96	10.986	2547.0
2016-03-08	ABEO	Stock	70.5	70.5	64.75	65.75	1668.0
2016-03-08	ABEOW-DELISTED	Stock	0.903	0.903	0.903	0.903	500.0
2016-03-08	ABEV	Stock	5.04	5.05	4.94	5.0	19438000.0
2016-03-08	ABG	Stock	60.58	61.18	57.87	58.25	786100.0
2016-03-08	ABGB-DELISTED	Stock	1.85	2.249	1.85	1.91	294505.0
2016-03-08	ABIL-DELISTED	Stock	6.45	6.8499	6.34	6.35	12054.0

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

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