PREVIEW / stock_daily / 2019-12-31

all stock daily files

  file:    by_date/stock_daily/2019/2019-12-31.parquet
  size:    223 KB
  rows:    6,631
  symbols: 2,449

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-31	AAPL	Stock	72.4825	73.42	72.38	73.4125	100805600.0
2019-12-31	MSFT	Stock	156.77	157.77	156.45	157.7	18369400.0
2019-12-31	NVDA	Stock	5.7725	5.892	5.7533	5.8825	231004000.0
2019-12-31	AMZN	Stock	92.1	92.663	91.6115	92.392	50130000.0
2019-12-31	GOOGL	Stock	66.7895	67.033	66.6065	66.9695	19521220.0
2019-12-31	META	Stock	204.0	205.56	203.6	205.25	8953500.0
2019-12-31	TSLA	Stock	27.0	28.086	26.8053	27.8887	154285500.0
2019-12-31	TLT	Stock	136.21	136.46	135.38	135.48	10707518.0
2019-12-31	ES	Stock	84.45	85.09	84.39	85.07	1625900.0
2019-12-31	CL	Stock	68.77	68.92	68.38	68.84	1960200.0
2019-12-31	A	Stock	84.84	85.34	84.67	85.31	1176200.0
2019-12-31	AA	Stock	21.37	21.67	21.26	21.51	2288500.0
2019-12-31	AACG	Stock	1.37	1.41	1.36	1.36	10800.0
2019-12-31	AAIC-DELISTED	Stock	5.62	5.65	5.57	5.57	528243.0
2019-12-31	AAIC.C-DELISTED	Stock	21.36	21.6038	21.36	21.465	3717.0
2019-12-31	AAL	Stock	28.2	28.79	28.19	28.68	4396800.0
2019-12-31	AAM.A-DELISTED	Stock	26.53	26.625	26.5	26.6	30901.0
2019-12-31	AAM.B-DELISTED	Stock	27.2359	27.2359	27.07	27.07	20763.0
2019-12-31	AAMC-DELISTED	Stock	3.3	3.6324	3.0	3.6324	73593.0
2019-12-31	AAME	Stock	1.93	1.97	1.85	1.97	3400.0
2019-12-31	AAMI	Stock	10.57	10.66	10.19	10.22	752300.0
2019-12-31	AAOI	Stock	11.56	12.06	11.5	11.88	559800.0
2019-12-31	AAON	Stock	32.9267	33.4	32.58	32.94	268350.0
2019-12-31	AAP	Stock	159.16	160.31	158.5	160.16	609600.0
2019-12-31	AAT	Stock	45.43	45.99	45.26	45.9	322600.0
2019-12-31	AAU-DELISTED	Stock	0.6	0.6	0.5748	0.589	250495.0
2019-12-31	AAUAF-DELISTED	Stock	0.6	0.6	0.5748	0.589	261623.0
2019-12-31	AAWW-DELISTED	Stock	26.45	27.68	26.45	27.55	160145.0
2019-12-31	AAXJ	Stock	73.26	73.53	73.16	73.5	213782.0
2019-12-31	AAXN-DELISTED	Stock	73.19	74.08	72.72	73.31	429726.0
2019-12-31	AB	Stock	30.36	30.38	30.12	30.26	182600.0
2019-12-31	ABB-DELISTED	Stock	24.0	24.09	23.93	24.08	886508.0
2019-12-31	ABBNY-DELISTED	Stock	24.0	24.09	23.93	24.09	942085.0
2019-12-31	ABBV	Stock	88.21	88.6	87.88	88.54	4702100.0
2019-12-31	ABC-DELISTED	Stock	83.38	85.03	83.22	85.01	802826.0
2019-12-31	ABCB	Stock	42.53	42.88	42.5	42.54	297500.0
2019-12-31	ABDC-DELISTED	Stock	9.17	9.18	9.02	9.02	83500.0
2019-12-31	ABEO	Stock	87.25	88.0	80.0	81.75	66856.0
2019-12-31	ABEV	Stock	4.64	4.67	4.62	4.66	4139200.0
2019-12-31	ABG	Stock	111.95	113.12	111.4	111.79	122800.0
2019-12-31	ABM	Stock	38.12	38.32	37.54	37.71	285400.0
2019-12-31	ABMD-DELISTED	Stock	167.33	171.19	167.26	170.58	538167.0
2019-12-31	ABR	Stock	14.45	14.52	14.33	14.35	978800.0
2019-12-31	ABR.A-DELISTED	Stock	26.2	26.2445	25.96	26.1	2046.0
2019-12-31	ABR.B-DELISTED	Stock	25.7553	25.7553	25.7091	25.7091	800.0
2019-12-31	ABR.C-DELISTED	Stock	26.5	26.5	26.4995	26.5	681.0
2019-12-31	ABT	Stock	86.5	86.99	86.27	86.86	3261100.0
2019-12-31	ABTC	Stock	240300.0	257850.0	227100.0	252900.0	7.666666666666667
2019-12-31	ABTS	Stock	31.65	31.65	31.65	31.65	107.0
2019-12-31	ABTX-DELISTED	Stock	37.48	37.69	37.4	37.57	87118.0

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

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