PREVIEW / stock_daily / 2019-09-13

all stock daily files

  file:    by_date/stock_daily/2019/2019-09-13.parquet
  size:    221 KB
  rows:    6,578
  symbols: 2,513

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-09-13	AAPL	Stock	55.0	55.1975	54.255	54.6875	159053200.0
2019-09-13	MSFT	Stock	137.78	138.06	136.57	137.32	23363100.0
2019-09-13	NVDA	Stock	4.5398	4.577	4.5045	4.5485	324592000.0
2019-09-13	AMZN	Stock	92.1005	92.306	91.7585	91.967	39426000.0
2019-09-13	GOOGL	Stock	61.6055	62.0525	61.354	62.0015	23675240.0
2019-09-13	META	Stock	187.33	187.97	186.54	187.19	11441100.0
2019-09-13	TSLA	Stock	16.464	16.5633	16.3247	16.3467	79696500.0
2019-09-13	TLT	Stock	138.28	138.71	136.54	136.54	18922161.0
2019-09-13	ES	Stock	82.5	83.08	82.27	82.38	1717600.0
2019-09-13	CL	Stock	71.6	71.72	70.39	70.71	4679600.0
2019-09-13	A	Stock	77.59	78.05	77.18	77.9	2673400.0
2019-09-13	AA	Stock	22.95	23.325	22.7	22.89	4218900.0
2019-09-13	AABA-DELISTED	Stock	70.03	70.22	69.95	70.06	7903811.0
2019-09-13	AAC-DELISTED	Stock	0.7692	0.7999	0.73	0.7654	83754.0
2019-09-13	AACG	Stock	1.86	1.86	1.81	1.85	14500.0
2019-09-13	AAIC-DELISTED	Stock	5.56	5.66	5.55	5.59	259767.0
2019-09-13	AAIC.C-DELISTED	Stock	21.929	21.9708	21.76	21.82	12907.0
2019-09-13	AAL	Stock	30.2	30.34	29.87	29.95	7131900.0
2019-09-13	AAM.A-DELISTED	Stock	26.37	26.407	26.2	26.2	29656.0
2019-09-13	AAM.B-DELISTED	Stock	26.56	26.5959	26.385	26.42	45842.0
2019-09-13	AAMC-DELISTED	Stock	2.9471	2.9471	2.9118	2.9471	9194.0
2019-09-13	AAME	Stock	2.74	2.74	2.68	2.74	2200.0
2019-09-13	AAMI	Stock	10.47	10.74	10.4	10.53	572200.0
2019-09-13	AAOI	Stock	11.09	11.303	11.05	11.17	281700.0
2019-09-13	AAON	Stock	33.94	34.34	33.1067	33.2267	288750.0
2019-09-13	AAP	Stock	159.1	159.32	154.85	157.0	996700.0
2019-09-13	AAT	Stock	47.0	47.88	46.35	46.88	554300.0
2019-09-13	AAU-DELISTED	Stock	0.73	0.73	0.708	0.7124	149308.0
2019-09-13	AAUAF-DELISTED	Stock	0.73	0.73	0.708	0.7124	157660.0
2019-09-13	AAWW-DELISTED	Stock	29.88	30.48	27.01	27.09	1531141.0
2019-09-13	AAXJ	Stock	68.82	69.035	68.71	68.92	1035307.0
2019-09-13	AAXN-DELISTED	Stock	64.5	65.66	63.96	65.13	366266.0
2019-09-13	AB	Stock	30.08	30.15	29.17	29.56	309200.0
2019-09-13	ABB-DELISTED	Stock	20.44	20.49	20.35	20.36	1283209.0
2019-09-13	ABBNY-DELISTED	Stock	20.44	20.49	20.35	20.36	1345479.0
2019-09-13	ABBV	Stock	71.15	71.51	70.48	70.51	8135600.0
2019-09-13	ABC-DELISTED	Stock	85.19	86.325	82.95	83.42	931309.0
2019-09-13	ABCB	Stock	39.05	39.86	38.71	39.42	582300.0
2019-09-13	ABDC-DELISTED	Stock	8.91	8.9302	8.81	8.83	93612.0
2019-09-13	ABEO	Stock	78.5	80.0	73.75	74.25	20404.0
2019-09-13	ABEV	Stock	4.77	4.81	4.65	4.66	23954300.0
2019-09-13	ABG	Stock	99.95	101.64	99.05	100.33	188700.0
2019-09-13	ABIL-DELISTED	Stock	0.65	0.66	0.64	0.66	21599.0
2019-09-13	ABM	Stock	36.84	37.5	36.24	36.3	468600.0
2019-09-13	ABMD-DELISTED	Stock	188.18	190.59	186.27	186.44	379528.0
2019-09-13	ABR	Stock	12.78	12.91	12.76	12.84	826200.0
2019-09-13	ABR.B-DELISTED	Stock	25.9	25.9	25.9	25.9	167.0
2019-09-13	ABR.C-DELISTED	Stock	26.3162	26.35	26.3162	26.35	1634.0
2019-09-13	ABT	Stock	85.3	85.36	83.89	84.27	3633200.0
2019-09-13	ABTC	Stock	260700.0	262500.0	254400.0	255600.0	0.6266666666666667

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

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