PREVIEW / stock_daily / 2019-12-02

all stock daily files

  file:    by_date/stock_daily/2019/2019-12-02.parquet
  size:    221 KB
  rows:    6,613
  symbols: 2,452

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
2019-12-02	AAPL	Stock	66.8175	67.0625	65.8625	66.04	94487200.0
2019-12-02	MSFT	Stock	151.81	151.83	148.32	149.55	27418400.0
2019-12-02	NVDA	Stock	5.4115	5.425	5.216	5.2312	372036000.0
2019-12-02	AMZN	Stock	90.22	90.2775	88.134	89.08	78512000.0
2019-12-02	GOOGL	Stock	65.128	65.272	64.019	64.443	26577780.0
2019-12-02	META	Stock	202.13	202.18	198.05	199.7	11503400.0
2019-12-02	TSLA	Stock	21.96	22.4253	21.9127	22.3247	91117500.0
2019-12-02	TLT	Stock	138.14	138.67	137.95	138.31	17705004.0
2019-12-02	ES	Stock	82.32	82.57	81.76	82.02	2328600.0
2019-12-02	CL	Stock	68.0	68.0	67.13	67.57	3487800.0
2019-12-02	A	Stock	80.78	80.99	80.02	80.35	1775600.0
2019-12-02	AA	Stock	20.47	20.96	20.33	20.33	2589100.0
2019-12-02	AACG	Stock	1.8	1.85	1.8	1.82	5400.0
2019-12-02	AAIC-DELISTED	Stock	5.85	5.85	5.78	5.84	352964.0
2019-12-02	AAIC.C-DELISTED	Stock	22.1	22.1873	22.0	22.18	3363.0
2019-12-02	AAL	Stock	28.79	28.99	28.01	28.08	6850800.0
2019-12-02	AAM.A-DELISTED	Stock	26.18	26.18	26.08	26.09	30403.0
2019-12-02	AAM.B-DELISTED	Stock	26.59	26.59	26.32	26.41	21495.0
2019-12-02	AAMC-DELISTED	Stock	4.3824	4.4118	3.9559	3.9559	4525.0
2019-12-02	AAME	Stock	1.83	1.83	1.65	1.65	5300.0
2019-12-02	AAMI	Stock	9.71	9.83	9.645	9.73	1153500.0
2019-12-02	AAOI	Stock	10.81	10.81	10.29	10.71	533000.0
2019-12-02	AAON	Stock	32.84	32.94	32.1933	32.3867	198750.0
2019-12-02	AAP	Stock	157.49	159.57	156.49	156.55	893600.0
2019-12-02	AAT	Stock	47.52	47.61	46.64	46.78	300000.0
2019-12-02	AAU-DELISTED	Stock	0.47	0.4901	0.4657	0.4825	301061.0
2019-12-02	AAUAF-DELISTED	Stock	0.47	0.4901	0.4657	0.4825	316266.0
2019-12-02	AAWW-DELISTED	Stock	26.06	26.77	24.95	25.08	250836.0
2019-12-02	AAXJ	Stock	69.72	69.81	69.275	69.44	2421936.0
2019-12-02	AAXN-DELISTED	Stock	74.14	75.27	73.43	73.72	456846.0
2019-12-02	AB	Stock	28.99	28.99	28.35	28.61	314800.0
2019-12-02	ABB-DELISTED	Stock	21.9	21.92	21.7404	21.79	1547132.0
2019-12-02	ABBNY-DELISTED	Stock	21.9	21.92	21.7404	21.79	1629105.0
2019-12-02	ABBV	Stock	87.84	88.03	87.0	87.03	6526400.0
2019-12-02	ABC-DELISTED	Stock	87.87	88.6	86.94	87.85	897227.0
2019-12-02	ABCB	Stock	43.87	44.0	43.25	43.55	323500.0
2019-12-02	ABDC-DELISTED	Stock	8.95	9.05	8.945	9.04	65389.0
2019-12-02	ABEO	Stock	85.75	87.0	77.75	85.25	25052.0
2019-12-02	ABEOW-DELISTED	Stock	0.2	0.2	0.2	0.2	620.0
2019-12-02	ABEV	Stock	4.26	4.28	4.22	4.24	9319800.0
2019-12-02	ABG	Stock	110.96	111.0	109.09	109.95	133200.0
2019-12-02	ABIL-DELISTED	Stock	0.385	0.4	0.35	0.4	56876.0
2019-12-02	ABM	Stock	38.12	38.26	37.64	37.72	257200.0
2019-12-02	ABMD-DELISTED	Stock	196.27	197.87	189.5168	192.11	364841.0
2019-12-02	ABR	Stock	15.23	15.24	14.86	14.87	1169700.0
2019-12-02	ABR.A-DELISTED	Stock	25.98	26.0	25.98	26.0	701.0
2019-12-02	ABR.B-DELISTED	Stock	25.74	25.93	25.74	25.89	737.0
2019-12-02	ABR.C-DELISTED	Stock	26.1432	26.2089	26.1432	26.15	1100.0
2019-12-02	ABT	Stock	85.57	85.72	83.98	84.51	3801100.0
2019-12-02	ABTC	Stock	225000.0	285300.0	223200.0	271800.0	29.933333333333334

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

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