PREVIEW / stock_daily / 2020-12-14

all stock daily files

  file:    by_date/stock_daily/2020/2020-12-14.parquet
  size:    239 KB
  rows:    7,250
  symbols: 2,646

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-12-14	AAPL	Stock	122.6	123.35	121.54	121.78	79184500.0
2020-12-14	MSFT	Stock	213.1	216.21	212.88	214.2	28798400.0
2020-12-14	NVDA	Stock	13.088	13.3888	13.0775	13.3088	270156000.0
2020-12-14	AMZN	Stock	157.15	159.5235	156.3	157.8485	83116000.0
2020-12-14	GOOGL	Stock	88.536	89.49	87.4565	87.613	33049420.0
2020-12-14	META	Stock	273.37	277.22	271.56	274.19	16376900.0
2020-12-14	TSLA	Stock	206.3333	214.25	203.4	213.2767	156121800.0
2020-12-14	TLT	Stock	157.49	158.69	157.11	158.33	7535875.0
2020-12-14	ES	Stock	86.48	87.61	85.39	85.46	1285400.0
2020-12-14	CL	Stock	85.08	85.45	84.14	84.19	2684400.0
2020-12-14	A	Stock	118.61	120.24	116.74	116.74	1395200.0
2020-12-14	AA	Stock	23.25	23.375	21.682	21.76	6286200.0
2020-12-14	AACG	Stock	1.17	1.21	1.16	1.17	21200.0
2020-12-14	AACQ-DELISTED	Stock	10.51	10.58	10.286	10.34	1593741.0
2020-12-14	AACQU-DELISTED	Stock	11.17	11.2484	10.94	10.96	41815.0
2020-12-14	AACQW-DELISTED	Stock	2.08	2.19	1.95	2.15	551376.0
2020-12-14	AAIC-DELISTED	Stock	3.65	3.72	3.56	3.6	142660.0
2020-12-14	AAIC.C-DELISTED	Stock	21.35	21.73	21.25	21.4106	7825.0
2020-12-14	AAL	Stock	17.52	17.81	16.68	16.7	88139900.0
2020-12-14	AAM.A-DELISTED	Stock	26.35	26.35	26.23	26.3092	4578.0
2020-12-14	AAM.B-DELISTED	Stock	27.13	27.13	27.03	27.05	14739.0
2020-12-14	AAMC-DELISTED	Stock	6.5328	6.75	6.5328	6.75	4209.0
2020-12-14	AAME	Stock	2.33	2.33	2.27	2.32	6100.0
2020-12-14	AAMI	Stock	19.4	19.4	18.425	18.47	673200.0
2020-12-14	AAN-DELISTED	Stock	18.08	18.56	17.95	17.98	1038500.0
2020-12-14	AAOI	Stock	7.87	8.07	7.82	7.93	556800.0
2020-12-14	AAON	Stock	43.1067	43.1067	41.4133	41.5867	262200.0
2020-12-14	AAP	Stock	158.61	161.33	157.3	157.56	961800.0
2020-12-14	AAT	Stock	29.26	29.53	28.55	28.73	245200.0
2020-12-14	AAU-DELISTED	Stock	0.69	0.69	0.6503	0.6649	910762.0
2020-12-14	AAUAF-DELISTED	Stock	0.69	0.69	0.6503	0.662	932721.0
2020-12-14	AAWW-DELISTED	Stock	55.59	56.0	53.83	54.53	269774.0
2020-12-14	AAXJ	Stock	87.07	87.12	86.47	86.47	1886251.0
2020-12-14	AAXN-DELISTED	Stock	124.5	129.8	124.5	127.27	713768.0
2020-12-14	AB	Stock	32.1	32.43	31.85	32.06	396700.0
2020-12-14	ABB-DELISTED	Stock	27.0	27.05	26.66	26.66	1231015.0
2020-12-14	ABBNY-DELISTED	Stock	27.0	27.05	26.66	26.66	1343580.0
2020-12-14	ABBV	Stock	107.43	108.07	104.09	104.2	8272700.0
2020-12-14	ABC-DELISTED	Stock	99.07	99.07	97.09	97.12	736329.0
2020-12-14	ABCB	Stock	38.1	38.65	37.72	37.76	419500.0
2020-12-14	ABCL	Stock	56.926	60.691	50.0	50.01	1487300.0
2020-12-14	ABCM-DELISTED	Stock	19.12	19.7	19.115	19.4	27109.0
2020-12-14	ABEO	Stock	39.0	39.5	38.0	38.75	64244.0
2020-12-14	ABEV	Stock	3.08	3.1	3.01	3.02	19669000.0
2020-12-14	ABG	Stock	145.72	148.92	139.71	139.8	240400.0
2020-12-14	ABM	Stock	40.54	40.94	39.75	39.87	248000.0
2020-12-14	ABMD-DELISTED	Stock	260.07	270.195	259.535	267.57	189286.0
2020-12-14	ABNB	Stock	135.0	135.3	125.16	130.0	16966100.0
2020-12-14	ABR	Stock	14.05	14.44	14.05	14.24	1895600.0
2020-12-14	ABR.A-DELISTED	Stock	25.46	25.58	25.32	25.35	5201.0

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

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