PREVIEW / stock_daily / 2016-07-25

all stock daily files

  file:    by_date/stock_daily/2016/2016-07-25.parquet
  size:    219 KB
  rows:    6,556
  symbols: 3,253

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-07-25	AAPL	Stock	24.5625	24.71	24.23	24.335	161531600.0
2016-07-25	MSFT	Stock	56.47	56.74	56.26	56.73	25610600.0
2016-07-25	NVDA	Stock	1.375	1.3953	1.369	1.392	312528000.0
2016-07-25	AMZN	Stock	37.3275	37.425	36.7675	36.9805	53586000.0
2016-07-25	GOOGL	Stock	37.884	37.9912	37.7035	37.876	21466200.0
2016-07-25	META	Stock	121.39	121.85	117.78	121.63	18487400.0
2016-07-25	TSLA	Stock	14.818	15.426	14.758	15.334	67360500.0
2016-07-25	TLT	Stock	138.94	139.26	138.5867	138.7	4243800.0
2016-07-25	ES	Stock	58.78	58.99	58.43	58.87	677000.0
2016-07-25	CL	Stock	74.4	74.57	73.99	74.23	1856700.0
2016-07-25	A	Stock	46.49	46.52	45.92	46.14	1719800.0
2016-07-25	AA.B-DELISTED	Stock	36.09	36.09	35.7	35.84	49972.0
2016-07-25	AAAP-DELISTED	Stock	30.63	32.5867	30.62	31.02	157299.0
2016-07-25	AABA-DELISTED	Stock	39.2	39.21	38.22	38.32	38752772.0
2016-07-25	AAC-DELISTED	Stock	22.12	22.88	21.77	22.64	55531.0
2016-07-25	AACG	Stock	4.28	4.28	3.8	3.81	6300.0
2016-07-25	AAIC-DELISTED	Stock	13.45	13.49	13.37	13.41	127616.0
2016-07-25	AAL	Stock	36.35	36.4	35.52	35.8	9526700.0
2016-07-25	AAMC-DELISTED	Stock	4.4618	4.5735	4.0059	4.0676	113407.0
2016-07-25	AAME	Stock	4.2	4.25	3.96	4.0	5100.0
2016-07-25	AAMI	Stock	13.9	14.02	13.69	13.81	115900.0
2016-07-25	AAOI	Stock	12.27	12.49	12.165	12.33	190800.0
2016-07-25	AAON	Stock	17.6867	17.7667	17.6467	17.7	89100.0
2016-07-25	AAP	Stock	165.99	166.77	165.38	166.67	502800.0
2016-07-25	AAT	Stock	45.3	45.63	45.09	45.42	144700.0
2016-07-25	AAU-DELISTED	Stock	1.34	1.34	1.31	1.33	339334.0
2016-07-25	AAUAF-DELISTED	Stock	1.34	1.34	1.31	1.33	341447.0
2016-07-25	AAV-DELISTED	Stock	6.49	6.5	6.22	6.22	85889.0
2016-07-25	AAWW-DELISTED	Stock	41.9	43.26	41.265	41.82	106877.0
2016-07-25	AAXJ	Stock	56.99	57.11	56.77	56.82	429433.0
2016-07-25	AAXN-DELISTED	Stock	28.53	28.74	28.4073	28.5	707950.0
2016-07-25	AB	Stock	24.41	24.69	24.38	24.6	124800.0
2016-07-25	ABAC-DELISTED	Stock	0.7999	0.8	0.79	0.7956	2900.0
2016-07-25	ABAX-DELISTED	Stock	46.29	47.94	46.041	47.8	300455.0
2016-07-25	ABB-DELISTED	Stock	20.86	20.88	20.745	20.84	910607.0
2016-07-25	ABBNY-DELISTED	Stock	20.86	20.88	20.745	20.84	1120643.0
2016-07-25	ABBV	Stock	63.91	64.5	63.71	64.32	7241200.0
2016-07-25	ABC-DELISTED	Stock	85.9	85.93	85.01	85.43	1691794.0
2016-07-25	ABCB	Stock	32.06	32.72	32.06	32.59	272100.0
2016-07-25	ABCD-DELISTED	Stock	4.83	4.83	4.6411	4.7699	22225.0
2016-07-25	ABCO-DELISTED	Stock	37.96	38.47	37.78	37.81	155680.0
2016-07-25	ABDC-DELISTED	Stock	12.28	12.39	12.21	12.25	21288.0
2016-07-25	ABE-DELISTED	Stock	12.46	12.47	12.42	12.4441	2489.0
2016-07-25	ABEO	Stock	63.0	68.75	61.75	63.75	2180.0
2016-07-25	ABEOW-DELISTED	Stock	1.0	1.0	1.0	1.0	1845.0
2016-07-25	ABEV	Stock	5.83	5.9	5.82	5.86	6097200.0
2016-07-25	ABG	Stock	61.25	61.77	60.56	60.91	211900.0
2016-07-25	ABIL-DELISTED	Stock	4.5	4.52	4.11	4.45	55798.0
2016-07-25	ABM	Stock	37.44	37.44	37.1	37.29	196500.0
2016-07-25	ABMD-DELISTED	Stock	116.35	116.41	114.26	114.66	682940.0

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

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