PREVIEW / stock_daily / 2020-01-06

all stock daily files

  file:    by_date/stock_daily/2020/2020-01-06.parquet
  size:    222 KB
  rows:    6,610
  symbols: 2,435

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-06	AAPL	Stock	73.4475	74.99	73.1875	74.95	118387200.0
2020-01-06	MSFT	Stock	157.08	159.1	156.51	159.03	20813700.0
2020-01-06	NVDA	Stock	5.808	5.9318	5.7818	5.9265	262636000.0
2020-01-06	AMZN	Stock	93.0	95.1845	93.0	95.144	81236000.0
2020-01-06	GOOGL	Stock	67.5815	69.916	67.55	69.8905	46786860.0
2020-01-06	META	Stock	206.7	212.78	206.52	212.6	17058900.0
2020-01-06	TSLA	Stock	29.3647	30.104	29.3333	30.1027	151995000.0
2020-01-06	TLT	Stock	139.69	139.71	138.15	138.33	11370199.0
2020-01-06	ES	Stock	83.05	83.75	83.0	83.31	2717500.0
2020-01-06	CL	Stock	68.08	68.85	68.01	68.49	4607500.0
2020-01-06	A	Stock	84.0	84.82	83.6	84.82	1993200.0
2020-01-06	AA	Stock	21.34	21.45	20.9	21.0	3060400.0
2020-01-06	AACG	Stock	1.51	1.51	1.36	1.43	18700.0
2020-01-06	AAIC-DELISTED	Stock	5.5	5.63	5.5	5.62	397207.0
2020-01-06	AAIC.C-DELISTED	Stock	21.72	21.72	21.64	21.65	4028.0
2020-01-06	AAL	Stock	27.19	27.49	27.08	27.32	6105800.0
2020-01-06	AAM.A-DELISTED	Stock	26.6794	26.84	26.6794	26.77	13522.0
2020-01-06	AAM.B-DELISTED	Stock	27.2	27.39	27.2	27.27	18296.0
2020-01-06	AAMC-DELISTED	Stock	3.9971	4.1324	3.9971	4.0176	18506.0
2020-01-06	AAME	Stock	2.0	2.0	1.86	1.86	2000.0
2020-01-06	AAMI	Stock	9.43	9.59	9.28	9.47	337300.0
2020-01-06	AAOI	Stock	12.0	12.2	11.86	12.15	361600.0
2020-01-06	AAON	Stock	33.2	33.5667	32.9067	33.5067	137700.0
2020-01-06	AAP	Stock	157.74	158.89	156.43	156.8	880200.0
2020-01-06	AAT	Stock	45.81	46.59	45.59	46.22	300300.0
2020-01-06	AAU-DELISTED	Stock	0.61	0.61	0.5512	0.5632	201709.0
2020-01-06	AAUAF-DELISTED	Stock	0.61	0.61	0.5512	0.5632	219066.0
2020-01-06	AAWW-DELISTED	Stock	27.07	27.57	26.825	27.44	187778.0
2020-01-06	AAXJ	Stock	73.14	73.48	73.06	73.42	413689.0
2020-01-06	AAXN-DELISTED	Stock	74.12	74.49	68.09	68.74	1348748.0
2020-01-06	AB	Stock	30.01	30.49	30.0	30.36	292700.0
2020-01-06	ABB-DELISTED	Stock	24.12	24.36	24.11	24.32	1626946.0
2020-01-06	ABBNY-DELISTED	Stock	24.12	24.36	24.11	24.31	1835112.0
2020-01-06	ABBV	Stock	88.22	89.62	87.98	89.4	6786600.0
2020-01-06	ABC-DELISTED	Stock	83.68	85.31	83.01	85.25	572293.0
2020-01-06	ABCB	Stock	42.04	42.65	41.86	42.44	242400.0
2020-01-06	ABDC-DELISTED	Stock	9.12	9.12	9.07	9.11	16069.0
2020-01-06	ABEO	Stock	72.0	72.0	65.5	69.25	117164.0
2020-01-06	ABEV	Stock	4.61	4.69	4.59	4.62	12846500.0
2020-01-06	ABG	Stock	107.89	108.29	107.01	107.74	523300.0
2020-01-06	ABM	Stock	37.83	38.36	37.67	38.31	339700.0
2020-01-06	ABMD-DELISTED	Stock	166.53	179.42	166.02	179.07	1129785.0
2020-01-06	ABR	Stock	14.17	14.31	14.15	14.2	772400.0
2020-01-06	ABR.A-DELISTED	Stock	26.2922	26.4	26.2532	26.4	2178.0
2020-01-06	ABR.B-DELISTED	Stock	25.8	26.0	25.8	26.0	900.0
2020-01-06	ABR.C-DELISTED	Stock	26.6999	26.6999	26.6999	26.6999	14490.0
2020-01-06	ABT	Stock	85.62	86.36	85.21	86.34	5631700.0
2020-01-06	ABTC	Stock	240000.0	249000.0	234300.0	237600.0	3.64
2020-01-06	ABTS	Stock	30.0	32.7	26.805	32.55	200.0
2020-01-06	ABTX-DELISTED	Stock	37.04	37.55	36.95	37.43	43593.0

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

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