PREVIEW / stock_daily / 2019-10-21

all stock daily files

  file:    by_date/stock_daily/2019/2019-10-21.parquet
  size:    220 KB
  rows:    6,581
  symbols: 2,457

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-21	AAPL	Stock	59.38	60.2475	59.33	60.1275	87247200.0
2019-10-21	MSFT	Stock	138.45	138.5	137.01	138.43	20078200.0
2019-10-21	NVDA	Stock	4.824	4.9138	4.805	4.9002	261868000.0
2019-10-21	AMZN	Stock	88.483	89.294	88.25	89.283	42608000.0
2019-10-21	GOOGL	Stock	62.435	62.6755	61.9995	62.214	20601700.0
2019-10-21	META	Stock	187.04	189.91	186.75	189.76	8122600.0
2019-10-21	TSLA	Stock	17.222	17.3	16.6787	16.9	75304500.0
2019-10-21	TLT	Stock	138.57	138.99	138.225	138.53	8189288.0
2019-10-21	ES	Stock	85.65	86.19	85.32	86.14	1569700.0
2019-10-21	CL	Stock	68.0	68.38	67.85	68.3	2520300.0
2019-10-21	A	Stock	74.88	75.51	74.69	75.48	1641500.0
2019-10-21	AA	Stock	21.57	21.66	20.45	20.47	6187000.0
2019-10-21	AAC-DELISTED	Stock	0.3988	0.405	0.3715	0.3899	133024.0
2019-10-21	AACG	Stock	1.75	1.89	1.75	1.82	15700.0
2019-10-21	AAIC-DELISTED	Stock	5.68	5.73	5.645	5.71	403132.0
2019-10-21	AAIC.C-DELISTED	Stock	21.15	21.39	21.15	21.2456	9980.0
2019-10-21	AAL	Stock	28.51	28.91	28.43	28.62	6746400.0
2019-10-21	AAM.A-DELISTED	Stock	26.62	26.634	26.53	26.5793	12360.0
2019-10-21	AAM.B-DELISTED	Stock	26.97	27.0862	26.925	26.93	17798.0
2019-10-21	AAMC-DELISTED	Stock	4.7559	4.9797	4.3434	4.5588	108283.0
2019-10-21	AAME	Stock	2.36	2.45	2.29	2.44	5000.0
2019-10-21	AAMI	Stock	9.71	9.84	9.623	9.71	523300.0
2019-10-21	AAOI	Stock	10.98	11.25	10.73	10.84	418400.0
2019-10-21	AAON	Stock	31.6933	32.4067	31.5067	32.0	205050.0
2019-10-21	AAP	Stock	164.53	166.35	163.99	166.03	663300.0
2019-10-21	AAT	Stock	47.25	47.78	47.13	47.69	244300.0
2019-10-21	AAU-DELISTED	Stock	0.67	0.67	0.6575	0.66	55444.0
2019-10-21	AAUAF-DELISTED	Stock	0.67	0.67	0.6574	0.66	56843.0
2019-10-21	AAWW-DELISTED	Stock	22.97	23.87	22.45	22.56	860860.0
2019-10-21	AAXJ	Stock	68.51	68.79	68.45	68.79	528556.0
2019-10-21	AAXN-DELISTED	Stock	51.19	52.47	50.57	52.31	428867.0
2019-10-21	AB	Stock	28.22	28.52	28.08	28.33	281800.0
2019-10-21	ABB-DELISTED	Stock	19.54	19.63	19.5	19.57	1911532.0
2019-10-21	ABBNY-DELISTED	Stock	19.54	19.63	19.5	19.57	2053481.0
2019-10-21	ABBV	Stock	76.88	77.85	75.85	77.3	7839100.0
2019-10-21	ABC-DELISTED	Stock	88.2	89.0	84.37	86.65	1894820.0
2019-10-21	ABCB	Stock	41.25	42.38	41.08	41.85	577300.0
2019-10-21	ABDC-DELISTED	Stock	8.92	8.9278	8.86	8.8947	10832.0
2019-10-21	ABEO	Stock	54.0	57.5	53.0	56.5	15412.0
2019-10-21	ABEV	Stock	4.51	4.59	4.5	4.58	12700500.0
2019-10-21	ABG	Stock	104.34	106.37	104.34	105.98	212200.0
2019-10-21	ABIL-DELISTED	Stock	0.506	0.529	0.48	0.5031	37717.0
2019-10-21	ABM	Stock	37.92	38.16	37.48	37.68	221100.0
2019-10-21	ABMD-DELISTED	Stock	177.03	177.91	175.3	176.02	449948.0
2019-10-21	ABR	Stock	13.46	13.66	13.44	13.64	1482300.0
2019-10-21	ABR.A-DELISTED	Stock	26.32	26.37	26.0401	26.15	1400.0
2019-10-21	ABR.B-DELISTED	Stock	26.0757	26.0757	26.0757	26.0757	132.0
2019-10-21	ABR.C-DELISTED	Stock	26.208	26.32	26.208	26.303	4155.0
2019-10-21	ABT	Stock	83.14	83.28	81.52	81.65	5487900.0
2019-10-21	ABTC	Stock	171000.0	172770.0	160800.0	163200.0	0.8133333333333332

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

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