PREVIEW / stock_daily / 2020-12-11

all stock daily files

  file:    by_date/stock_daily/2020/2020-12-11.parquet
  size:    238 KB
  rows:    7,215
  symbols: 2,635

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-11	AAPL	Stock	122.43	122.76	120.55	122.41	86939800.0
2020-12-11	MSFT	Stock	210.05	213.32	209.11	213.26	30979400.0
2020-12-11	NVDA	Stock	12.9673	13.02	12.823	13.0132	209264000.0
2020-12-11	AMZN	Stock	154.833	155.9335	153.641	155.821	61294000.0
2020-12-11	GOOGL	Stock	88.0	88.8655	87.637	88.74	18628620.0
2020-12-11	META	Stock	274.53	276.48	270.25	273.55	14391400.0
2020-12-11	TSLA	Stock	205.0033	208.0	198.9333	203.33	139425000.0
2020-12-11	TLT	Stock	158.65	159.39	158.32	158.77	8136090.0
2020-12-11	ES	Stock	85.51	86.13	85.03	85.79	1221600.0
2020-12-11	CL	Stock	84.16	85.09	84.15	84.68	2610200.0
2020-12-11	A	Stock	118.67	119.06	117.29	118.48	1400800.0
2020-12-11	AA	Stock	23.5	23.59	22.16	22.84	6157400.0
2020-12-11	AACG	Stock	1.16	1.19	1.16	1.16	13200.0
2020-12-11	AACQ-DELISTED	Stock	10.36	10.447	10.3	10.38	799703.0
2020-12-11	AACQU-DELISTED	Stock	10.9664	11.06	10.9	11.0	96590.0
2020-12-11	AACQW-DELISTED	Stock	2.0	2.05	1.85	1.879	195633.0
2020-12-11	AAIC-DELISTED	Stock	3.67	3.69	3.58	3.64	135099.0
2020-12-11	AAIC.C-DELISTED	Stock	21.29	21.5	21.29	21.35	2400.0
2020-12-11	AAL	Stock	17.82	17.91	16.81	17.05	106957300.0
2020-12-11	AAM.A-DELISTED	Stock	26.38	26.38	26.22	26.3	15309.0
2020-12-11	AAM.B-DELISTED	Stock	27.22	27.22	27.03	27.03	8683.0
2020-12-11	AAMC-DELISTED	Stock	6.7015	6.7015	6.7015	6.7015	1856.0
2020-12-11	AAME	Stock	2.3	2.33	2.17	2.27	4300.0
2020-12-11	AAMI	Stock	19.32	19.359	19.04	19.25	514500.0
2020-12-11	AAN-DELISTED	Stock	17.47	17.79	17.32	17.72	844500.0
2020-12-11	AAOI	Stock	7.84	7.91	7.62	7.76	721100.0
2020-12-11	AAON	Stock	41.4	42.2933	41.4	42.0667	154800.0
2020-12-11	AAP	Stock	158.02	160.9	156.43	157.66	906900.0
2020-12-11	AAT	Stock	29.25	29.51	28.9	28.96	181900.0
2020-12-11	AAU-DELISTED	Stock	0.7	0.7098	0.6761	0.6882	523720.0
2020-12-11	AAUAF-DELISTED	Stock	0.7	0.7098	0.6761	0.6929	539558.0
2020-12-11	AAWW-DELISTED	Stock	55.84	56.17	54.84	55.23	201197.0
2020-12-11	AAXJ	Stock	87.69	87.781	87.36	87.51	2195934.0
2020-12-11	AAXN-DELISTED	Stock	126.06	127.5799	122.55	123.1	339063.0
2020-12-11	AB	Stock	31.86	32.88	31.76	32.1	454500.0
2020-12-11	ABB-DELISTED	Stock	26.78	26.96	26.605	26.76	1425526.0
2020-12-11	ABBNY-DELISTED	Stock	26.78	26.96	26.605	26.75	1731198.0
2020-12-11	ABBV	Stock	107.01	107.42	105.58	106.34	5205200.0
2020-12-11	ABC-DELISTED	Stock	98.85	99.38	97.58	98.09	539991.0
2020-12-11	ABCB	Stock	37.44	37.95	37.18	37.62	291700.0
2020-12-11	ABCM-DELISTED	Stock	18.69	19.0899	18.65	19.02	53980.0
2020-12-11	ABEO	Stock	38.75	39.75	37.5	38.25	51384.0
2020-12-11	ABEV	Stock	3.1	3.13	3.05	3.13	32572600.0
2020-12-11	ABG	Stock	140.01	145.07	140.01	143.44	183000.0
2020-12-11	ABM	Stock	40.6	40.99	40.12	40.22	151900.0
2020-12-11	ABMD-DELISTED	Stock	266.2	267.31	254.41	258.505	230534.0
2020-12-11	ABNB	Stock	146.55	151.5	135.1	139.25	26980800.0
2020-12-11	ABR	Stock	14.1	14.19	13.85	13.94	775800.0
2020-12-11	ABR.A-DELISTED	Stock	25.4	25.59	25.3909	25.545	15730.0
2020-12-11	ABR.B-DELISTED	Stock	25.25	25.345	25.25	25.26	1800.0

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

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