PREVIEW / stock_daily / 2019-10-17

all stock daily files

  file:    by_date/stock_daily/2019/2019-10-17.parquet
  size:    219 KB
  rows:    6,568
  symbols: 2,469

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-17	AAPL	Stock	58.7725	59.0375	58.38	58.82	67585200.0
2019-10-17	MSFT	Stock	140.95	141.42	139.02	139.69	21460600.0
2019-10-17	NVDA	Stock	4.9	4.9453	4.8025	4.8573	263436000.0
2019-10-17	AMZN	Stock	89.8245	89.9425	89.101	89.374	52948000.0
2019-10-17	GOOGL	Stock	62.57	63.1875	62.4935	62.64	21279620.0
2019-10-17	META	Stock	190.3	190.84	188.77	190.39	9603000.0
2019-10-17	TSLA	Stock	17.5	17.652	17.3447	17.4647	71539500.0
2019-10-17	TLT	Stock	139.52	140.38	139.2967	139.58	6558397.0
2019-10-17	ES	Stock	84.54	85.33	84.47	85.12	1065700.0
2019-10-17	CL	Stock	68.16	68.65	67.89	68.08	3760600.0
2019-10-17	A	Stock	75.69	76.25	74.9	74.92	1650000.0
2019-10-17	AA	Stock	20.55	21.63	20.03	20.3	9109900.0
2019-10-17	AAC-DELISTED	Stock	0.366	0.41	0.36	0.4	787950.0
2019-10-17	AACG	Stock	1.83	1.87	1.83	1.84	5400.0
2019-10-17	AAIC-DELISTED	Stock	5.5	5.61	5.5	5.54	634301.0
2019-10-17	AAIC.C-DELISTED	Stock	21.2	21.3697	21.02	21.02	7785.0
2019-10-17	AAL	Stock	28.31	28.44	27.85	27.93	6709600.0
2019-10-17	AAM.A-DELISTED	Stock	26.78	26.79	26.66	26.72	20071.0
2019-10-17	AAM.B-DELISTED	Stock	27.04	27.25	27.04	27.16	28862.0
2019-10-17	AAMC-DELISTED	Stock	3.8794	4.2941	3.8529	4.1176	47331.0
2019-10-17	AAME	Stock	2.52	2.52	2.46	2.46	500.0
2019-10-17	AAMI	Stock	9.55	9.6	9.46	9.48	174100.0
2019-10-17	AAOI	Stock	11.0	11.2	10.63	10.65	349500.0
2019-10-17	AAON	Stock	31.62	32.12	31.2667	31.84	311400.0
2019-10-17	AAP	Stock	162.5	164.71	161.25	163.75	730800.0
2019-10-17	AAT	Stock	47.47	47.83	47.37	47.67	267200.0
2019-10-17	AAU-DELISTED	Stock	0.67	0.6836	0.66	0.6684	85847.0
2019-10-17	AAUAF-DELISTED	Stock	0.67	0.6836	0.66	0.6684	88488.0
2019-10-17	AAWW-DELISTED	Stock	22.4	23.12	22.06	22.55	359775.0
2019-10-17	AAXJ	Stock	68.92	68.92	68.57	68.71	696563.0
2019-10-17	AAXN-DELISTED	Stock	52.0	52.59	51.66	51.7	306448.0
2019-10-17	AB	Stock	28.0	28.25	27.23	27.54	857700.0
2019-10-17	ABB-DELISTED	Stock	19.03	19.08	18.95	18.97	1000012.0
2019-10-17	ABBNY-DELISTED	Stock	19.04	19.08	18.95	18.97	1061869.0
2019-10-17	ABBV	Stock	74.99	76.18	74.65	75.14	6811300.0
2019-10-17	ABC-DELISTED	Stock	86.11	89.83	86.11	89.49	2843557.0
2019-10-17	ABCB	Stock	41.22	41.5	41.01	41.48	503700.0
2019-10-17	ABDC-DELISTED	Stock	8.94	8.99	8.862	8.87	11920.0
2019-10-17	ABEO	Stock	59.75	62.5	55.25	56.5	28968.0
2019-10-17	ABEV	Stock	4.57	4.58	4.49	4.49	10384800.0
2019-10-17	ABG	Stock	100.4	101.6	100.02	101.13	135200.0
2019-10-17	ABIL-DELISTED	Stock	0.51	0.5399	0.4709	0.52	50776.0
2019-10-17	ABM	Stock	36.96	37.22	36.64	37.0	307800.0
2019-10-17	ABMD-DELISTED	Stock	179.03	179.1	176.2	176.55	316350.0
2019-10-17	ABR	Stock	13.33	13.33	13.25	13.31	1189000.0
2019-10-17	ABR.A-DELISTED	Stock	26.22	26.28	26.1493	26.28	2651.0
2019-10-17	ABR.B-DELISTED	Stock	26.1166	26.28	26.0	26.28	1000.0
2019-10-17	ABR.C-DELISTED	Stock	26.1686	26.2715	25.95	26.1	9518.0
2019-10-17	ABT	Stock	81.52	83.0	81.47	82.38	4172800.0
2019-10-17	ABTC	Stock	169500.0	174300.0	154500.0	173700.0	1.3066666666666666

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

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