PREVIEW / stock_daily / 2019-10-24

all stock daily files

  file:    by_date/stock_daily/2019/2019-10-24.parquet
  size:    220 KB
  rows:    6,575
  symbols: 2,474

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-10-24	AAPL	Stock	61.1275	61.2	60.4525	60.895	69275200.0
2019-10-24	MSFT	Stock	139.39	140.42	138.67	139.94	37029300.0
2019-10-24	NVDA	Stock	4.9188	4.9553	4.8845	4.9215	232020000.0
2019-10-24	AMZN	Stock	88.5545	89.417	88.0135	89.039	88922000.0
2019-10-24	GOOGL	Stock	62.9555	63.145	62.6175	62.9555	22809560.0
2019-10-24	META	Stock	184.62	186.73	182.8	186.38	11413500.0
2019-10-24	TSLA	Stock	19.8913	20.3287	19.28	19.9787	445813500.0
2019-10-24	TLT	Stock	139.68	140.24	139.03	139.2	6830080.0
2019-10-24	ES	Stock	86.02	86.53	85.87	86.2	804000.0
2019-10-24	CL	Stock	67.75	68.54	67.55	68.34	4994800.0
2019-10-24	A	Stock	75.03	75.11	74.46	75.0	1475100.0
2019-10-24	AA	Stock	21.34	21.57	20.445	20.74	4190300.0
2019-10-24	AAC-DELISTED	Stock	0.69	0.69	0.4522	0.4665	486558.0
2019-10-24	AACG	Stock	1.82	1.87	1.8	1.83	7400.0
2019-10-24	AAIC-DELISTED	Stock	5.88	5.88	5.72	5.73	241523.0
2019-10-24	AAIC.C-DELISTED	Stock	21.15	21.32	21.15	21.3	4952.0
2019-10-24	AAL	Stock	29.27	29.85	28.49	29.41	17890900.0
2019-10-24	AAM.A-DELISTED	Stock	26.7607	26.88	26.72	26.88	8554.0
2019-10-24	AAM.B-DELISTED	Stock	27.2766	27.33	27.18	27.31	11576.0
2019-10-24	AAMC-DELISTED	Stock	4.7353	4.7353	4.5588	4.5588	8272.0
2019-10-24	AAME	Stock	2.29	2.29	2.29	2.29	100.0
2019-10-24	AAMI	Stock	9.45	9.53	9.345	9.38	554300.0
2019-10-24	AAOI	Stock	10.15	10.15	9.84	9.84	409700.0
2019-10-24	AAON	Stock	31.5267	31.9333	31.1867	31.7267	171300.0
2019-10-24	AAP	Stock	168.44	170.55	166.3	166.81	1070100.0
2019-10-24	AAT	Stock	47.89	48.02	47.61	47.86	224200.0
2019-10-24	AAU-DELISTED	Stock	0.65	0.6646	0.65	0.6625	151916.0
2019-10-24	AAUAF-DELISTED	Stock	0.65	0.6646	0.65	0.6625	157614.0
2019-10-24	AAWW-DELISTED	Stock	24.41	24.41	23.27	23.98	340109.0
2019-10-24	AAXJ	Stock	68.83	68.83	68.58	68.71	706273.0
2019-10-24	AAXN-DELISTED	Stock	53.82	55.06	53.56	54.92	405694.0
2019-10-24	AB	Stock	28.34	29.68	28.12	29.25	583800.0
2019-10-24	ABB-DELISTED	Stock	20.72	20.8	20.63	20.79	1754457.0
2019-10-24	ABBNY-DELISTED	Stock	20.72	20.8	20.63	20.79	2272787.0
2019-10-24	ABBV	Stock	77.84	77.89	76.25	76.8	5699300.0
2019-10-24	ABC-DELISTED	Stock	85.96	86.29	84.84	85.99	558759.0
2019-10-24	ABCB	Stock	43.19	43.19	42.44	42.82	302800.0
2019-10-24	ABDC-DELISTED	Stock	8.93	8.96	8.89	8.9	8121.0
2019-10-24	ABEO	Stock	60.5	61.0	57.0	57.0	14076.0
2019-10-24	ABEOW-DELISTED	Stock	0.16	0.16	0.15	0.15	2649.0
2019-10-24	ABEV	Stock	4.71	4.81	4.71	4.73	30702300.0
2019-10-24	ABG	Stock	99.92	103.69	99.69	103.29	270800.0
2019-10-24	ABIL-DELISTED	Stock	0.4999	0.4999	0.46	0.4898	19472.0
2019-10-24	ABM	Stock	37.44	37.44	36.38	36.83	240800.0
2019-10-24	ABMD-DELISTED	Stock	178.86	183.2	177.895	179.83	396000.0
2019-10-24	ABR	Stock	13.41	13.43	13.28	13.36	631700.0
2019-10-24	ABR.A-DELISTED	Stock	26.16	26.16	26.051	26.051	3098.0
2019-10-24	ABR.C-DELISTED	Stock	26.25	26.2914	26.14	26.14	1727.0
2019-10-24	ABT	Stock	81.59	82.09	81.21	81.36	4470900.0
2019-10-24	ABTC	Stock	172500.0	177120.0	169500.0	170100.0	0.52

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

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