PREVIEW / stock_daily / 2020-12-03

all stock daily files

  file:    by_date/stock_daily/2020/2020-12-03.parquet
  size:    236 KB
  rows:    7,159
  symbols: 2,585

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-03	AAPL	Stock	123.52	123.78	122.21	122.94	78967600.0
2020-12-03	MSFT	Stock	214.61	216.38	213.65	214.24	25120900.0
2020-12-03	NVDA	Stock	13.5875	13.66	13.329	13.396	199520000.0
2020-12-03	AMZN	Stock	160.273	161.432	159.0655	159.3365	57840000.0
2020-12-03	GOOGL	Stock	91.027	92.1915	90.85	91.092	24727320.0
2020-12-03	META	Stock	286.25	286.65	281.07	281.85	12921700.0
2020-12-03	TSLA	Stock	196.6733	199.6567	194.1433	197.7933	127656000.0
2020-12-03	TLT	Stock	156.94	157.82	156.58	157.51	9626457.0
2020-12-03	ES	Stock	87.86	88.1	86.46	86.81	997000.0
2020-12-03	CL	Stock	85.52	85.73	84.41	85.19	3842100.0
2020-12-03	A	Stock	114.15	115.42	113.16	113.58	1511400.0
2020-12-03	AA	Stock	22.74	22.89	21.96	22.04	5909500.0
2020-12-03	AACG	Stock	1.17	1.24	1.17	1.23	73200.0
2020-12-03	AACQ-DELISTED	Stock	9.95	9.95	9.9	9.95	68149.0
2020-12-03	AACQU-DELISTED	Stock	10.4369	10.51	10.4369	10.46	5134.0
2020-12-03	AACQW-DELISTED	Stock	1.43	1.52	1.4232	1.43	33316.0
2020-12-03	AAIC-DELISTED	Stock	3.4	3.41	3.3	3.41	242160.0
2020-12-03	AAIC.C-DELISTED	Stock	21.25	21.26	20.875	21.25	3068.0
2020-12-03	AAL	Stock	15.19	16.5	15.16	16.09	169287200.0
2020-12-03	AAM.A-DELISTED	Stock	26.245	26.33	26.24	26.3	4164.0
2020-12-03	AAM.B-DELISTED	Stock	27.11	27.12	27.07	27.11	9845.0
2020-12-03	AAMC-DELISTED	Stock	6.7632	7.0971	6.7632	6.7647	17731.0
2020-12-03	AAME	Stock	2.17	2.17	2.13	2.16	5400.0
2020-12-03	AAMI	Stock	17.88	19.35	17.864	19.19	1299100.0
2020-12-03	AAN-DELISTED	Stock	18.39	19.14	18.03	18.75	1555600.0
2020-12-03	AAOI	Stock	8.35	8.44	8.18	8.2	533900.0
2020-12-03	AAON	Stock	42.5467	42.8733	41.3	41.3333	466500.0
2020-12-03	AAP	Stock	148.64	151.06	148.31	150.14	646200.0
2020-12-03	AAT	Stock	30.33	30.7	30.1	30.43	204300.0
2020-12-03	AAU-DELISTED	Stock	0.79	0.89	0.79	0.8308	2287350.0
2020-12-03	AAUAF-DELISTED	Stock	0.79	0.89	0.79	0.83	2599302.0
2020-12-03	AAWW-DELISTED	Stock	54.78	56.95	53.62	56.02	503212.0
2020-12-03	AAXJ	Stock	87.12	87.56	86.95	87.19	869412.0
2020-12-03	AAXN-DELISTED	Stock	123.92	126.62	123.42	123.85	216434.0
2020-12-03	AB	Stock	33.29	34.3	33.29	33.79	666100.0
2020-12-03	ABB-DELISTED	Stock	26.79	27.01	26.74	26.9	1814044.0
2020-12-03	ABBNY-DELISTED	Stock	26.79	27.01	26.74	26.91	1915858.0
2020-12-03	ABBV	Stock	105.0	105.7	104.3	104.74	4693600.0
2020-12-03	ABC-DELISTED	Stock	102.74	103.11	100.89	101.53	554500.0
2020-12-03	ABCB	Stock	35.82	35.88	35.02	35.45	296600.0
2020-12-03	ABCM-DELISTED	Stock	18.91	19.35	18.805	19.0	38984.0
2020-12-03	ABEO	Stock	39.0	39.25	37.0	38.5	62844.0
2020-12-03	ABEV	Stock	2.8	2.93	2.8	2.89	28295400.0
2020-12-03	ABG	Stock	126.51	133.53	126.51	130.6	222200.0
2020-12-03	ABM	Stock	38.53	39.46	38.18	38.92	194700.0
2020-12-03	ABMD-DELISTED	Stock	263.79	267.7836	262.79	266.92	82459.0
2020-12-03	ABR	Stock	13.71	13.93	13.56	13.6	866900.0
2020-12-03	ABR.A-DELISTED	Stock	25.49	25.5252	25.38	25.39	3220.0
2020-12-03	ABR.B-DELISTED	Stock	25.21	25.2302	25.2	25.21	1100.0
2020-12-03	ABR.C-DELISTED	Stock	25.63	25.9548	25.3801	25.9	5400.0

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

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