PREVIEW / stock_daily / 2020-01-08

all stock daily files

  file:    by_date/stock_daily/2020/2020-01-08.parquet
  size:    222 KB
  rows:    6,603
  symbols: 2,433

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-08	AAPL	Stock	74.29	76.11	74.29	75.7975	132079200.0
2020-01-08	MSFT	Stock	158.93	160.8	157.95	160.09	27746500.0
2020-01-08	NVDA	Stock	5.994	6.051	5.9538	6.0095	277108000.0
2020-01-08	AMZN	Stock	94.902	95.55	94.322	94.5985	70160000.0
2020-01-08	GOOGL	Stock	69.741	70.5925	69.6315	70.252	35325480.0
2020-01-08	META	Stock	213.0	216.24	212.61	215.22	13475000.0
2020-01-08	TSLA	Stock	31.58	33.2327	31.2153	32.8093	467164500.0
2020-01-08	TLT	Stock	137.93	138.31	136.32	136.74	10626391.0
2020-01-08	ES	Stock	82.61	83.17	82.34	82.75	1548900.0
2020-01-08	CL	Stock	67.8	69.65	67.73	69.27	4676100.0
2020-01-08	A	Stock	85.96	86.47	85.2	85.92	1847600.0
2020-01-08	AA	Stock	21.3	21.39	20.4	20.46	3706300.0
2020-01-08	AACG	Stock	1.41	1.58	1.36	1.51	90900.0
2020-01-08	AAIC-DELISTED	Stock	5.65	5.695	5.62	5.64	258408.0
2020-01-08	AAIC.C-DELISTED	Stock	21.633	21.67	21.6061	21.628	2509.0
2020-01-08	AAL	Stock	27.1	28.09	27.07	27.84	10496800.0
2020-01-08	AAM.A-DELISTED	Stock	26.78	26.78	26.73	26.74	26136.0
2020-01-08	AAM.B-DELISTED	Stock	27.22	27.39	27.22	27.35	14091.0
2020-01-08	AAMC-DELISTED	Stock	3.9781	4.0244	3.7735	4.0244	9112.0
2020-01-08	AAME	Stock	1.95	2.0	1.85	1.9	5700.0
2020-01-08	AAMI	Stock	9.67	9.86	9.64	9.78	406300.0
2020-01-08	AAOI	Stock	12.41	12.82	12.37	12.7	520600.0
2020-01-08	AAON	Stock	33.4333	33.8	33.3067	33.34	185100.0
2020-01-08	AAP	Stock	154.85	156.05	153.14	153.16	825700.0
2020-01-08	AAT	Stock	45.32	45.63	45.22	45.48	213000.0
2020-01-08	AAU-DELISTED	Stock	0.57	0.59	0.54	0.5418	300249.0
2020-01-08	AAUAF-DELISTED	Stock	0.57	0.59	0.54	0.54	331025.0
2020-01-08	AAWW-DELISTED	Stock	26.44	27.34	26.44	27.18	178945.0
2020-01-08	AAXJ	Stock	73.44	74.27	73.38	73.84	1311292.0
2020-01-08	AAXN-DELISTED	Stock	69.95	71.625	69.51	69.59	762790.0
2020-01-08	AB	Stock	31.15	32.04	31.0	31.76	616700.0
2020-01-08	ABB-DELISTED	Stock	24.22	24.45	24.22	24.36	1287569.0
2020-01-08	ABBNY-DELISTED	Stock	24.22	24.45	24.22	24.34	1384735.0
2020-01-08	ABBV	Stock	89.15	90.06	88.87	89.52	7696800.0
2020-01-08	ABC-DELISTED	Stock	84.56	85.815	84.53	85.45	984319.0
2020-01-08	ABCB	Stock	42.11	42.83	42.11	42.65	306300.0
2020-01-08	ABDC-DELISTED	Stock	9.1	9.2	9.1	9.18	11783.0
2020-01-08	ABEO	Stock	63.5	68.0	62.5	65.5	72984.0
2020-01-08	ABEV	Stock	4.63	4.69	4.59	4.64	18280200.0
2020-01-08	ABG	Stock	104.17	105.56	102.87	103.13	158200.0
2020-01-08	ABM	Stock	37.87	38.67	37.85	38.4	326700.0
2020-01-08	ABMD-DELISTED	Stock	178.38	180.73	174.29	178.72	871812.0
2020-01-08	ABR	Stock	14.23	14.55	14.22	14.41	1434000.0
2020-01-08	ABR.B-DELISTED	Stock	25.88	26.0384	25.88	26.0311	600.0
2020-01-08	ABR.C-DELISTED	Stock	26.55	26.55	26.5	26.5	1100.0
2020-01-08	ABT	Stock	86.24	86.66	85.93	86.21	5693900.0
2020-01-08	ABTC	Stock	228000.0	233370.0	211200.0	214500.0	5.7733333333333325
2020-01-08	ABTX-DELISTED	Stock	37.0	37.59	37.0	37.58	71967.0
2020-01-08	ABUS	Stock	3.02	3.22	3.01	3.07	264500.0
2020-01-08	ACA	Stock	45.02	45.74	44.99	45.61	461220.0

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

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