PREVIEW / stock_daily / 2019-08-29

all stock daily files

  file:    by_date/stock_daily/2019/2019-08-29.parquet
  size:    219 KB
  rows:    6,591
  symbols: 2,538

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-08-29	AAPL	Stock	52.125	52.33	51.665	52.2525	83962000.0
2019-08-29	MSFT	Stock	137.25	138.44	136.91	138.12	20168700.0
2019-08-29	NVDA	Stock	4.1225	4.2075	4.119	4.175	357976000.0
2019-08-29	AMZN	Stock	89.15	89.9275	88.8625	89.32	60302000.0
2019-08-29	GOOGL	Stock	59.321	59.9595	59.264	59.712	19641960.0
2019-08-29	META	Stock	183.77	186.08	183.47	185.57	10128700.0
2019-08-29	TSLA	Stock	14.6	14.8933	14.5333	14.7807	77692500.0
2019-08-29	TLT	Stock	147.25	147.34	146.13	147.24	8884955.0
2019-08-29	ES	Stock	80.51	80.82	79.54	80.41	1243200.0
2019-08-29	CL	Stock	74.47	74.55	73.38	74.2	1819700.0
2019-08-29	A	Stock	70.81	71.29	70.48	70.7	1611200.0
2019-08-29	AA	Stock	17.32	17.98	17.263	17.8	3069400.0
2019-08-29	AABA-DELISTED	Stock	69.65	69.65	69.47	69.5	3965512.0
2019-08-29	AAC-DELISTED	Stock	0.61	0.7799	0.61	0.65	682950.0
2019-08-29	AACG	Stock	1.85	1.94	1.84	1.9	20200.0
2019-08-29	AAIC-DELISTED	Stock	5.07	5.11	4.96	4.96	424891.0
2019-08-29	AAIC.C-DELISTED	Stock	22.083	22.15	22.083	22.15	3064.0
2019-08-29	AAL	Stock	25.79	26.61	25.7	26.32	7205600.0
2019-08-29	AAM.A-DELISTED	Stock	26.4	26.4062	26.28	26.28	29037.0
2019-08-29	AAM.B-DELISTED	Stock	26.64	26.6436	26.46	26.55	14587.0
2019-08-29	AAMC-DELISTED	Stock	3.1029	3.1029	2.9412	3.0735	2938.0
2019-08-29	AAME	Stock	2.56	2.84	2.56	2.72	5400.0
2019-08-29	AAMI	Stock	8.97	9.15	8.94	9.06	570700.0
2019-08-29	AAOI	Stock	8.71	9.11	8.71	8.92	394200.0
2019-08-29	AAON	Stock	31.4867	31.9067	31.1933	31.6867	128700.0
2019-08-29	AAP	Stock	138.04	140.74	137.78	138.07	1203800.0
2019-08-29	AAT	Stock	46.64	47.0	46.42	46.78	156900.0
2019-08-29	AAU-DELISTED	Stock	0.78	0.7804	0.705	0.71	437204.0
2019-08-29	AAUAF-DELISTED	Stock	0.78	0.7804	0.705	0.71	449615.0
2019-08-29	AAWW-DELISTED	Stock	25.8	26.89	25.8	25.98	237463.0
2019-08-29	AAXJ	Stock	64.9	65.22	64.75	65.09	1779858.0
2019-08-29	AAXN-DELISTED	Stock	61.15	62.06	60.935	61.33	312550.0
2019-08-29	AB	Stock	28.54	28.71	28.43	28.59	113300.0
2019-08-29	ABB-DELISTED	Stock	18.75	18.865	18.72	18.82	1322034.0
2019-08-29	ABBNY-DELISTED	Stock	18.75	18.865	18.72	18.82	1868022.0
2019-08-29	ABBV	Stock	66.73	67.03	65.96	66.22	6011900.0
2019-08-29	ABC-DELISTED	Stock	81.83	82.77	81.13	81.91	863529.0
2019-08-29	ABCB	Stock	35.07	35.57	34.84	35.39	199700.0
2019-08-29	ABDC-DELISTED	Stock	8.95	9.0	8.8828	8.96	47402.0
2019-08-29	ABEO	Stock	45.25	46.5	43.75	45.5	6072.0
2019-08-29	ABEV	Stock	4.39	4.48	4.38	4.48	23878300.0
2019-08-29	ABG	Stock	93.63	94.5	93.1	93.34	109400.0
2019-08-29	ABIL-DELISTED	Stock	0.5936	0.6332	0.5743	0.61	23956.0
2019-08-29	ABM	Stock	37.09	37.4	36.77	37.15	381800.0
2019-08-29	ABMD-DELISTED	Stock	192.0	194.37	190.0	192.08	280728.0
2019-08-29	ABR	Stock	12.5	12.58	12.42	12.55	614400.0
2019-08-29	ABR.A-DELISTED	Stock	25.97	25.97	25.928	25.9477	2515.0
2019-08-29	ABR.B-DELISTED	Stock	25.7164	25.76	25.7164	25.76	230.0
2019-08-29	ABR.C-DELISTED	Stock	26.07	26.3737	25.87	26.31	2733.0
2019-08-29	ABT	Stock	85.0	85.11	84.47	84.82	3758600.0

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

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