PREVIEW / stock_daily / 2020-10-28

all stock daily files

  file:    by_date/stock_daily/2020/2020-10-28.parquet
  size:    229 KB
  rows:    6,988
  symbols: 2,494

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-10-28	AAPL	Stock	115.05	115.43	111.1	111.2	143937800.0
2020-10-28	MSFT	Stock	207.67	208.84	202.1	202.68	51195600.0
2020-10-28	NVDA	Stock	13.198	13.26	12.609	12.627	376520000.0
2020-10-28	AMZN	Stock	162.465	163.201	158.1235	158.139	111766000.0
2020-10-28	GOOGL	Stock	77.5005	77.6905	75.424	75.54	45173500.0
2020-10-28	META	Stock	278.79	278.79	267.26	267.67	23121800.0
2020-10-28	TSLA	Stock	138.8267	139.5333	135.3333	135.34	76354200.0
2020-10-28	TLT	Stock	161.38	161.46	160.2	160.7	11765784.0
2020-10-28	ES	Stock	90.86	91.68	88.68	88.91	1347800.0
2020-10-28	CL	Stock	77.42	78.18	76.7	76.86	4767300.0
2020-10-28	A	Stock	104.42	105.37	101.58	101.66	1180800.0
2020-10-28	AA	Stock	12.5	12.63	12.35	12.36	4349800.0
2020-10-28	AACG	Stock	1.12	1.12	1.09	1.09	35800.0
2020-10-28	AACQ-DELISTED	Stock	9.67	9.69	9.575	9.62	587805.0
2020-10-28	AACQU-DELISTED	Stock	10.07	10.07	10.0	10.05	21088.0
2020-10-28	AACQW-DELISTED	Stock	1.19	1.2	0.985	1.075	131523.0
2020-10-28	AAIC-DELISTED	Stock	2.56	2.58	2.47	2.51	212489.0
2020-10-28	AAIC.C-DELISTED	Stock	18.26	18.89	18.26	18.86	1509.0
2020-10-28	AAL	Stock	10.89	11.16	10.63	10.95	64399800.0
2020-10-28	AAM.A-DELISTED	Stock	26.15	26.15	25.93	25.96	24120.0
2020-10-28	AAM.B-DELISTED	Stock	26.74	26.94	26.48	26.48	12828.0
2020-10-28	AAMC-DELISTED	Stock	6.5554	6.9647	6.5554	6.7647	3176.0
2020-10-28	AAME	Stock	2.08	2.08	2.08	2.08	400.0
2020-10-28	AAMI	Stock	13.68	14.01	13.52	13.6	560600.0
2020-10-28	AAOI	Stock	9.75	9.855	9.43	9.57	420000.0
2020-10-28	AAON	Stock	39.4133	39.7467	38.2867	38.3533	399000.0
2020-10-28	AAP	Stock	147.42	150.07	146.15	146.38	687900.0
2020-10-28	AAT	Stock	21.76	21.97	20.92	21.02	507200.0
2020-10-28	AAU-DELISTED	Stock	0.96	0.96	0.871	0.9046	924326.0
2020-10-28	AAUAF-DELISTED	Stock	0.96	0.96	0.871	0.91	940587.0
2020-10-28	AAWW-DELISTED	Stock	60.9	60.97	59.49	59.65	427464.0
2020-10-28	AAXJ	Stock	79.38	79.46	78.67	78.76	1472661.0
2020-10-28	AAXN-DELISTED	Stock	100.0	102.8	99.09	102.0	314793.0
2020-10-28	AB	Stock	30.0	30.21	29.56	29.59	682900.0
2020-10-28	ABB-DELISTED	Stock	24.82	24.95	24.425	24.44	1897350.0
2020-10-28	ABBNY-DELISTED	Stock	24.82	24.95	24.425	24.45	2020147.0
2020-10-28	ABBV	Stock	81.35	82.21	80.24	80.49	11480200.0
2020-10-28	ABC-DELISTED	Stock	96.22	97.45	95.63	95.75	1345260.0
2020-10-28	ABCB	Stock	27.49	28.89	27.15	28.22	400700.0
2020-10-28	ABCM-DELISTED	Stock	19.4	19.64	18.97	19.11	213640.0
2020-10-28	ABEO	Stock	28.5	29.25	27.25	27.25	118436.0
2020-10-28	ABEV	Stock	2.37	2.38	2.31	2.33	23898300.0
2020-10-28	ABG	Stock	103.08	107.02	102.25	106.51	299600.0
2020-10-28	ABM	Stock	35.78	36.16	35.06	35.19	298600.0
2020-10-28	ABMD-DELISTED	Stock	286.87	290.67	279.84	283.35	291696.0
2020-10-28	ABR	Stock	11.51	11.55	11.06	11.26	1692200.0
2020-10-28	ABR.A-DELISTED	Stock	25.265	25.305	25.16	25.305	1500.0
2020-10-28	ABR.B-DELISTED	Stock	25.19	25.19	25.03	25.03	700.0
2020-10-28	ABR.C-DELISTED	Stock	25.7	25.7	25.37	25.68	10061.0
2020-10-28	ABST-DELISTED	Stock	11.0	11.85	10.91	11.1	948167.0

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

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