PREVIEW / stock_daily / 2020-01-15

all stock daily files

  file:    by_date/stock_daily/2020/2020-01-15.parquet
  size:    223 KB
  rows:    6,608
  symbols: 2,424

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-01-15	AAPL	Stock	77.9625	78.875	77.3875	77.835	121923600.0
2020-01-15	MSFT	Stock	162.62	163.94	162.57	163.18	21417900.0
2020-01-15	NVDA	Stock	6.1948	6.2172	6.1133	6.1393	263104000.0
2020-01-15	AMZN	Stock	93.6125	93.943	92.7545	93.101	57932000.0
2020-01-15	GOOGL	Stock	71.651	72.039	71.583	71.96	21550380.0
2020-01-15	META	Stock	220.61	221.68	220.14	221.15	10036500.0
2020-01-15	TSLA	Stock	35.3173	35.856	34.4527	34.5667	260532000.0
2020-01-15	TLT	Stock	139.52	139.76	139.02	139.65	6290520.0
2020-01-15	ES	Stock	86.2	87.73	86.15	87.32	2196900.0
2020-01-15	CL	Stock	70.34	71.05	70.34	70.8	3606200.0
2020-01-15	A	Stock	87.63	89.11	87.55	88.62	1630400.0
2020-01-15	AA	Stock	20.33	20.48	20.045	20.18	5699400.0
2020-01-15	AACG	Stock	1.54	1.8	1.54	1.61	51000.0
2020-01-15	AAIC-DELISTED	Stock	5.66	5.78	5.65	5.74	316532.0
2020-01-15	AAIC.C-DELISTED	Stock	22.0272	22.1426	22.0	22.02	11685.0
2020-01-15	AAL	Stock	27.45	28.06	27.32	27.58	5689900.0
2020-01-15	AAM.A-DELISTED	Stock	26.875	26.875	26.74	26.79	13351.0
2020-01-15	AAM.B-DELISTED	Stock	27.38	27.38	27.27	27.27	23724.0
2020-01-15	AAMC-DELISTED	Stock	3.9706	4.0	3.8015	3.8765	31572.0
2020-01-15	AAME	Stock	1.91	1.91	1.91	1.91	600.0
2020-01-15	AAMI	Stock	9.95	10.11	9.95	10.07	299600.0
2020-01-15	AAOI	Stock	13.92	15.68	13.9	15.6	2104000.0
2020-01-15	AAON	Stock	34.5133	35.1533	34.2933	34.8533	185100.0
2020-01-15	AAP	Stock	149.58	151.49	147.82	150.21	1208800.0
2020-01-15	AAT	Stock	45.83	46.48	45.83	46.24	344600.0
2020-01-15	AAU-DELISTED	Stock	0.52	0.52	0.5	0.5172	229086.0
2020-01-15	AAUAF-DELISTED	Stock	0.52	0.5211	0.5	0.5211	252704.0
2020-01-15	AAWW-DELISTED	Stock	28.17	28.275	27.26	27.51	166987.0
2020-01-15	AAXJ	Stock	75.51	75.66	75.255	75.45	1509944.0
2020-01-15	AAXN-DELISTED	Stock	71.54	72.965	71.54	72.71	282390.0
2020-01-15	AB	Stock	32.42	32.72	32.41	32.66	256400.0
2020-01-15	ABB-DELISTED	Stock	23.92	23.99	23.81	23.86	1147025.0
2020-01-15	ABBNY-DELISTED	Stock	23.92	23.99	23.81	23.85	1213496.0
2020-01-15	ABBV	Stock	88.18	89.88	88.18	89.26	8490100.0
2020-01-15	ABC-DELISTED	Stock	88.79	91.64	88.68	91.38	1141036.0
2020-01-15	ABCB	Stock	42.47	42.75	42.11	42.29	229300.0
2020-01-15	ABDC-DELISTED	Stock	9.3261	9.3294	9.26	9.26	16331.0
2020-01-15	ABEO	Stock	64.5	67.5	63.0	66.0	48508.0
2020-01-15	ABEV	Stock	4.53	4.56	4.45	4.46	18156000.0
2020-01-15	ABG	Stock	101.95	102.37	100.64	101.24	214300.0
2020-01-15	ABM	Stock	39.18	39.67	39.09	39.28	252000.0
2020-01-15	ABMD-DELISTED	Stock	173.58	178.33	171.65	177.91	1092399.0
2020-01-15	ABR	Stock	14.54	14.55	14.41	14.47	761400.0
2020-01-15	ABR.A-DELISTED	Stock	26.31	26.405	26.31	26.405	3296.0
2020-01-15	ABR.B-DELISTED	Stock	26.1726	26.2391	26.1726	26.195	2894.0
2020-01-15	ABR.C-DELISTED	Stock	26.7	26.7	26.6597	26.6597	1074.0
2020-01-15	ABT	Stock	86.11	87.85	86.11	87.38	5389700.0
2020-01-15	ABTC	Stock	216600.0	281700.0	214800.0	270000.0	21.0
2020-01-15	ABTS	Stock	30.3	30.3	30.3	30.3	20.0
2020-01-15	ABTX-DELISTED	Stock	37.22	37.41	36.95	37.17	53549.0

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

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