PREVIEW / stock_daily / 2017-07-31

all stock daily files

  file:    by_date/stock_daily/2017/2017-07-31.parquet
  size:    215 KB
  rows:    6,458
  symbols: 2,964

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
2017-07-31	AAPL	Stock	37.475	37.5825	37.0325	37.1825	79383600.0
2017-07-31	MSFT	Stock	73.3	73.44	72.41	72.7	23600100.0
2017-07-31	NVDA	Stock	4.1235	4.16	4.0155	4.0628	559672000.0
2017-07-31	AMZN	Stock	50.9525	50.9525	49.351	49.389	147042000.0
2017-07-31	GOOGL	Stock	48.0	48.0596	47.0863	47.275	45867780.0
2017-07-31	META	Stock	172.0	172.72	168.55	169.25	25478900.0
2017-07-31	TSLA	Stock	22.3667	22.766	21.4027	21.5647	128026500.0
2017-07-31	TLT	Stock	123.46	124.05	123.4	124.04	5464596.0
2017-07-31	ES	Stock	60.4	60.95	60.26	60.79	1190300.0
2017-07-31	CL	Stock	72.45	72.78	72.18	72.2	3196200.0
2017-07-31	A	Stock	60.32	60.62	59.76	59.79	1038700.0
2017-07-31	AA	Stock	35.97	36.44	35.665	36.4	2145900.0
2017-07-31	AAAP-DELISTED	Stock	47.4	48.97	47.04	47.78	117519.0
2017-07-31	AABA-DELISTED	Stock	59.7	59.89	58.07	58.31	6338074.0
2017-07-31	AAC-DELISTED	Stock	6.51	6.51	6.07	6.27	197768.0
2017-07-31	AACG	Stock	4.54	4.8	4.54	4.8	7200.0
2017-07-31	AAIC-DELISTED	Stock	12.83	12.97	12.825	12.9	318811.0
2017-07-31	AAL	Stock	50.85	51.23	50.04	50.44	6062900.0
2017-07-31	AAM.A-DELISTED	Stock	26.057	26.187	26.04	26.08	34846.0
2017-07-31	AAMC-DELISTED	Stock	27.0147	27.0588	27.0	27.0588	10040.0
2017-07-31	AAME	Stock	3.55	3.65	3.45	3.55	3800.0
2017-07-31	AAMI	Stock	14.94	15.19	14.85	15.07	860600.0
2017-07-31	AAOI	Stock	98.2	98.37	95.08	97.49	2091300.0
2017-07-31	AAON	Stock	22.5	22.6667	22.1667	22.5333	270450.0
2017-07-31	AAP	Stock	111.61	112.9	110.55	112.01	1977700.0
2017-07-31	AAT	Stock	40.18	40.7	39.8	40.61	171800.0
2017-07-31	AAU-DELISTED	Stock	1.18	1.2	1.16	1.18	323444.0
2017-07-31	AAUAF-DELISTED	Stock	1.18	1.2	1.16	1.18	342917.0
2017-07-31	AAV-DELISTED	Stock	7.05	7.05	6.825	6.85	69546.0
2017-07-31	AAWW-DELISTED	Stock	58.9	59.65	58.45	59.35	362221.0
2017-07-31	AAXJ	Stock	71.06	71.06	70.76	70.84	608628.0
2017-07-31	AAXN-DELISTED	Stock	24.66	24.74	24.18	24.6	539061.0
2017-07-31	AB	Stock	24.25	24.8	24.2	24.75	279400.0
2017-07-31	ABAC-DELISTED	Stock	2.57	2.57	2.44	2.4486	3537.0
2017-07-31	ABAX-DELISTED	Stock	47.54	47.54	46.69	47.0	125733.0
2017-07-31	ABB-DELISTED	Stock	23.53	23.5858	23.46	23.5	903721.0
2017-07-31	ABBNY-DELISTED	Stock	23.53	23.5858	23.46	23.5	947332.0
2017-07-31	ABBV	Stock	70.52	70.58	69.83	69.91	7770400.0
2017-07-31	ABC-DELISTED	Stock	94.3	94.42	93.25	93.8	877288.0
2017-07-31	ABCB	Stock	45.8	46.3	45.05	45.8	142700.0
2017-07-31	ABCD-DELISTED	Stock	4.84	4.96	4.77	4.95	18847.0
2017-07-31	ABCO-DELISTED	Stock	56.8	57.0	56.075	56.2	224236.0
2017-07-31	ABDC-DELISTED	Stock	11.96	11.96	11.61	11.95	40171.0
2017-07-31	ABE-DELISTED	Stock	14.3	14.3	14.1892	14.3	3306.0
2017-07-31	ABEO	Stock	220.0	225.0	208.75	211.25	20136.0
2017-07-31	ABEOW-DELISTED	Stock	4.5135	4.6129	4.5	4.5	913.0
2017-07-31	ABEV	Stock	6.13	6.16	6.06	6.08	19448000.0
2017-07-31	ABG	Stock	55.4	55.75	53.45	54.0	287800.0
2017-07-31	ABIL-DELISTED	Stock	0.7599	0.77	0.72	0.7401	113842.0
2017-07-31	ABM	Stock	44.85	44.85	44.45	44.62	337500.0

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

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