PREVIEW / stock_daily / 2019-04-30

all stock daily files

  file:    by_date/stock_daily/2019/2019-04-30.parquet
  size:    221 KB
  rows:    6,543
  symbols: 2,584

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-30	AAPL	Stock	50.765	50.85	49.7775	50.1675	186139600.0
2019-04-30	MSFT	Stock	129.81	130.7	129.39	130.6	24166500.0
2019-04-30	NVDA	Stock	4.4508	4.5508	4.4315	4.525	362920000.0
2019-04-30	AMZN	Stock	96.505	96.7855	95.3475	96.326	70120000.0
2019-04-30	GOOGL	Stock	59.5315	60.0489	59.15	59.948	133177100.0
2019-04-30	META	Stock	194.19	197.39	192.28	193.4	23494700.0
2019-04-30	TSLA	Stock	16.1373	16.2807	15.8	15.9127	141969000.0
2019-04-30	TLT	Stock	122.95	123.74	122.93	123.65	7957662.0
2019-04-30	ES	Stock	70.69	71.68	70.5	71.66	1584900.0
2019-04-30	CL	Stock	71.51	72.85	71.23	72.79	4050200.0
2019-04-30	A	Stock	77.44	78.59	77.38	78.5	1726200.0
2019-04-30	AA	Stock	26.71	27.02	26.37	26.68	3270000.0
2019-04-30	AABA-DELISTED	Stock	75.53	76.43	74.75	75.38	3929110.0
2019-04-30	AAC-DELISTED	Stock	1.72	1.72	1.57	1.61	109947.0
2019-04-30	AACG	Stock	1.98	2.06	1.88	1.88	233900.0
2019-04-30	AAIC-DELISTED	Stock	7.89	7.89	7.745	7.85	291226.0
2019-04-30	AAIC.C-DELISTED	Stock	23.7	23.7	23.48	23.48	3138.0
2019-04-30	AAL	Stock	33.78	34.39	33.55	34.18	5719600.0
2019-04-30	AAM.A-DELISTED	Stock	25.23	25.24	25.17	25.17	61177.0
2019-04-30	AAM.B-DELISTED	Stock	25.08	25.25	25.07	25.14	112268.0
2019-04-30	AAMC-DELISTED	Stock	7.9412	7.9412	7.9412	7.9412	2502.0
2019-04-30	AAME	Stock	2.45	2.46	2.45	2.46	1500.0
2019-04-30	AAMI	Stock	14.82	14.87	14.57	14.66	362900.0
2019-04-30	AAOI	Stock	12.42	12.54	12.22	12.52	337200.0
2019-04-30	AAON	Stock	33.4067	33.62	33.1733	33.4733	252300.0
2019-04-30	AAP	Stock	167.41	168.71	165.25	166.32	872200.0
2019-04-30	AAT	Stock	46.2	46.58	45.79	46.19	222400.0
2019-04-30	AAU-DELISTED	Stock	0.5171	0.5278	0.5081	0.5189	71395.0
2019-04-30	AAUAF-DELISTED	Stock	0.5171	0.5278	0.5081	0.5185	74685.0
2019-04-30	AAWW-DELISTED	Stock	48.74	49.085	48.0	48.29	147553.0
2019-04-30	AAXJ	Stock	72.19	72.39	71.87	72.26	849401.0
2019-04-30	AAXN-DELISTED	Stock	63.29	64.015	62.93	63.5	581788.0
2019-04-30	AB	Stock	29.34	29.53	28.93	29.51	272100.0
2019-04-30	ABB-DELISTED	Stock	20.57	20.685	20.4824	20.65	1362809.0
2019-04-30	ABBNY-DELISTED	Stock	20.57	20.685	20.4824	20.66	1415243.0
2019-04-30	ABBV	Stock	80.68	80.69	78.68	79.39	9367400.0
2019-04-30	ABC-DELISTED	Stock	74.8	75.057	73.61	74.73	886903.0
2019-04-30	ABCB	Stock	36.91	36.94	36.36	36.46	278400.0
2019-04-30	ABDC-DELISTED	Stock	8.55	8.58	8.32	8.46	72004.0
2019-04-30	ABEO	Stock	204.0	205.5	190.25	192.5	12164.0
2019-04-30	ABEV	Stock	4.7	4.73	4.6	4.71	25537200.0
2019-04-30	ABG	Stock	79.82	80.78	79.18	80.18	171100.0
2019-04-30	ABIL-DELISTED	Stock	1.42	1.4299	1.34	1.4024	38784.0
2019-04-30	ABM	Stock	37.94	38.05	37.29	37.97	850300.0
2019-04-30	ABMD-DELISTED	Stock	273.01	279.2	272.45	277.41	552737.0
2019-04-30	ABR	Stock	13.72	13.75	13.57	13.66	1112500.0
2019-04-30	ABR.A-DELISTED	Stock	26.0269	26.0269	25.8701	25.8701	1000.0
2019-04-30	ABR.B-DELISTED	Stock	25.7038	25.7108	25.7025	25.7025	925.0
2019-04-30	ABR.C-DELISTED	Stock	26.2342	26.27	26.21	26.2699	1200.0
2019-04-30	ABT	Stock	78.27	79.69	77.93	79.56	5514100.0

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

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