PREVIEW / stock_daily / 2018-11-16

all stock daily files

  file:    by_date/stock_daily/2018/2018-11-16.parquet
  size:    221 KB
  rows:    6,565
  symbols: 2,713

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
2018-11-16	AAPL	Stock	47.625	48.7425	47.365	48.3825	147713200.0
2018-11-16	MSFT	Stock	107.08	108.88	106.8	108.29	33502100.0
2018-11-16	NVDA	Stock	4.083	4.2665	4.0402	4.1108	1963520000.0
2018-11-16	AMZN	Stock	79.375	80.724	78.656	79.6705	121322000.0
2018-11-16	GOOGL	Stock	53.2615	53.622	52.745	53.4135	35366160.0
2018-11-16	META	Stock	141.07	141.77	137.77	139.53	37250600.0
2018-11-16	TSLA	Stock	23.0127	23.7133	23.008	23.6207	108093000.0
2018-11-16	TLT	Stock	114.2	114.81	113.92	114.7	9236764.0
2018-11-16	ES	Stock	66.97	67.05	66.15	67.04	2033200.0
2018-11-16	CL	Stock	62.44	63.74	62.29	63.24	5368300.0
2018-11-16	A	Stock	64.38	65.6	64.38	64.99	2963300.0
2018-11-16	AA	Stock	35.85	36.72	35.72	35.95	3092100.0
2018-11-16	AABA-DELISTED	Stock	63.6	64.26	63.16	63.59	4107811.0
2018-11-16	AAC-DELISTED	Stock	2.36	2.4	1.89	1.99	840130.0
2018-11-16	AACG	Stock	1.07	1.09	0.98	1.0	135700.0
2018-11-16	AAIC-DELISTED	Stock	8.4	8.67	8.35	8.67	688723.0
2018-11-16	AAL	Stock	37.4	37.53	36.5	36.75	10645700.0
2018-11-16	AAM.A-DELISTED	Stock	24.21	24.339	24.1	24.1857	22609.0
2018-11-16	AAM.B-DELISTED	Stock	24.24	24.2564	24.09	24.2005	13632.0
2018-11-16	AAMC-DELISTED	Stock	12.9529	13.8118	12.9529	13.3529	4576.0
2018-11-16	AAME	Stock	2.81	3.03	2.81	3.03	600.0
2018-11-16	AAMI	Stock	12.72	12.85	12.55	12.76	465100.0
2018-11-16	AAOI	Stock	21.13	21.39	20.47	20.99	477900.0
2018-11-16	AAON	Stock	27.12	27.6067	26.1133	26.1867	720300.0
2018-11-16	AAP	Stock	177.55	179.49	176.0	179.21	876000.0
2018-11-16	AAT	Stock	38.64	39.22	38.55	39.21	234000.0
2018-11-16	AAU-DELISTED	Stock	0.505	0.5198	0.505	0.515	139601.0
2018-11-16	AAUAF-DELISTED	Stock	0.505	0.5198	0.505	0.515	150360.0
2018-11-16	AAWW-DELISTED	Stock	54.82	54.98	53.4	54.17	167229.0
2018-11-16	AAXJ	Stock	65.55	66.45	65.36	66.2	774573.0
2018-11-16	AAXN-DELISTED	Stock	49.09	50.02	48.04	49.95	656326.0
2018-11-16	AB	Stock	29.73	29.74	28.92	29.65	276100.0
2018-11-16	ABAC-DELISTED	Stock	1.55	1.6	1.55	1.6	3720.0
2018-11-16	ABB-DELISTED	Stock	19.96	20.18	19.93	20.14	2994332.0
2018-11-16	ABBNY-DELISTED	Stock	19.96	20.18	19.93	20.14	3261230.0
2018-11-16	ABBV	Stock	89.73	92.0	89.2	91.53	8691100.0
2018-11-16	ABC-DELISTED	Stock	88.31	89.12	87.45	88.78	977719.0
2018-11-16	ABCB	Stock	44.18	44.74	43.43	44.53	691200.0
2018-11-16	ABCD-DELISTED	Stock	14.43	14.43	14.39	14.405	247931.0
2018-11-16	ABDC-DELISTED	Stock	6.2	6.39	6.15	6.32	66403.0
2018-11-16	ABEO	Stock	200.0	208.0	191.25	206.25	17968.0
2018-11-16	ABEV	Stock	4.26	4.39	4.25	4.35	21939300.0
2018-11-16	ABG	Stock	68.76	69.43	67.72	69.03	656700.0
2018-11-16	ABIL-DELISTED	Stock	3.0	3.0187	2.84	2.9	12402.0
2018-11-16	ABM	Stock	30.75	31.56	30.53	31.47	535200.0
2018-11-16	ABMD-DELISTED	Stock	318.04	332.15	315.3827	319.74	576470.0
2018-11-16	ABR	Stock	11.93	12.12	11.91	12.1	829900.0
2018-11-16	ABR.A-DELISTED	Stock	25.2	25.32	25.2	25.28	1600.0
2018-11-16	ABR.B-DELISTED	Stock	25.05	25.1751	25.01	25.11	940.0
2018-11-16	ABR.C-DELISTED	Stock	25.25	25.25	25.25	25.25	100.0

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

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