PREVIEW / stock_daily / 2019-09-26

all stock daily files

  file:    by_date/stock_daily/2019/2019-09-26.parquet
  size:    220 KB
  rows:    6,558
  symbols: 2,474

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-09-26	AAPL	Stock	55.0	55.235	54.7075	54.9725	75334000.0
2019-09-26	MSFT	Stock	139.44	140.18	138.44	139.54	17456600.0
2019-09-26	NVDA	Stock	4.446	4.4548	4.3822	4.4335	234564000.0
2019-09-26	AMZN	Stock	88.1395	88.1685	86.575	86.992	70736000.0
2019-09-26	GOOGL	Stock	62.107	62.2335	61.591	62.1145	23431540.0
2019-09-26	META	Stock	181.33	181.4	177.67	180.11	16083300.0
2019-09-26	TSLA	Stock	15.3773	16.2207	15.16	16.1707	178267500.0
2019-09-26	TLT	Stock	142.27	142.99	141.895	142.38	10775214.0
2019-09-26	ES	Stock	84.87	85.51	84.66	85.26	1344800.0
2019-09-26	CL	Stock	72.3	73.08	72.2	72.72	2265200.0
2019-09-26	A	Stock	76.45	76.96	76.09	76.52	1313300.0
2019-09-26	AA	Stock	21.19	21.23	20.59	20.99	2260200.0
2019-09-26	AABA-DELISTED	Stock	19.52	19.72	19.52	19.7	20068218.0
2019-09-26	AAC-DELISTED	Stock	0.7011	0.7472	0.7	0.728	27161.0
2019-09-26	AACG	Stock	1.7	1.74	1.68	1.73	8900.0
2019-09-26	AAIC-DELISTED	Stock	5.78	5.795	5.68	5.76	593405.0
2019-09-26	AAIC.C-DELISTED	Stock	21.35	21.37	21.29	21.29	1150.0
2019-09-26	AAL	Stock	27.57	27.6	26.91	27.19	4831300.0
2019-09-26	AAM.A-DELISTED	Stock	26.5	26.5	26.3501	26.46	9402.0
2019-09-26	AAM.B-DELISTED	Stock	26.78	26.84	26.62	26.84	39030.0
2019-09-26	AAMC-DELISTED	Stock	3.0529	3.3147	3.0511	3.0882	41150.0
2019-09-26	AAME	Stock	2.77	2.77	2.77	2.77	100.0
2019-09-26	AAMI	Stock	10.05	10.115	9.96	9.98	372600.0
2019-09-26	AAOI	Stock	11.72	11.85	11.11	11.195	443000.0
2019-09-26	AAON	Stock	32.0867	32.0867	30.54	30.58	244650.0
2019-09-26	AAP	Stock	162.07	162.07	158.5	160.38	727500.0
2019-09-26	AAT	Stock	46.55	46.87	46.42	46.8	219600.0
2019-09-26	AAU-DELISTED	Stock	0.71	0.7317	0.6833	0.6851	136508.0
2019-09-26	AAUAF-DELISTED	Stock	0.71	0.7317	0.6833	0.6851	141396.0
2019-09-26	AAWW-DELISTED	Stock	24.75	24.85	23.94	24.61	291146.0
2019-09-26	AAXJ	Stock	66.9	66.93	66.62	66.83	903155.0
2019-09-26	AAXN-DELISTED	Stock	60.44	60.555	58.2401	59.02	547355.0
2019-09-26	AB	Stock	29.14	29.53	28.9	29.48	155100.0
2019-09-26	ABB-DELISTED	Stock	19.46	19.51	19.4	19.46	921891.0
2019-09-26	ABBNY-DELISTED	Stock	19.46	19.51	19.4	19.44	979034.0
2019-09-26	ABBV	Stock	72.95	74.46	72.62	74.03	10324100.0
2019-09-26	ABC-DELISTED	Stock	83.43	83.87	80.86	82.04	705860.0
2019-09-26	ABCB	Stock	39.67	40.03	39.44	39.51	315900.0
2019-09-26	ABDC-DELISTED	Stock	8.83	8.8943	8.81	8.81	23397.0
2019-09-26	ABEO	Stock	64.5	65.0	58.25	58.5	14848.0
2019-09-26	ABEOW-DELISTED	Stock	0.3867	0.3867	0.3867	0.3867	200.0
2019-09-26	ABEV	Stock	4.74	4.76	4.67	4.68	20299000.0
2019-09-26	ABG	Stock	101.63	101.63	99.09	100.36	75900.0
2019-09-26	ABIL-DELISTED	Stock	0.588	0.6188	0.5301	0.58	10227.0
2019-09-26	ABM	Stock	36.4	36.82	36.34	36.73	251800.0
2019-09-26	ABMD-DELISTED	Stock	185.51	185.51	175.74	177.71	476906.0
2019-09-26	ABR	Stock	13.12	13.18	13.1	13.12	711800.0
2019-09-26	ABR.A-DELISTED	Stock	26.1696	26.295	25.92	26.17	6293.0
2019-09-26	ABR.C-DELISTED	Stock	26.47	26.47	26.45	26.45	580.0
2019-09-26	ABT	Stock	83.28	83.38	82.09	82.66	3265200.0

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

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