PREVIEW / stock_daily / 2016-04-06

all stock daily files

  file:    by_date/stock_daily/2016/2016-04-06.parquet
  size:    218 KB
  rows:    6,552
  symbols: 3,311

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-06	AAPL	Stock	27.5575	27.745	27.3	27.74	105616400.0
2016-04-06	MSFT	Stock	54.36	55.2	54.21	55.12	21188700.0
2016-04-06	NVDA	Stock	0.8825	0.8955	0.8658	0.895	453376000.0
2016-04-06	AMZN	Stock	29.376	30.1195	29.375	30.104	56998000.0
2016-04-06	GOOGL	Stock	37.892	38.421	37.815	38.4035	25311540.0
2016-04-06	META	Stock	112.47	113.81	112.42	113.71	20814600.0
2016-04-06	TSLA	Stock	16.9313	17.8493	16.8967	17.6947	175582500.0
2016-04-06	TLT	Stock	131.53	131.67	130.74	131.23	6393875.0
2016-04-06	ES	Stock	57.0	57.17	56.54	56.89	2047000.0
2016-04-06	CL	Stock	71.11	71.42	70.87	71.41	3442000.0
2016-04-06	A	Stock	39.29	40.25	39.17	40.24	1566600.0
2016-04-06	AA.B-DELISTED	Stock	32.25	32.7499	31.7728	32.61	20578.0
2016-04-06	AAAP-DELISTED	Stock	35.3999	37.9	35.16	36.81	11500.0
2016-04-06	AABA-DELISTED	Stock	36.4	37.0	36.31	36.66	18697467.0
2016-04-06	AAC-DELISTED	Stock	18.95	19.04	17.81	18.57	276209.0
2016-04-06	AACG	Stock	5.45	5.84	5.19	5.44	31300.0
2016-04-06	AAIC-DELISTED	Stock	12.36	12.48	12.14	12.23	231230.0
2016-04-06	AAL	Stock	39.07	39.07	38.34	38.9	5650000.0
2016-04-06	AAMC-DELISTED	Stock	4.25	4.9735	4.1912	4.8794	73253.0
2016-04-06	AAME	Stock	4.91	4.91	4.86	4.9	500.0
2016-04-06	AAMI	Stock	13.02	13.15	12.97	13.0	147600.0
2016-04-06	AAOI	Stock	14.8	15.13	14.27	14.88	179400.0
2016-04-06	AAON	Stock	17.8867	17.9933	17.7333	17.94	449850.0
2016-04-06	AAP	Stock	160.9	161.07	158.18	159.88	694900.0
2016-04-06	AAT	Stock	38.88	38.94	38.51	38.7	140300.0
2016-04-06	AAU-DELISTED	Stock	0.6585	0.6895	0.6585	0.6807	34042.0
2016-04-06	AAUAF-DELISTED	Stock	0.6585	0.6895	0.6585	0.6807	34581.0
2016-04-06	AAV-DELISTED	Stock	5.18	5.23	5.09	5.21	70687.0
2016-04-06	AAVL-DELISTED	Stock	5.38	5.65	5.31	5.48	373535.0
2016-04-06	AAWW-DELISTED	Stock	39.55	39.95	38.64	39.12	151135.0
2016-04-06	AAXJ	Stock	53.02	53.66	52.88	53.64	476042.0
2016-04-06	AAXN-DELISTED	Stock	18.49	18.77	18.45	18.68	660733.0
2016-04-06	AB	Stock	24.05	24.28	23.8	24.01	241500.0
2016-04-06	ABAC-DELISTED	Stock	0.55	0.665	0.55	0.65	17676.0
2016-04-06	ABAX-DELISTED	Stock	43.87	44.8	42.8	44.56	96367.0
2016-04-06	ABB-DELISTED	Stock	19.02	19.22	18.96	19.21	2606590.0
2016-04-06	ABBNY-DELISTED	Stock	19.02	19.22	18.96	19.2	2760531.0
2016-04-06	ABBV	Stock	58.52	59.9	58.52	59.89	6322800.0
2016-04-06	ABC-DELISTED	Stock	85.76	87.6	85.72	87.56	2524048.0
2016-04-06	ABCB	Stock	28.45	28.69	28.18	28.51	160600.0
2016-04-06	ABCD-DELISTED	Stock	4.16	4.2	4.12	4.14	25391.0
2016-04-06	ABCO-DELISTED	Stock	32.22	32.8	32.1	32.68	296059.0
2016-04-06	ABCW-DELISTED	Stock	44.48	44.8	44.48	44.71	20399.0
2016-04-06	ABDC-DELISTED	Stock	11.5	11.99	11.3701	11.91	25911.0
2016-04-06	ABE-DELISTED	Stock	11.5566	11.6399	11.53	11.6399	4133.0
2016-04-06	ABEO	Stock	76.25	78.25	72.5	74.0	4240.0
2016-04-06	ABEOW-DELISTED	Stock	1.0	1.0	1.0	1.0	2334.0
2016-04-06	ABEV	Stock	5.02	5.06	4.96	5.05	6953300.0
2016-04-06	ABG	Stock	56.22	56.88	55.52	56.44	338400.0
2016-04-06	ABGB-DELISTED	Stock	1.48	1.55	1.48	1.54	43236.0

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

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