PREVIEW / stock_daily / 2019-12-06

all stock daily files

  file:    by_date/stock_daily/2019/2019-12-06.parquet
  size:    222 KB
  rows:    6,599
  symbols: 2,441

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-06	AAPL	Stock	66.87	67.75	66.825	67.6775	106075600.0
2019-12-06	MSFT	Stock	150.99	151.87	150.27	151.75	16403500.0
2019-12-06	NVDA	Stock	5.288	5.3373	5.278	5.3042	232236000.0
2019-12-06	AMZN	Stock	87.56	87.72	87.0065	87.58	62348000.0
2019-12-06	GOOGL	Stock	66.6375	67.1235	66.5615	66.9695	32974580.0
2019-12-06	META	Stock	200.5	201.57	200.06	201.05	12270600.0
2019-12-06	TSLA	Stock	22.3333	22.5907	22.318	22.3927	114186000.0
2019-12-06	TLT	Stock	138.03	139.12	137.86	138.35	7931904.0
2019-12-06	ES	Stock	81.9	82.31	81.1	81.2	2100700.0
2019-12-06	CL	Stock	67.88	68.33	67.39	68.24	3504700.0
2019-12-06	A	Stock	82.24	82.42	81.82	82.21	1783400.0
2019-12-06	AA	Stock	20.13	20.9	20.06	20.6	5271100.0
2019-12-06	AACG	Stock	1.72	1.72	1.6	1.65	12100.0
2019-12-06	AAIC-DELISTED	Stock	5.85	5.92	5.8492	5.92	407523.0
2019-12-06	AAIC.C-DELISTED	Stock	22.1753	22.1753	21.9	22.0	7886.0
2019-12-06	AAL	Stock	27.5	27.96	27.47	27.73	6093100.0
2019-12-06	AAM.A-DELISTED	Stock	26.101	26.1899	26.1	26.14	7130.0
2019-12-06	AAM.B-DELISTED	Stock	26.25	26.4957	26.25	26.44	17945.0
2019-12-06	AAMC-DELISTED	Stock	3.6903	4.1912	3.6846	4.1225	43738.0
2019-12-06	AAME	Stock	1.7	2.0	1.7	1.96	12000.0
2019-12-06	AAMI	Stock	9.74	9.96	9.7	9.91	363300.0
2019-12-06	AAOI	Stock	10.58	10.78	10.355	10.37	353900.0
2019-12-06	AAON	Stock	33.0733	33.7267	33.0733	33.5333	321900.0
2019-12-06	AAP	Stock	153.29	155.45	151.93	154.62	1803900.0
2019-12-06	AAT	Stock	47.72	48.04	47.26	47.4	295800.0
2019-12-06	AAU-DELISTED	Stock	0.54	0.5422	0.51	0.516	149691.0
2019-12-06	AAUAF-DELISTED	Stock	0.54	0.5422	0.51	0.516	153573.0
2019-12-06	AAWW-DELISTED	Stock	25.02	26.1	25.02	26.07	380933.0
2019-12-06	AAXJ	Stock	70.23	70.26	70.09	70.24	509378.0
2019-12-06	AAXN-DELISTED	Stock	73.58	74.255	71.68	71.86	456502.0
2019-12-06	AB	Stock	28.85	29.4	28.85	29.32	315100.0
2019-12-06	ABB-DELISTED	Stock	22.53	22.57	22.44	22.46	1997949.0
2019-12-06	ABBNY-DELISTED	Stock	22.53	22.57	22.44	22.46	2112293.0
2019-12-06	ABBV	Stock	87.21	87.71	86.78	86.98	6044600.0
2019-12-06	ABC-DELISTED	Stock	88.25	89.21	87.8907	88.24	558437.0
2019-12-06	ABCB	Stock	43.8	44.16	43.31	43.41	346600.0
2019-12-06	ABDC-DELISTED	Stock	8.94	9.01	8.93	9.01	38512.0
2019-12-06	ABEO	Stock	70.25	76.0	64.75	75.0	66636.0
2019-12-06	ABEOW-DELISTED	Stock	0.0508	0.0508	0.0508	0.0508	620.0
2019-12-06	ABEV	Stock	4.38	4.45	4.34	4.45	11216300.0
2019-12-06	ABG	Stock	110.8	112.08	110.72	110.92	193100.0
2019-12-06	ABIL-DELISTED	Stock	0.5405	0.63	0.5405	0.5771	183325.0
2019-12-06	ABM	Stock	38.07	38.63	38.03	38.14	281700.0
2019-12-06	ABMD-DELISTED	Stock	191.08	192.105	187.4	189.22	318442.0
2019-12-06	ABR	Stock	14.72	14.81	14.72	14.78	684700.0
2019-12-06	ABR.C-DELISTED	Stock	26.15	26.1501	26.05	26.076	1893.0
2019-12-06	ABT	Stock	85.67	85.91	85.38	85.48	4104600.0
2019-12-06	ABTC	Stock	315000.0	348900.0	303000.0	311400.0	7.8
2019-12-06	ABTS	Stock	34.2	34.2	33.6	33.6	127.0
2019-12-06	ABTX-DELISTED	Stock	36.25	36.5	36.17	36.47	115967.0

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

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