PREVIEW / stock_daily / 2016-04-04

all stock daily files

  file:    by_date/stock_daily/2016/2016-04-04.parquet
  size:    219 KB
  rows:    6,586
  symbols: 3,333

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-04	AAPL	Stock	27.605	28.0475	27.5675	27.78	149424800.0
2016-04-04	MSFT	Stock	55.43	55.66	55.0	55.43	18928800.0
2016-04-04	NVDA	Stock	0.9113	0.916	0.8915	0.895	393940000.0
2016-04-04	AMZN	Stock	29.95	29.975	29.5275	29.6595	49416000.0
2016-04-04	GOOGL	Stock	38.4755	38.622	38.0892	38.256	26928480.0
2016-04-04	META	Stock	114.07	114.55	111.61	112.55	48487900.0
2016-04-04	TSLA	Stock	16.608	16.808	16.2427	16.466	202129500.0
2016-04-04	TLT	Stock	130.79	130.97	130.27	130.76	5145057.0
2016-04-04	ES	Stock	58.87	59.09	58.28	58.59	1290200.0
2016-04-04	CL	Stock	70.87	71.27	70.59	71.16	2641100.0
2016-04-04	A	Stock	40.32	40.52	39.8	40.01	2958100.0
2016-04-04	AA.B-DELISTED	Stock	32.6	32.96	32.09	32.22	22581.0
2016-04-04	AAAP-DELISTED	Stock	35.4001	36.13	35.25	35.25	7900.0
2016-04-04	AABA-DELISTED	Stock	36.55	37.5	36.54	37.02	19395882.0
2016-04-04	AAC-DELISTED	Stock	20.97	20.97	19.64	20.1	178074.0
2016-04-04	AACG	Stock	5.48	5.49	5.39	5.49	4400.0
2016-04-04	AAIC-DELISTED	Stock	12.67	12.76	12.4	12.41	195099.0
2016-04-04	AAL	Stock	39.81	40.24	39.15	39.37	7831200.0
2016-04-04	AAMC-DELISTED	Stock	3.8618	4.4706	3.8265	4.2	69112.0
2016-04-04	AAME	Stock	4.85	5.0	4.52	4.81	6100.0
2016-04-04	AAMI	Stock	13.41	13.56	13.01	13.34	196100.0
2016-04-04	AAOI	Stock	15.05	15.54	14.83	15.09	243100.0
2016-04-04	AAON	Stock	18.8333	18.8467	18.0933	18.1267	388500.0
2016-04-04	AAP	Stock	161.21	164.14	157.56	159.23	1041000.0
2016-04-04	AAT	Stock	39.54	39.77	39.37	39.74	151500.0
2016-04-04	AAU-DELISTED	Stock	0.7	0.71	0.6722	0.69	89178.0
2016-04-04	AAUAF-DELISTED	Stock	0.7	0.71	0.6722	0.69	89452.0
2016-04-04	AAV-DELISTED	Stock	5.2	5.26	5.09	5.09	69218.0
2016-04-04	AAVL-DELISTED	Stock	5.22	5.5	5.12	5.41	408011.0
2016-04-04	AAWW-DELISTED	Stock	41.19	41.77	40.75	40.81	123601.0
2016-04-04	AAXJ	Stock	54.34	54.35	53.86	53.93	1810583.0
2016-04-04	AAXN-DELISTED	Stock	19.0	19.21	18.6	18.62	751314.0
2016-04-04	AB	Stock	24.4	24.51	24.01	24.13	315500.0
2016-04-04	ABAC-DELISTED	Stock	0.69	0.69	0.69	0.69	345.0
2016-04-04	ABAX-DELISTED	Stock	44.75	44.82	43.92	44.76	163061.0
2016-04-04	ABB-DELISTED	Stock	19.54	19.58	19.325	19.38	1778047.0
2016-04-04	ABBNY-DELISTED	Stock	19.54	19.58	19.325	19.39	1822405.0
2016-04-04	ABBV	Stock	57.64	59.4	57.49	59.21	8108100.0
2016-04-04	ABC-DELISTED	Stock	86.74	88.1	86.61	87.16	2030623.0
2016-04-04	ABCB	Stock	29.49	29.87	29.05	29.1	143600.0
2016-04-04	ABCD-DELISTED	Stock	4.2	4.22	4.12	4.2	26126.0
2016-04-04	ABCO-DELISTED	Stock	32.85	33.26	32.38	32.5	610488.0
2016-04-04	ABCW-DELISTED	Stock	45.2	45.36	44.95	45.13	23196.0
2016-04-04	ABDC-DELISTED	Stock	11.63	11.87	11.565	11.78	42690.0
2016-04-04	ABE-DELISTED	Stock	11.78	11.79	11.71	11.71	8538.0
2016-04-04	ABEO	Stock	72.0	79.75	71.25	75.25	12536.0
2016-04-04	ABEOW-DELISTED	Stock	0.92	1.03	0.92	0.99	7590.0
2016-04-04	ABEV	Stock	5.15	5.17	5.07	5.1	14530500.0
2016-04-04	ABG	Stock	56.6	56.98	55.17	55.39	612300.0
2016-04-04	ABGB-DELISTED	Stock	1.55	1.55	1.49	1.52	13602.0

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

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