PREVIEW / stock_daily / 2020-07-16

all stock daily files

  file:    by_date/stock_daily/2020/2020-07-16.parquet
  size:    222 KB
  rows:    6,718
  symbols: 2,399

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-07-16	AAPL	Stock	96.5625	97.405	95.905	96.5225	110577600.0
2020-07-16	MSFT	Stock	205.4	205.7	202.31	203.92	29940700.0
2020-07-16	NVDA	Stock	10.015	10.2068	9.8955	10.1348	344964000.0
2020-07-16	AMZN	Stock	148.553	151.6	145.9115	149.995	127884000.0
2020-07-16	GOOGL	Stock	75.075	75.7955	74.4135	75.746	26484540.0
2020-07-16	META	Stock	238.0	241.76	236.33	240.93	18880700.0
2020-07-16	TSLA	Stock	98.4773	102.114	97.7333	100.0427	214512000.0
2020-07-16	TLT	Stock	167.4	167.77	167.04	167.13	9107383.0
2020-07-16	ES	Stock	85.21	86.08	84.86	85.81	1391200.0
2020-07-16	CL	Stock	74.8	75.12	74.2	74.98	2557800.0
2020-07-16	A	Stock	92.98	93.21	92.06	92.86	1226400.0
2020-07-16	AA	Stock	12.81	13.7	12.75	13.49	16696900.0
2020-07-16	AACG	Stock	1.52	1.87	1.52	1.7	848500.0
2020-07-16	AACQU-DELISTED	Stock	10.35	10.4	10.33	10.37	1143834.0
2020-07-16	AAIC-DELISTED	Stock	3.06	3.1443	3.01	3.01	180952.0
2020-07-16	AAIC.C-DELISTED	Stock	19.01	19.2	19.01	19.09	1399.0
2020-07-16	AAL	Stock	12.8	13.07	12.29	12.45	81514000.0
2020-07-16	AAM.A-DELISTED	Stock	26.4	26.55	26.3312	26.5472	7149.0
2020-07-16	AAM.B-DELISTED	Stock	26.87	26.95	26.83	26.9265	7640.0
2020-07-16	AAMC-DELISTED	Stock	4.4118	4.4118	4.1176	4.2647	6814.0
2020-07-16	AAME	Stock	1.69	1.7	1.68	1.7	1900.0
2020-07-16	AAMI	Stock	12.38	12.49	12.23	12.32	583800.0
2020-07-16	AAOI	Stock	10.98	11.03	10.35	10.665	730500.0
2020-07-16	AAON	Stock	38.1667	38.9667	38.0333	38.4267	219000.0
2020-07-16	AAP	Stock	143.47	147.56	142.98	145.35	941400.0
2020-07-16	AAT	Stock	26.6	26.64	26.13	26.26	267400.0
2020-07-16	AAU-DELISTED	Stock	0.5	0.5009	0.48	0.4821	277320.0
2020-07-16	AAUAF-DELISTED	Stock	0.5	0.5009	0.48	0.49	288378.0
2020-07-16	AAWW-DELISTED	Stock	48.32	49.5372	48.09	49.23	210719.0
2020-07-16	AAXJ	Stock	73.22	73.59	72.96	73.45	1207158.0
2020-07-16	AAXN-DELISTED	Stock	92.2	92.35	90.275	91.23	308121.0
2020-07-16	AB	Stock	28.59	28.93	28.31	28.57	185300.0
2020-07-16	ABB-DELISTED	Stock	24.54	24.9	24.53	24.845	2258550.0
2020-07-16	ABBNY-DELISTED	Stock	24.54	24.9	24.53	24.85	2441617.0
2020-07-16	ABBV	Stock	99.69	100.23	98.81	99.92	4269200.0
2020-07-16	ABC-DELISTED	Stock	101.82	103.33	101.05	102.73	691129.0
2020-07-16	ABCB	Stock	22.27	23.12	21.98	22.35	472700.0
2020-07-16	ABEO	Stock	72.0	74.5	69.75	74.25	20444.0
2020-07-16	ABEV	Stock	2.66	2.71	2.62	2.65	40471500.0
2020-07-16	ABG	Stock	100.34	103.86	99.52	101.18	215200.0
2020-07-16	ABM	Stock	35.57	36.3	34.79	35.01	422600.0
2020-07-16	ABMD-DELISTED	Stock	273.55	276.795	271.22	273.05	98259.0
2020-07-16	ABR	Stock	8.65	8.82	8.39	8.66	1446900.0
2020-07-16	ABR.A-DELISTED	Stock	24.69	25.0	24.61	24.97	3079.0
2020-07-16	ABR.B-DELISTED	Stock	23.85	23.85	23.69	23.69	400.0
2020-07-16	ABT	Stock	97.85	97.99	94.29	96.4	7582200.0
2020-07-16	ABTC	Stock	219600.0	220200.0	213000.0	214500.0	1.7866666666666666
2020-07-16	ABTS	Stock	15.75	16.65	15.75	16.65	2220.0
2020-07-16	ABTX-DELISTED	Stock	23.85	24.23	23.53	23.85	27498.0
2020-07-16	ABUS	Stock	1.9	2.08	1.89	2.01	1224700.0

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

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