PREVIEW / stock_daily / 2020-11-18

all stock daily files

  file:    by_date/stock_daily/2020/2020-11-18.parquet
  size:    233 KB
  rows:    7,050
  symbols: 2,517

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
2020-11-18	AAPL	Stock	118.61	119.82	118.0	118.03	76322100.0
2020-11-18	MSFT	Stock	213.65	215.17	210.93	211.08	28372800.0
2020-11-18	NVDA	Stock	13.4652	13.6058	13.185	13.4288	510924000.0
2020-11-18	AMZN	Stock	156.7	157.0	155.255	155.273	58336000.0
2020-11-18	GOOGL	Stock	87.832	88.25	86.9283	87.032	20107540.0
2020-11-18	META	Stock	274.52	277.39	271.84	271.97	12152900.0
2020-11-18	TSLA	Stock	149.45	165.3333	147.8333	162.2133	234132000.0
2020-11-18	TLT	Stock	159.44	159.57	158.35	159.27	10333345.0
2020-11-18	ES	Stock	92.35	92.36	89.59	89.75	1059100.0
2020-11-18	CL	Stock	85.64	85.94	84.6	84.61	4168500.0
2020-11-18	A	Stock	109.55	109.88	105.73	105.95	2047900.0
2020-11-18	AA	Stock	18.3	18.85	18.3	18.33	6255300.0
2020-11-18	AACG	Stock	1.15	1.2	1.12	1.16	127700.0
2020-11-18	AACQ-DELISTED	Stock	9.78	9.8	9.74	9.8	23262.0
2020-11-18	AACQU-DELISTED	Stock	10.135	10.16	10.1	10.145	2096.0
2020-11-18	AACQW-DELISTED	Stock	1.2	1.2	1.141	1.16	38593.0
2020-11-18	AAIC-DELISTED	Stock	3.11	3.1684	3.03	3.04	261115.0
2020-11-18	AAIC.C-DELISTED	Stock	20.0	20.0	20.0	20.0	950.0
2020-11-18	AAL	Stock	12.91	13.36	12.73	12.74	99888500.0
2020-11-18	AAM.A-DELISTED	Stock	26.45	26.68	26.45	26.45	12634.0
2020-11-18	AAM.B-DELISTED	Stock	27.53	27.67	27.49	27.5	9663.0
2020-11-18	AAMC-DELISTED	Stock	6.8382	6.8618	6.6176	6.6177	6739.0
2020-11-18	AAME	Stock	2.21	2.22	2.14	2.17	4100.0
2020-11-18	AAMI	Stock	18.73	19.06	18.24	18.26	457600.0
2020-11-18	AAOI	Stock	7.51	7.81	7.29	7.54	1158700.0
2020-11-18	AAON	Stock	44.7	45.3267	43.4133	44.6733	424350.0
2020-11-18	AAP	Stock	148.93	151.83	147.98	148.1	881600.0
2020-11-18	AAT	Stock	29.26	29.45	28.13	28.18	352400.0
2020-11-18	AAU-DELISTED	Stock	1.15	1.15	1.0601	1.08	373895.0
2020-11-18	AAUAF-DELISTED	Stock	1.15	1.15	1.0601	1.09	416075.0
2020-11-18	AAWW-DELISTED	Stock	56.6	57.4	55.93	55.95	369422.0
2020-11-18	AAXJ	Stock	85.55	85.55	84.94	84.97	1078455.0
2020-11-18	AAXN-DELISTED	Stock	119.64	121.85	118.98	119.77	257066.0
2020-11-18	AB	Stock	31.48	32.18	31.34	31.39	291400.0
2020-11-18	ABB-DELISTED	Stock	27.84	28.03	27.53	27.53	1741116.0
2020-11-18	ABBNY-DELISTED	Stock	27.84	28.03	27.53	27.53	1861756.0
2020-11-18	ABBV	Stock	100.0	100.29	98.68	98.72	8880600.0
2020-11-18	ABC-DELISTED	Stock	105.63	107.75	103.39	103.41	537785.0
2020-11-18	ABCB	Stock	35.47	35.47	34.29	34.31	371200.0
2020-11-18	ABCM-DELISTED	Stock	18.46	18.52	18.18	18.18	61510.0
2020-11-18	ABEO	Stock	33.75	36.5	33.25	35.0	140992.0
2020-11-18	ABEV	Stock	2.9	2.91	2.77	2.77	29554500.0
2020-11-18	ABG	Stock	125.4	129.78	123.88	123.95	156700.0
2020-11-18	ABM	Stock	38.91	39.15	38.37	38.38	192100.0
2020-11-18	ABMD-DELISTED	Stock	269.23	269.56	263.18	266.48	95857.0
2020-11-18	ABR	Stock	13.22	13.6	13.11	13.15	1898600.0
2020-11-18	ABR.A-DELISTED	Stock	25.35	25.42	25.25	25.3069	11339.0
2020-11-18	ABR.B-DELISTED	Stock	25.4	25.4	25.28	25.28	1100.0
2020-11-18	ABR.C-DELISTED	Stock	25.85	25.92	25.8	25.8	1942.0
2020-11-18	ABST-DELISTED	Stock	10.03	10.03	9.53	9.55	204674.0

> showing 50 of 7,050 rows — these rows as CSV

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