PREVIEW / stock_daily / 2020-03-20

all stock daily files

  file:    by_date/stock_daily/2020/2020-03-20.parquet
  size:    212 KB
  rows:    6,676
  symbols: 2,408

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-03-20	AAPL	Stock	61.795	62.9575	57.0	57.31	401693200.0
2020-03-20	MSFT	Stock	146.0	147.1	135.86	137.35	84866200.0
2020-03-20	NVDA	Stock	5.475	5.758	5.1283	5.1438	804636000.0
2020-03-20	AMZN	Stock	96.3155	97.85	91.0365	92.3045	196358000.0
2020-03-20	GOOGL	Stock	56.545	56.9239	53.105	53.4105	82877940.0
2020-03-20	META	Stock	156.02	159.27	148.0	149.73	32568400.0
2020-03-20	TSLA	Stock	29.2133	31.8	28.386	28.502	424282500.0
2020-03-20	TLT	Stock	153.3	159.43	152.11	159.43	20863060.0
2020-03-20	ES	Stock	77.51	77.75	67.42	68.34	4340500.0
2020-03-20	CL	Stock	66.74	66.85	61.39	62.08	9168300.0
2020-03-20	A	Stock	65.99	71.0	64.96	66.46	3258400.0
2020-03-20	AA	Stock	6.07	6.17	5.43	5.48	9957200.0
2020-03-20	AACG	Stock	0.75	1.1	0.75	0.9	9200.0
2020-03-20	AAIC-DELISTED	Stock	2.33	2.51	2.06	2.18	1587218.0
2020-03-20	AAIC.C-DELISTED	Stock	10.5	10.85	9.47	10.52	51248.0
2020-03-20	AAL	Stock	10.65	12.0	10.3	10.38	62681800.0
2020-03-20	AAM.A-DELISTED	Stock	18.84	21.3996	18.84	19.21	100606.0
2020-03-20	AAM.B-DELISTED	Stock	18.6768	21.38	18.6768	19.15	54513.0
2020-03-20	AAMC-DELISTED	Stock	3.4441	3.6235	3.2941	3.3529	5433.0
2020-03-20	AAME	Stock	2.31	2.31	2.31	2.31	100.0
2020-03-20	AAMI	Stock	4.41	4.8	4.27	4.52	1177400.0
2020-03-20	AAOI	Stock	6.66	7.96	6.54	6.74	1171700.0
2020-03-20	AAON	Stock	33.5133	34.4267	29.8067	30.26	714300.0
2020-03-20	AAP	Stock	86.49	89.0	73.74	75.03	1548500.0
2020-03-20	AAT	Stock	22.7	24.54	22.06	22.46	638200.0
2020-03-20	AAU-DELISTED	Stock	0.27	0.28	0.252	0.255	196529.0
2020-03-20	AAUAF-DELISTED	Stock	0.27	0.28	0.252	0.255	199358.0
2020-03-20	AAWW-DELISTED	Stock	22.38	23.86	20.88	22.92	997599.0
2020-03-20	AAXJ	Stock	56.84	56.96	54.85	55.0	5204442.0
2020-03-20	AAXN-DELISTED	Stock	62.15	65.22	59.8	60.78	983697.0
2020-03-20	AB	Stock	19.49	19.96	17.0	17.06	1346400.0
2020-03-20	ABB-DELISTED	Stock	16.56	16.82	15.93	15.96	4621669.0
2020-03-20	ABBNY-DELISTED	Stock	16.56	16.82	15.93	15.96	4926781.0
2020-03-20	ABBV	Stock	73.0	73.0	66.81	68.82	18844500.0
2020-03-20	ABC-DELISTED	Stock	86.84	87.63	79.32	80.63	2676516.0
2020-03-20	ABCB	Stock	22.3	22.6	20.18	20.76	850800.0
2020-03-20	ABEO	Stock	46.5	55.75	45.5	53.25	198868.0
2020-03-20	ABEV	Stock	2.41	2.51	2.35	2.4	45750300.0
2020-03-20	ABG	Stock	48.92	53.57	48.48	50.6	590300.0
2020-03-20	ABM	Stock	24.09	24.09	20.84	21.05	979900.0
2020-03-20	ABMD-DELISTED	Stock	142.13	143.87	130.01	130.18	595037.0
2020-03-20	ABR	Stock	5.12	5.88	4.75	4.82	5161600.0
2020-03-20	ABR.A-DELISTED	Stock	17.44	17.661	17.0	17.0	13286.0
2020-03-20	ABR.B-DELISTED	Stock	15.2	16.8088	14.6	16.8	11132.0
2020-03-20	ABR.C-DELISTED	Stock	18.0	19.68	17.65	18.2212	4694.0
2020-03-20	ABT	Stock	74.05	74.86	67.95	68.0	15131400.0
2020-03-20	ABTC	Stock	138300.0	141600.0	120900.0	120900.0	3.08
2020-03-20	ABTS	Stock	15.0	15.0	13.545	13.65	193.0
2020-03-20	ABTX-DELISTED	Stock	27.14	27.32	24.765	25.0	139253.0
2020-03-20	ABUS	Stock	1.81	1.96	1.43	1.44	983900.0

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

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