PREVIEW / stock_daily / 2020-04-02

all stock daily files

  file:    by_date/stock_daily/2020/2020-04-02.parquet
  size:    213 KB
  rows:    6,614
  symbols: 2,369

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-02	AAPL	Stock	60.085	61.2875	59.225	61.2325	165934000.0
2020-04-02	MSFT	Stock	151.86	155.48	150.36	155.26	49630700.0
2020-04-02	NVDA	Stock	6.106	6.4	6.0578	6.3868	675764000.0
2020-04-02	AMZN	Stock	95.082	96.3765	94.5	95.9415	86720000.0
2020-04-02	GOOGL	Stock	55.0	56.1385	54.6565	55.8515	56410680.0
2020-04-02	META	Stock	159.1	161.35	155.92	158.19	20886300.0
2020-04-02	TSLA	Stock	32.0687	32.9507	29.76	30.298	297876000.0
2020-04-02	TLT	Stock	168.83	169.22	167.26	168.1	5771227.0
2020-04-02	ES	Stock	74.53	79.89	74.53	79.29	3084200.0
2020-04-02	CL	Stock	64.78	68.69	64.71	68.17	5676700.0
2020-04-02	A	Stock	68.27	72.45	68.14	72.29	1840300.0
2020-04-02	AA	Stock	6.29	6.685	5.92	6.08	10277700.0
2020-04-02	AACG	Stock	0.95	0.95	0.91	0.92	5200.0
2020-04-02	AAIC-DELISTED	Stock	1.95	2.15	1.9	2.15	685430.0
2020-04-02	AAIC.C-DELISTED	Stock	12.0	13.18	11.9001	13.1	5961.0
2020-04-02	AAL	Stock	10.61	11.03	10.0	10.06	65534600.0
2020-04-02	AAM.A-DELISTED	Stock	20.77	22.74	20.16	21.36	29314.0
2020-04-02	AAM.B-DELISTED	Stock	21.21	22.6065	21.2	21.67	32383.0
2020-04-02	AAMC-DELISTED	Stock	3.9265	3.9265	3.4706	3.6853	19455.0
2020-04-02	AAME	Stock	2.19	2.19	1.91	2.1	3600.0
2020-04-02	AAMI	Stock	5.83	6.39	5.83	6.17	442300.0
2020-04-02	AAOI	Stock	7.34	7.8	7.19	7.69	653300.0
2020-04-02	AAON	Stock	31.44	32.5267	31.0667	32.1067	284700.0
2020-04-02	AAP	Stock	87.71	89.89	81.94	88.41	3036900.0
2020-04-02	AAT	Stock	22.13	23.84	22.13	22.7	337500.0
2020-04-02	AAU-DELISTED	Stock	0.265	0.3	0.2602	0.2961	289906.0
2020-04-02	AAUAF-DELISTED	Stock	0.265	0.3	0.2602	0.2961	305836.0
2020-04-02	AAWW-DELISTED	Stock	24.51	25.08	23.05	23.48	387036.0
2020-04-02	AAXJ	Stock	58.15	59.17	58.105	59.02	1942254.0
2020-04-02	AAXN-DELISTED	Stock	64.99	67.29	61.23	62.51	369944.0
2020-04-02	AB	Stock	16.94	18.72	16.88	18.49	556000.0
2020-04-02	ABB-DELISTED	Stock	16.65	17.14	16.61	16.88	2800971.0
2020-04-02	ABBNY-DELISTED	Stock	16.65	17.14	16.61	16.88	3219099.0
2020-04-02	ABBV	Stock	72.78	75.5	71.46	75.13	8077800.0
2020-04-02	ABC-DELISTED	Stock	84.64	86.53	80.0	83.78	2156474.0
2020-04-02	ABCB	Stock	22.28	23.36	22.11	22.92	440300.0
2020-04-02	ABEO	Stock	51.25	54.25	49.25	52.75	56164.0
2020-04-02	ABEV	Stock	2.21	2.36	2.21	2.31	23894600.0
2020-04-02	ABG	Stock	46.56	49.19	45.54	47.0	278600.0
2020-04-02	ABM	Stock	22.91	24.28	22.8	24.24	468500.0
2020-04-02	ABMD-DELISTED	Stock	143.11	147.46	140.385	143.1361	314792.0
2020-04-02	ABR	Stock	4.59	4.79	4.28	4.28	2665300.0
2020-04-02	ABR.A-DELISTED	Stock	14.3	15.3	14.1413	14.6563	13006.0
2020-04-02	ABR.B-DELISTED	Stock	13.6458	14.7735	12.96	13.7	8570.0
2020-04-02	ABR.C-DELISTED	Stock	14.0	14.85	13.36	13.5	8700.0
2020-04-02	ABT	Stock	76.12	79.66	76.0	79.44	10167900.0
2020-04-02	ABTC	Stock	179100.0	179100.0	159000.0	163800.0	1.8533333333333333
2020-04-02	ABTS	Stock	9.3	9.75	9.0	9.0	3420.0
2020-04-02	ABTX-DELISTED	Stock	21.79	23.355	21.79	23.04	62530.0
2020-04-02	ABUS	Stock	1.09	1.1	0.99	1.0	528100.0

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

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