PREVIEW / stock_daily / 2020-11-02

all stock daily files

  file:    by_date/stock_daily/2020/2020-11-02.parquet
  size:    228 KB
  rows:    6,968
  symbols: 2,489

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-11-02	AAPL	Stock	109.11	110.68	107.32	108.77	122866900.0
2020-11-02	MSFT	Stock	204.29	205.28	200.12	202.33	30842200.0
2020-11-02	NVDA	Stock	12.6578	12.8368	12.395	12.5808	299652000.0
2020-11-02	AMZN	Stock	153.087	153.9855	147.506	150.224	145148000.0
2020-11-02	GOOGL	Stock	81.177	82.912	80.712	81.216	44228980.0
2020-11-02	META	Stock	264.6	270.47	257.34	261.36	27165700.0
2020-11-02	TSLA	Stock	131.3333	135.66	130.7667	133.5033	87063300.0
2020-11-02	TLT	Stock	158.7	159.19	158.33	158.58	10810494.0
2020-11-02	ES	Stock	88.08	90.67	87.68	90.59	1343100.0
2020-11-02	CL	Stock	80.18	81.02	79.51	80.16	4217700.0
2020-11-02	A	Stock	103.52	105.35	103.29	105.24	1572300.0
2020-11-02	AA	Stock	13.1	13.7	13.03	13.61	4940800.0
2020-11-02	AACG	Stock	1.09	1.14	1.09	1.1	35500.0
2020-11-02	AACQ-DELISTED	Stock	9.64	9.69	9.6084	9.69	428143.0
2020-11-02	AACQU-DELISTED	Stock	10.0	10.01	9.96	10.0	671258.0
2020-11-02	AACQW-DELISTED	Stock	1.15	1.165	1.14	1.14	34794.0
2020-11-02	AAIC-DELISTED	Stock	2.46	2.58	2.45	2.58	160062.0
2020-11-02	AAIC.C-DELISTED	Stock	18.85	18.8875	18.73	18.85	17945.0
2020-11-02	AAL	Stock	11.32	11.34	10.87	11.19	41094500.0
2020-11-02	AAM.A-DELISTED	Stock	26.0858	26.1	25.88	25.93	18977.0
2020-11-02	AAM.B-DELISTED	Stock	26.3261	26.63	26.3261	26.4	9818.0
2020-11-02	AAMC-DELISTED	Stock	6.8382	6.8382	6.2412	6.7941	10530.0
2020-11-02	AAME	Stock	2.06	2.15	2.05	2.13	5000.0
2020-11-02	AAMI	Stock	13.81	14.01	13.4	13.81	752200.0
2020-11-02	AAOI	Stock	8.82	8.98	8.51	8.715	535300.0
2020-11-02	AAON	Stock	39.36	40.0933	39.14	39.6667	241950.0
2020-11-02	AAP	Stock	149.49	152.47	148.76	151.38	1010900.0
2020-11-02	AAT	Stock	21.31	21.31	20.83	21.27	296500.0
2020-11-02	AAU-DELISTED	Stock	1.02	1.15	1.0	1.14	1244207.0
2020-11-02	AAUAF-DELISTED	Stock	1.02	1.15	1.0	1.15	1302206.0
2020-11-02	AAWW-DELISTED	Stock	59.54	62.04	59.3615	61.84	319246.0
2020-11-02	AAXJ	Stock	79.54	79.74	79.055	79.74	1149440.0
2020-11-02	AAXN-DELISTED	Stock	99.67	101.32	96.6607	97.87	299208.0
2020-11-02	AB	Stock	29.38	29.57	28.87	29.2	466700.0
2020-11-02	ABB-DELISTED	Stock	24.81	25.05	24.71	24.93	1214255.0
2020-11-02	ABBNY-DELISTED	Stock	24.81	25.05	24.71	24.93	1319418.0
2020-11-02	ABBV	Stock	86.03	88.54	86.0	88.25	10781400.0
2020-11-02	ABC-DELISTED	Stock	97.36	99.62	95.71	98.95	1216299.0
2020-11-02	ABCB	Stock	29.83	30.31	29.24	29.85	323000.0
2020-11-02	ABCM-DELISTED	Stock	19.4	20.25	19.3398	19.95	203110.0
2020-11-02	ABEO	Stock	26.75	27.0	25.75	25.75	55944.0
2020-11-02	ABEV	Stock	2.18	2.21	2.14	2.18	19866800.0
2020-11-02	ABG	Stock	104.86	110.02	104.86	109.51	155900.0
2020-11-02	ABM	Stock	35.21	35.76	35.0	35.44	251800.0
2020-11-02	ABMD-DELISTED	Stock	253.42	259.75	250.725	255.0	320952.0
2020-11-02	ABR	Stock	12.05	12.9	12.01	12.76	2758500.0
2020-11-02	ABR.A-DELISTED	Stock	25.42	25.81	25.23	25.69	3866.0
2020-11-02	ABR.B-DELISTED	Stock	25.55	25.59	25.44	25.54	1200.0
2020-11-02	ABR.C-DELISTED	Stock	25.8	25.87	25.8	25.8201	2700.0
2020-11-02	ABST-DELISTED	Stock	11.35	11.48	11.18	11.45	23869.0

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

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