PREVIEW / stock_daily / 2020-06-23

all stock daily files

  file:    by_date/stock_daily/2020/2020-06-23.parquet
  size:    222 KB
  rows:    6,719
  symbols: 2,401

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-06-23	AAPL	Stock	91.0	93.095	90.5675	91.6325	212155600.0
2020-06-23	MSFT	Stock	202.09	203.95	201.43	201.91	30917400.0
2020-06-23	NVDA	Stock	9.551	9.6425	9.4075	9.45	375108000.0
2020-06-23	AMZN	Stock	136.301	139.1555	135.902	138.2205	84634000.0
2020-06-23	GOOGL	Stock	72.6	73.76	72.25	73.199	37751660.0
2020-06-23	META	Stock	241.28	245.19	239.86	242.24	24017900.0
2020-06-23	TSLA	Stock	66.592	67.4667	66.2673	66.7853	95479500.0
2020-06-23	TLT	Stock	161.48	162.06	161.12	161.3	9088580.0
2020-06-23	ES	Stock	84.88	85.38	83.15	83.39	2293400.0
2020-06-23	CL	Stock	73.34	73.87	72.8	72.92	3489000.0
2020-06-23	A	Stock	89.19	89.7	88.66	89.28	1160300.0
2020-06-23	AA	Stock	12.12	12.31	11.93	12.2	7237300.0
2020-06-23	AACG	Stock	1.19	1.22	1.14	1.17	57000.0
2020-06-23	AAIC-DELISTED	Stock	2.92	2.92	2.845	2.85	334773.0
2020-06-23	AAIC.C-DELISTED	Stock	19.7213	19.75	19.5	19.72	3261.0
2020-06-23	AAL	Stock	13.76	14.29	13.71	14.0	204022300.0
2020-06-23	AAM.A-DELISTED	Stock	26.09	26.39	26.06	26.2437	8392.0
2020-06-23	AAM.B-DELISTED	Stock	25.92	26.17	25.85	26.088	19200.0
2020-06-23	AAMC-DELISTED	Stock	5.0	5.4118	5.0	5.3647	37189.0
2020-06-23	AAME	Stock	1.88	1.99	1.75	1.75	22900.0
2020-06-23	AAMI	Stock	10.5	10.57	10.18	10.27	1086400.0
2020-06-23	AAOI	Stock	10.01	10.04	9.52	9.8	522800.0
2020-06-23	AAON	Stock	36.4533	36.5467	36.0733	36.14	181200.0
2020-06-23	AAP	Stock	152.51	153.47	149.78	149.97	1210300.0
2020-06-23	AAT	Stock	28.86	29.14	28.15	28.45	374100.0
2020-06-23	AAU-DELISTED	Stock	0.5	0.52	0.49	0.5102	304027.0
2020-06-23	AAUAF-DELISTED	Stock	0.5	0.52	0.49	0.512	321545.0
2020-06-23	AAWW-DELISTED	Stock	41.03	41.74	40.62	41.43	287208.0
2020-06-23	AAXJ	Stock	70.37	70.69	70.28	70.35	830780.0
2020-06-23	AAXN-DELISTED	Stock	93.41	97.7422	92.0785	95.54	1565529.0
2020-06-23	AB	Stock	27.11	27.25	26.11	26.13	462200.0
2020-06-23	ABB-DELISTED	Stock	22.27	22.28	21.95	21.98	3446143.0
2020-06-23	ABBNY-DELISTED	Stock	22.24	22.27	21.95	21.98	3577772.0
2020-06-23	ABBV	Stock	98.42	99.1	97.05	97.31	6715600.0
2020-06-23	ABC-DELISTED	Stock	102.27	102.8	100.85	101.49	1977665.0
2020-06-23	ABCB	Stock	24.61	25.32	23.66	23.68	317700.0
2020-06-23	ABEO	Stock	76.0	78.75	74.5	76.5	63956.0
2020-06-23	ABEV	Stock	2.75	2.8	2.71	2.72	25300300.0
2020-06-23	ABG	Stock	77.13	77.32	75.36	76.61	158700.0
2020-06-23	ABM	Stock	39.51	39.57	37.63	38.01	774100.0
2020-06-23	ABMD-DELISTED	Stock	254.67	258.8161	252.13	252.59	264972.0
2020-06-23	ABR	Stock	9.69	10.03	9.69	9.97	2165900.0
2020-06-23	ABR.A-DELISTED	Stock	24.81	24.98	24.81	24.88	2396.0
2020-06-23	ABR.B-DELISTED	Stock	23.69	23.69	23.2	23.41	5799.0
2020-06-23	ABR.C-DELISTED	Stock	25.05	25.3555	24.87	25.218	2780.0
2020-06-23	ABT	Stock	91.11	92.3	90.79	91.3	4156900.0
2020-06-23	ABTC	Stock	284400.0	285000.0	237300.0	243000.0	8.133333333333333
2020-06-23	ABTS	Stock	16.2	16.2	14.865	15.6	6207.0
2020-06-23	ABTX-DELISTED	Stock	25.58	25.88	24.94	25.01	62918.0
2020-06-23	ABUS	Stock	2.11	2.2	2.05	2.05	1162400.0

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

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