PREVIEW / stock_daily / 2019-08-26

all stock daily files

  file:    by_date/stock_daily/2019/2019-08-26.parquet
  size:    219 KB
  rows:    6,553
  symbols: 2,504

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-26	AAPL	Stock	51.465	51.7975	51.265	51.6225	104174400.0
2019-08-26	MSFT	Stock	134.99	135.56	133.9	135.45	20312600.0
2019-08-26	NVDA	Stock	4.1403	4.1645	4.0978	4.1362	318208000.0
2019-08-26	AMZN	Stock	88.3455	88.5	87.1755	88.4435	61600000.0
2019-08-26	GOOGL	Stock	57.9725	58.593	57.7422	58.559	21178520.0
2019-08-26	META	Stock	179.4	180.5	178.24	180.36	8773600.0
2019-08-26	TSLA	Stock	14.24	14.3347	14.1027	14.3333	75778500.0
2019-08-26	TLT	Stock	145.87	146.29	145.29	145.37	12174799.0
2019-08-26	ES	Stock	79.27	79.97	79.12	79.94	796400.0
2019-08-26	CL	Stock	72.66	72.94	72.21	72.77	1770300.0
2019-08-26	A	Stock	70.11	70.64	68.79	69.64	1827300.0
2019-08-26	AA	Stock	17.73	17.73	17.09	17.17	3108700.0
2019-08-26	AABA-DELISTED	Stock	69.67	69.72	69.53	69.58	3293687.0
2019-08-26	AAC-DELISTED	Stock	0.5731	0.6	0.55	0.59	127982.0
2019-08-26	AACG	Stock	1.88	1.88	1.68	1.87	59400.0
2019-08-26	AAIC-DELISTED	Stock	5.22	5.27	5.2	5.21	209287.0
2019-08-26	AAIC.C-DELISTED	Stock	22.2	22.45	22.13	22.43	7920.0
2019-08-26	AAL	Stock	25.9	25.91	25.03	25.19	6722600.0
2019-08-26	AAM.A-DELISTED	Stock	26.85	26.85	26.67	26.67	13705.0
2019-08-26	AAM.B-DELISTED	Stock	26.7915	26.9	26.6601	26.84	10058.0
2019-08-26	AAMC-DELISTED	Stock	2.9294	2.9324	2.9118	2.9118	1802.0
2019-08-26	AAME	Stock	2.72	2.73	2.6	2.73	4300.0
2019-08-26	AAMI	Stock	8.99	9.14	8.91	8.95	434800.0
2019-08-26	AAOI	Stock	9.25	9.42	9.05	9.12	489800.0
2019-08-26	AAON	Stock	30.9	31.0067	30.4467	30.9467	145200.0
2019-08-26	AAP	Stock	135.62	135.7	132.89	135.0	901000.0
2019-08-26	AAT	Stock	46.71	46.71	46.05	46.44	257200.0
2019-08-26	AAU-DELISTED	Stock	0.765	0.784	0.7212	0.7234	376183.0
2019-08-26	AAUAF-DELISTED	Stock	0.765	0.784	0.7212	0.7234	392113.0
2019-08-26	AAWW-DELISTED	Stock	25.96	26.47	24.78	24.97	382817.0
2019-08-26	AAXJ	Stock	64.32	64.37	64.04	64.31	1361714.0
2019-08-26	AAXN-DELISTED	Stock	60.09	61.02	59.05	61.02	313104.0
2019-08-26	AB	Stock	27.99	28.27	27.89	28.11	152300.0
2019-08-26	ABB-DELISTED	Stock	18.51	18.538	18.39	18.46	1353155.0
2019-08-26	ABBNY-DELISTED	Stock	18.51	18.538	18.39	18.46	1433824.0
2019-08-26	ABBV	Stock	66.43	66.93	66.08	66.46	4841100.0
2019-08-26	ABC-DELISTED	Stock	84.41	85.92	84.1	85.92	848385.0
2019-08-26	ABCB	Stock	35.33	35.55	34.68	35.31	293500.0
2019-08-26	ABDC-DELISTED	Stock	8.88	8.88	8.82	8.82	93428.0
2019-08-26	ABEO	Stock	47.75	48.5	45.5	47.0	11772.0
2019-08-26	ABEV	Stock	4.43	4.46	4.32	4.37	18155800.0
2019-08-26	ABG	Stock	89.58	91.0	89.24	90.49	141000.0
2019-08-26	ABIL-DELISTED	Stock	0.72	0.72	0.6201	0.66	64474.0
2019-08-26	ABM	Stock	37.34	37.34	36.7	37.23	845100.0
2019-08-26	ABMD-DELISTED	Stock	190.81	193.24	188.05	190.5	244846.0
2019-08-26	ABR	Stock	12.55	12.61	12.48	12.6	618300.0
2019-08-26	ABR.A-DELISTED	Stock	25.88	25.925	25.85	25.87	5414.0
2019-08-26	ABR.C-DELISTED	Stock	26.3052	26.3052	26.25	26.25	1000.0
2019-08-26	ABT	Stock	82.61	83.18	82.02	83.12	3521200.0
2019-08-26	ABTC	Stock	263100.0	269700.0	259500.0	264000.0	0.8

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

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