PREVIEW / stock_daily / 2020-08-05

all stock daily files

  file:    by_date/stock_daily/2020/2020-08-05.parquet
  size:    223 KB
  rows:    6,753
  symbols: 2,397

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-05	AAPL	Stock	109.3775	110.3925	108.8975	110.0625	121776800.0
2020-08-05	MSFT	Stock	214.9	215.0	211.57	212.94	28806400.0
2020-08-05	NVDA	Stock	11.244	11.3718	11.1662	11.2868	249924000.0
2020-08-05	AMZN	Stock	157.1885	160.6795	156.365	160.2515	78330000.0
2020-08-05	GOOGL	Stock	73.841	74.5	73.5608	73.9545	29150360.0
2020-08-05	META	Stock	250.19	252.27	247.77	249.12	13050100.0
2020-08-05	TSLA	Stock	99.5327	99.9893	97.8873	99.0013	74217000.0
2020-08-05	TLT	Stock	170.06	170.56	169.69	170.07	6954183.0
2020-08-05	ES	Stock	90.36	90.65	87.89	88.18	953900.0
2020-08-05	CL	Stock	76.79	77.1	75.95	76.18	2730200.0
2020-08-05	A	Stock	98.09	98.83	97.7	97.89	955900.0
2020-08-05	AA	Stock	14.0	14.845	14.0	14.68	9431700.0
2020-08-05	AACG	Stock	1.24	1.33	1.23	1.3	36100.0
2020-08-05	AACQU-DELISTED	Stock	10.2	10.2	10.05	10.1	936769.0
2020-08-05	AAIC-DELISTED	Stock	2.72	2.8	2.7	2.78	202324.0
2020-08-05	AAIC.C-DELISTED	Stock	19.0	19.185	18.981	19.185	1308.0
2020-08-05	AAL	Stock	11.84	12.85	11.55	12.56	113130600.0
2020-08-05	AAM.A-DELISTED	Stock	26.915	27.0	26.8457	26.885	7843.0
2020-08-05	AAM.B-DELISTED	Stock	27.505	27.56	27.41	27.448	7512.0
2020-08-05	AAMC-DELISTED	Stock	4.0441	4.0441	3.9265	3.9265	10601.0
2020-08-05	AAME	Stock	1.82	1.88	1.75	1.88	10300.0
2020-08-05	AAMI	Stock	13.29	13.94	13.27	13.82	944700.0
2020-08-05	AAOI	Stock	16.48	16.5	15.84	16.11	1693100.0
2020-08-05	AAON	Stock	40.02	40.3333	39.5533	39.9867	270750.0
2020-08-05	AAP	Stock	153.23	154.14	151.14	151.72	845300.0
2020-08-05	AAT	Stock	27.58	27.62	26.72	26.99	198300.0
2020-08-05	AAU-DELISTED	Stock	0.79	0.84	0.729	0.7599	1895653.0
2020-08-05	AAUAF-DELISTED	Stock	0.79	0.84	0.729	0.7639	1940148.0
2020-08-05	AAWW-DELISTED	Stock	56.94	58.21	56.45	57.73	645206.0
2020-08-05	AAXJ	Stock	77.09	77.6	77.09	77.34	744125.0
2020-08-05	AAXN-DELISTED	Stock	90.0	93.12	89.41	92.57	599618.0
2020-08-05	AB	Stock	27.8	27.94	27.42	27.82	301500.0
2020-08-05	ABB-DELISTED	Stock	25.99	26.12	25.91	25.95	991170.0
2020-08-05	ABBNY-DELISTED	Stock	25.96	26.12	25.91	25.95	1110106.0
2020-08-05	ABBV	Stock	94.47	94.8	93.13	93.25	6918900.0
2020-08-05	ABC-DELISTED	Stock	104.0	106.45	103.11	103.45	1135174.0
2020-08-05	ABCB	Stock	23.62	24.46	23.39	24.43	318600.0
2020-08-05	ABEO	Stock	73.75	74.5	72.75	73.75	14440.0
2020-08-05	ABEV	Stock	2.57	2.59	2.47	2.49	46307800.0
2020-08-05	ABG	Stock	104.12	106.09	102.35	106.08	175900.0
2020-08-05	ABM	Stock	36.53	37.34	36.19	37.31	450300.0
2020-08-05	ABMD-DELISTED	Stock	305.36	319.19	303.11	316.65	312401.0
2020-08-05	ABR	Stock	10.81	10.87	10.44	10.71	1933300.0
2020-08-05	ABR.A-DELISTED	Stock	25.21	25.35	25.21	25.35	9539.0
2020-08-05	ABR.B-DELISTED	Stock	24.55	24.7899	24.407	24.5197	5760.0
2020-08-05	ABR.C-DELISTED	Stock	25.8	25.8	25.42	25.75	2400.0
2020-08-05	ABT	Stock	99.97	102.36	99.88	102.14	4415300.0
2020-08-05	ABTC	Stock	201000.0	202950.0	195300.0	198600.0	1.0799999999999998
2020-08-05	ABTS	Stock	18.0	18.15	16.65	17.85	11200.0
2020-08-05	ABTX-DELISTED	Stock	24.31	24.73	22.54	24.73	33104.0

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

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