PREVIEW / stock_daily / 2016-05-25

all stock daily files

  file:    by_date/stock_daily/2016/2016-05-25.parquet
  size:    219 KB
  rows:    6,552
  symbols: 3,288

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-05-25	AAPL	Stock	24.6675	24.935	24.5275	24.905	152675200.0
2016-05-25	MSFT	Stock	51.92	52.49	51.79	52.12	24040200.0
2016-05-25	NVDA	Stock	1.1375	1.1422	1.1203	1.1292	458076000.0
2016-05-25	AMZN	Stock	35.4	35.543	35.276	35.4175	65354000.0
2016-05-25	GOOGL	Stock	36.75	36.9945	36.63	36.905	32332480.0
2016-05-25	META	Stock	118.13	118.67	117.38	117.89	20019800.0
2016-05-25	TSLA	Stock	14.5273	14.7573	14.434	14.6387	46902000.0
2016-05-25	TLT	Stock	129.83	130.245	129.31	129.37	6367396.0
2016-05-25	ES	Stock	54.51	54.78	54.19	54.3	1505600.0
2016-05-25	CL	Stock	70.96	71.15	70.64	70.67	2098500.0
2016-05-25	A	Stock	45.12	45.61	45.12	45.42	2352400.0
2016-05-25	AA.B-DELISTED	Stock	33.0	33.67	33.0	33.41	22387.0
2016-05-25	AAAP-DELISTED	Stock	29.52	29.7	29.01	29.27	20031.0
2016-05-25	AABA-DELISTED	Stock	36.71	36.96	35.47	35.59	32526676.0
2016-05-25	AAC-DELISTED	Stock	21.58	22.45	21.04	21.21	325372.0
2016-05-25	AACG	Stock	5.29	5.29	4.78	5.0	3800.0
2016-05-25	AAIC-DELISTED	Stock	12.94	13.13	12.92	13.01	387421.0
2016-05-25	AAL	Stock	32.39	32.9	32.1	32.17	7401800.0
2016-05-25	AAMC-DELISTED	Stock	4.3147	4.9823	4.2118	4.7265	88927.0
2016-05-25	AAME	Stock	3.21	3.49	3.21	3.49	2000.0
2016-05-25	AAMI	Stock	14.9	15.1	14.81	14.83	417500.0
2016-05-25	AAOI	Stock	10.18	10.265	9.795	10.11	471700.0
2016-05-25	AAON	Stock	18.8267	18.96	18.6867	18.78	172800.0
2016-05-25	AAP	Stock	149.28	154.34	148.79	153.53	1681000.0
2016-05-25	AAT	Stock	39.68	39.76	39.08	39.66	84600.0
2016-05-25	AAU-DELISTED	Stock	1.03	1.065	1.0	1.04	560712.0
2016-05-25	AAUAF-DELISTED	Stock	1.03	1.065	1.0	1.04	564685.0
2016-05-25	AAV-DELISTED	Stock	5.77	5.95	5.77	5.91	44435.0
2016-05-25	AAWW-DELISTED	Stock	44.02	45.11	43.83	44.97	227811.0
2016-05-25	AAXJ	Stock	52.36	52.69	52.36	52.55	515540.0
2016-05-25	AAXN-DELISTED	Stock	21.95	22.16	21.8763	21.95	597092.0
2016-05-25	AB	Stock	23.4	23.67	23.28	23.38	175500.0
2016-05-25	ABAC-DELISTED	Stock	0.71	0.719	0.631	0.676	5609.0
2016-05-25	ABAX-DELISTED	Stock	45.78	46.29	45.09	45.93	140663.0
2016-05-25	ABB-DELISTED	Stock	20.67	20.755	20.65	20.7	1422670.0
2016-05-25	ABBNY-DELISTED	Stock	20.67	20.755	20.65	20.69	1475416.0
2016-05-25	ABBV	Stock	61.08	61.47	60.79	61.22	5857600.0
2016-05-25	ABC-DELISTED	Stock	74.59	74.75	73.87	74.02	1482671.0
2016-05-25	ABCB	Stock	31.34	32.23	31.34	32.0	522600.0
2016-05-25	ABCD-DELISTED	Stock	4.59	4.68	4.58	4.67	13429.0
2016-05-25	ABCO-DELISTED	Stock	32.01	32.49	31.87	32.31	301569.0
2016-05-25	ABDC-DELISTED	Stock	12.02	12.1	11.93	12.0501	14509.0
2016-05-25	ABE-DELISTED	Stock	11.7	11.72	11.69	11.71	7219.0
2016-05-25	ABEO	Stock	66.25	78.0	66.25	76.0	8320.0
2016-05-25	ABEOW-DELISTED	Stock	0.8	0.9	0.8	0.9	41884.0
2016-05-25	ABEV	Stock	5.22	5.33	5.21	5.27	43941300.0
2016-05-25	ABG	Stock	53.62	55.22	53.22	55.04	192400.0
2016-05-25	ABIL-DELISTED	Stock	2.7	2.8	2.65	2.74	29372.0
2016-05-25	ABM	Stock	33.43	33.52	33.3	33.38	168200.0
2016-05-25	ABMD-DELISTED	Stock	99.81	99.95	98.8	98.96	323367.0

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

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