PREVIEW / stock_daily / 2019-10-23

all stock daily files

  file:    by_date/stock_daily/2019/2019-10-23.parquet
  size:    220 KB
  rows:    6,573
  symbols: 2,466

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-23	AAPL	Stock	60.525	60.81	60.305	60.795	75828800.0
2019-10-23	MSFT	Stock	136.88	137.45	135.61	137.24	29844600.0
2019-10-23	NVDA	Stock	4.8078	4.8915	4.7758	4.8772	279916000.0
2019-10-23	AMZN	Stock	88.065	88.5025	87.1	88.1085	42764000.0
2019-10-23	GOOGL	Stock	62.0105	62.902	62.0105	62.8815	23525620.0
2019-10-23	META	Stock	182.01	186.38	182.0	186.15	12300400.0
2019-10-23	TSLA	Stock	16.9667	17.076	16.7567	16.9787	78916500.0
2019-10-23	TLT	Stock	140.03	140.3138	139.36	139.48	5999896.0
2019-10-23	ES	Stock	86.05	86.24	85.51	86.06	1245400.0
2019-10-23	CL	Stock	66.82	67.7	66.8	67.54	4092600.0
2019-10-23	A	Stock	75.02	75.89	74.68	74.98	1778300.0
2019-10-23	AA	Stock	20.81	21.39	20.81	21.28	3167000.0
2019-10-23	AAC-DELISTED	Stock	0.433	0.68	0.43	0.606	713194.0
2019-10-23	AACG	Stock	1.76	1.86	1.76	1.83	6500.0
2019-10-23	AAIC-DELISTED	Stock	5.88	5.89	5.785	5.86	246907.0
2019-10-23	AAIC.C-DELISTED	Stock	21.21	21.21	21.21	21.21	171.0
2019-10-23	AAL	Stock	28.25	28.4	27.88	28.29	8396900.0
2019-10-23	AAM.A-DELISTED	Stock	26.65	26.83	26.6479	26.76	12783.0
2019-10-23	AAM.B-DELISTED	Stock	27.2	27.29	27.13	27.29	9828.0
2019-10-23	AAMC-DELISTED	Stock	4.2682	4.415	4.2682	4.415	4247.0
2019-10-23	AAME	Stock	2.35	2.35	2.18	2.29	4000.0
2019-10-23	AAMI	Stock	9.42	9.59	9.39	9.48	258800.0
2019-10-23	AAOI	Stock	10.29	10.32	9.86	10.14	487800.0
2019-10-23	AAON	Stock	31.6867	31.8467	31.2333	31.38	183300.0
2019-10-23	AAP	Stock	165.25	166.68	163.26	165.12	701000.0
2019-10-23	AAT	Stock	47.66	47.8	47.22	47.8	234500.0
2019-10-23	AAU-DELISTED	Stock	0.65	0.6695	0.65	0.65	77600.0
2019-10-23	AAUAF-DELISTED	Stock	0.65	0.6695	0.65	0.65	79615.0
2019-10-23	AAWW-DELISTED	Stock	23.88	24.38	23.36	24.28	413555.0
2019-10-23	AAXJ	Stock	68.29	68.58	68.26	68.58	375338.0
2019-10-23	AAXN-DELISTED	Stock	53.4	54.21	53.2	53.7	456836.0
2019-10-23	AB	Stock	27.84	28.34	27.83	28.16	449400.0
2019-10-23	ABB-DELISTED	Stock	20.15	20.68	20.03	20.47	4449508.0
2019-10-23	ABBNY-DELISTED	Stock	20.15	20.68	20.03	20.47	4633187.0
2019-10-23	ABBV	Stock	77.79	78.02	77.19	77.75	6136700.0
2019-10-23	ABC-DELISTED	Stock	85.73	86.03	84.81	85.64	586361.0
2019-10-23	ABCB	Stock	42.77	42.96	42.14	42.95	460400.0
2019-10-23	ABDC-DELISTED	Stock	8.88	8.94	8.87	8.92	13700.0
2019-10-23	ABEO	Stock	59.75	62.5	57.5	59.75	10968.0
2019-10-23	ABEOW-DELISTED	Stock	0.2	0.2	0.179	0.179	600.0
2019-10-23	ABEV	Stock	4.56	4.64	4.56	4.62	11034600.0
2019-10-23	ABG	Stock	97.44	99.95	96.57	99.34	225800.0
2019-10-23	ABIL-DELISTED	Stock	0.5042	0.52	0.4401	0.4913	31188.0
2019-10-23	ABM	Stock	37.97	38.11	37.21	37.37	243400.0
2019-10-23	ABMD-DELISTED	Stock	171.74	184.17	170.62	178.9	573782.0
2019-10-23	ABR	Stock	13.42	13.5	13.33	13.4	857600.0
2019-10-23	ABR.A-DELISTED	Stock	26.22	26.22	26.07	26.1621	1300.0
2019-10-23	ABR.B-DELISTED	Stock	26.1113	26.1113	25.887	25.927	8270.0
2019-10-23	ABT	Stock	80.69	81.6	80.41	81.27	4308300.0
2019-10-23	ABTC	Stock	167400.0	174000.0	167400.0	169800.0	0.6666666666666666

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

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