PREVIEW / stock_daily / 2019-10-28

all stock daily files

  file:    by_date/stock_daily/2019/2019-10-28.parquet
  size:    221 KB
  rows:    6,607
  symbols: 2,479

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-28	AAPL	Stock	61.855	62.3125	61.68	62.2625	96572800.0
2019-10-28	MSFT	Stock	144.4	145.67	143.51	144.19	35280100.0
2019-10-28	NVDA	Stock	5.1575	5.2225	5.128	5.1698	330792000.0
2019-10-28	AMZN	Stock	87.403	88.935	87.125	88.854	74178000.0
2019-10-28	GOOGL	Stock	63.75	64.962	63.6155	64.449	65428220.0
2019-10-28	META	Stock	187.2	189.53	185.08	189.4	13657900.0
2019-10-28	TSLA	Stock	21.836	22.7227	21.5067	21.8473	283054500.0
2019-10-28	TLT	Stock	137.58	137.58	136.99	137.26	11402050.0
2019-10-28	ES	Stock	84.82	85.15	83.58	83.85	1370000.0
2019-10-28	CL	Stock	68.64	68.7	66.96	67.35	4595500.0
2019-10-28	A	Stock	75.69	76.56	75.69	76.15	1143900.0
2019-10-28	AA	Stock	21.22	21.77	21.19	21.52	2825800.0
2019-10-28	AACG	Stock	1.88	1.88	1.79	1.79	7800.0
2019-10-28	AAIC-DELISTED	Stock	5.74	5.78	5.66	5.68	186352.0
2019-10-28	AAIC.C-DELISTED	Stock	21.39	21.3901	21.2758	21.34	6434.0
2019-10-28	AAL	Stock	31.0	31.67	31.0	31.36	10298500.0
2019-10-28	AAM.A-DELISTED	Stock	26.77	26.79	26.69	26.69	7224.0
2019-10-28	AAM.B-DELISTED	Stock	27.21	27.2147	27.09	27.09	11062.0
2019-10-28	AAMC-DELISTED	Stock	4.6559	4.6559	4.4412	4.4412	792.0
2019-10-28	AAME	Stock	2.18	2.22	2.02	2.12	2300.0
2019-10-28	AAMI	Stock	9.51	9.73	9.51	9.69	382400.0
2019-10-28	AAOI	Stock	9.98	10.4	9.962	10.16	363800.0
2019-10-28	AAON	Stock	32.1067	33.0133	32.1067	32.88	198150.0
2019-10-28	AAP	Stock	165.96	167.97	165.23	166.41	978800.0
2019-10-28	AAT	Stock	47.72	47.8	47.0	47.02	339600.0
2019-10-28	AAU-DELISTED	Stock	0.65	0.6682	0.61	0.61	522396.0
2019-10-28	AAUAF-DELISTED	Stock	0.65	0.6682	0.61	0.61	537324.0
2019-10-28	AAWW-DELISTED	Stock	25.72	26.33	25.58	25.71	615193.0
2019-10-28	AAXJ	Stock	69.43	69.83	69.43	69.65	1494086.0
2019-10-28	AAXN-DELISTED	Stock	54.73	55.25	54.19	54.74	386725.0
2019-10-28	AB	Stock	28.95	29.2	28.81	29.14	300000.0
2019-10-28	ABB-DELISTED	Stock	21.19	21.19	21.095	21.12	1370040.0
2019-10-28	ABBNY-DELISTED	Stock	21.19	21.19	21.095	21.12	1517217.0
2019-10-28	ABBV	Stock	76.67	78.38	76.49	78.33	7146400.0
2019-10-28	ABC-DELISTED	Stock	87.2	88.2	86.8	87.41	312999.0
2019-10-28	ABCB	Stock	43.56	44.26	43.56	44.08	479500.0
2019-10-28	ABDC-DELISTED	Stock	8.99	9.01	8.9446	8.9446	33450.0
2019-10-28	ABEO	Stock	62.25	65.5	58.75	64.25	10888.0
2019-10-28	ABEOW-DELISTED	Stock	0.27	0.27	0.27	0.27	689.0
2019-10-28	ABEV	Stock	4.44	4.45	4.32	4.37	26747800.0
2019-10-28	ABG	Stock	103.57	106.52	102.73	104.48	137500.0
2019-10-28	ABIL-DELISTED	Stock	0.4648	0.489	0.46	0.48	16836.0
2019-10-28	ABM	Stock	37.46	37.92	37.46	37.71	273100.0
2019-10-28	ABMD-DELISTED	Stock	183.76	186.26	180.36	183.85	347425.0
2019-10-28	ABR	Stock	13.44	13.55	13.39	13.54	1083800.0
2019-10-28	ABR.A-DELISTED	Stock	26.16	26.1665	25.94	26.15	1697.0
2019-10-28	ABR.B-DELISTED	Stock	25.89	25.945	25.89	25.945	300.0
2019-10-28	ABR.C-DELISTED	Stock	26.1	26.2193	26.05	26.1833	5975.0
2019-10-28	ABT	Stock	81.8	82.89	81.76	82.66	4768800.0
2019-10-28	ABTC	Stock	156900.0	164700.0	154500.0	156000.0	0.9733333333333333

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

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