PREVIEW / stock_daily / 2020-09-10

all stock daily files

  file:    by_date/stock_daily/2020/2020-09-10.parquet
  size:    225 KB
  rows:    6,829
  symbols: 2,423

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-09-10	AAPL	Stock	120.36	120.5	112.5	113.49	182274400.0
2020-09-10	MSFT	Stock	213.4	214.74	204.11	205.37	35461500.0
2020-09-10	NVDA	Stock	12.9893	13.0652	12.167	12.3118	698684000.0
2020-09-10	AMZN	Stock	165.361	167.4945	158.5275	158.7555	106614000.0
2020-09-10	GOOGL	Stock	77.509	78.683	76.0	76.3025	33023880.0
2020-09-10	META	Stock	275.51	279.16	267.03	268.09	24814700.0
2020-09-10	TSLA	Stock	128.7367	132.9967	120.1867	123.78	254791800.0
2020-09-10	TLT	Stock	162.46	164.35	161.95	164.13	8847742.0
2020-09-10	ES	Stock	85.54	85.61	83.29	83.34	1343700.0
2020-09-10	CL	Stock	77.11	77.78	76.26	76.41	4165800.0
2020-09-10	A	Stock	98.88	100.1	98.24	98.57	1933200.0
2020-09-10	AA	Stock	14.15	14.34	13.73	13.78	4206100.0
2020-09-10	AACG	Stock	1.08	1.09	1.07	1.07	26900.0
2020-09-10	AACQ-DELISTED	Stock	10.0	10.025	9.836	9.96	1758528.0
2020-09-10	AACQU-DELISTED	Stock	10.4036	10.47	10.28	10.4	108859.0
2020-09-10	AACQW-DELISTED	Stock	1.9	2.3285	1.56	1.588	361601.0
2020-09-10	AAIC-DELISTED	Stock	2.69	2.725	2.68	2.71	213804.0
2020-09-10	AAIC.C-DELISTED	Stock	19.35	19.3501	19.35	19.3501	306.0
2020-09-10	AAL	Stock	13.21	13.49	12.97	13.01	52318600.0
2020-09-10	AAM.A-DELISTED	Stock	26.49	26.555	26.44	26.44	19384.0
2020-09-10	AAM.B-DELISTED	Stock	27.15	27.3	27.14	27.21	14095.0
2020-09-10	AAMC-DELISTED	Stock	6.2853	7.3529	6.2853	6.9118	98083.0
2020-09-10	AAME	Stock	2.01	2.03	1.96	1.96	800.0
2020-09-10	AAMI	Stock	13.22	13.3	12.885	12.92	551700.0
2020-09-10	AAOI	Stock	10.39	10.46	9.86	9.86	506400.0
2020-09-10	AAON	Stock	37.0933	37.6533	36.8467	37.3933	394650.0
2020-09-10	AAP	Stock	154.65	155.72	153.1	153.56	418700.0
2020-09-10	AAT	Stock	25.31	25.38	24.86	25.14	234000.0
2020-09-10	AAU-DELISTED	Stock	0.695	0.7	0.672	0.68	222465.0
2020-09-10	AAUAF-DELISTED	Stock	0.695	0.7	0.672	0.68	235975.0
2020-09-10	AAWW-DELISTED	Stock	56.5	57.8	56.475	57.19	338422.0
2020-09-10	AAXJ	Stock	76.94	77.05	75.72	75.76	988829.0
2020-09-10	AAXN-DELISTED	Stock	85.47	87.285	83.9102	84.24	403796.0
2020-09-10	AB	Stock	27.45	27.45	26.63	26.84	438000.0
2020-09-10	ABB-DELISTED	Stock	26.55	26.58	25.94	25.95	1668157.0
2020-09-10	ABBNY-DELISTED	Stock	26.55	26.58	25.94	25.95	1742358.0
2020-09-10	ABBV	Stock	91.07	91.41	89.48	89.65	10403600.0
2020-09-10	ABC-DELISTED	Stock	96.41	96.77	94.23	94.26	867681.0
2020-09-10	ABCB	Stock	24.02	24.25	23.37	23.4	188600.0
2020-09-10	ABEO	Stock	51.5	53.75	50.25	51.0	25348.0
2020-09-10	ABEV	Stock	2.34	2.41	2.33	2.33	28408200.0
2020-09-10	ABG	Stock	112.17	112.42	107.79	107.98	133400.0
2020-09-10	ABM	Stock	38.9	38.9	37.09	37.78	458800.0
2020-09-10	ABMD-DELISTED	Stock	279.0	282.835	271.16	272.27	118083.0
2020-09-10	ABR	Stock	11.7	11.91	11.5	11.51	960500.0
2020-09-10	ABR.A-DELISTED	Stock	25.25	25.25	25.102	25.1753	595.0
2020-09-10	ABR.B-DELISTED	Stock	25.235	25.235	25.02	25.085	1100.0
2020-09-10	ABR.C-DELISTED	Stock	25.39	25.44	25.32	25.44	900.0
2020-09-10	ABT	Stock	105.6	105.6	103.73	104.0	4271200.0
2020-09-10	ABTC	Stock	141000.0	141000.0	137100.0	138300.0	1.6666666666666667

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

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