PREVIEW / stock_daily / 2019-11-05

all stock daily files

  file:    by_date/stock_daily/2019/2019-11-05.parquet
  size:    221 KB
  rows:    6,615
  symbols: 2,486

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-11-05	AAPL	Stock	64.2625	64.5475	64.08	64.2825	79897600.0
2019-11-05	MSFT	Stock	144.97	145.02	143.91	144.46	18250200.0
2019-11-05	NVDA	Stock	5.2623	5.2885	5.192	5.2403	300868000.0
2019-11-05	AMZN	Stock	90.458	90.5125	89.7	90.0855	37710000.0
2019-11-05	GOOGL	Stock	64.56	64.862	64.469	64.572	25148540.0
2019-11-05	META	Stock	195.37	195.75	193.6	194.32	9942000.0
2019-11-05	TSLA	Stock	21.308	21.5673	21.0747	21.148	104151000.0
2019-11-05	TLT	Stock	137.22	137.44	136.73	137.15	13496331.0
2019-11-05	ES	Stock	81.05	81.68	80.53	81.08	2167600.0
2019-11-05	CL	Stock	65.17	66.19	64.75	65.96	5394100.0
2019-11-05	A	Stock	76.82	76.91	75.47	75.55	2362700.0
2019-11-05	AA	Stock	23.2	23.465	22.55	22.59	5205300.0
2019-11-05	AACG	Stock	1.74	1.78	1.74	1.74	5800.0
2019-11-05	AAIC-DELISTED	Stock	5.85	5.9301	5.805	5.81	284863.0
2019-11-05	AAIC.C-DELISTED	Stock	21.38	21.45	21.37	21.37	5485.0
2019-11-05	AAL	Stock	31.0	31.58	30.91	31.18	5500200.0
2019-11-05	AAM.A-DELISTED	Stock	26.578	26.578	26.5	26.55	18374.0
2019-11-05	AAM.B-DELISTED	Stock	27.118	27.19	27.0	27.18	14927.0
2019-11-05	AAMC-DELISTED	Stock	3.7824	3.8824	3.7689	3.8824	2543.0
2019-11-05	AAME	Stock	2.28	2.28	2.1	2.26	4800.0
2019-11-05	AAMI	Stock	10.39	10.425	9.63	10.03	905700.0
2019-11-05	AAOI	Stock	11.52	11.74	11.27	11.33	1944900.0
2019-11-05	AAON	Stock	33.1267	33.3333	32.7333	33.1467	178500.0
2019-11-05	AAP	Stock	167.67	170.87	166.51	168.14	1222500.0
2019-11-05	AAT	Stock	48.28	48.55	47.48	47.81	201300.0
2019-11-05	AAU-DELISTED	Stock	0.4984	0.51	0.4772	0.4855	403138.0
2019-11-05	AAUAF-DELISTED	Stock	0.4984	0.51	0.4772	0.4855	413723.0
2019-11-05	AAWW-DELISTED	Stock	25.26	26.86	25.2214	26.26	658343.0
2019-11-05	AAXJ	Stock	71.57	71.66	71.32	71.57	1748152.0
2019-11-05	AAXN-DELISTED	Stock	51.87	54.13	51.72	53.08	674468.0
2019-11-05	AB	Stock	29.2	29.7	29.2	29.54	373500.0
2019-11-05	ABB-DELISTED	Stock	21.46	21.58	21.39	21.58	2477340.0
2019-11-05	ABBNY-DELISTED	Stock	21.46	21.58	21.39	21.58	3102719.0
2019-11-05	ABBV	Stock	83.17	83.4	81.47	81.84	7475600.0
2019-11-05	ABC-DELISTED	Stock	87.9	88.78	83.8	86.11	1641468.0
2019-11-05	ABCB	Stock	44.34	44.71	43.79	43.95	426700.0
2019-11-05	ABDC-DELISTED	Stock	8.8	8.89	8.8	8.8	25531.0
2019-11-05	ABEO	Stock	66.25	69.5	65.75	67.0	10180.0
2019-11-05	ABEV	Stock	4.36	4.43	4.35	4.39	15341600.0
2019-11-05	ABG	Stock	108.89	109.75	108.38	109.09	276600.0
2019-11-05	ABIL-DELISTED	Stock	0.444	0.447	0.41	0.411	21407.0
2019-11-05	ABM	Stock	36.93	37.34	36.74	37.33	265600.0
2019-11-05	ABMD-DELISTED	Stock	220.23	220.46	214.5	217.54	400788.0
2019-11-05	ABR	Stock	14.24	14.32	14.1	14.32	1733600.0
2019-11-05	ABR.A-DELISTED	Stock	26.37	26.38	26.0338	26.05	3085.0
2019-11-05	ABR.B-DELISTED	Stock	26.01	26.1798	26.0001	26.1798	2046.0
2019-11-05	ABR.C-DELISTED	Stock	26.3022	26.3022	26.0418	26.12	7000.0
2019-11-05	ABT	Stock	82.87	82.9	80.9	82.34	8238800.0
2019-11-05	ABTC	Stock	142800.0	145290.0	135300.0	137700.0	1.7866666666666666
2019-11-05	ABTS	Stock	32.1	32.85	29.775	30.0	1820.0

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

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