PREVIEW / stock_daily / 2020-10-30

all stock daily files

  file:    by_date/stock_daily/2020/2020-10-30.parquet
  size:    229 KB
  rows:    6,970
  symbols: 2,486

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-30	AAPL	Stock	111.06	111.99	107.72	108.86	190272600.0
2020-10-30	MSFT	Stock	203.5	204.29	199.62	202.47	36953700.0
2020-10-30	NVDA	Stock	12.85	12.9365	12.3	12.534	416820000.0
2020-10-30	AMZN	Stock	157.8875	158.35	150.95	151.8075	167728000.0
2020-10-30	GOOGL	Stock	83.372	84.0658	80.0785	80.8055	99923940.0
2020-10-30	META	Stock	274.5	276.7	259.1	263.11	47247800.0
2020-10-30	TSLA	Stock	135.6333	135.8633	126.37	129.3467	127533900.0
2020-10-30	TLT	Stock	159.03	159.35	157.57	157.57	13095938.0
2020-10-30	ES	Stock	88.2	88.85	86.41	87.27	1437700.0
2020-10-30	CL	Stock	79.94	81.09	77.68	78.89	7362900.0
2020-10-30	A	Stock	101.77	102.35	100.65	102.09	2310000.0
2020-10-30	AA	Stock	12.7	13.032	12.61	12.92	3996300.0
2020-10-30	AACG	Stock	1.09	1.1	1.08	1.09	28800.0
2020-10-30	AACQ-DELISTED	Stock	9.6	9.69	9.58	9.647	152002.0
2020-10-30	AACQU-DELISTED	Stock	10.01	10.04	9.94	10.0	38013.0
2020-10-30	AACQW-DELISTED	Stock	1.1401	1.18	1.14	1.155	51978.0
2020-10-30	AAIC-DELISTED	Stock	2.42	2.5	2.38	2.46	160698.0
2020-10-30	AAIC.C-DELISTED	Stock	18.6301	18.85	18.6301	18.85	979.0
2020-10-30	AAL	Stock	11.06	11.42	10.98	11.28	51284700.0
2020-10-30	AAM.A-DELISTED	Stock	26.0084	26.04	25.8	25.97	1237816.0
2020-10-30	AAM.B-DELISTED	Stock	26.6	26.63	26.41	26.49	26555.0
2020-10-30	AAME	Stock	2.08	2.14	2.01	2.02	2000.0
2020-10-30	AAMI	Stock	13.43	13.91	13.32	13.8	831500.0
2020-10-30	AAOI	Stock	9.15	9.22	8.469	8.78	1044700.0
2020-10-30	AAON	Stock	39.1667	39.4133	37.5133	38.94	194700.0
2020-10-30	AAP	Stock	144.87	147.41	144.6	147.28	822000.0
2020-10-30	AAT	Stock	20.99	21.38	20.75	20.93	327900.0
2020-10-30	AAU-DELISTED	Stock	1.0	1.02	0.9579	0.97	2510797.0
2020-10-30	AAUAF-DELISTED	Stock	1.0	1.02	0.9579	0.9869	2546697.0
2020-10-30	AAWW-DELISTED	Stock	61.01	61.35	57.43	59.24	525736.0
2020-10-30	AAXJ	Stock	79.03	79.1	78.25	78.6	1481751.0
2020-10-30	AAXN-DELISTED	Stock	103.01	103.43	98.01	98.9	313475.0
2020-10-30	AB	Stock	29.44	29.44	28.61	29.06	581300.0
2020-10-30	ABB-DELISTED	Stock	24.36	24.4	24.07	24.29	1632504.0
2020-10-30	ABBNY-DELISTED	Stock	24.36	24.4	24.07	24.29	1755540.0
2020-10-30	ABBV	Stock	83.2	86.14	83.0	85.1	18089100.0
2020-10-30	ABC-DELISTED	Stock	94.08	96.48	94.03	96.17	854912.0
2020-10-30	ABCB	Stock	28.79	29.43	28.79	29.3	289400.0
2020-10-30	ABCM-DELISTED	Stock	19.21	19.45	18.94	19.0	31891.0
2020-10-30	ABEO	Stock	28.0	28.0	25.75	26.75	75404.0
2020-10-30	ABEV	Stock	2.24	2.24	2.13	2.14	36839300.0
2020-10-30	ABG	Stock	102.73	103.43	99.65	102.98	293000.0
2020-10-30	ABM	Stock	35.2	35.43	34.28	34.72	613700.0
2020-10-30	ABMD-DELISTED	Stock	253.65	258.18	242.73	251.87	276524.0
2020-10-30	ABR	Stock	11.8	12.07	11.56	11.82	1825900.0
2020-10-30	ABR.A-DELISTED	Stock	25.3	25.89	25.3	25.41	6786.0
2020-10-30	ABR.B-DELISTED	Stock	25.44	25.48	25.316	25.32	9184.0
2020-10-30	ABR.C-DELISTED	Stock	25.56	25.882	25.53	25.8	8482.0
2020-10-30	ABST-DELISTED	Stock	11.73	11.8	11.1	11.28	120726.0
2020-10-30	ABT	Stock	104.76	105.55	103.13	105.11	4433200.0

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

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