PREVIEW / stock_daily / 2019-07-11

all stock daily files

  file:    by_date/stock_daily/2019/2019-07-11.parquet
  size:    221 KB
  rows:    6,596
  symbols: 2,551

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-07-11	AAPL	Stock	50.8275	51.0975	50.4275	50.4375	80767200.0
2019-07-11	MSFT	Stock	138.2	139.22	137.87	138.4	22327900.0
2019-07-11	NVDA	Stock	4.075	4.198	4.0375	4.157	682560000.0
2019-07-11	AMZN	Stock	101.281	101.79	99.765	100.0535	86356000.0
2019-07-11	GOOGL	Stock	57.308	57.662	56.9765	57.204	26010580.0
2019-07-11	META	Stock	203.26	203.8	200.21	201.23	13678500.0
2019-07-11	TSLA	Stock	15.876	16.1	15.72	15.9067	112716000.0
2019-07-11	TLT	Stock	131.31	131.41	129.76	130.07	14126804.0
2019-07-11	ES	Stock	77.72	78.09	77.28	78.06	1912300.0
2019-07-11	CL	Stock	73.78	73.91	73.18	73.89	2878200.0
2019-07-11	A	Stock	73.77	73.78	71.48	71.74	6562400.0
2019-07-11	AA	Stock	22.31	22.595	21.98	22.5	3323600.0
2019-07-11	AABA-DELISTED	Stock	69.38	69.72	68.9	69.27	2098175.0
2019-07-11	AAC-DELISTED	Stock	1.27	1.34	1.21	1.25	139056.0
2019-07-11	AACG	Stock	2.56	2.68	2.56	2.57	65000.0
2019-07-11	AAIC-DELISTED	Stock	6.39	6.54	6.3899	6.46	450363.0
2019-07-11	AAIC.C-DELISTED	Stock	21.9357	21.9829	21.9	21.91	2636.0
2019-07-11	AAL	Stock	33.06	33.3	32.82	33.03	6842900.0
2019-07-11	AAM.A-DELISTED	Stock	25.86	25.86	25.8	25.8	4808.0
2019-07-11	AAM.B-DELISTED	Stock	25.98	25.98	25.9	25.95	23323.0
2019-07-11	AAMC-DELISTED	Stock	3.5147	3.7294	3.2441	3.4782	120741.0
2019-07-11	AAME	Stock	2.35	2.35	2.29	2.29	900.0
2019-07-11	AAMI	Stock	11.62	11.62	11.4	11.49	344400.0
2019-07-11	AAOI	Stock	10.45	10.45	9.87	9.9	610700.0
2019-07-11	AAON	Stock	33.9867	34.0933	33.12	33.2333	125550.0
2019-07-11	AAP	Stock	155.86	157.52	155.08	156.29	970300.0
2019-07-11	AAT	Stock	48.18	48.2	47.3	47.61	317900.0
2019-07-11	AAU-DELISTED	Stock	0.6779	0.6779	0.6462	0.6462	98992.0
2019-07-11	AAUAF-DELISTED	Stock	0.6779	0.6779	0.6462	0.6462	107695.0
2019-07-11	AAWW-DELISTED	Stock	41.47	41.47	40.31	41.04	94137.0
2019-07-11	AAXJ	Stock	69.51	69.53	69.13	69.29	2085782.0
2019-07-11	AAXN-DELISTED	Stock	63.46	64.1	62.73	62.92	990040.0
2019-07-11	AB	Stock	30.44	30.95	30.4	30.71	238600.0
2019-07-11	ABB-DELISTED	Stock	18.73	18.755	18.57	18.71	1635971.0
2019-07-11	ABBNY-DELISTED	Stock	18.73	18.755	18.57	18.71	1732083.0
2019-07-11	ABBV	Stock	72.3	72.4	69.85	71.24	13001000.0
2019-07-11	ABC-DELISTED	Stock	91.76	94.2	89.79	90.53	1811236.0
2019-07-11	ABCB	Stock	38.81	38.81	38.35	38.6	634800.0
2019-07-11	ABDC-DELISTED	Stock	8.33	8.35	8.29	8.32	17062.0
2019-07-11	ABEO	Stock	108.0	111.0	106.75	108.5	30668.0
2019-07-11	ABEV	Stock	5.08	5.09	4.92	4.95	27402100.0
2019-07-11	ABG	Stock	84.43	84.78	83.71	84.16	97400.0
2019-07-11	ABIL-DELISTED	Stock	0.9199	0.94	0.8962	0.9158	20577.0
2019-07-11	ABM	Stock	40.65	40.9	40.12	40.81	193400.0
2019-07-11	ABMD-DELISTED	Stock	257.96	266.54	256.01	265.92	314515.0
2019-07-11	ABR	Stock	12.4	12.47	12.32	12.34	791500.0
2019-07-11	ABR.A-DELISTED	Stock	25.91	26.04	25.9	26.0295	3280.0
2019-07-11	ABR.B-DELISTED	Stock	25.9	26.02	25.85	25.9276	2624.0
2019-07-11	ABR.C-DELISTED	Stock	26.1933	26.1933	26.087	26.118	542.0
2019-07-11	ABT	Stock	85.65	85.99	85.19	85.77	3653600.0

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

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