PREVIEW / stock_daily / 2020-12-29

all stock daily files

  file:    by_date/stock_daily/2020/2020-12-29.parquet
  size:    239 KB
  rows:    7,269
  symbols: 2,640

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-12-29	AAPL	Stock	138.05	138.79	134.34	134.87	121047300.0
2020-12-29	MSFT	Stock	226.31	227.18	223.58	224.15	17403200.0
2020-12-29	NVDA	Stock	12.925	13.0725	12.8423	12.9433	170372000.0
2020-12-29	AMZN	Stock	165.497	167.5325	164.061	166.1	97458000.0
2020-12-29	GOOGL	Stock	89.3615	89.4235	87.7555	87.888	19725740.0
2020-12-29	META	Stock	276.95	280.51	276.28	276.78	16383000.0
2020-12-29	TSLA	Stock	220.3333	223.3	218.3333	221.9967	68732400.0
2020-12-29	TLT	Stock	156.39	157.29	156.36	157.16	9030948.0
2020-12-29	ES	Stock	85.52	85.93	84.94	85.19	1221500.0
2020-12-29	CL	Stock	85.83	86.21	84.92	85.03	2390900.0
2020-12-29	A	Stock	118.56	119.12	116.83	117.23	1007400.0
2020-12-29	AA	Stock	22.14	22.34	21.15	22.04	3493000.0
2020-12-29	AACG	Stock	1.19	1.23	1.17	1.19	139600.0
2020-12-29	AACQ-DELISTED	Stock	10.67	10.68	10.5	10.53	1913497.0
2020-12-29	AACQU-DELISTED	Stock	11.43	11.61	11.3	11.3	86038.0
2020-12-29	AACQW-DELISTED	Stock	2.65	2.65	2.2902	2.33	480044.0
2020-12-29	AAIC-DELISTED	Stock	3.8	3.8437	3.77	3.81	168072.0
2020-12-29	AAIC.C-DELISTED	Stock	20.925	20.925	20.7	20.7001	2437.0
2020-12-29	AAL	Stock	16.32	16.41	15.75	15.86	51559500.0
2020-12-29	AAM.A-DELISTED	Stock	26.54	26.66	26.38	26.52	12490.0
2020-12-29	AAM.B-DELISTED	Stock	27.52	27.56	27.16	27.25	23376.0
2020-12-29	AAMC-DELISTED	Stock	6.6294	6.9824	6.6294	6.9115	28951.0
2020-12-29	AAME	Stock	2.07	2.1	2.05	2.1	1300.0
2020-12-29	AAMI	Stock	19.08	19.16	18.85	18.98	366500.0
2020-12-29	AAN-DELISTED	Stock	16.4	17.0	16.38	16.92	474900.0
2020-12-29	AAOI	Stock	8.92	9.09	8.68	8.8	1173200.0
2020-12-29	AAON	Stock	44.48	44.6933	43.8067	44.48	406050.0
2020-12-29	AAP	Stock	159.13	159.42	156.19	156.69	704300.0
2020-12-29	AAT	Stock	28.85	29.07	27.97	28.34	146600.0
2020-12-29	AAU-DELISTED	Stock	0.475	0.485	0.45	0.466	1610663.0
2020-12-29	AAUAF-DELISTED	Stock	0.475	0.485	0.45	0.465	1634341.0
2020-12-29	AAWW-DELISTED	Stock	54.82	55.2907	53.56	54.06	271364.0
2020-12-29	AAXJ	Stock	87.98	88.22	87.53	88.16	1181691.0
2020-12-29	AAXN-DELISTED	Stock	126.0	126.6095	120.85	123.18	462367.0
2020-12-29	AB	Stock	33.41	33.41	32.75	32.87	213300.0
2020-12-29	ABB-DELISTED	Stock	28.08	28.11	27.76	27.89	1215106.0
2020-12-29	ABBNY-DELISTED	Stock	28.08	28.11	27.76	27.89	1301873.0
2020-12-29	ABBV	Stock	103.95	105.37	103.95	104.7	5096400.0
2020-12-29	ABC-DELISTED	Stock	97.64	98.26	96.32	97.13	802084.0
2020-12-29	ABCB	Stock	38.11	38.4	37.2	37.4	302800.0
2020-12-29	ABCL	Stock	41.13	41.5	38.0	39.0	1672000.0
2020-12-29	ABCM-DELISTED	Stock	20.3	20.68	20.2	20.3	121436.0
2020-12-29	ABEO	Stock	42.5	42.5	38.0	38.5	111360.0
2020-12-29	ABEV	Stock	3.08	3.12	3.06	3.12	20124700.0
2020-12-29	ABG	Stock	144.71	145.38	137.22	139.3	129800.0
2020-12-29	ABM	Stock	38.64	38.83	37.56	37.72	198600.0
2020-12-29	ABMD-DELISTED	Stock	314.25	327.91	314.0	321.0	252912.0
2020-12-29	ABNB	Stock	150.0	151.651	143.12	150.0	5402300.0
2020-12-29	ABR	Stock	14.2	14.27	14.02	14.11	820000.0
2020-12-29	ABR.A-DELISTED	Stock	25.47	25.555	25.45	25.45	5914.0

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

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