PREVIEW / stock_daily / 2017-02-10

all stock daily files

  file:    by_date/stock_daily/2017/2017-02-10.parquet
  size:    215 KB
  rows:    6,502
  symbols: 3,091

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-02-10	AAPL	Stock	33.115	33.235	33.0125	33.03	80262000.0
2017-02-10	MSFT	Stock	64.25	64.3	63.98	64.0	18170700.0
2017-02-10	NVDA	Stock	2.9983	3.0175	2.815	2.8405	1651092000.0
2017-02-10	AMZN	Stock	41.191	41.4	41.1425	41.373	48592000.0
2017-02-10	GOOGL	Stock	41.6475	41.8575	41.5255	41.7425	28302560.0
2017-02-10	META	Stock	134.1	134.94	133.68	134.19	15061900.0
2017-02-10	TSLA	Stock	17.986	18.0633	17.7407	17.9487	54295500.0
2017-02-10	TLT	Stock	120.11	120.95	120.11	120.76	7978462.0
2017-02-10	ES	Stock	55.89	56.45	55.89	56.42	700100.0
2017-02-10	CL	Stock	66.66	67.85	66.47	67.72	5568100.0
2017-02-10	A	Stock	50.51	50.59	50.02	50.36	2092500.0
2017-02-10	AA	Stock	37.92	38.54	37.505	38.3	3628600.0
2017-02-10	AAAP-DELISTED	Stock	35.45	37.5999	35.16	37.16	367236.0
2017-02-10	AABA-DELISTED	Stock	45.15	45.23	44.96	45.025	3532288.0
2017-02-10	AAC-DELISTED	Stock	7.99	8.11	7.88	7.9	80079.0
2017-02-10	AACG	Stock	3.47	3.54	3.38	3.54	19100.0
2017-02-10	AAIC-DELISTED	Stock	14.75	15.1	14.63	14.99	388591.0
2017-02-10	AAL	Stock	46.62	46.7	46.17	46.45	4040600.0
2017-02-10	AAMC-DELISTED	Stock	21.5735	22.7206	21.5735	22.1029	10887.0
2017-02-10	AAME	Stock	3.75	4.0	3.7	3.75	4000.0
2017-02-10	AAMI	Stock	14.75	14.98	14.695	14.85	363700.0
2017-02-10	AAOI	Stock	31.74	32.88	31.04	32.66	527800.0
2017-02-10	AAON	Stock	23.0333	23.1667	22.6667	22.9	203700.0
2017-02-10	AAP	Stock	165.23	165.87	163.19	164.05	734900.0
2017-02-10	AAT	Stock	43.26	43.92	43.07	43.9	81000.0
2017-02-10	AAU-DELISTED	Stock	1.19	1.23	1.16	1.23	232018.0
2017-02-10	AAUAF-DELISTED	Stock	1.19	1.23	1.16	1.23	234815.0
2017-02-10	AAV-DELISTED	Stock	6.7	6.7	6.45	6.45	113466.0
2017-02-10	AAWW-DELISTED	Stock	52.05	52.1	51.3	51.9	122500.0
2017-02-10	AAXJ	Stock	60.04	60.28	59.94	60.22	374089.0
2017-02-10	AAXN-DELISTED	Stock	27.0	27.4	26.87	27.34	977977.0
2017-02-10	AB	Stock	23.35	23.6	23.25	23.4	392400.0
2017-02-10	ABAC-DELISTED	Stock	3.5883	3.619	3.56	3.56	1600.0
2017-02-10	ABAX-DELISTED	Stock	50.36	50.5879	49.8	50.23	150690.0
2017-02-10	ABB-DELISTED	Stock	22.89	22.96	22.56	22.87	4583353.0
2017-02-10	ABBNY-DELISTED	Stock	22.89	22.96	22.56	22.88	4664083.0
2017-02-10	ABBV	Stock	60.85	61.0	60.27	60.42	5749200.0
2017-02-10	ABC-DELISTED	Stock	91.54	91.75	90.266	91.13	1343417.0
2017-02-10	ABCB	Stock	46.4	46.5	45.75	46.45	96600.0
2017-02-10	ABCD-DELISTED	Stock	4.93	5.0	4.91	4.92	22295.0
2017-02-10	ABCO-DELISTED	Stock	47.4	47.8	47.05	47.25	488338.0
2017-02-10	ABDC-DELISTED	Stock	12.32	12.5146	12.21	12.28	32990.0
2017-02-10	ABE-DELISTED	Stock	12.48	12.48	11.995	12.09	36594.0
2017-02-10	ABEO	Stock	128.75	131.25	125.0	127.5	7684.0
2017-02-10	ABEOW-DELISTED	Stock	2.87	3.0	2.87	3.0	250.0
2017-02-10	ABEV	Stock	5.39	5.5	5.37	5.46	9000400.0
2017-02-10	ABG	Stock	65.85	66.35	65.35	65.65	254400.0
2017-02-10	ABIL-DELISTED	Stock	3.4357	3.49	3.4357	3.49	1400.0
2017-02-10	ABM	Stock	40.28	40.8	40.24	40.56	249700.0
2017-02-10	ABMD-DELISTED	Stock	108.36	109.0	107.65	108.66	527964.0

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

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