PREVIEW / stock_daily / 2019-11-20

all stock daily files

  file:    by_date/stock_daily/2019/2019-11-20.parquet
  size:    221 KB
  rows:    6,611
  symbols: 2,465

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-11-20	AAPL	Stock	66.385	66.52	65.1	65.7975	106234400.0
2019-11-20	MSFT	Stock	150.31	150.84	148.46	149.62	25696800.0
2019-11-20	NVDA	Stock	5.1768	5.3638	5.164	5.2795	472588000.0
2019-11-20	AMZN	Stock	87.457	88.126	86.706	87.2765	55800000.0
2019-11-20	GOOGL	Stock	65.568	65.6605	64.4605	65.093	28917400.0
2019-11-20	META	Stock	198.58	199.59	195.43	197.51	12355400.0
2019-11-20	TSLA	Stock	24.0	24.08	23.3047	23.4813	100876500.0
2019-11-20	TLT	Stock	139.91	140.6	139.77	140.6	7909901.0
2019-11-20	ES	Stock	82.36	83.12	82.03	82.5	2149500.0
2019-11-20	CL	Stock	67.23	67.59	66.82	67.21	3008600.0
2019-11-20	A	Stock	79.16	79.36	78.21	78.52	2429800.0
2019-11-20	AA	Stock	20.4	20.98	20.23	20.37	2526000.0
2019-11-20	AACG	Stock	1.75	1.77	1.68	1.77	10800.0
2019-11-20	AAIC-DELISTED	Stock	5.68	5.77	5.66	5.67	262580.0
2019-11-20	AAIC.C-DELISTED	Stock	21.7469	21.7469	21.4426	21.69	5211.0
2019-11-20	AAL	Stock	29.14	29.24	28.05	28.23	9936100.0
2019-11-20	AAM.A-DELISTED	Stock	26.58	26.605	26.517	26.59	3231.0
2019-11-20	AAM.B-DELISTED	Stock	27.09	27.09	26.9	26.99	18360.0
2019-11-20	AAME	Stock	1.77	1.91	1.75	1.91	1700.0
2019-11-20	AAMI	Stock	9.52	9.59	9.35	9.49	399000.0
2019-11-20	AAOI	Stock	10.14	10.52	10.05	10.28	430500.0
2019-11-20	AAON	Stock	33.68	34.0	32.94	33.0267	291000.0
2019-11-20	AAP	Stock	161.79	161.96	159.72	161.74	724000.0
2019-11-20	AAT	Stock	47.09	47.22	46.5	46.77	268700.0
2019-11-20	AAU-DELISTED	Stock	0.5167	0.52	0.4937	0.4942	139624.0
2019-11-20	AAUAF-DELISTED	Stock	0.5167	0.52	0.4937	0.4942	150658.0
2019-11-20	AAWW-DELISTED	Stock	24.93	25.05	24.2	24.39	239380.0
2019-11-20	AAXJ	Stock	70.26	70.4	69.86	70.03	602973.0
2019-11-20	AAXN-DELISTED	Stock	67.94	72.0	67.45	72.0	1044456.0
2019-11-20	AB	Stock	29.36	29.48	29.07	29.3	130600.0
2019-11-20	ABB-DELISTED	Stock	21.77	21.88	21.684	21.765	988022.0
2019-11-20	ABBNY-DELISTED	Stock	21.77	21.88	21.684	21.77	1049570.0
2019-11-20	ABBV	Stock	88.72	88.72	86.54	87.2	10933000.0
2019-11-20	ABC-DELISTED	Stock	87.44	88.35	86.88	87.52	963937.0
2019-11-20	ABCB	Stock	43.06	43.61	42.9	43.27	330500.0
2019-11-20	ABDC-DELISTED	Stock	8.96	9.02	8.96	9.02	10882.0
2019-11-20	ABEO	Stock	58.0	62.5	58.0	60.75	9136.0
2019-11-20	ABEOW-DELISTED	Stock	0.12	0.12	0.12	0.12	100.0
2019-11-20	ABEV	Stock	4.16	4.26	4.16	4.21	10669600.0
2019-11-20	ABG	Stock	109.53	110.56	107.83	108.4	146600.0
2019-11-20	ABIL-DELISTED	Stock	0.31	0.3662	0.31	0.3403	75480.0
2019-11-20	ABM	Stock	38.48	39.18	38.48	38.61	250700.0
2019-11-20	ABMD-DELISTED	Stock	184.34	192.01	184.34	185.25	815360.0
2019-11-20	ABR	Stock	15.01	15.18	14.95	15.15	1131200.0
2019-11-20	ABR.A-DELISTED	Stock	25.78	25.865	25.78	25.78	1250.0
2019-11-20	ABR.B-DELISTED	Stock	25.56	25.63	25.5499	25.58	5720.0
2019-11-20	ABR.C-DELISTED	Stock	25.88	25.949	25.75	25.77	13480.0
2019-11-20	ABT	Stock	84.34	84.73	83.2	83.89	5416200.0
2019-11-20	ABTC	Stock	149400.0	154470.0	140100.0	142500.0	2.7866666666666666
2019-11-20	ABTS	Stock	36.75	36.75	35.25	36.45	287.0

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

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