PREVIEW / stock_daily / 2019-12-11

all stock daily files

  file:    by_date/stock_daily/2019/2019-12-11.parquet
  size:    221 KB
  rows:    6,579
  symbols: 2,438

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-12-11	AAPL	Stock	67.2025	67.775	67.125	67.6925	78756800.0
2019-12-11	MSFT	Stock	151.54	151.87	150.33	151.7	18856600.0
2019-12-11	NVDA	Stock	5.36	5.439	5.3575	5.4335	233796000.0
2019-12-11	AMZN	Stock	87.0835	87.5	86.7855	87.436	41952000.0
2019-12-11	GOOGL	Stock	67.415	67.4945	67.055	67.2125	20486160.0
2019-12-11	META	Stock	200.28	202.63	200.28	202.26	8036800.0
2019-12-11	TSLA	Stock	23.4587	23.8127	23.406	23.5133	103467000.0
2019-12-11	TLT	Stock	139.3	140.14	139.23	139.75	6257375.0
2019-12-11	ES	Stock	80.92	81.5	80.48	81.35	1561900.0
2019-12-11	CL	Stock	67.92	68.68	67.3	67.46	3229300.0
2019-12-11	A	Stock	82.93	83.47	82.57	83.42	1718300.0
2019-12-11	AA	Stock	20.55	20.92	20.46	20.65	2535400.0
2019-12-11	AACG	Stock	1.52	1.52	1.46	1.48	10200.0
2019-12-11	AAIC-DELISTED	Stock	5.85	5.89	5.84	5.85	206291.0
2019-12-11	AAIC.C-DELISTED	Stock	22.0	22.0763	21.95	21.95	5434.0
2019-12-11	AAL	Stock	27.08	27.1	26.68	26.86	5434600.0
2019-12-11	AAM.A-DELISTED	Stock	26.27	26.27	26.18	26.265	12096.0
2019-12-11	AAM.B-DELISTED	Stock	26.52	26.6229	26.51	26.56	17875.0
2019-12-11	AAMC-DELISTED	Stock	4.1294	4.1294	4.1294	4.1294	1289.0
2019-12-11	AAME	Stock	1.72	2.08	1.72	1.76	3700.0
2019-12-11	AAMI	Stock	10.27	10.44	10.2	10.31	537100.0
2019-12-11	AAOI	Stock	10.28	10.97	10.28	10.96	1017200.0
2019-12-11	AAON	Stock	32.6267	33.0133	32.4667	32.9	209700.0
2019-12-11	AAP	Stock	155.86	157.45	153.77	155.9	944900.0
2019-12-11	AAT	Stock	47.14	47.14	46.31	46.35	249900.0
2019-12-11	AAU-DELISTED	Stock	0.49	0.5098	0.4852	0.505	224427.0
2019-12-11	AAUAF-DELISTED	Stock	0.49	0.5098	0.4852	0.505	237289.0
2019-12-11	AAWW-DELISTED	Stock	26.35	26.8	26.12	26.67	174209.0
2019-12-11	AAXJ	Stock	70.46	71.05	70.43	70.92	1047292.0
2019-12-11	AAXN-DELISTED	Stock	72.68	73.42	71.93	72.47	253325.0
2019-12-11	AB	Stock	28.5	28.85	28.5	28.8	339800.0
2019-12-11	ABB-DELISTED	Stock	22.75	22.96	22.75	22.93	1001052.0
2019-12-11	ABBNY-DELISTED	Stock	22.75	22.96	22.75	22.94	1061576.0
2019-12-11	ABBV	Stock	86.7	87.26	86.23	86.7	7326400.0
2019-12-11	ABC-DELISTED	Stock	86.43	87.04	85.93	86.68	736838.0
2019-12-11	ABCB	Stock	43.37	43.62	42.92	43.24	343200.0
2019-12-11	ABDC-DELISTED	Stock	9.0684	9.18	9.03	9.1	21848.0
2019-12-11	ABEO	Stock	84.75	104.5	83.0	100.5	135216.0
2019-12-11	ABEOW-DELISTED	Stock	0.14	0.2	0.14	0.18	2200.0
2019-12-11	ABEV	Stock	4.45	4.47	4.39	4.45	11460900.0
2019-12-11	ABG	Stock	110.6	114.89	110.02	114.53	153700.0
2019-12-11	ABIL-DELISTED	Stock	0.62	0.62	0.555	0.57	127530.0
2019-12-11	ABM	Stock	38.13	38.39	38.01	38.13	185900.0
2019-12-11	ABMD-DELISTED	Stock	179.53	181.89	178.05	178.96	320195.0
2019-12-11	ABR	Stock	14.28	14.5	14.26	14.33	1922700.0
2019-12-11	ABR.A-DELISTED	Stock	26.0324	26.0805	26.0324	26.0474	796.0
2019-12-11	ABR.B-DELISTED	Stock	25.9349	25.9349	25.6295	25.67	6696.0
2019-12-11	ABR.C-DELISTED	Stock	26.09	26.1648	26.09	26.1648	1500.0
2019-12-11	ABT	Stock	84.62	85.04	84.21	84.91	2937500.0
2019-12-11	ABTC	Stock	345300.0	382500.0	330300.0	360000.0	7.666666666666667

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

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