PREVIEW / stock_daily / 2020-08-19

all stock daily files

  file:    by_date/stock_daily/2020/2020-08-19.parquet
  size:    225 KB
  rows:    6,799
  symbols: 2,421

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-08-19	AAPL	Stock	115.9825	117.1625	115.61	115.7075	145538000.0
2020-08-19	MSFT	Stock	211.49	212.1	209.25	209.7	27627600.0
2020-08-19	NVDA	Stock	12.2965	12.315	12.098	12.1385	622624000.0
2020-08-19	AMZN	Stock	165.1505	165.795	162.8	163.024	83702000.0
2020-08-19	GOOGL	Stock	77.6245	78.443	77.0	77.2305	30471840.0
2020-08-19	META	Stock	261.39	267.91	261.35	262.59	23291500.0
2020-08-19	TSLA	Stock	124.3333	127.4	122.7473	125.2353	183079500.0
2020-08-19	TLT	Stock	165.37	165.6101	163.3	163.73	12497748.0
2020-08-19	ES	Stock	87.24	87.24	85.74	86.21	1060400.0
2020-08-19	CL	Stock	77.86	78.19	77.68	77.95	2470600.0
2020-08-19	A	Stock	95.23	99.4	94.53	97.96	2830800.0
2020-08-19	AA	Stock	14.8	15.945	14.77	15.31	7297300.0
2020-08-19	AACG	Stock	1.2	1.21	1.1	1.1	51000.0
2020-08-19	AACQU-DELISTED	Stock	10.07	10.15	10.05	10.08	746387.0
2020-08-19	AAIC-DELISTED	Stock	2.78	2.871	2.75	2.79	196831.0
2020-08-19	AAIC.C-DELISTED	Stock	19.167	19.42	19.167	19.3325	1128.0
2020-08-19	AAL	Stock	12.65	13.44	12.58	12.68	59266500.0
2020-08-19	AAM.A-DELISTED	Stock	27.03	27.05	26.55	26.55	30339.0
2020-08-19	AAM.B-DELISTED	Stock	27.52	27.5928	27.25	27.26	17103.0
2020-08-19	AAMC-DELISTED	Stock	6.5588	6.9706	5.8647	6.0441	165777.0
2020-08-19	AAME	Stock	2.07	2.82	2.07	2.3	185200.0
2020-08-19	AAMI	Stock	13.3	13.6	13.29	13.35	419700.0
2020-08-19	AAOI	Stock	12.97	13.41	12.97	13.09	702400.0
2020-08-19	AAON	Stock	40.0333	40.4267	39.5	39.6467	234900.0
2020-08-19	AAP	Stock	163.17	163.84	158.93	160.81	1289500.0
2020-08-19	AAT	Stock	26.17	26.32	25.2	25.29	293300.0
2020-08-19	AAU-DELISTED	Stock	0.803	0.803	0.71	0.735	786672.0
2020-08-19	AAUAF-DELISTED	Stock	0.803	0.803	0.71	0.735	802065.0
2020-08-19	AAWW-DELISTED	Stock	58.74	60.15	58.475	58.89	200220.0
2020-08-19	AAXJ	Stock	77.25	77.25	76.65	76.75	732832.0
2020-08-19	AAXN-DELISTED	Stock	79.73	82.08	79.17	81.01	425165.0
2020-08-19	AB	Stock	28.59	28.89	28.41	28.58	204300.0
2020-08-19	ABB-DELISTED	Stock	26.48	26.515	26.245	26.28	805104.0
2020-08-19	ABBNY-DELISTED	Stock	26.48	26.515	26.245	26.27	856253.0
2020-08-19	ABBV	Stock	97.11	97.42	95.85	96.1	7672000.0
2020-08-19	ABC-DELISTED	Stock	102.5	103.01	101.63	101.72	347118.0
2020-08-19	ABCB	Stock	24.91	25.49	24.75	24.86	247000.0
2020-08-19	ABEO	Stock	68.25	68.25	65.25	67.0	25624.0
2020-08-19	ABEV	Stock	2.41	2.42	2.33	2.34	19197700.0
2020-08-19	ABG	Stock	109.73	109.8	107.18	107.65	150500.0
2020-08-19	ABM	Stock	37.17	37.29	36.41	36.61	271700.0
2020-08-19	ABMD-DELISTED	Stock	312.38	317.69	311.49	314.35	144926.0
2020-08-19	ABR	Stock	10.89	11.26	10.79	11.16	1099300.0
2020-08-19	ABR.A-DELISTED	Stock	25.18	25.44	25.16	25.3	6281.0
2020-08-19	ABR.B-DELISTED	Stock	25.01	25.1572	24.95	24.9501	1895.0
2020-08-19	ABR.C-DELISTED	Stock	25.46	25.59	25.41	25.59	3000.0
2020-08-19	ABT	Stock	101.08	101.62	100.33	100.48	2716800.0
2020-08-19	ABTC	Stock	183900.0	195000.0	177300.0	192900.0	1.9333333333333333
2020-08-19	ABTS	Stock	21.3	23.85	20.4	21.6	18193.0
2020-08-19	ABTX-DELISTED	Stock	25.06	25.9	25.06	25.45	44519.0

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

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