PREVIEW / stock_daily / 2019-04-29

all stock daily files

  file:    by_date/stock_daily/2019/2019-04-29.parquet
  size:    220 KB
  rows:    6,543
  symbols: 2,591

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-04-29	AAPL	Stock	51.1	51.4925	50.965	51.1525	88818800.0
2019-04-29	MSFT	Stock	129.9	130.18	129.35	129.77	16324200.0
2019-04-29	NVDA	Stock	4.4602	4.5112	4.3875	4.4833	391920000.0
2019-04-29	AMZN	Stock	97.45	97.817	96.7045	96.9215	80426000.0
2019-04-29	GOOGL	Stock	64.0255	64.8488	63.5855	64.81	72367240.0
2019-04-29	META	Stock	190.95	195.41	190.65	194.78	19641300.0
2019-04-29	TSLA	Stock	15.724	16.2653	15.478	16.098	250717500.0
2019-04-29	TLT	Stock	123.23	123.35	122.85	123.02	10246172.0
2019-04-29	ES	Stock	70.86	71.14	70.37	70.58	1076700.0
2019-04-29	CL	Stock	71.25	71.58	70.79	71.38	3383900.0
2019-04-29	A	Stock	77.47	78.44	77.32	77.33	2177700.0
2019-04-29	AA	Stock	26.82	26.94	26.48	26.85	2298600.0
2019-04-29	AABA-DELISTED	Stock	75.82	76.44	75.72	75.98	3261255.0
2019-04-29	AAC-DELISTED	Stock	1.64	1.75	1.63	1.72	81907.0
2019-04-29	AACG	Stock	2.04	2.12	2.0	2.0	152900.0
2019-04-29	AAIC-DELISTED	Stock	7.87	7.95	7.86	7.89	239259.0
2019-04-29	AAIC.C-DELISTED	Stock	23.5	23.515	23.4	23.48	11700.0
2019-04-29	AAL	Stock	33.51	33.99	33.31	33.77	5558200.0
2019-04-29	AAM.A-DELISTED	Stock	25.0	25.2266	25.0	25.2266	7370.0
2019-04-29	AAM.B-DELISTED	Stock	25.16	25.2	25.138	25.195	166096.0
2019-04-29	AAMC-DELISTED	Stock	7.9971	8.2868	7.9412	8.2868	4709.0
2019-04-29	AAME	Stock	2.36	2.36	2.36	2.36	200.0
2019-04-29	AAMI	Stock	14.63	14.82	14.63	14.8	400200.0
2019-04-29	AAOI	Stock	12.61	12.7	12.43	12.44	264400.0
2019-04-29	AAON	Stock	33.0067	33.7	33.0067	33.3933	169650.0
2019-04-29	AAP	Stock	169.94	170.56	166.64	166.77	811000.0
2019-04-29	AAT	Stock	46.37	46.65	46.08	46.21	295700.0
2019-04-29	AAU-DELISTED	Stock	0.55	0.554	0.51	0.5171	350161.0
2019-04-29	AAUAF-DELISTED	Stock	0.55	0.554	0.51	0.5171	361759.0
2019-04-29	AAWW-DELISTED	Stock	48.31	49.1	47.81	48.86	255914.0
2019-04-29	AAXJ	Stock	72.37	72.49	72.27	72.4	529800.0
2019-04-29	AAXN-DELISTED	Stock	63.02	64.0	62.28	63.37	559580.0
2019-04-29	AB	Stock	29.21	29.5	29.04	29.19	392000.0
2019-04-29	ABB-DELISTED	Stock	20.55	20.65	20.5146	20.56	1191670.0
2019-04-29	ABBNY-DELISTED	Stock	20.55	20.65	20.5146	20.57	1404839.0
2019-04-29	ABBV	Stock	80.46	80.98	79.91	80.3	6444500.0
2019-04-29	ABC-DELISTED	Stock	74.03	74.78	73.75	74.5	582672.0
2019-04-29	ABCB	Stock	36.39	37.23	36.39	36.77	420200.0
2019-04-29	ABDC-DELISTED	Stock	8.46	8.55	8.4057	8.46	44317.0
2019-04-29	ABEO	Stock	203.75	209.25	201.0	204.25	11332.0
2019-04-29	ABEV	Stock	4.65	4.7	4.62	4.68	26088500.0
2019-04-29	ABG	Stock	80.79	81.35	78.95	79.67	172300.0
2019-04-29	ABIL-DELISTED	Stock	1.43	1.4567	1.32	1.42	263393.0
2019-04-29	ABM	Stock	37.32	37.89	37.12	37.85	211100.0
2019-04-29	ABMD-DELISTED	Stock	275.43	277.0	271.95	274.0	509742.0
2019-04-29	ABR	Stock	13.79	13.87	13.72	13.72	921100.0
2019-04-29	ABR.A-DELISTED	Stock	25.83	26.1	25.83	25.87	7224.0
2019-04-29	ABR.C-DELISTED	Stock	26.2329	26.29	26.2329	26.2559	503.0
2019-04-29	ABT	Stock	78.56	78.63	77.58	78.27	4355000.0
2019-04-29	ABTC	Stock	304800.0	306000.0	304800.0	304800.0	0.8666666666666667

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

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