PREVIEW / stock_daily / 2019-12-12

all stock daily files

  file:    by_date/stock_daily/2019/2019-12-12.parquet
  size:    223 KB
  rows:    6,619
  symbols: 2,463

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
2019-12-12	AAPL	Stock	66.945	68.14	66.83	67.865	137310400.0
2019-12-12	MSFT	Stock	151.65	153.44	151.02	153.24	24612100.0
2019-12-12	NVDA	Stock	5.4045	5.62	5.3955	5.6018	404348000.0
2019-12-12	AMZN	Stock	87.5	88.2	87.272	88.0165	61918000.0
2019-12-12	GOOGL	Stock	67.1605	67.729	66.91	67.4245	29129320.0
2019-12-12	META	Stock	202.35	203.66	194.1	196.75	23734800.0
2019-12-12	TSLA	Stock	23.6613	24.1827	23.5487	23.9787	116458500.0
2019-12-12	TLT	Stock	139.19	139.2846	136.61	137.45	14868125.0
2019-12-12	ES	Stock	81.31	81.52	80.74	80.85	1066300.0
2019-12-12	CL	Stock	67.55	67.83	66.94	67.23	3658400.0
2019-12-12	A	Stock	83.49	84.98	83.17	84.81	1920800.0
2019-12-12	AA	Stock	20.4	21.34	20.31	21.26	3444100.0
2019-12-12	AACG	Stock	1.47	1.48	1.35	1.36	18500.0
2019-12-12	AAIC-DELISTED	Stock	5.86	5.92	5.81	5.84	313443.0
2019-12-12	AAIC.C-DELISTED	Stock	21.972	22.15	21.93	22.15	13950.0
2019-12-12	AAL	Stock	27.09	28.02	26.95	27.72	9645300.0
2019-12-12	AAM.A-DELISTED	Stock	26.2469	26.31	26.205	26.3	10435.0
2019-12-12	AAM.B-DELISTED	Stock	26.51	26.67	26.46	26.67	30306.0
2019-12-12	AAMC-DELISTED	Stock	4.1265	4.1265	4.1265	4.1265	1221.0
2019-12-12	AAME	Stock	2.15	2.15	1.72	1.95	10100.0
2019-12-12	AAMI	Stock	10.24	10.89	10.24	10.79	733500.0
2019-12-12	AAOI	Stock	10.92	11.42	10.831	11.28	583800.0
2019-12-12	AAON	Stock	33.0333	33.88	33.0333	33.4933	249300.0
2019-12-12	AAP	Stock	155.59	157.84	155.45	156.12	710300.0
2019-12-12	AAT	Stock	46.28	46.51	44.89	44.9	331300.0
2019-12-12	AAU-DELISTED	Stock	0.54	0.54	0.5016	0.52	184936.0
2019-12-12	AAUAF-DELISTED	Stock	0.54	0.54	0.5016	0.52	197282.0
2019-12-12	AAWW-DELISTED	Stock	26.69	28.47	26.55	28.24	276744.0
2019-12-12	AAXJ	Stock	71.22	72.455	71.22	72.4	1333473.0
2019-12-12	AAXN-DELISTED	Stock	72.37	73.07	70.61	71.82	290336.0
2019-12-12	AB	Stock	28.85	30.2	28.83	30.19	1012100.0
2019-12-12	ABB-DELISTED	Stock	23.18	23.64	23.17	23.62	2524245.0
2019-12-12	ABBNY-DELISTED	Stock	23.18	23.64	23.17	23.62	2637242.0
2019-12-12	ABBV	Stock	86.76	88.94	86.75	88.73	6260500.0
2019-12-12	ABC-DELISTED	Stock	87.1	87.81	86.125	86.77	365683.0
2019-12-12	ABCB	Stock	43.4	44.54	43.05	44.23	322600.0
2019-12-12	ABDC-DELISTED	Stock	9.17	9.17	9.0201	9.11	19079.0
2019-12-12	ABEO	Stock	99.5	101.5	92.5	99.75	64244.0
2019-12-12	ABEOW-DELISTED	Stock	0.18	0.18	0.18	0.18	500.0
2019-12-12	ABEV	Stock	4.46	4.57	4.46	4.57	14951300.0
2019-12-12	ABG	Stock	114.75	123.45	114.75	122.67	316100.0
2019-12-12	ABIL-DELISTED	Stock	0.605	0.605	0.5402	0.5638	70269.0
2019-12-12	ABM	Stock	38.16	38.52	37.83	37.95	263600.0
2019-12-12	ABMD-DELISTED	Stock	179.27	181.77	177.135	179.07	435827.0
2019-12-12	ABR	Stock	14.34	14.36	14.03	14.05	1997600.0
2019-12-12	ABR.A-DELISTED	Stock	26.059	26.28	26.05	26.28	1531.0
2019-12-12	ABR.B-DELISTED	Stock	25.7767	25.7767	25.7767	25.7767	246.0
2019-12-12	ABR.C-DELISTED	Stock	26.1494	26.26	26.0509	26.2	6187.0
2019-12-12	ABT	Stock	84.78	86.28	84.64	85.97	4155200.0
2019-12-12	ABTC	Stock	360000.0	387000.0	351000.0	372900.0	6.333333333333333

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

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