PREVIEW / stock_daily / 2019-10-10

all stock daily files

  file:    by_date/stock_daily/2019/2019-10-10.parquet
  size:    220 KB
  rows:    6,593
  symbols: 2,486

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-10	AAPL	Stock	56.9825	57.61	56.825	57.5225	113013600.0
2019-10-10	MSFT	Stock	138.49	139.67	138.25	139.1	17654600.0
2019-10-10	NVDA	Stock	4.5155	4.627	4.5102	4.5758	309124000.0
2019-10-10	AMZN	Stock	86.262	86.9145	85.6875	86.013	51504000.0
2019-10-10	GOOGL	Stock	59.93	60.781	59.893	60.4735	13364880.0
2019-10-10	META	Stock	180.32	181.61	179.17	180.03	8605000.0
2019-10-10	TSLA	Stock	16.352	16.6187	16.1053	16.316	94249500.0
2019-10-10	TLT	Stock	143.12	143.18	141.73	142.2	15057081.0
2019-10-10	ES	Stock	85.64	85.96	84.82	85.54	1497000.0
2019-10-10	CL	Stock	69.96	70.88	69.7	70.77	2219600.0
2019-10-10	A	Stock	73.43	74.43	73.43	74.0	1399900.0
2019-10-10	AA	Stock	18.64	18.994	18.42	18.69	3313500.0
2019-10-10	AAC-DELISTED	Stock	0.5	0.525	0.3771	0.399	980511.0
2019-10-10	AACG	Stock	1.64	1.64	1.58	1.61	4100.0
2019-10-10	AAIC-DELISTED	Stock	5.36	5.42	5.34	5.41	271578.0
2019-10-10	AAIC.C-DELISTED	Stock	20.55	20.9	20.55	20.9	3033.0
2019-10-10	AAL	Stock	26.68	27.25	26.5	27.18	7057600.0
2019-10-10	AAM.A-DELISTED	Stock	26.55	26.67	26.55	26.63	7308.0
2019-10-10	AAM.B-DELISTED	Stock	27.11	27.13	27.0	27.13	13441.0
2019-10-10	AAMC-DELISTED	Stock	3.7059	4.0559	3.55	3.55	25180.0
2019-10-10	AAME	Stock	2.5	2.5	2.5	2.5	200.0
2019-10-10	AAMI	Stock	9.13	9.35	9.09	9.27	1198200.0
2019-10-10	AAOI	Stock	10.43	10.43	9.97	10.16	325100.0
2019-10-10	AAON	Stock	30.2333	30.6133	30.16	30.34	203400.0
2019-10-10	AAP	Stock	154.6	156.42	153.82	155.95	731400.0
2019-10-10	AAT	Stock	46.42	46.49	46.13	46.32	246900.0
2019-10-10	AAU-DELISTED	Stock	0.74	0.76	0.72	0.73	147295.0
2019-10-10	AAUAF-DELISTED	Stock	0.74	0.76	0.72	0.7366	155094.0
2019-10-10	AAWW-DELISTED	Stock	21.44	21.5	20.99	21.25	237192.0
2019-10-10	AAXJ	Stock	66.35	66.95	66.35	66.7	806598.0
2019-10-10	AAXN-DELISTED	Stock	52.26	52.76	51.8848	52.53	801797.0
2019-10-10	AB	Stock	28.57	28.83	28.51	28.77	157700.0
2019-10-10	ABB-DELISTED	Stock	18.03	18.24	18.0	18.145	1609591.0
2019-10-10	ABBNY-DELISTED	Stock	18.03	18.24	18.0	18.15	1693271.0
2019-10-10	ABBV	Stock	73.22	74.63	73.2	74.45	7329400.0
2019-10-10	ABC-DELISTED	Stock	80.55	81.57	79.84	80.81	595012.0
2019-10-10	ABCB	Stock	39.19	39.55	39.07	39.41	279200.0
2019-10-10	ABDC-DELISTED	Stock	8.86	8.87	8.8	8.82	19430.0
2019-10-10	ABEO	Stock	55.5	57.0	53.75	55.0	8360.0
2019-10-10	ABEV	Stock	4.54	4.54	4.43	4.47	21839200.0
2019-10-10	ABG	Stock	97.56	100.22	97.19	99.02	136100.0
2019-10-10	ABIL-DELISTED	Stock	0.475	0.4891	0.4548	0.4568	19934.0
2019-10-10	ABM	Stock	34.43	35.03	34.37	35.0	232700.0
2019-10-10	ABMD-DELISTED	Stock	159.12	162.58	155.02	162.34	835400.0
2019-10-10	ABR	Stock	13.14	13.2	13.08	13.18	1798800.0
2019-10-10	ABR.A-DELISTED	Stock	25.96	26.01	25.75	25.85	10738.0
2019-10-10	ABR.B-DELISTED	Stock	26.08	26.222	26.08	26.1	2546.0
2019-10-10	ABR.C-DELISTED	Stock	26.35	26.35	25.75	25.76	6732.0
2019-10-10	ABT	Stock	79.09	80.46	79.07	80.14	5085000.0
2019-10-10	ABTC	Stock	174000.0	175500.0	162000.0	166500.0	2.3066666666666666

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

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