PREVIEW / stock_daily / 2020-11-23

all stock daily files

  file:    by_date/stock_daily/2020/2020-11-23.parquet
  size:    235 KB
  rows:    7,106
  symbols: 2,551

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-23	AAPL	Stock	117.18	117.62	113.75	113.85	127959300.0
2020-11-23	MSFT	Stock	210.95	212.29	208.16	210.11	25683500.0
2020-11-23	NVDA	Stock	13.1712	13.3825	13.0155	13.14	361356000.0
2020-11-23	AMZN	Stock	155.835	156.9875	153.273	154.9195	94178000.0
2020-11-23	GOOGL	Stock	87.011	87.2995	85.509	86.378	22552360.0
2020-11-23	META	Stock	270.89	270.95	264.53	268.43	20990800.0
2020-11-23	TSLA	Stock	167.8333	175.3333	167.2633	173.95	150780900.0
2020-11-23	TLT	Stock	160.82	160.99	160.28	160.77	11304789.0
2020-11-23	ES	Stock	88.84	89.11	87.48	87.79	931000.0
2020-11-23	CL	Stock	85.23	85.23	83.97	84.54	3046000.0
2020-11-23	A	Stock	111.4	112.42	109.56	112.21	3258700.0
2020-11-23	AA	Stock	19.3	20.08	19.24	19.81	7392400.0
2020-11-23	AACG	Stock	1.18	1.19	1.16	1.17	34900.0
2020-11-23	AACQ-DELISTED	Stock	9.9	9.9099	9.8	9.88	290295.0
2020-11-23	AACQU-DELISTED	Stock	10.2101	10.29	10.2101	10.26	18238.0
2020-11-23	AACQW-DELISTED	Stock	1.35	1.35	1.22	1.3	158242.0
2020-11-23	AAIC-DELISTED	Stock	3.06	3.19	3.01	3.17	242093.0
2020-11-23	AAIC.C-DELISTED	Stock	20.24	22.24	20.24	20.75	16553.0
2020-11-23	AAL	Stock	12.75	13.58	12.69	13.56	100764000.0
2020-11-23	AAM.A-DELISTED	Stock	26.58	26.64	26.547	26.61	13174.0
2020-11-23	AAM.B-DELISTED	Stock	27.56	27.56	27.44	27.535	12264.0
2020-11-23	AAMC-DELISTED	Stock	6.8941	6.9179	6.6059	6.719	27897.0
2020-11-23	AAME	Stock	2.21	2.21	2.14	2.17	2300.0
2020-11-23	AAMI	Stock	18.46	18.635	18.31	18.36	404800.0
2020-11-23	AAOI	Stock	8.03	8.15	7.8	7.84	762100.0
2020-11-23	AAON	Stock	43.82	44.28	42.9533	44.0	201300.0
2020-11-23	AAP	Stock	142.99	146.86	142.59	145.56	1087700.0
2020-11-23	AAT	Stock	29.06	30.78	28.99	30.26	551300.0
2020-11-23	AAU-DELISTED	Stock	1.05	1.08	0.9901	1.01	821612.0
2020-11-23	AAUAF-DELISTED	Stock	1.05	1.08	0.9901	1.02	872256.0
2020-11-23	AAWW-DELISTED	Stock	54.01	55.38	53.76	54.04	324705.0
2020-11-23	AAXJ	Stock	86.63	86.63	85.75	85.9	1400404.0
2020-11-23	AAXN-DELISTED	Stock	126.29	127.22	123.1373	126.5	285759.0
2020-11-23	AB	Stock	31.94	32.25	31.66	31.7	270300.0
2020-11-23	ABB-DELISTED	Stock	26.8	26.81	26.445	26.61	2728841.0
2020-11-23	ABBNY-DELISTED	Stock	26.81	26.81	26.445	26.61	2874533.0
2020-11-23	ABBV	Stock	101.94	102.76	101.07	102.18	7541500.0
2020-11-23	ABC-DELISTED	Stock	101.28	101.84	100.08	100.48	1143889.0
2020-11-23	ABCB	Stock	34.55	34.99	34.12	34.5	311700.0
2020-11-23	ABCM-DELISTED	Stock	18.7008	18.9068	18.43	18.43	38622.0
2020-11-23	ABEO	Stock	34.0	35.0	32.75	34.5	69536.0
2020-11-23	ABEV	Stock	2.71	2.74	2.67	2.74	22927900.0
2020-11-23	ABG	Stock	118.18	122.59	116.72	121.37	183600.0
2020-11-23	ABM	Stock	38.73	39.39	38.36	39.18	213900.0
2020-11-23	ABMD-DELISTED	Stock	268.1	271.675	265.35	266.33	161390.0
2020-11-23	ABR	Stock	13.38	13.61	13.29	13.47	1985500.0
2020-11-23	ABR.A-DELISTED	Stock	25.3	25.44	25.26	25.37	8390.0
2020-11-23	ABR.B-DELISTED	Stock	25.3	25.4	25.3	25.3731	424.0
2020-11-23	ABR.C-DELISTED	Stock	25.81	25.81	25.66	25.6668	1541.0
2020-11-23	ABST-DELISTED	Stock	11.0	11.0	9.83	10.01	146558.0

> showing 50 of 7,106 rows — these rows as CSV

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