PREVIEW / stock_daily / 2016-02-03

all stock daily files

  file:    by_date/stock_daily/2016/2016-02-03.parquet
  size:    218 KB
  rows:    6,588
  symbols: 3,357

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-02-03	AAPL	Stock	23.75	24.21	23.52	24.0875	183857200.0
2016-02-03	MSFT	Stock	53.25	53.39	51.26	52.16	57559800.0
2016-02-03	NVDA	Stock	0.707	0.7113	0.6888	0.705	326772000.0
2016-02-03	AMZN	Stock	27.675	27.8	26.095	26.5535	200974000.0
2016-02-03	GOOGL	Stock	39.314	39.5715	36.813	37.469	131114620.0
2016-02-03	META	Stock	115.27	115.34	109.75	112.69	56919300.0
2016-02-03	TSLA	Stock	12.2393	12.2627	11.3453	11.5653	118971000.0
2016-02-03	TLT	Stock	128.28	129.94	127.92	127.95	13308995.0
2016-02-03	ES	Stock	55.47	55.97	55.34	55.72	1939300.0
2016-02-03	CL	Stock	65.84	66.26	65.0	66.03	4037600.0
2016-02-03	A	Stock	37.27	37.36	36.29	37.19	2128100.0
2016-02-03	AA.B-DELISTED	Stock	25.77	26.9972	25.32	26.82	88581.0
2016-02-03	AAAP-DELISTED	Stock	24.39	25.73	23.71	25.02	47982.0
2016-02-03	AABA-DELISTED	Stock	28.45	28.61	26.57	27.67	52757527.0
2016-02-03	AAC-DELISTED	Stock	18.1	18.4	17.54	18.29	77226.0
2016-02-03	AACG	Stock	5.59	5.6	5.25	5.25	2900.0
2016-02-03	AAIC-DELISTED	Stock	10.93	11.88	10.93	11.86	647861.0
2016-02-03	AAL	Stock	37.38	37.61	35.76	37.51	12390500.0
2016-02-03	AAMC-DELISTED	Stock	4.4647	4.6118	4.3824	4.6118	114165.0
2016-02-03	AAME	Stock	4.5	4.5	4.5	4.5	200.0
2016-02-03	AAMI	Stock	10.47	10.7	10.27	10.67	268000.0
2016-02-03	AAOI	Stock	15.7	15.7	15.02	15.42	197600.0
2016-02-03	AAON	Stock	14.0467	14.2067	13.7	14.0267	139050.0
2016-02-03	AAP	Stock	151.58	152.95	146.02	147.94	1513600.0
2016-02-03	AAT	Stock	37.29	37.4	36.71	37.1	264800.0
2016-02-03	AAU-DELISTED	Stock	0.63	0.649	0.583	0.62	38634.0
2016-02-03	AAUAF-DELISTED	Stock	0.63	0.649	0.583	0.62	41088.0
2016-02-03	AAV-DELISTED	Stock	5.39	5.51	5.23	5.5	377750.0
2016-02-03	AAVL-DELISTED	Stock	4.89	4.89	4.525	4.7	576860.0
2016-02-03	AAWW-DELISTED	Stock	35.83	35.83	33.89	35.0	223593.0
2016-02-03	AAXJ	Stock	48.31	48.89	47.5	48.87	2164332.0
2016-02-03	AAXN-DELISTED	Stock	14.8	15.15	14.22	15.06	833430.0
2016-02-03	AB	Stock	18.15	18.61	17.8	18.11	200000.0
2016-02-03	ABAC-DELISTED	Stock	0.6599	0.6599	0.55	0.56	11540.0
2016-02-03	ABAX-DELISTED	Stock	43.32	43.73	41.71	42.41	228806.0
2016-02-03	ABB-DELISTED	Stock	17.05	17.2799	16.84	17.24	5011483.0
2016-02-03	ABBNY-DELISTED	Stock	17.05	17.2799	16.84	17.23	7229840.0
2016-02-03	ABBV	Stock	54.53	57.18	54.05	56.84	16435700.0
2016-02-03	ABC-DELISTED	Stock	88.34	88.545	86.87	87.98	3679470.0
2016-02-03	ABCB	Stock	28.42	28.42	27.31	27.84	210800.0
2016-02-03	ABCD-DELISTED	Stock	4.41	4.51	4.13	4.49	50731.0
2016-02-03	ABCO-DELISTED	Stock	45.76	45.87	42.99	43.57	178003.0
2016-02-03	ABCW-DELISTED	Stock	42.11	42.21	40.9	41.19	208480.0
2016-02-03	ABDC-DELISTED	Stock	10.73	10.73	10.26	10.42	14530.0
2016-02-03	ABE-DELISTED	Stock	10.24	10.35	10.23	10.34	2826.0
2016-02-03	ABEO	Stock	58.75	60.75	55.0	58.75	1608.0
2016-02-03	ABEOW-DELISTED	Stock	0.414	0.9	0.414	0.7303	1010.0
2016-02-03	ABEV	Stock	4.53	4.66	4.41	4.64	19940700.0
2016-02-03	ABG	Stock	45.56	45.98	43.56	45.2	609700.0
2016-02-03	ABGB-DELISTED	Stock	0.9905	1.03	0.9605	1.0	250582.0

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

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