PREVIEW / stock_daily / 2020-01-09

all stock daily files

  file:    by_date/stock_daily/2020/2020-01-09.parquet
  size:    223 KB
  rows:    6,619
  symbols: 2,447

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
2020-01-09	AAPL	Stock	76.81	77.6075	76.55	77.4075	170108400.0
2020-01-09	MSFT	Stock	161.84	162.22	161.03	162.09	21385000.0
2020-01-09	NVDA	Stock	6.0963	6.1483	6.0215	6.0755	255112000.0
2020-01-09	AMZN	Stock	95.4945	95.891	94.79	95.0525	63346000.0
2020-01-09	GOOGL	Stock	71.0965	71.434	70.5105	70.9895	33228760.0
2020-01-09	META	Stock	217.54	218.38	216.28	218.3	12642800.0
2020-01-09	TSLA	Stock	33.14	33.2533	31.5247	32.0893	426606000.0
2020-01-09	TLT	Stock	136.0	137.435	135.905	137.22	7412990.0
2020-01-09	ES	Stock	82.55	83.52	82.54	83.4	1372100.0
2020-01-09	CL	Stock	69.38	69.94	69.06	69.86	3996100.0
2020-01-09	A	Stock	86.46	87.7	86.17	87.27	1912700.0
2020-01-09	AA	Stock	20.46	20.52	19.73	19.81	5700700.0
2020-01-09	AACG	Stock	1.57	1.63	1.43	1.45	27300.0
2020-01-09	AAIC-DELISTED	Stock	5.63	5.65	5.58	5.58	307577.0
2020-01-09	AAIC.C-DELISTED	Stock	21.68	21.71	21.65	21.71	3158.0
2020-01-09	AAL	Stock	28.09	28.23	27.71	27.95	6898900.0
2020-01-09	AAM.A-DELISTED	Stock	26.6578	26.75	26.6397	26.747	30926.0
2020-01-09	AAM.B-DELISTED	Stock	27.2	27.33	27.13	27.33	15378.0
2020-01-09	AAMC-DELISTED	Stock	3.7941	3.9941	3.7941	3.9941	2220.0
2020-01-09	AAME	Stock	1.8	2.0	1.8	1.86	1900.0
2020-01-09	AAMI	Stock	9.86	9.91	9.75	9.89	244400.0
2020-01-09	AAOI	Stock	12.89	13.88	12.86	13.06	1633300.0
2020-01-09	AAON	Stock	33.5733	34.0	33.4133	33.9	142500.0
2020-01-09	AAP	Stock	153.78	153.98	150.25	152.87	1177400.0
2020-01-09	AAT	Stock	45.43	45.75	45.26	45.4	231400.0
2020-01-09	AAU-DELISTED	Stock	0.54	0.5473	0.515	0.5265	217785.0
2020-01-09	AAUAF-DELISTED	Stock	0.54	0.5473	0.515	0.53	227002.0
2020-01-09	AAWW-DELISTED	Stock	27.32	27.38	26.6	26.86	123592.0
2020-01-09	AAXJ	Stock	74.71	74.74	74.45	74.58	2997732.0
2020-01-09	AAXN-DELISTED	Stock	70.09	71.0	69.935	70.19	435895.0
2020-01-09	AB	Stock	31.9	31.99	31.58	31.71	327700.0
2020-01-09	ABB-DELISTED	Stock	24.25	24.27	24.14	24.18	1226994.0
2020-01-09	ABBNY-DELISTED	Stock	24.25	24.27	24.14	24.17	1303121.0
2020-01-09	ABBV	Stock	90.01	90.23	89.05	90.21	7518000.0
2020-01-09	ABC-DELISTED	Stock	85.62	86.73	84.82	86.66	623629.0
2020-01-09	ABCB	Stock	42.85	42.94	42.5	42.72	215100.0
2020-01-09	ABDC-DELISTED	Stock	9.19	9.26	9.14	9.15	29201.0
2020-01-09	ABEO	Stock	64.25	71.25	63.25	65.25	83532.0
2020-01-09	ABEV	Stock	4.57	4.58	4.51	4.58	29817800.0
2020-01-09	ABG	Stock	103.74	103.74	100.01	100.6	296300.0
2020-01-09	ABM	Stock	38.55	38.92	38.42	38.72	225100.0
2020-01-09	ABMD-DELISTED	Stock	180.19	183.8	179.25	183.8	767558.0
2020-01-09	ABR	Stock	14.44	14.53	14.41	14.47	1377100.0
2020-01-09	ABR.A-DELISTED	Stock	26.4	26.5	26.4	26.4972	2783.0
2020-01-09	ABR.B-DELISTED	Stock	26.0838	26.0838	26.0838	26.0838	100.0
2020-01-09	ABR.C-DELISTED	Stock	26.6218	26.627	26.6	26.6	1148.0
2020-01-09	ABT	Stock	86.3	86.68	85.75	86.44	6432500.0
2020-01-09	ABTC	Stock	214200.0	225000.0	203400.0	223500.0	4.426666666666667
2020-01-09	ABTS	Stock	32.55	32.55	32.55	32.55	46.7
2020-01-09	ABTX-DELISTED	Stock	37.55	37.68	37.29	37.45	51087.0

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

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