PREVIEW / stock_daily / 2020-04-07

all stock daily files

  file:    by_date/stock_daily/2020/2020-04-07.parquet
  size:    214 KB
  rows:    6,588
  symbols: 2,352

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-04-07	AAPL	Stock	67.7	67.925	64.75	64.8575	202887200.0
2020-04-07	MSFT	Stock	169.59	170.0	163.26	163.49	62769000.0
2020-04-07	NVDA	Stock	6.9325	6.9562	6.4325	6.4758	784520000.0
2020-04-07	AMZN	Stock	100.8555	101.786	99.881	100.58	102280000.0
2020-04-07	GOOGL	Stock	60.8505	61.0388	58.8625	59.128	61619100.0
2020-04-07	META	Stock	171.79	173.39	166.01	168.83	31411900.0
2020-04-07	TSLA	Stock	36.3333	37.6667	35.4893	36.3633	268797000.0
2020-04-07	TLT	Stock	164.96	166.42	163.71	166.3	13811848.0
2020-04-07	ES	Stock	83.25	83.99	79.45	79.78	2830600.0
2020-04-07	CL	Stock	70.28	71.79	68.83	69.04	5964900.0
2020-04-07	A	Stock	76.61	77.56	74.02	74.03	2458000.0
2020-04-07	AA	Stock	7.14	7.75	6.96	7.03	16046000.0
2020-04-07	AACG	Stock	0.95	0.95	0.8	0.9	19100.0
2020-04-07	AAIC-DELISTED	Stock	2.15	2.37	2.07	2.14	1000614.0
2020-04-07	AAIC.C-DELISTED	Stock	13.5	15.09	13.5	14.93	13098.0
2020-04-07	AAL	Stock	11.07	12.2	10.05	10.22	138061000.0
2020-04-07	AAM.A-DELISTED	Stock	22.8702	23.17	22.29	23.17	50525.0
2020-04-07	AAM.B-DELISTED	Stock	23.19	23.19	22.525	23.1	30248.0
2020-04-07	AAMC-DELISTED	Stock	4.0324	4.0324	3.6941	3.8941	7517.0
2020-04-07	AAME	Stock	2.2	2.2	1.9	2.19	1300.0
2020-04-07	AAMI	Stock	6.72	6.94	6.31	6.35	539200.0
2020-04-07	AAOI	Stock	8.11	8.35	7.82	7.94	578500.0
2020-04-07	AAON	Stock	32.6667	33.12	30.9467	31.3	424800.0
2020-04-07	AAP	Stock	102.23	103.72	97.48	99.44	1255800.0
2020-04-07	AAT	Stock	24.41	25.95	24.32	24.68	637900.0
2020-04-07	AAU-DELISTED	Stock	0.3	0.3044	0.2782	0.285	324447.0
2020-04-07	AAUAF-DELISTED	Stock	0.3	0.3044	0.2782	0.285	350512.0
2020-04-07	AAWW-DELISTED	Stock	22.94	23.6	22.26	23.11	699039.0
2020-04-07	AAXJ	Stock	62.8	62.8	61.13	61.27	2170625.0
2020-04-07	AAXN-DELISTED	Stock	70.67	71.99	68.1	69.01	587455.0
2020-04-07	AB	Stock	19.0	20.61	19.0	20.14	760200.0
2020-04-07	ABB-DELISTED	Stock	18.43	18.49	17.685	17.73	2932809.0
2020-04-07	ABBNY-DELISTED	Stock	18.43	18.49	17.685	17.73	3149468.0
2020-04-07	ABBV	Stock	78.38	78.58	75.25	75.39	11591700.0
2020-04-07	ABC-DELISTED	Stock	88.87	89.43	86.62	87.04	1055036.0
2020-04-07	ABCB	Stock	23.59	24.65	22.56	22.86	382600.0
2020-04-07	ABEO	Stock	58.75	62.75	55.25	57.5	54284.0
2020-04-07	ABEV	Stock	2.5	2.5	2.36	2.37	22311000.0
2020-04-07	ABG	Stock	50.28	52.98	48.54	49.04	276100.0
2020-04-07	ABM	Stock	26.5	28.17	26.18	26.32	930700.0
2020-04-07	ABMD-DELISTED	Stock	153.0	162.23	151.6	152.75	654968.0
2020-04-07	ABR	Stock	5.49	6.09	5.23	5.46	4326000.0
2020-04-07	ABR.A-DELISTED	Stock	16.83	18.31	16.83	17.97	4919.0
2020-04-07	ABR.B-DELISTED	Stock	16.1046	19.31	15.7551	17.95	9505.0
2020-04-07	ABR.C-DELISTED	Stock	14.67	17.6585	14.67	16.62	11930.0
2020-04-07	ABT	Stock	83.45	84.48	81.77	81.93	10872100.0
2020-04-07	ABTC	Stock	195600.0	201000.0	187500.0	190500.0	3.0666666666666664
2020-04-07	ABTS	Stock	8.7	8.85	7.8	7.95	3520.0
2020-04-07	ABTX-DELISTED	Stock	23.94	24.49	22.7	22.96	64281.0
2020-04-07	ABUS	Stock	1.09	1.14	1.03	1.04	478800.0

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

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