PREVIEW / stock_daily / 2019-10-15

all stock daily files

  file:    by_date/stock_daily/2019/2019-10-15.parquet
  size:    220 KB
  rows:    6,585
  symbols: 2,472

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-10-15	AAPL	Stock	59.0975	59.4125	58.72	58.83	87360000.0
2019-10-15	MSFT	Stock	140.06	141.79	139.81	141.57	19695700.0
2019-10-15	NVDA	Stock	4.754	4.9823	4.74	4.9092	664124000.0
2019-10-15	AMZN	Stock	87.107	88.8225	87.031	88.369	62234000.0
2019-10-15	GOOGL	Stock	61.075	62.3562	61.046	62.112	30544320.0
2019-10-15	META	Stock	183.8	190.38	183.66	188.89	15039100.0
2019-10-15	TSLA	Stock	17.18	17.3333	16.9413	17.1927	96492000.0
2019-10-15	TLT	Stock	140.67	140.945	139.55	139.75	12663622.0
2019-10-15	ES	Stock	84.89	85.14	83.79	84.09	1678700.0
2019-10-15	CL	Stock	69.43	69.52	68.23	68.4	4404000.0
2019-10-15	A	Stock	75.8	76.36	75.68	75.75	844900.0
2019-10-15	AA	Stock	19.11	19.813	18.961	19.46	7569500.0
2019-10-15	AAC-DELISTED	Stock	0.4	0.41	0.3599	0.3681	733394.0
2019-10-15	AACG	Stock	1.71	1.92	1.71	1.9	68800.0
2019-10-15	AAIC-DELISTED	Stock	5.5	5.5668	5.45	5.46	235177.0
2019-10-15	AAIC.C-DELISTED	Stock	21.08	21.3	21.05	21.27	22681.0
2019-10-15	AAL	Stock	27.63	28.37	27.28	28.27	7019200.0
2019-10-15	AAM.A-DELISTED	Stock	26.55	26.6207	26.52	26.54	32006.0
2019-10-15	AAM.B-DELISTED	Stock	27.19	27.19	27.0659	27.13	26857.0
2019-10-15	AAMC-DELISTED	Stock	3.6147	3.7588	3.6147	3.7588	2400.0
2019-10-15	AAME	Stock	2.36	2.43	2.31	2.4	6500.0
2019-10-15	AAMI	Stock	9.33	9.63	9.27	9.45	851800.0
2019-10-15	AAOI	Stock	10.56	11.215	10.56	10.96	531800.0
2019-10-15	AAON	Stock	31.3667	31.64	30.6933	31.3667	186300.0
2019-10-15	AAP	Stock	158.74	161.24	157.15	159.73	620300.0
2019-10-15	AAT	Stock	47.22	47.61	47.02	47.6	375300.0
2019-10-15	AAU-DELISTED	Stock	0.7	0.7	0.661	0.661	200697.0
2019-10-15	AAUAF-DELISTED	Stock	0.7	0.7	0.661	0.661	211155.0
2019-10-15	AAWW-DELISTED	Stock	21.62	22.34	21.48	22.33	1025831.0
2019-10-15	AAXJ	Stock	67.77	68.3	67.77	68.2	2018408.0
2019-10-15	AAXN-DELISTED	Stock	52.84	53.64	52.44	53.33	307702.0
2019-10-15	AB	Stock	28.08	28.26	27.86	28.02	264600.0
2019-10-15	ABB-DELISTED	Stock	18.7	18.89	18.65	18.78	1486539.0
2019-10-15	ABBNY-DELISTED	Stock	18.7	18.89	18.65	18.78	1656145.0
2019-10-15	ABBV	Stock	74.2	74.98	73.8	74.5	6028300.0
2019-10-15	ABC-DELISTED	Stock	82.21	83.61	81.86	83.18	588990.0
2019-10-15	ABCB	Stock	40.17	41.27	39.92	41.07	333900.0
2019-10-15	ABDC-DELISTED	Stock	8.8	8.91	8.7956	8.91	11360.0
2019-10-15	ABEO	Stock	55.5	71.0	55.25	67.75	78776.0
2019-10-15	ABEOW-DELISTED	Stock	0.2	0.22	0.19	0.19	4001.0
2019-10-15	ABEV	Stock	4.55	4.59	4.52	4.52	10583700.0
2019-10-15	ABG	Stock	98.87	99.84	97.95	99.5	386600.0
2019-10-15	ABIL-DELISTED	Stock	0.45	0.54	0.45	0.49	134184.0
2019-10-15	ABM	Stock	36.97	37.15	36.43	36.69	317300.0
2019-10-15	ABMD-DELISTED	Stock	177.14	179.7	175.64	177.86	393220.0
2019-10-15	ABR	Stock	13.25	13.3	13.21	13.23	1467200.0
2019-10-15	ABR.C-DELISTED	Stock	26.4	26.4	26.4	26.4	600.0
2019-10-15	ABT	Stock	80.7	82.75	80.7	81.98	6429100.0
2019-10-15	ABTC	Stock	163200.0	176700.0	163200.0	172200.0	1.0933333333333333
2019-10-15	ABTS	Stock	27.9	27.9	26.07	26.25	26.7

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

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