PREVIEW / stock_daily / 2019-08-28

all stock daily files

  file:    by_date/stock_daily/2019/2019-08-28.parquet
  size:    219 KB
  rows:    6,572
  symbols: 2,516

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-28	AAPL	Stock	51.025	51.43	50.83	51.3825	63755200.0
2019-08-28	MSFT	Stock	134.88	135.76	133.55	135.56	17393300.0
2019-08-28	NVDA	Stock	4.0145	4.0835	3.975	4.0305	255612000.0
2019-08-28	AMZN	Stock	87.75	88.393	87.2025	88.2125	48394000.0
2019-08-28	GOOGL	Stock	58.2435	58.925	58.0125	58.6875	16816580.0
2019-08-28	META	Stock	180.53	181.95	178.92	181.76	9386100.0
2019-08-28	TSLA	Stock	14.246	14.4833	14.154	14.3727	48382500.0
2019-08-28	TLT	Stock	148.78	148.9	147.66	147.8	10097776.0
2019-08-28	ES	Stock	80.85	81.13	79.71	80.29	1300700.0
2019-08-28	CL	Stock	73.5	74.07	73.32	74.0	2050600.0
2019-08-28	A	Stock	69.26	70.26	68.81	69.94	1674000.0
2019-08-28	AA	Stock	16.58	17.28	16.46	17.01	2915700.0
2019-08-28	AABA-DELISTED	Stock	69.58	69.59	69.3	69.51	5433792.0
2019-08-28	AAC-DELISTED	Stock	0.5899	0.6	0.53	0.5796	290923.0
2019-08-28	AACG	Stock	1.84	1.91	1.76	1.86	31100.0
2019-08-28	AAIC-DELISTED	Stock	5.14	5.24	5.055	5.07	358706.0
2019-08-28	AAIC.C-DELISTED	Stock	22.2	22.28	22.0	22.02	4555.0
2019-08-28	AAL	Stock	24.41	25.51	24.23	25.33	9079100.0
2019-08-28	AAM.A-DELISTED	Stock	26.63	26.8623	26.62	26.74	16854.0
2019-08-28	AAM.B-DELISTED	Stock	26.8016	27.04	26.8016	27.04	11779.0
2019-08-28	AAMC-DELISTED	Stock	3.0912	3.0971	3.0912	3.0971	2948.0
2019-08-28	AAME	Stock	2.77	2.78	2.57	2.57	1700.0
2019-08-28	AAMI	Stock	8.74	9.045	8.62	8.85	380200.0
2019-08-28	AAOI	Stock	8.49	8.735	8.34	8.67	497300.0
2019-08-28	AAON	Stock	30.3733	31.4267	30.3733	31.18	89100.0
2019-08-28	AAP	Stock	134.3	137.56	133.3	136.76	1800700.0
2019-08-28	AAT	Stock	46.18	46.59	46.06	46.4	193100.0
2019-08-28	AAU-DELISTED	Stock	0.76	0.78	0.76	0.7788	209827.0
2019-08-28	AAUAF-DELISTED	Stock	0.76	0.78	0.76	0.7788	218255.0
2019-08-28	AAWW-DELISTED	Stock	24.53	26.035	24.46	25.66	431832.0
2019-08-28	AAXJ	Stock	64.22	64.57	64.08	64.48	1857706.0
2019-08-28	AAXN-DELISTED	Stock	60.71	61.91	59.21	59.94	383408.0
2019-08-28	AB	Stock	28.25	28.6	28.07	28.38	199400.0
2019-08-28	ABB-DELISTED	Stock	18.25	18.52	18.2	18.475	1107187.0
2019-08-28	ABBNY-DELISTED	Stock	18.23	18.52	18.2	18.48	1462021.0
2019-08-28	ABBV	Stock	65.57	66.38	65.4	66.07	6872800.0
2019-08-28	ABC-DELISTED	Stock	81.03	82.03	80.41	81.0	1510190.0
2019-08-28	ABCB	Stock	34.09	35.04	34.09	34.76	247500.0
2019-08-28	ABDC-DELISTED	Stock	8.75	8.96	8.73	8.96	60236.0
2019-08-28	ABEO	Stock	43.25	45.75	42.75	44.75	14976.0
2019-08-28	ABEV	Stock	4.35	4.4	4.31	4.39	22231900.0
2019-08-28	ABG	Stock	89.9	93.17	89.9	92.63	135500.0
2019-08-28	ABIL-DELISTED	Stock	0.6211	0.65	0.5726	0.6101	25801.0
2019-08-28	ABM	Stock	36.44	36.79	35.98	36.58	304800.0
2019-08-28	ABMD-DELISTED	Stock	189.88	194.22	189.3092	191.03	157987.0
2019-08-28	ABR	Stock	12.43	12.53	12.38	12.49	649800.0
2019-08-28	ABR.A-DELISTED	Stock	25.8978	25.8978	25.8978	25.8978	125.0
2019-08-28	ABR.B-DELISTED	Stock	25.74	25.87	25.551	25.8699	4642.0
2019-08-28	ABR.C-DELISTED	Stock	26.2	26.33	25.98	26.1208	2910.0
2019-08-28	ABT	Stock	83.2	84.26	83.06	84.22	3889500.0

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

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