PREVIEW / stock_daily / 2020-01-14

all stock daily files

  file:    by_date/stock_daily/2020/2020-01-14.parquet
  size:    223 KB
  rows:    6,610
  symbols: 2,428

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-14	AAPL	Stock	79.175	79.3925	78.0425	78.17	161954400.0
2020-01-14	MSFT	Stock	163.39	163.6	161.72	162.13	23477400.0
2020-01-14	NVDA	Stock	6.2565	6.282	6.1688	6.182	359088000.0
2020-01-14	AMZN	Stock	94.294	94.3555	92.9275	93.472	68818000.0
2020-01-14	GOOGL	Stock	72.0	72.1315	71.3885	71.5295	26112720.0
2020-01-14	META	Stock	221.61	222.38	218.63	219.06	13288900.0
2020-01-14	TSLA	Stock	36.284	36.494	34.9933	35.8613	434943000.0
2020-01-14	TLT	Stock	138.18	138.82	138.135	138.73	13921031.0
2020-01-14	ES	Stock	85.26	85.91	85.15	85.85	2317900.0
2020-01-14	CL	Stock	70.14	70.4	70.03	70.29	4711900.0
2020-01-14	A	Stock	87.27	88.21	86.7	87.99	1675200.0
2020-01-14	AA	Stock	19.73	20.54	19.68	20.37	4218800.0
2020-01-14	AACG	Stock	1.51	1.55	1.5	1.55	5100.0
2020-01-14	AAIC-DELISTED	Stock	5.7	5.72	5.65	5.67	406437.0
2020-01-14	AAIC.C-DELISTED	Stock	22.04	22.04	21.8938	22.02	5597.0
2020-01-14	AAL	Stock	27.91	28.4	27.35	27.53	8888900.0
2020-01-14	AAM.A-DELISTED	Stock	26.7501	26.9112	26.7501	26.88	16916.0
2020-01-14	AAM.B-DELISTED	Stock	27.3139	27.5	27.3139	27.5	14192.0
2020-01-14	AAMC-DELISTED	Stock	3.9382	3.9706	3.9382	3.9706	6004.0
2020-01-14	AAME	Stock	1.82	2.09	1.82	2.01	2200.0
2020-01-14	AAMI	Stock	10.09	10.16	9.99	10.06	278100.0
2020-01-14	AAOI	Stock	13.81	13.88	13.4	13.86	778900.0
2020-01-14	AAON	Stock	34.4533	34.7533	34.3133	34.6067	158700.0
2020-01-14	AAP	Stock	145.59	149.08	144.34	148.9	1568400.0
2020-01-14	AAT	Stock	46.03	46.03	45.44	45.76	292500.0
2020-01-14	AAU-DELISTED	Stock	0.52	0.521	0.5011	0.5031	180134.0
2020-01-14	AAUAF-DELISTED	Stock	0.52	0.521	0.5011	0.506	186731.0
2020-01-14	AAWW-DELISTED	Stock	27.07	28.47	27.01	27.89	247274.0
2020-01-14	AAXJ	Stock	75.95	75.98	75.61	75.94	1099975.0
2020-01-14	AAXN-DELISTED	Stock	70.67	71.85	69.47	71.37	930270.0
2020-01-14	AB	Stock	32.5	32.5	32.28	32.37	420900.0
2020-01-14	ABB-DELISTED	Stock	23.81	23.985	23.77	23.88	1756922.0
2020-01-14	ABBNY-DELISTED	Stock	23.81	23.985	23.77	23.88	1859438.0
2020-01-14	ABBV	Stock	87.1	88.44	86.77	88.2	8876900.0
2020-01-14	ABC-DELISTED	Stock	86.6	88.98	86.02	88.83	1685257.0
2020-01-14	ABCB	Stock	42.61	42.99	42.28	42.71	218900.0
2020-01-14	ABDC-DELISTED	Stock	9.24	9.355	9.24	9.26	31698.0
2020-01-14	ABEO	Stock	60.0	65.5	57.5	64.5	57772.0
2020-01-14	ABEV	Stock	4.64	4.65	4.56	4.58	35525600.0
2020-01-14	ABG	Stock	101.86	103.63	101.46	101.88	230200.0
2020-01-14	ABM	Stock	39.01	39.53	38.72	39.3	287600.0
2020-01-14	ABMD-DELISTED	Stock	170.18	174.77	169.0001	172.73	769565.0
2020-01-14	ABR	Stock	14.47	14.53	14.45	14.51	1056900.0
2020-01-14	ABR.A-DELISTED	Stock	26.3	26.31	26.3	26.31	750.0
2020-01-14	ABR.B-DELISTED	Stock	26.14	26.2	26.14	26.2	610.0
2020-01-14	ABR.C-DELISTED	Stock	26.71	26.71	26.71	26.71	100.0
2020-01-14	ABT	Stock	84.13	86.0	84.01	85.74	8751400.0
2020-01-14	ABTC	Stock	214800.0	220800.0	206400.0	217200.0	6.293333333333334
2020-01-14	ABTS	Stock	30.555	30.555	30.555	30.555	6.67
2020-01-14	ABTX-DELISTED	Stock	37.3	37.615	37.03	37.37	50257.0

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

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