PREVIEW / stock_daily / 2020-01-10

all stock daily files

  file:    by_date/stock_daily/2020/2020-01-10.parquet
  size:    223 KB
  rows:    6,609
  symbols: 2,425

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-10	AAPL	Stock	77.65	78.1675	77.0625	77.5825	140644800.0
2020-01-10	MSFT	Stock	162.82	163.22	161.18	161.34	20725900.0
2020-01-10	NVDA	Stock	6.1833	6.2138	6.0938	6.108	316296000.0
2020-01-10	AMZN	Stock	95.2685	95.347	94.0	94.158	57074000.0
2020-01-10	GOOGL	Stock	71.4735	71.747	70.9799	71.448	26263560.0
2020-01-10	META	Stock	219.2	219.88	217.42	218.06	12119400.0
2020-01-10	TSLA	Stock	32.1193	32.3293	31.58	31.8767	194392500.0
2020-01-10	TLT	Stock	137.67	138.47	137.6299	138.44	8776937.0
2020-01-10	ES	Stock	83.64	84.56	83.64	84.41	2028500.0
2020-01-10	CL	Stock	69.73	70.43	69.46	70.15	3724000.0
2020-01-10	A	Stock	87.72	88.24	87.32	87.59	1417000.0
2020-01-10	AA	Stock	19.9	19.94	19.34	19.45	5059200.0
2020-01-10	AACG	Stock	1.45	1.52	1.41	1.48	35800.0
2020-01-10	AAIC-DELISTED	Stock	5.59	5.64	5.59	5.61	176205.0
2020-01-10	AAIC.C-DELISTED	Stock	21.97	22.07	21.71	22.05	16451.0
2020-01-10	AAL	Stock	27.96	27.99	27.25	27.32	8106800.0
2020-01-10	AAM.A-DELISTED	Stock	26.67	26.85	26.67	26.85	10004.0
2020-01-10	AAM.B-DELISTED	Stock	27.3428	27.39	27.31	27.3768	11276.0
2020-01-10	AAMC-DELISTED	Stock	3.8208	3.9382	3.8208	3.9382	1751.0
2020-01-10	AAME	Stock	1.92	2.0	1.92	2.0	8400.0
2020-01-10	AAMI	Stock	9.89	10.04	9.83	10.04	343100.0
2020-01-10	AAOI	Stock	13.1	13.25	12.59	12.93	855300.0
2020-01-10	AAON	Stock	33.8267	34.1933	33.7	33.8733	189750.0
2020-01-10	AAP	Stock	153.18	153.5	148.61	149.01	1416100.0
2020-01-10	AAT	Stock	45.4	45.64	45.24	45.56	213800.0
2020-01-10	AAU-DELISTED	Stock	0.53	0.5399	0.52	0.5361	182432.0
2020-01-10	AAUAF-DELISTED	Stock	0.53	0.5399	0.52	0.5361	185422.0
2020-01-10	AAWW-DELISTED	Stock	26.9	26.97	26.205	26.5	162363.0
2020-01-10	AAXJ	Stock	75.01	75.265	74.89	75.05	1304894.0
2020-01-10	AAXN-DELISTED	Stock	70.22	70.85	69.21	69.52	464929.0
2020-01-10	AB	Stock	31.75	32.04	31.63	31.88	281300.0
2020-01-10	ABB-DELISTED	Stock	24.08	24.115	23.95	23.965	1093970.0
2020-01-10	ABBNY-DELISTED	Stock	24.08	24.115	23.95	23.97	1165110.0
2020-01-10	ABBV	Stock	90.23	90.29	88.83	89.06	8581400.0
2020-01-10	ABC-DELISTED	Stock	87.04	87.39	86.6	87.01	774845.0
2020-01-10	ABCB	Stock	42.61	42.89	42.09	42.2	196700.0
2020-01-10	ABDC-DELISTED	Stock	9.19	9.223	9.15	9.15	5545.0
2020-01-10	ABEO	Stock	65.5	65.75	63.5	63.5	70088.0
2020-01-10	ABEV	Stock	4.64	4.66	4.55	4.61	24067500.0
2020-01-10	ABG	Stock	101.02	101.76	100.19	100.28	298200.0
2020-01-10	ABM	Stock	38.7	38.87	38.46	38.66	205300.0
2020-01-10	ABMD-DELISTED	Stock	190.6	195.49	185.33	188.98	1116863.0
2020-01-10	ABR	Stock	14.48	14.48	14.31	14.37	857200.0
2020-01-10	ABR.A-DELISTED	Stock	26.33	26.365	26.31	26.31	827.0
2020-01-10	ABT	Stock	86.79	86.99	85.17	85.36	4680400.0
2020-01-10	ABTC	Stock	225300.0	232200.0	211500.0	212700.0	4.4399999999999995
2020-01-10	ABTS	Stock	31.2	32.1	31.2	31.95	360.0
2020-01-10	ABTX-DELISTED	Stock	37.35	37.48	37.01	37.29	67655.0
2020-01-10	ABUS	Stock	2.93	3.03	2.88	3.03	241100.0
2020-01-10	ACA	Stock	45.99	46.1	44.79	45.55	371119.0

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

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